Export Wizard: Destination tab

Select either SQL Server or Oracle.

If your Axiom system is hosted on the Axiom Cloud, then you must specify a remote data connection in order to connect with the external database.

You can select any remote data connection that has been set up in Scheduler. For more information, see Managing remote data connections. If no remote data connections have been defined in your system, then this setting does not apply and will not display.

• For SQL Server, enter the server name for the external database.

• For Oracle, enter the connection parameters for the external database. You can obtain these parameters from the Oracle TNS Names entry. For more information, see the similar discussion for setting up Oracle as an import source (Connection information for Oracle).

Enter the name of the external database. This setting only applies if the database is SQL Server.

Enter the user name to use to connect to the external database. For SQL Server, the user credentials must be for a SQL Server account; network domain credentials cannot be used.

NOTE: The user credentials must have the appropriate permissions to perform the table actions for the export in that database.

Enter the password to use to connect to the external database.

NOTE: The password must be re-entered whenever any of the other connection properties are changed.

Specify the name of the table to create or update in the destination database. If desired, you can use the Choose Table button to the right of the box to look up existing table names in the destination database.

You can update an existing table or create a new table. The behavior is determined by the setting Drop and Create Destination Table. Note that if "drop and create" is not enabled for the export, then the table must already exist in the destination database because the export will not create it. You can either manually create the table in the destination database before running the export, or you can run the export once with "drop and create" enabled to initially create the table, then disable the option for future executions to update the existing table.

Specifies whether the destination table is created or updated.

• If enabled (default), the destination table will be created as part of the export. If the destination table already exists in the destination database, it will first be dropped (deleted), and then re-created with the new data from the export. Any existing data in the table will be lost.

• If disabled, the existing destination table will be updated with the new data from the export. The destination table must already exist in the destination database; the export will not create the table. Any existing data in the table may or may not be retained, depending on whether the option Truncate Destination Table is enabled.

Select Delimited File to export data to a delimited text file.

Select a remote data connection to use for the export. You can use any remote data connection that has been set up in Scheduler. For more information, see Managing remote data connections.

Enter the folder path where you want the destination file to be saved. You can type the path or click the folder icon to navigate to the desired path.

The folder path must be a UNC path (i.e. \\servername\foldername). If you enter a mapped drive, it will automatically be converted to a UNC path. The folder path must be accessible to the Axiom Cloud Integration Service.

Enter the name of the delimited file for the export to create.

By default, comma-delimited files are saved as CSV format, and all other delimiters are saved as TXT format. If you want a comma-delimited file to be saved as TXT format instead, then include the file extension on the file name.

Select this option if you want the first row of the delimited file to contain column names.

In the box to the right of the option, enter the delimiting character to use in the export file. For example, to delimit by a pipe character, enter a pipe character into the box. By default, the delimiter is set to comma.

If you want to use a space or tab as the delimiting character, place your cursor in the box and press the space bar or the tab key. The character will be indicated in parentheses to the right of the box (since the character is not visible in this case).

By default, the character used as the text qualifier is double quotation marks ("). If desired, you can enter a different character as the text qualifier, or you can clear the field if you do not want to use a text qualifier.

The text qualifier is used when values in the data may contain the delimiting character. For example, when the delimiting character is a comma, but the data contains values such as full names with a comma (for example: "Doe, Jane"). When the delimited file is created by the export, the value with the comma will be wrapped in quotation marks so that the comma is not read as a delimiter.