Cognos, Tabeau, and other SQL tools require an ODBC driver on the client machine to communicate with MarkLogic Server. This chapter describes how to install and configure your MarkLogic Server ODBC driver on your client.
There is a 32-bit and 64-bit Windows MarkLogic ODBC driver and a 64-bit Linux ODBC driver, which are available from the MarkLogic Developer site:
Cognos and Tableau communicate with MarkLogic Server via a 32-bit or 64-bit ODBC driver. This section describes how to configure your ODBC driver for use with MarkLogic.
To launch the ODBC Data Source Administrator, open your Control Panel and navigate to:
Administrative Tools > ODBC Data Source Administrator
Click the System DSN tab and click Add:
Select either the MarkLogicSQL (64-bit) or MarkLogicSQL (x86) (32-bit) driver and click Finish:
In the MarkLogic SQL ODBC Driver Setup dialog, enter a name for your data source, the database name (SQLdata), the name of the machine that hosts your MarkLogic Server, the port number of your MarkLogic ODBC App Server (5432), set SSL mode to ‘allow', and your MarkLogic Server login credentials. Click Test to test the connection to MarkLogic Server.
If your connection test was successful, click Save. Otherwise, recheck your settings and retest.
The following procedure describes how to install the MarkLogic ODBC driver on Linux:
Obtain a copy of unixODBC (2.3.2). You might be able to install it with yum, but if not, you can download the correct version from http://www.unixodbc.org/ to your /tmp directory and use the following procedure to install:
tar -xvzf unixODBC-2.3.2.tar.gz
sudo make install
If you want to communicate with MarkLogic over SSL, you can install the openssl libraries as follows:
yum install openssl-libs
You can optionally install the GUI tools for unixODBC:
yum install unixODBC-gui-qt
Install the ODBC driver package (named mlsqlodbc-1.1-20140528.x86_64.rpm in this example):
rpm -i mlsqlodbc-1.1-20140528.x86_64.rpm
Call odbcinst to write the DSN to the current user's .odbc.ini file:
The name of the ODBC driver is MarkLogicSQL. Use isql to connect to MarkLogicSQL to confirm that the ODBC driver was correctly installed (the MarkLogic username and password in this example is admin/admin):
isql -v MarkLogicSQL admin admin
If you don't what to have to enter your username and password each time you run isql, you can edit the ~/.odbc.ini file to add your MarkLogic username and password:
If you encounter problems, make sure that the settings in the configuration files point to the right locations for your environment. Calling odbcinst -j will return the list of the configuration files for the ODBC driver.