Tech Monger

In this article we will learn to install ODBC Driver for Denodo VDP database. We will use installed ODBC driver to establish connectivity between Informatica Powercenter Clients and Denodo Server. You can also use postgres odbc drivers to connect to the regular denodo database.

---

Download and Install Denodo ODBC Drivers

Download Denodo ODBC Driversfor Linux from Denodo website. You should get driver in tar.gz format. Make sure you are downloading 32 / 64 Bit drivers depending on your server operating system.

Installation Steps

Create directory to store driver binaries

mkdir /path/to/odbc-drivers/

Extract downloaded driver tar file in above directory

cd /path/to/odbc-drivers/
tar -xzvf denodo-drivers.tar.gz

Verify the Extracted Driver Path

ls /path/to/odbc-drivers/denodo-vdp-odbcdriver-linux/lib/unixodbc_x32/denodoodbc.so

Create Denodo ODBC Entry in Following Format

DENODO_VDP_CONNECTION=ODBC DRIVER FOR DENODO VDP

[DENODO_VDP_CONNECTION]
Driver=/path/to/odbc-drivers/denodo-vdp-odbcdriver-linux/lib/unixodbc_x32/denodoodbc.so
Description=ODBC DRIVER FOR DENODO VDP
DriverUnicodeType=1
Servername=denododb.example.com
Database=Denodo_DB_NAME
PortNumber=9999
Username=Denodo_DB_USERNAME
Password=Denodo_DB_PASS

By default denodo odbc driver denodoodbc.so connect with Unicode using iODBC manager. Flag DriverUnicodeType=1 ensures that Unicode connectivity is configured with Informatica Server. Denodo drivers also supports ANSI connectivity with denodoodbcca.so.

Test Connection with SSGODBC Utility

ssgodbc.linux32 -d DENODO_VDP_CONNECTION -u Denodo_DB_USERNAME -p Denodo_DB_PASS -v

If you are unable to connect then kindly check denodo host and port number from denodo admins. Also check for the open ports in both informatica and denodo firewall.

---

Create ODBC Connection in Powercenter Client by using data source DENODO_VDP_CONNECTION as connect string and use it like regular informatica connection.

---

Conclusion

Tagged Under : Informatica Linux ODBC