Skip to content

Configure Sybase IQ 15.2 as OBIEE 11g Data Source Using DataDirect ODBC Platinum Driver

June 7, 2012

Introduction

This blog show how to connect to a Sybase IQ 15.2 data source from OBIEE 11g Using DataDirect ODBC Platinum Driver.

In a following blog I will explain how to configure Sybase IQ 15.2 data source from OBIEE 11g Using the Sybase IQ 15.2 ODBC Driver.

Environment

  • OBIEE Plus 11.1.1.6 running on Solaris 10 Sun Sparc 64 architecture.
  • OBIEE Database repository on MS SQL 2005 running on Windows 2003
  • Sybase IQ 15.2 ESD#3 running on Solaris 10 over Sun Sparc 64 architecture.
  • DataDirect ODBC Platinum

Solution with DataDirect ODBC Drivers

Mr. Sumit Sarkar, from DataDirect, helped me to solve the problem as follow:

  1. copy the following files to the ORACLE_INSTANCE/Oracle_BI1/bifoundation/odbc/lib folder:
  • ddsyiq26.so
  • DDODBC.LIC
  • libddicu26.so
  1. Modify the odbc.ini file to user the ddsyiq26.so driver

No modification the user.sh file is required.

Please note that as the time of this posting, the DataDirect ODBC Platinum is not part of the ODBC drivers provided with OBIEE 11g and a license for it use is required.

More Info

Mr. Sumit Sarkar, from Progress Software, wrote a more detailed article on how to configure the Data Direct Sybase IQ ODBC driver, his article can be find here: http://blogs.datadirect.com/2012/06/sybase-iq-data-warehouse-connectivity-from-oracle-business-intelligence-obiee-via-odbc-platinum.html

Advertisements

From → OBIEE, SAP IQ

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: