Skip to content

ODBC connection configuration


When you connect to Database via ODBC , select Local DB as the location, select ODBC as the data type, and configure the detailed settings.



No Item Description
1 User ID
2 Password
3 Connection Type Select Basic
4 DSN ODBC Datasource Name
5 Default Schema If Default Schema is specified, the tables and views of the specified schema will be listed during mapping.
If blank, all accessible tables and views will be listed.
6 Transaction Supported Transactional statements may not be supported by some databases when making an ODBC connection. At that time, it was necessary to set Transaction Supported to off.
e.g Bigquery

ODBC Connection String

SDI uses System.Data.Odbc to connect to Database via ODBC.
You can connect ODBC by using ODBC Connection String directly.

No Item Description
1 Connetion Type Select ODBC Connection String
2 ODBC Connection String Enter the details of the ODBC Connection String.
* Do not enter user and password information in the Connection String.
Reference:OdbcConnection.ConnectionString property
Back to top