Skip to content

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

July 12, 2012

Introduction

In a previous post I explained how to connect to Sybase IQ 15.2 data sources from OBIEE 11g using the DataDirect Wired Driver.

Oracle Engineering helped me to make the same connection using the Sybase IQ 15.2 ODBC Driver 64b.

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, Sun Sparc 64 architecture.
  • Sybase IQ 15.2 64-bit ODBC Driver for Solaris 10

Installation and Configuration Process

  1. Download the required ODBC Kit from Sybase Support Web site, I used iq1520_ntwrkclnt_sparc64.tgz
  2. Using Gnu unzip, decompress the iq1520_ntwrkclnt_sparc64.tgz file.
  3. Using Gnu tar, extract all the files from the archive file.
  4. Execute the Sybase IQ 15.2 Installation Wizard (setupSunOS64).
  5. On the welcome screen click on the button “Next”.
  6. Enter the name of the directory where you what to install the driver, and click on the button “Next”.
  7. Select the licence type that you are using, and click on the button “Next”.
  8. Select your country, read the licence agreement, agree with the terms if you want to continue, and click on the button “Next”.
  9. Since you only what to install the driver, select Custom Installation and click on the button “Next”.
  10. Deselect all except “Sybase IQ ODBC” and click on the button “Next”.
  11. Click on the button “Next” to confirm the installation.
  12. Verify the summary information and click on the button “Install” to start the installation.
  13. Verify that the installation has been successful and click on the “Finish” button to exist the Wizard.
  14. Review the content of the new created folder.
  15. At this point, the Sybase IQ ODBC driver is installed; in the next following steps you are going to test connectivity.

  16. Add a new data source for Sybase IQ to the OBIEE obdc.ini file; this file is located in

    /<Install folder>/Obiee11/instances/<instance name>/bifoundation/OracleBIApplication/coreapplication/setup

    [MyIQDb]

    Driver=/oracle/opt/Sybase/IQ-15_2/lib64/libdbodbc11.so

    DriverUnicodeType=1

    Description=Sybase IQ

    EngineName=MyIqSrvr

    CommLinks=tcpip(host=<IP Address:Port number>)

    DatabaseName=MyIqDb

    DatabaseFile=/IQ/Data/test/MyIqDb.db

  17. The DriverUnicodeType=1 is required to handle Unicode format differences (2-bytes vs. 4-bytes) between the ODBC driver and manager. Errors and core dump can occur if you miss this parameter.

  18. Set the ODBCINI environment variable to the full path of the OBIEE odbc.ini file
  19. Execute IQ-15_2.sh or IQ-15_2.csh to configure the Sybase IQ required environment variable.
  20. Use Sybase dbping tool to test connectivity to the database; this tool is installed with the ODBC driver in the bin64 folder.

    dbping –c “DSN=MyIqDb;UID=MyUser;PWD=MyPassword”

    You should receive a message similar to:

    SQL Anywhere Server Ping Utility Version 11.0.1.5604

    Ping server successful.

  21. Now, you need to clear the environment variables set during the test; If you are using telnet, the easier way to do this is to close you session an create a new session.

  22. Append the path to the Sybase IQ 15.2 Driver library to the LD_LIBRARY_PATH in the OBIEE user.sh file; this file is located in

    /<Install folder>/Obiee11/instances/<instance name>/bifoundation/OracleBIApplication/coreapplication/setup

  23. LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/oracle/opt/Sybase/IQ-15_2/lib64

    export LD_LIBRARY_PATH

    Note: It is important that the path of to the Sybase IQ ODBC driver library be added at the end of the LD_LIBRARY_PATH, otherwise some OBIEE BI Services could not restart.

  24. Restart the BI services

Done!

Especial thanks to the guys from Oracle Engineering for helping me solve some issues encountered.

Advertisements

From → OBIEE, ODBC, 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: