Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 51 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 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
Data Sync Moving Updates/Changes from Dev to Prod.
Summary
Data Sync Moving Updates/Changes and New FACT/DIM tables from Dev to Prod.
Content
I am looking for documentation as to How-To move Updates,Changes (New FACT&DIM tables and altered tables) from DEV to PROD. The PROD was set up and has some tables in it but a lot of changes and additions have taken place. Thanks
Version
Oracle Analytics Cloud Data Sync (2.5)
Answers
-
Migrate Data Sync content from Non-Prod(Dev) to Prod
Login to Non-Prod DS (Dev – NTBHI2012). Export DS metadata from DataSync à Tools à Export.
Note: Make sure you select “Logical” and “System” when you are migrating for the first time. System option brings over connectivity and other universal settings. Subsequent migrations doesn’t need “System” option, just “Logical” will work fine.
Copy this new export folder from Non-prod to Prod DS server.
Make sure all the projects and mappings came over and migration was successful.
Update all the connections so source and target connections point to Prod:
Go to “Connections” à Update passwords à Test connections.
Make sure Connection’s Advanced Properties is setup correctly.
Start running jobs.
Configure email settings: Tools à Email à Setup
0