Settings for ODBC
This topic describes how to set up ODBC for DataSync.
-
In DataSync, create a new source connection for ODBC.
-
Fill out the fields in the New Connection dialog box as described below.
-
Click Save.
Connection Properties | Description |
---|---|
Description | Enter a name for the source connection. |
Null Expression / Not Null Expression | Represents the expressions when comparing to NULL and NOT NULL values. |
Left / Right Delimiter |
The Left and Right delimiters of the provider. Example of delimiters using square brackets: SELECT * FROM [TABLE] [COLUMN] |
Supports Schemas, Joins, Group By, Parameters, Order By, Subqueries, Quotes | Indicates whether the data source supports the selected options. |
Supports Limits |
If this option is selected, it sets limitations of the data source query results:
|
Supports Table Alias | Model of table alias supported in the data source. Select the appropriate table prefix. |
Supports Column Alias | Model of column alias supported in the data source. Select the appropriate column prefix. |
Metadata Loading | Specifies if the metadata will be loaded from a loaded column or a SELECT statement. |