The Canary ODBC Client is used for generating reports using SQL queries and populating data from the Enterprise Historian into SQL databases. It is a server/client based architecture in which the ODBC server component must be installed on the historian machine itself and the ODBC client installed on any machine wishing to make queries against the Canary database.

Licensing is server based and can be managed through the Canary Admin>License Tile.

This article will take you through the basic steps of installing and licensing the ODBC client. If the server component is already installed and licensed, skip to Installing the ODBC Client.

Installing the ODBC Server

Using the CanaryInstaller, select 'ODBC' as a feature to install along with the Historian and any other services that are needed on the historian server.

Licensing the ODBC Server

1. Open the Canary Admin and select the License tile.
2. If the server has internet access, fill out the necessary information underneath 'ADD LICENSE THROUGH INTERNET'. Otherwise, you may license your product by visiting https://canarylabs.com/support/license.                                                                                                                                      
3. Check 'ODBC Connector' and click 'GET LICENSE'.

Installing the ODBC Client

The ODBC client will need to be installed on the SQL server instance that will connect to the historian. The client installs as a System DSN (Data Source Name).

1. Run the CanaryInstaller and select the 'ODBC Client' to install.
2. Open the ODBC Data Source Administrator (32 or 64-bit, depending on the application using the Canary ODBC client) and select the 'System DSN' tab. Click the 'Configure...' button.
3. Set the 'Server IP' to the IP address of the Canary Historian machine or use the machine name.                           
4. Click 'Test Connection' to verify the client can connect to the server.
5. Click 'OK'.