How to create a datasource in OBIEE?

Fabricio_Jorge

Hi all,

   OBIEE....: 12.2.1.0.0

   Host.......: OEL 7.1

   I have my production server (SRVPRD01) with a production database (DBPRD). Inside this database, i have 3 tables (TAB1, TAB2 and TAB3). What i would like to do is to create a datasource do this database (DBPRD) to work with the data in these 3 tables.

   First, i created an ODBC connection pointing to my Oracle BI Server (port 9514) and checked the checkbox "Connect"... and in the next screen, it loads to me a database named "Sample App Lite Data". Why? How can i point to my production database to use my work tables?

I tryed to create a new repository using Administration Tool, but in the "datasource view" area, i can only see the "Sample Sales Lite".

How to create a new repository pointing to my real data?

Thanks for the attention.

Gianni Ceresa

Hi,

You probably need to have a look at a tutorial ...

Creating a Repository Using the Oracle BI Administration Tool

It's based on a older version of OBIEE but it works in the same way with 12c.

Gianni Ceresa

Just don't confuse and mix the ODBC connection required to use the Admintool in "online" mode and the Admintool itself.

You need to use the Admintool to add a source to your RPD, and you can do it offline (so creating a RPD locally and you will then upload it on the server) or connect online to the RPD deployed on the server. To connect online you need a ODBC connection pointing to your server, and this sounds like the steps you were doing.