How to Add New JDBC "Data Source" for DBCS in OTBI (Oracle Transactional Business Intelligence) in c

Question

Hi,

I want my "Reports and Analytics", OTBI to have a new data source which should be pointing to Database Cloud Service (DBCS). DBCS database instance is 12c version . I have the connection string from the my services for the DBCS instance. However in the Add "Data Source" option in the "Administrator" of "Report and Analytics" which is OTBI has no option for oracle 12c in drop down and also not sure what to enter in the "Database Driver Class".

Please help.

Thanks,

Sameer

Sameer S · Answer

Thanks for the quick response.

Hi,

I tried below scenarios and it didn't work giving me following error in every case.

Error:

-------

Could not establish connection. No suitable driver found for <connection string got from the DBCS for my pdb>

1. Tried connecting with Driver Type as Oracle 11g and Database Driver class as oracle.jdbc.OracleDriver

2. Tried connecting with Driver Type as Oracle 11g and Database Driver class as oracle.jdbc.driver.OracleDriver

3. Tried connecting with Driver Type as Other and Database Driver class as oracle.jdbc.OracleDriver

4. Tried connecting with Driver Type as Other and Database Driver class as oracle.jdbc.driver.OracleDriver

All the above points scenarios, I got the above error.

Also in case I have install or upload the driver file to OTBI, how should that be done, As I understand in Cloud access are limited for administration.

Thank you.

Regards,

Sameer

Gianni Ceresa · Answer

Did you try selecting the Oracle 11g option?

JDBC is quite nice and works across most of the version in general...

The Driver Class Name is probably something like "oracle.jdbc.driver.OracleDriver" (in case of the Oracle JDBC), it tells the system which driver to instantiate. It also require you uploaded the JAR of the driver in the folder where it will look for it.

(I don't have that tool, so you would need to check the documentation to get details on where a JDBC driver need to be loaded etc.)

But give it a try with Oracle 11g, it can probably work (assuming they didn't implemented something special just for 11g, but don't think so.