Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 51 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 287 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI 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