Sybase IQ data warehouse connectivity from Oracle Business Intelligence OBIEE via ODBC platinum

Sybase IQ data warehouse connectivity from Oracle Business Intelligence OBIEE via ODBC platinum

June 04, 2012 0 Comments

As a member of The Data Warehousing Institute (TDWI), I am really excited about DataDirect's growing portfolio of data connectivity solutions against data warehouses.  One of my favorite engagements is with a data warehousing group looking for superior ODBC/JDBC connectivity solutions for their enterprise data warehouse built on one or more of the following technologies:

It's always interesting to hear which organizations chose 3NF schemas, star schemas or hybrid approaches; and learn about newer requirements for integrating bigdata and SaaS data.  And I guarantee we can find at least one place where our technology is already running throughout your enterprise data warehouse (EDW) architecture from OLTP systems to data marts either directly or through one of our 300 ISV partners both on premise and in the cloud.  We'll send you a nice polo or tee shirt if I am wrong!

Other than a free shirt, what should you know about data warehouse connectivity?

Stephen Brobst (CEO/founder of Sampo Technologies & Systems) spoke last year at the TDWI World Conference San Diego about how software in the EDW architecture must scale regardless of hardware when designing a data warehouse for high performance.  Data connectivity is a component of your EDW architecture that applies to this reality check as well; and superior ODBC and JDBC connectivity is critical for usability of your enterprise data warehouse.  When looking at Sybase IQ (columnar database implementation of vertical partitioning and compression) and Oracle Business Intelligence (OBIEE); it's important to use data connectivity that is built on same technology as the ODBC drivers bundled with OBIEE.  DataDirect’s Sybase IQ ODBC driver delivers faster response times and massive scalability for OBIEE; supports login and query timeouts, and our drivers outperform competitive drivers in throughput, CPU efficiency, and memory usage.

Getting started with Oracle Business Intelligence (OBIEE) and Sybase IQ

1. Download 15 day trial of the DataDirect Connect or Connect64 XE for ODBC Sybase IQ platinum drivers for your Unix/Linux/Windows platform.

2. Install the Connect XE for ODBC drivers per the installation guide to a directory we shall call:


3. Add the shared library path in the file to include DATADIRECTXE_HOME/lib in:


4. Edit the odbc.ini file where you have configured data sources to SQL Server, Sybase ASE. and Informix:


5. Add the data source for IQ as follows:

[testDwIqDb] Driver=DATADIRECTXE_HOME/lib/ NetworkAddress=host,port Database=db_name

6. Copy the driver message files in DATADIRECTXE_HOME/locale/en_US/LC_MESSAGES into ORACLE_INSTANCE/Oracle_BI1/bifoundation/odbc/locale/en_US/LC_MESSAGES

7. Restart the BI Server

8. Setup the Sybase IQ data source named, "testDwIqDb" in the Connection Pool Oracle BI Administration Tool

Connection Pool Configuration

Admin Tool Connection Configuration

9. Test connect and you're now ready to build intelligence against the new Sybase IQ source

Execution form OBIEE Answers

Simple analysis execution from OBIEE Answers using Sybase IQ 15.2 as data source

Can the DataDirect Connect XE drivers be integrated in the same directory as the DataDirect Connect drivers installed with OBIEE?

Yes, you can copy the following files into the same directory as the branded DataDirect libraries such as SEmsssxx, SEifclxx, and SEasexx where xx is the version (11.1.1 bundled version 23).

Note: After Oracle Business Intelligence is installed, the DataDirect Connect ODBC 32-bit drivers are installed in ORACLE_HOME/odbc/lib. The 64-bit drivers are installed in ORACLE_HOME/odbc/lib64.

The files to copy over from DATADIRECTXE_HOME/lib to ORACLE_INSTANCE/Oracle_BI1/bifoundation/odbc/lib or /lib64 are:






Call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with OBIEE and DataDirect Connect XE for ODBC.  Progress DataDirect is a member of the alliance, along with Oracle Corporation, enabling both organizations to collaborate on your behalf for OBIEE questions related to data connectivity.

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
ProgressNEXT: Premier Event for Modern Application Development
Read More
Creating Quick, Codeless Connectivity with Autonomous REST Connector
Read More
Getting Started with Kinvey
Read More