Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BICS Integration with DBaaS (EBS Custom table history data migration to cloud for analytics)
Summary
BICS Integration with DBaaS (EBS Custom table history data migration to cloud for analytics)
Content
Hello Experts,
I have a requirement where we are moving to EBS11i client to Oracle Fusion Cloud. Client has some old data in Custom Table database which is also required to be moved to cloud for analytics point of view until certain point as long as that data has some value out of it.
in nutshell I need to make avail Oracle EBS11i custom Table history data in Oracle Cloud.
I have taken the approach where I took the trail version of Oracle DBaaS and I got BICS instance for data visualization.
Is this approach feasible? If not what is best way i can achieve this?
Your any help is greatly appreciated. Thank you in advance.
Summary : In above approach
1. How I can migrate data from on prim EBS11i Databse to DBaaS ?
2. How I can integrate BICS to visualize the data(Dashboard) with DBaaS ?
Regards
Narendra Kolhe
HCC
Answers
-
Hi,
1. Yes you can upload data to DBaaS, there are several ways to do it, one of them is Oracle BICS Data Sync
2. BICS "lives" on top of your DBaaS, all you have to do is to model your fact and dimensions in ythe data modeller, the following link is a tutorial on how to use it from Oracle http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/bics/DataModeler/bimodeler.html
0 -
If you got the answer to your question you can maybe close the thread? It will help others with same/similar questions, right now it's still This question is Not Answered.
0