How to import data from ORACLE EBS to OBIEE

682981

Hi
I am new to OBIEE, how to extract the data from ORACLE EBS to OBIEE
To individual subject areas, like
Financials- AR Transactions
Financials- AP Transactions
Inventory- Balances
Inventory – Bill of Materials

Any materials which may contain step by step procedure to extract
The data to the subject areas
Please do needful
Thanks in advance
Regards
Babu

rmoff

step by step procedure?

1. Install OBIA
2. Press the big red button marked "GO"

sorry....

you are looking for OBIA (of which OBIEE is part), start here:
http://www.oracle.com/appserver/business-intelligence/bi-applications.html
http://siebel-essentials.blogspot.com/2009/06/can-you-describe-oracle-bi-applications.html

679808

Good points from rnm,

considering OBIA installation point, you may find [OBIA Installation Guide|http://download.oracle.com/docs/cd/E14223_01/bia.796/e14217/toc.htm] useful.
This one is for the latest, 7.9.6 version.

Hope it helps..
Michal

Christian Berg-0racle

Or (seeing that it's EBS) 7.9.5.2 with ODI if he wants to be funky ;-)

66787

7.9.5.2 is limited use release so I will stay away from it for now..

7.9.6 is best best, the Fin, SCM and P&S analytics apps are quite stable so for most part you need those for the subject areas you have specified from EBS
;like financial analytics will include AP, AR, GL, Profitability etc...

Make sure not to inclide the Financial account group cleanup subject area else you will get errors in ETL load.

User_71SVP

Hi ,

to get started,get hold of Windows XP machine with min 2gb RAM ,2GHz CPU and atleast 70 GB of free Harddisk space.

Install with Oracle 10g,
Jdk (latest version)
sql developer ( to query database)
install OBIEE,
install BI Apps 7.9.6 ( you will get Project analytics and Loyalty Analytics too with this release!!)
Install Informatica
get Hibernate libraries and configure DAC server,clients.
get hold to the machine with APPs user of EBS source system.
query the EBS source system and get the details as per the configuration guide and start filling your config files in SrcFiles and LkpFiles folder.
once DAC is configured ,Start the execution plan and the dataloading for say 2 years of period (depending on the harddrive size that yu may have).
you may also need to troubleshoot and debug during the ETL loading errors.
once done you may disconnect the EBS system and work on the Datawarehouse.

66787

If you use 7.9.6, Hibernate files are not required. use DAC 10g and it is much easier to install OBIA.