Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c with MySQL Database Connectivity

Bose Pandian

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.

Error Screenshot.PNG

Thanks in Advance.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

"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?

Bose Pandian

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.

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-C03C12DB-50AA-4ED5-B5B0-A32EA0E73D92.htm#datadirect_sybase

[Deleted User]

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?

Bose Pandian

same credentials.. never changed.

[Deleted User]

What database type and call interface do you use in the RPD?

Bose Pandian

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

[Deleted User]

;-)