Migrating OAS Components
Migration of Oracle Analytics Server components from one environment to another typically involves moving the two main components of the tool - the presentation catalogs and the repository file.
The following sections focus on how to migrate each of these and whether a migration is actually needed or not.
Presentation Catalog
You are not expected to modify any of the catalogs delivered with the base product. This being the case the catalogs from base product package can directly be deployed across multiple environments. Follow the same steps as mentioned in the Dashboard Component section of the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
You can extend the analytics by adding some additional dashboards and reports to cater to any some additional business requirements. The details have been provided in the
Extending Analytics section. Make sure that the new objects are saved in a separate folder/catalog other than the base product catalogs. With the extra objects in place, you need to move these additional catalogs across their environments.
The recommended way from Analytics Server is to archive the catalogs from the source environment, move the files across and unarchive them in the target environment. Oracle Analytics Server provides the Catalog Manager utility for this purpose. The utility is available for both Windows and UNIX machines and is installed along with the Oracle Analytics Server product.
Follow these steps:
1. Start the Catalog Manager in the source Oracle Analytics Server environment.
2. Login in the Online mode.
3. Pick the custom catalogs created and archive them.
4. Save the archived files (.catalog) on the local server.
5. Move these catalog files to the target server through FTP or other available means.
6. Start the Catalog Manager in the target Oracle Analytics Server environment in the Online mode.
7. Select Unarchive and select the catalog files that were moved.
Once the custom catalogs have been successfully deployed, the custom dashboards and reports should start coming up on the target Oracle Analytics Server environment.
Repository
An implementation can create a custom version of the base product repository file for some additional business requirements. In such cases, the modified repository file needs to be migrated to the other Oracle Analytics Server environments that customers have. The Oracle Analytics Server Administration Tool that comes with the Oracle Analytics Server product can be used to save a copy of the repository file.
1. Start the Oracle Utilities Analytics Warehouse Administration Tool in the source Oracle Analytics Server environment.
2. Open the repository in Online mode.
3. Navigate to File > Copy As > Repository.
4. Enter a custom name for the repository (such as CM_UtilitiesBusinessAnalytics) and save the copy on the local machine.
5. Login to the Oracle Analytics Server Enterprise Manager console of the target Oracle Analytics Server environment.
6. Navigate to BI Instance > Coreapplication > Deployment.
7. Lock and edit. The Repository text box is enabled.
8. Browse to select the modified RPD file and submit it.
9. Provide the RPD password and click Apply.
10. Activate the changes and restart Oracle Analytics Server services.
Note: If the database connections used by the repository in the target environment are different, ensure to update the connection pool details in the repository file before deploying it on the server.