ODBC connections

To access a source database, Connector uses ODBC connections. ODBC connections establish the connection to a data source. These may be relational data sources (SQL Server, Oracle, Access or others), text files (.txt-, csv-files and others) and Excel. To get a complete list of available data source drivers, open the ODBC Data Source Administrator dialog. ODBC data sources do not contain categorization information.

When the ODBC connection is enabled tables that contain a primary key which consists of only one field, will be categorized as dimension tables.