Categories
- All Categories
- Oracle Analytics Learning Hub
- 26 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 234 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
I could not retrieve a data from a DB2 database.
I am using OBIEE 11.1.1.1.9 on Oracle Linux. I have to connect in connection pool to DB2 database.
How can I do it?
Answers
-
Physical Layer. Right-click. "New database" -> Database type -> Choose your DB2.
0 -
Tried. No result. Have to setup odbc.ini file on OS.
0 -
Of course, otherwise OBI can't use the connectivity
But that's outside OBI and a DB2 problem: https://www.ibm.com/docs/en/db2/11.1?topic=environment-setting-up-odbc-linux-unix0 -
I succesfuly set up IBM DB2 connection on Linux and I can connect to DB2 from command line interface on Linux.
But still can't connect through OBIEE Admin tool. I have not set up ibm db2 odbc in Windows.
0 -
What kind of connection isn't working in the Admin tool?
You mean your RPD, once deployed on the OBIEE server, doesn't return data when you run analysis?
Or you can't view data via the Admin tool when you click on a physical table?
I don't remember much about 11.1.1.9 (time for an upgrade maybe?), but the Admin tool for many type of sources doesn't go via the OBIEE server but tries to connect directly instead. If this is the case (again, I don't remember how it was 7 years ago), you will need the same ODBC connection (name of it) locally where you are running the Admin tool.
0 -
Yes, it is the case. I need db2 odbc driver on windows workstation from which I using Admin Tool. Also I need ibm odbc driver on obiee linux server side.
0 -
Very interesting. I set up odbc ibm driver in Windows machine. After setting up db2 connection in the admin tool I get error:
nQSError: 36001 Unable to load the dll db2cli.dll
I checked the connection from cmd:
db2cli validate -dsn TRIGLAV -connect -user proba -passwd adminxp
C:\WINDOWS\system32>db2cli validate -dsn TRIGLAV-connect -user proba -passwd adminxp
===============================================================================
Client information for the current copy (copy name: C_clidriver):
===============================================================================
Client Package Type : IBM Data Server Driver For ODBC and CLI
Client Version (level/bit): DB2 v11.5.6000.1809 (s2106111000/64-bit)
Client Platform : NT 64BIT
Install/Instance Path : C:\clidriver
Common App Data Path : C:\ProgramData\IBM\DB2\C_clidriver
DB2DSDRIVER_CFG_PATH value: <not-set>
db2dsdriver.cfg Path * : C:\clidriver\cfg\db2dsdriver.cfg
User db2dsdriver.cfg Path : C:\Users\savdalovic\db2dsdriver.cfg
DB2CLIINIPATH value : <not-set>
db2cli.ini Path : <Common App Data Path>\cfg\db2cli.ini
db2diag.log Path : <Common App Data Path>\db2diag.log
* - Warning: db2dsdriver.cfg configuration file is found at the location which
will be deprecated soon. It is recommended to move this file to the location:
"C:\ProgramData\IBM\DB2\C_clidriver\cfg\".
===============================================================================
List of all IBM Data Server client packages on the current workstation:
===============================================================================
Copyname Version Package Language Installed-Location
-------------------------------------------------------------------------------
C_clidriver[C] 11.5.0600 CLI EN C:\clidriver
-------------------------------------------------------------------------------
CLI: IBM Data Server Driver for ODBC and CLI
-------------------------------------------------------------------------------
===============================================================================
db2dsdriver.cfg schema validation for the entire file:
===============================================================================
Success: The system db2dsdriver.cfg schema validation completed successfully without any errors.
Success: The User db2dsdriver.cfg schema validation completed successfully without any errors.
===============================================================================
db2cli.ini validation for data source name "TRIGLAV":
===============================================================================
[ Keywords used for the connection ]
Keyword Value
---------------------------------------------------------------------------
PWD ********
UID proba
===============================================================================
db2dsdriver.cfg validation for data source name "TRIGLAV":
===============================================================================
[WARNING] Database entry for dsn is missing in IBM Data Server Configuration
file.
===============================================================================
[ Parameters used for the connection ]
Keywords Valid For Value
---------------------------------------------------------------------------
DATABASE CLI,.NET,ESQL triglav
HOSTNAME CLI,.NET,ESQL 192.168.205.176
PORT CLI,.NET,ESQL 50000
===============================================================================
Connection attempt for data source name "TRIGLAV":
===============================================================================
[SUCCESS]
===============================================================================
The validation is completed.
===============================================================================
C:\WINDOWS\system32>
0 -
I have seen the document. I will try it. Thanks.
0
