Enabling the Support for ODBC Sources When the Virtual DataPort Server Runs on Linux¶
Virtual DataPort provides access to ODBC data sources. However, this feature is disabled by default when the Virtual DataPort server runs on Linux. The reason for being disabled by default is that on Linux, depending on the configuration of the host, Virtual DataPort could load the wrong library to connect to ODBC sources. If the wrong library is loaded, Virtual DataPort crashes. To avoid that a user creates an ODBC source that leads the Virtual DataPort server to crash, ODBC sources are disabled by default.
Follow these steps to enable this feature:
Install the package unixODBC. The section Install unixODBC of the Developer Guide explains how to do it.
Connect to the host where Denodo is installed. Log in with the user account you will use to launch Virtual DataPort.
Check that these files exist:
Their location may change depending on the Linux/Unix distribution.
Edit the file
~/.bash_profileand add the following at the end.
With this change in the value of the variable
LD_PRELOAD, you make sure that Virtual DataPort loads the files
libodbcinst.soprovided by unixODBC and not the ones provided by other libraries.
If the two files listed above are in
lib64and not in
lib, change the line above accordingly.
Logout and login again from this user account. Do this to apply the changes done in
If the Virtual DataPort server was started, stop it.
Start the Virtual DataPort server and login with an administrator account. Then, execute this command on the VQL Shell:
SET 'com.denodo.vdb.ODBCDataSource.enable' = 'true';
To check that the configuration has been updated correctly, do the following from the administration tool:
Create an ODBC data source.
Create an ODBC base view.
Query this base view.