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?
Physical Layer. Right-click. "New database" -> Database type -> Choose your DB2.
Tried. No result. Have to setup odbc.ini file on OS.
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-unix
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.
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.
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.
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>
https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2104125_1.html
I have seen the document. I will try it. Thanks.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
