Skip to content

OBIEE 11g with MS SQL Data Source

February 6, 2013

Introduction

In this post I explain how to connect to MS SQL data sources from OBIEE 11g using the bundled DataDirect SQL Server Wired Protocol ODBC driver.

Environment

  • OBIEE Plus 11.1.1.6 running on Solaris 10, Sun Sparc 64 architecture and install under the /oracle/Obiee11 directory.
  • OBIEE Database repository on MS SQL 2008 running on Windows 2008 (64b).
  • MS SQL 2008 SR2 running on Windows Server 2008 SP2 , 64 architecture.
  • DataDirect 5.3 MS SQL Wired Protocol ODBC driver that is bundled with Oracle Business Intelligence.

Configuration Process

  1. Add the path to the ODBC driver’s library directory to the LD_LIBRARY_PATH variable in the /oracle/Obiee11/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/user.sh file.

    ################################
    # DataDirect Wired Protocol ODBC drivers
    #################################
    LD_LIBRARY_PATH=/oracle/Obiee11/Oracle_BI1/bifoundation/odbc/lib:$LD_LIBRARY_PATH
    export LD_LIBRARY_PATH

  1. Add the ODBC data source entry in the /oracle/Obiee11/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini file.

[ODBC Data Sources]
AnalyticsWeb = Oracle BI Server
Cluster = Oracle BI Server
SSL_Sample = Oracle BI Server
myMSSQL = DataDirect 5.3 SQL Server Wire Protocol

[myMSSQL]
Driver = /oracle/Obiee11/Oracle_BI1/bifoundation/odbc/lib/SEmsss23.so
Description = DataDirect 5.1 SQL Server Wire Protocol
Address = 10.1.1.98,1433
AlternateServers =
AnsiNPW = Yes
ConnectionRetryCount = 0
ConnectionRetryDelay = 3
Database = myDatabase
LoadBalancing = 0
LogonID = myUser
Password = myPassword
QuoteID = No
ReportCodePageConversionErrors = 0

Done!

Advertisements

From → MSSQL, OBIEE, ODBC

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: