Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE 12c with MySQL Database Connectivity
Hi All,
We are having 5.7.12 MySQL Community Server is our development database where all the DW tables resides.
Now, I am trying to import and develop some OBIEE reports but seems like my server is connecting to MysQL.
Does anybody help me on this configuration.
My OBIEE version: 12.2.1.3.0 (Installed in AWS Server)
Attached the screenshot for reference.
Thanks in Advance.
Answers
-
"Data soure name not found and no default driver specified". You seem to be having very low level connectivity issues. Way below the level of OBIEE. Can your OBI server even reach the MySQL database server? Can it ping it? Can it connect to it?
Same thing for the database itself.Can the OBI server even reach the database and access it?
ODBC: check what connectivity the OBI server uses to get to the database server and the DB.
Next: check your RPD. Do you have appropriate settigns doe DB type and call interface?
0 -
Hi Christian,
Thanks for the response!
I am able to ping the database server from BI Server and It does respond to the ping.
From the same server, I am able to import tables in Admin Tool in my windows machine and developed the RPD modeling.
After deploying the RPD in my AWS Linux server, I am not getting any data as there is DataDirect issues.
By following the below link, DataDirect configurations is updated in server for MySQL but no luck.
0 -
Being able to import but not read from the source is a rather strange behaviour. Are you using the exact same credentials for import as for data reading? Or do you change them after the import?
0 -
same credentials.. never changed.
0 -
What database type and call interface do you use in the RPD?
0 -
Hi Christian,
It is MySQL Aurora DB in AWS.
I am able to trace the issue and updated the ODBC.ini file and It is working fine now.
Thanks for your effort
Thanks,
Bose
0 -
;-)
0