Settings for ODBC

This topic describes how to set up ODBC for DataSync.

  1. In DataSync, create a new source connection for ODBC.

  2. Fill out the fields in the New Connection dialog box as described below.

  3. 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:

  • Limit Type: Indicates how the limitation will be expressed in the results.

  • Limit Position: Indicates where the results will be displayed in the query.
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.