Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
How to import data from ORACLE EBS to OBIEE

682981
Member Posts: 37
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
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
Answers
-
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 -
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 -
Or (seeing that it's EBS) 7.9.5.2 with ODI if he wants to be funky ;-)
-
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. -
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. -
If you use 7.9.6, Hibernate files are not required. use DAC 10g and it is much easier to install OBIA.
This discussion has been closed.