Legal | Privacy
Migrating an Essbase Application Across Servers Using Migration Wizard (Shared Services)

Migrating an Essbase Application Across Servers Using Migration Wizard (Shared Services Security)

This tutorial shows you how to migrate an Essbase application from one server to another using Migration Wizard, when Shared Services security is in force.

Approximately 20 minutes

Topics

This tutorial covers the following topics:

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over each individual icon in the following steps to load and view only the screenshot associated with that step.

Overview

Essbase Administration Services provides a Wizard for migrating Essbase applications and databases from one server to another under Shared Services security. For example, you might migrate an application from a development to test server or from a production to a test server to try out a new release of Essbase software. With Migration Wizard, you can migrate application and database objects without leaving Administration Services Console.

Back to Topic List

In this tutorial, you migrate an Essbase application from an Essbase Release 7.1.0 server (localhost:1425) to a Release 9.3.1 server (WIN3KB) running Shared Services security.

Back to Topic List

Prerequisites

Before starting this tutorial, you should:

1.

Have both an Essbase Release 7.1.0 server and an Essbase Release 9.3.1 server installed and running.

2.

Utilize Shared Services security on one or both servers.

3.

Have an Essbase application on the Release 7.1.0 server available for migrating. This tutorial migrates an application called Mexcorp.

Back to Topic List

Usage Notes

The following points apply to applications migrated using Migration Wizard:

1.

Only application and database objects are migrated. No data is transferred.

2.

Objects and security on the source server are unchanged. Migration Wizard makes copies on the target server.

3.

Source and target servers may be on different operating systems. For example, you can migrate an application from a Windows to a Unix server.

Back to Topic List

Examining Source and Target Servers

From Administration Services Console in the navigation panel, expand the source server node (localhost:1425), then expand the Applications node to reveal the Mexcorp application.

Back to Topic List

Expand the Mexcorp application to reveal the Mexsales database, including the database outline, calculation script CalcMex, and rules file LoadMex.

Back to Topic List

Launching Migration Wizard

From the Administration Services Console control menu, select File > Wizards > Migration.

Back to Topic List

The Migration Wizard dialog box is displayed, showing the following steps to be performed:

Back to Topic List

Selecting Source and Target Servers

From the User level drop-down list, select Novice. From the Source Analytic Server drop-down list, select localhost:1425. Finally, from the Target Analytic Server drop-down list, select WIN3KB, then click Next.

Choosing User level Advanced generates an error, since, under Shared Services security, Essbase does not manage security. Thus, under Shared Services security, users and groups cannot be migrated using Migration Wizard.

Back to Topic List

Selecting Source and Target Applications

From the Source application on Analytic Server drop-down list, select Mexcorp. In the Target application on Analytic Server text box, enter Mexcorp. Finally, select Replace target objects if they exist, then click Next.

Back to Topic List

Selecting Application-Level Objects to Migrate

Ensure that all application-level checkboxes are selected. Click Next.

Back to Topic List

Selecting Database-Level Objects to Migrate

Expand the Databases node and ensure that all database-level checkboxes are selected.

Back to Topic List

Optionally, expand subnodes to see individual objects.

Click Finish.

Back to Topic List

Examining Migration Results

When the migration is complete, a message is displayed in the message panel of Administration Services Console.

In the Navigation panel, expand the target server node (WIN3KB) to reveal the migrated Mexcorp application. If Mexcorp is not displayed, right-click Applications and select Refresh application list.

Back to Topic List

In this lesson, you learned how to migrate an Essbase application from one server to another using Migration Wizard, where Shared Services security is in force.

Back to Topic List

To learn more about migrating Essbase applications using Migration Wizard, you can refer to:

Back to Topic List

Place the cursor over this icon to hide all screenshots.

 

 

 

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy