Integration Services

  To back up Integration Services:

  1. Perform a complete backup of the Oracle Essbase Integration Services catalog repository.

  2. Optional: Export all models and metaoutlines into XML files.

  3. Create and save a list of all source Open Database Connectivity (ODBC) Data Source Names (DSNs) that were set up.

  4. Keep a current copy of installed software, along with all property files, such as ais.cfg.

  To recover Integration Services:

  • If Integration Services installation files are lost because of hardware failure, you must reinstall Integration Services.

  • If the database containing the catalog is corrupted, you must restore it and then create an ODBC DSN to the catalog and use it to retrieve models and metaoutlines.

  • If the backup catalog database is also corrupted, then, from Oracle Essbase Integration Services Console, create an empty catalog and import each model and metaoutline using XML files.