Relational Database Destination

Database Type

Select type of database for the data destination.

Connection String for Database

Connection string used to connect to the data destination.

Use the Show Connection String Manager button to show the Connection String Manager for the selected database platform. See Connection String Manager Overview for more information.

OutputTableName

Type the name to give the table that will be created by the extractor process.

NOTE: If the database destination platform requires schema names as part of the table name, you will need to prefix the table name with the appropriate schema name. Example: dbo.OutputTable (dbo is the schema name).

Overwrite Table if it Already Exists

Set this option to true (checked) to overwrite the output data table if it already exists.

If set to false (unchecked) and the table already exists, the extractor process will terminate with an error message.

Output Batch Size

For some database types, setting this number to a higher number may increase output data creation speed. CAUTION: Setting this number too high can cause out-of-memory issues.

For other databases, this setting is ignored and a default of 1 is used.

A default batch size for the particular database type will be shown when you select a database from the Database Type drop-down list.