ODBC connection configuration
Overview
When you connect to Database via ODBC , select Local DB as the location, select ODBC as the data type, and configure the detailed settings.
Configuration
Basic
| 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 |