ODBC (Open DataBase Connectivity) is a standard to access databases originally developed by Microsoft. ODBC provides an API to make the code independent of database systems and operating systems.
Denodo provides an ODBC interface, but it requires the installation of the ODBC driver. Like any other ODBC driver, you have to install it on the machine where the client application is running.
In this section you will learn how to access to the Denodo server using an ODBC client. This information is also valid for any other ODBC connection. For the example, we will use MS Excel but feel free to use any other ODBC client.
The first thing that we have to do when connecting using ODBC is to install the Denodo ODBC driver. Denodo Platform 7.0
includes an ODBC driver named DenodoODBC and it is located under the
Extract the folders in this directory and run the programs inside to install the drivers. Once this is complete,
restart your Virtual DataPort Server from the Denodo Control Panel.
Once you've installed the ODBC driver you will need to add a new user data source:
Control Panel > Administrative Tools > Data Sources (ODBC).
Add User DSNor
Add System DSN. The difference is that "User DSN" can only be used by the current user and "System DSN" can be used by all the users of the system.
In the configuration dialog fill in the following information:
Now, you have to configure some of the Advanced properties by clicking on the Datasource button (a pop-up will open). Select the same options shown in the screenshots below and write "SET QUERYTIMEOUT TO 3600000" in the Connect Settings Box on page 2:
Finally, click the Ok button and then click Save button to finish.
Now, you have your environment ready to connect to Denodo using ODBC (remember than the previous steps are only valid to connect to the "tutorial" virtual database, so if you want to connect to another database you will have to create a new DSN).
For an example of an ODBC client application you can use the well-known Microsoft Excel. You will only have to select this DSN as a data provider to import the customer data into the spreadsheet.
Please, follow these steps and see the results:
Data > From Other Sources > From Microsoft Query
And voilà! The results from Denodo are populated into the MS Excel spreadsheet!