Post-migration tasks

After migrating the data warehouse projects with the InfoSphere Warehouse Migration wizard, you must perform some post-migration tasks to ensure that you do not face errors when using the migrated data warehouse projects in the Design Studio. You must also specify the install location of the InfoSphere Warehouse in the config.properties file before you start using the Administration Console.

Before you begin

• Migrate the data warehouse projects from Data Warehouse Edition V9.1.x to InfoSphere Warehouse.

ProcedurePerform the following post-migration tasks:

1. Switch to a new workspace for working with the migrated projects in the Design Studio, Version 9.5.1
2. Import the migrated projects into this new workspace:
   1. Click File > Import. The Import window opens.
   2. Click General > Existing Projects into Workspace and then click Next.
   3. Browse to the directory that contains the migrated projects.
   4. Select the projects that you want to import in the workspace and click Finish. The imported projects are displayed in the Data Project Explorer.
   Recommended: After migrating the old Data Warehouse Edition V9.1.x projects to InfoSphere Warehouse, import the migrated projects to a new workspace before you start using these projects in InfoSphere Warehouse. If you accidentally or intentionally import the migrated projects to an old workspace that was used in Data Warehouse Edition V9.1.x, you might not see some of the views in the BI perspective or the new menu shortcuts (for example, Workload Management, Text Analysis, and so on). Therefore, to continue using the old workspace, you must perform one of the following two steps:

   • Reset the BI perspective by selecting Window > Reset Perspective.
   • Select Window > Customize Perspective and select the shortcuts that you would like to see in the various menus of the BI perspective.
3. Re-create the database connections in the Database Explorer view. The migration wizard does not migrate the workspace preferences and the database connections to the destination directory. Only the data warehouse projects that are contained in the source directory are migrated. Therefore, you must re-create the database connections in the Database Explorer view.
4. If you migrated mining flows that are contained in your data warehouse projects, then you must restore the links to the database connections that are used by the mining flows. Perform one of the following two steps:
   • In the Data Project Explorer, right-click the Mining Flows folder in your data warehouse project. Select Set Online Database and then select the mining flows for which you want to restore the database links. Design Studio sets the online database to the same value as the SQL execution database for each of the selected mining flows.
   • Alternatively, you can right-click the name of mining flow and select the Set Database option. Then, select the name of the database connection and click OK. This is not a convenient method to restore database links, particularly when you have to restore links to several database connections.
5. Before you start using the InfoSphere Warehouse Administration Console, perform these steps:
   1. Open the config.properties file that is located in the InfoSphere Warehouse installation directory (product_installation_directory\DWEAdmin\lib\custom).
   2. Add the keyword dwe.installLocation and specify the complete path to the product installation directory.
      For example, dwe.installLocation = C\:Program Files\IBM\dwe95
      Remember: The keyword dwe.installLocation is case sensitive.
   3. Restart the WebSphere^® Application Server.