Create MS SQL Data Source in OBIEE 11g

-

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







Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more