SmartConnect 2018

ODBC Connections

The default ODBC connections screen allow connections to ODBC compliant data sources to be set and used throughout SmartConnect. The main advantage of using this approach to managing ODBC data sources is that when something within the environment changes amendments can be made in a single place and automatically applied to all data sources that use the connection.

 

Default ODBC connections may be used in an ODBC data source instead of defining the data source on the map.

 

To create a default ODBC connection:

1.Select ODBC Data Source from the Maintenance tab.
2.Enter a name for the default connection. Names must be unique and not contain spaces.
3.Select the connection type required, then enter the connection details required by that connection type.

ODBC_Types

 

4.Select save to record the changes.

ODBC_Default