Guidelines for defining ODBC data sources

Open Database Connectivity (ODBC) is a data access standard you can use to define ACL tables from a variety of data sources. ODBC support inACL enables you to import data from any ODBC-compliant data source on your computer, or from any location on your network that you have the appropriate security rights to access.

ODBC provides a middle layer, called a database driver, between the data source and ACL. This layer translates ACL queries into commands that the data source understands. ODBC drivers exist for almost all relational databases, and are also available for many non-relational data sources such as spreadsheets and text files.

The following file formats and databases are some examples of data sources that can be defined using ODBC:

Each of the data sources listed above can also be defined from the file or database using the options specific to that data source in the Data Definition Wizard and the functionality built into ACL or ACL Server. In some cases, you may need to use ODBC instead because you do not have direct access to the data source. For example, you want to define an ACL table from an Access database that is maintained by another department and you can only connect to it using ODBC. In other cases, you can choose which method to use. For example, if your organization has purchased ACL Analytics Exchange you can use either a server profile and database profile, via ACL Analytics Exchange Connector, to connect to a SQL Server database, or you can use an ODBC connection from ACL.

The following guidelines apply when you use ODBC to define an ACL table:

(C) 2015 ACL Services Ltd. All Rights Reserved.