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

Question

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 · Answer

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,

cesar.advincula.o · Answer

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,

7688438 · Answer

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