Collect

Source Connection Types H

Source Connection Types V

Use this page to Set up Connection Types.

To access this page:

  1. Select Collect > Administrative > Connection Types in Navigation pane.
  2. Click Sources for a Target Connection Type of SQLSERVER.

Field

Description

SOURCE CONNECTION TYPE

Displays database connection type for the source.

NOTE: Collect only supports SQL Server Source databases. SQL 2012 and 2014 connection types are supported.

OLE PROVIDER

Displays name of OLE settings.

ODBC DRIVER

Displays name of driver used in the Windows ODBC setup for the DSN.

DSP SUPPLIED

If checked, the Source Connection Type was delivered with the product and cannot be deleted.

This check box cannot be updated.

If unchecked, the Source Connection Type was added as a custom type.

Data Type Conversions

Click to open the Connection Type Data Conversion page to manage data type conversions for the source.

Source Connection Types V

Source Connection Types H

Use this page to Set up Connection Types.

Field

Description

Source Connection Type

Displays database connection type for the source.

NOTE: Collect only supports SQL Server Source databases. SQL 2012 and 2014 connection types are supported.

Fetchsize

Displays number of records put into a buffer (i.e., the number of records to load into memory to run faster) on the Windows server.

Download SQL

Displays the SQL command used to read non-SAP databases to download table and column information from the source during the Build Package process. The data type conversions are performed during this load process and are followed by the Create Table and Create Keys/Indices process.

Download Table SQL

Displays the SQL called during Fetch Table process. When the Fetch Table icon on the Target Sourcespage is clicked, Collect uses the SQL entered in the Download Table SQL field to download a list of tables.

Download Primary Key SQL

Displays the SQL called during Build Package process. SQL verifies table built from SQL has a primary key. This field is only used for non-SAP sources.

Download Index SQL

Displays the SQL called during Build Package process. SQL verifies table built from SQL has indices. This field is only used for non-SAP sources.

SAP Table Check SQL

Displays the SQL called during the Build Package process to verify if the table is Transparent, Pooled, Clustered or Other. Tables are not created for objects (views, structures, etc.) marked as “other.”

SAP Column Download SQL

Displays the SQL called during the Build Package process to download all column information from SAP DD03L table, which is an SAP table that contains column information.

SAP Primary Key SQL

Displays the SQL called during the Build Package process to download all primary key information from SAP DD03L table, which is an SAP table that contains column information.

ODBC Driver

Displays name of the driver used in the Windows ODBC setup for the DSN.

OLE Provider

Displays name of OLE settings.

Connection String Example

Displays an example of a connection string for reference.

Left Column Delimiter

Displays character that wraps around special characters in field and table names.

Right Column Delimiter

Displays character that wraps around special characters in field and table names.