Skip to Content
Former Member
Nov 17, 2009 at 12:32 PM

SAP BI on SQL-Server with DB-Connect to Oracle Database


Hi, Everybody.

I have a question.

I'm trying to configure the DB Connect to extract data from a Oracle Database (NON-SAP data) to our BI System (Windows + MS.SQL Server).

I've installed the Shared Library "dboraslib.dll" in the run directory and I've already installed the Oracle Client.

The problem is to Set the variable DBMS_TYPE which value it must has ?

DBMS_TYPE=mss --> (This is the current SAP Database)

DBMS_TYPE=ora --> (This is the Database that I want to connect to)

DBMS_TYPE=mss;ora ---> Am I mad ??

I've configured the TNS_ADMIN variable as well as NSL_LANG.

When I try to create the connection the process dies in GET_CONNECTION method.