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.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (ERP). The session will cover updates on Finance, Projects, and Procurement. Presented by: Ashlesh Bajpai - Vice President, Product Management, Fusion Data Intelligence Shobana…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
