Can't connect to oracle EBS Database using BI admin tool

7688438

Hi all, Trying to configure ODBC connection to import oracle ebs tables into OBIEE bi admin tool but it is giving me hard time. Please give some inputs. Source EBS-DB version-Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production OBIEE version-Oracle Business Intelligence Product Version 11.1.1.7.150120 (Build 150111.1659 64-bit) Error:-

Thanks

R

cesar.advincula.o

Use oracle set database object.in the.physical layer and set your oracle.database type,

And  Use Oci driver,.

Kind regards,

7688438

Cesar, Thanks for your response.Please explain the steps in detail. Thanks R

cesar.advincula.o

The Oracle EBS ( E-Business Suite) Database  is an Oracle database

1. When you use it you have to sep what it is your Version of database:

2. Use the OCI (Oracle call interface)

3. Set up your connection pool:

   - DATA SOURCE:

            1 format:       <YOUR HOSTNAME OR IP>: PORT/SID

            2 format:

                           ORA11 =

                            (DESCRIPTION =

                                         (ADDRESS_LIST =

                                             (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))

                                            (CONNECT_DATA = (SERVICE_NAME = ORA11) ) )

            3 format:  tnsname.ora from Oracle BI

   

  - USERNAME

  - PASSWORD

Kind Regards,

cesar.advincula.o

Hello,

OK, lets get in order, if you want to model and RPD:

1. Check if there is any firewall between your OBIEE SERVER and your ADMIN TOOL Client.

2. Setting up your ODBC, connect to ADMIN TOOL to ORACLE BI SERVER:

    

  

   

      

      How do you what is port of your BI server?

       Go inside your EM

       

Click on Next and finish.

Kind Regards,