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.