Skip to Content

Oracle - BI IDT Connection issue

Aug 26, 2017 at 04:23 PM


avatar image
Former Member

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Thomas Nielsen Aug 28, 2017 at 11:23 AM


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:



10 |10000 characters needed characters left characters exceeded
Denis Konovalov
Aug 28, 2017 at 01:31 PM

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
This will help you with specifics on BOE side, such as how to create JDBC connection to Oracle.

10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Aug 30, 2017 at 08:31 PM

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.



10 |10000 characters needed characters left characters exceeded