Oracle - BI IDT Connection issue

[md_fasi]

Hi Team,

I am have installed BO 4.2 and trying to integrate with Oracle system with JDBC connection.

My requirement is I need to create IDT with Oracle JDBC connection. And Im unable connect the system. I have got the credentials from Oracle DBA.

Could you please suggest if there is any prerequisites required from Oracle side that need to be done at BOBJ server level

1) Oracle system is installed in different system
2) BO 4.2 Server up and running

I have heard something related to TNS need to be installed, I searched and didnt find complete information in forums.

Could you please help,

Thanks in advance

Thanks & Regards,
MFR

[Verakso]

Hi

I believe the reason why you can’t find any specific information related to Oracle TNS files in the forums, is because that is a standard way Oracle makes connection, and therefore is Oracle specific and not SAP BI specific.

So you most likely need to install the Oracle client, and configure the TNSNAMES file accordingly, but as I wrote - that is Oracle specific.

Perhaps you can find some inspiration in this blog post: https://blogs.sap.com/2014/11/18/audit-configuration-for-bi-41-with-oracle-database/

Regards

/Thomas

[former_member182521]

I configured oracle JDBC connection (to 11G) to my customer last week. Just follow the steps used in the below blog. Works like a charmJust make sure you updated the oracle.sbo file in your data access directory.

https://blogs.sap.com/2013/12/04/configuring-jdbc-driver-and-creating-connection/

Thanks

Mani

[denis_konovalov]

There are 2 parts of this that you need:
1. You need your DBA to setup required Oracle client or drivers on your client machine as well as on BOE server. This includes proper JDBC drivers.
2. You need to review Data Connection guide for Business Intelligence platform, which you can find on help.sap.com.
This will help you with specifics on BOE side, such as how to create JDBC connection to Oracle.