Friday, December 28, 2012

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


Purpose


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.


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.

Scenario


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.

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.

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.

Examining Source and Target Servers


1.
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.
Screenshot for Step
2.
Expand the Mexcorp application to reveal the Mexsales database, including the database outline, calculation script CalcMex, and rules file LoadMex.
Screenshot for Step

Launching Migration Wizard


From the Administration Services Console control menu, select File > Wizards > Migration.
Screenshot for Step
The Migration Wizard dialog box is displayed, showing the following steps to be performed:
Screenshot for Step

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.
Screenshot for Step
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.
Screenshot for Step

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.
Screenshot for Step

Selecting Application-Level Objects to Migrate


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

Selecting Database-Level Objects to Migrate


1.
Expand the Databases node and ensure that all database-level checkboxes are selected.
Screenshot for Step
2.
Optionally, expand subnodes to see individual objects.
Screenshot for Step
3.
Click Finish.
When the migration is complete, a message is displayed in the message panel of Administration Services Console.
Screenshot for Step

Examining Migration Results


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.
Screenshot for Step

Summary


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.