Collect
Connection Types H
Use this page to Set Up Connection Types.
To access this page, select
Field |
Description |
TARGET CONNECTION TYPE |
Displays the database connection type for the target. |
OLE PROVIDER |
Displays name of OLE settings. |
ODBC DRIVER |
Displays name of driver used in the Windows ODBC setup for the DSN. |
SYSTEM SUPPLIED |
If checked, the Target Connection Type was delivered with the product and cannot be deleted. This check box cannot be updated. |
Sources |
Click to open the Source Connection Types page to add, edit and delete sources connections for the target. |
Connection Types V
Use this page to Set Up Connection Types.
Field |
Description |
Target Connection Type |
Displays the database connection type for the target. |
Download Table SQL |
Displays the SQL command used to download all tables in a database and inserts them into a group that has the same name as the Connection. If the group does not exist, the process creates the group and inserts all the tables into the group from the database. |
Createtable SQL |
Displays the SQL called during the Fetch Table process. A list of tables that is available to download from source is downloaded. |
Create Primary Key SQL |
Displays the SQL called during the Build Package process. Only used for non-SAP systems. Checks to see if the table built from the SQL has any primary keys attached. If blank, a new table in SQL will not have primary keys. |
Create Index SQL |
Displays the SQL used to create index. |
OLE Provider |
Displays name of OLE settings. |
Connection String Example |
Displays an example of a connection string for reference. |
Left Column Delimiter |
Displays the character that wraps around the left of columns and table names. |
Right Column Delimiter |
Displays the character that wraps around the right of columns and table names. |