Skip to Content
avatar image
Former Member

Oracle - BI IDT Connection issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 28, 2017 at 11:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    Add comment
    10|10000 characters needed characters exceeded

  • 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.

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

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded