Quick Start Guide

Component Overview

Migration-center has 3 main components: Database component, Windows Client and Jobserver component.

The Database stores all the migration-center configurations and all scanned and imported objects with their source and target metadata.

The MC Client is the UI where you can manage all the scanner, importer and migset configurations and you can trigger scan, import or transformation jobs. Multiple Clients can be installed.

The Jobserver component receives the scan or import configuration from the Client and connects to source/target systems to extract/import objects, processes metadata into/from the Database and the content into/from the file system staging area. Multiple Jobservers can be installed.

Component installation

This is just a quick overview of the installation process. For specific details please see System Requirements and Installation Guide.

All main migration-center components can be installed either on the same machine or on separate machines, by using the windows installers.

The Database installer needs a 32-bit Oracle Client to connect to the Oracle Database and install the migration-center schema. If the installer is run directly on the Oracle Server, the Oracle Database needs to be 32-bit for the installer to see it, otherwise an 32-bit Oracle Client needs to be installed as well.

The Jobserver installer can be run on any windows machine, but to actually start the Jobserver you need Java 8 or 11 installed. The Linux Jobserver does not have an installer, it has scripts to install the service.

The MC Client installer can be run on any Windows machine as well, but to connect the Client to the Oracle Database it also needs a 32-bit Oracle Client configured or a 32-bit Oracle Database if it is installed on the Oracle server. The Oracle Client must have the connection information of the Database in its tnsnames.ora file.

Component port connections

The Client connects as follows: - to the Database via Oracle Client through the Oracle port, default is 1521 - to the Jobserver via port 9700 by default (this can be changed in the ...\lib\mc-core\server-config.properties​ file)

The Jobserver connects as follows: - to the Database via JDBC connection on the same Oracle port as the Client - to each source or target system differently based on the system itself

When using the scheduler feature the job will be triggered by the Database instance itself, therefore the Database machine will also connect to the Jobserver via port 9700 by default.

Here is a diagram of the mentioned port connections:

Migration Process

The general process of performing migrations with migration-center is done in several steps:

The Analyze phase involves configuring a Scanner to connect to a Source System, that will extract the metadata and save it as objects in the migration-center database, and export the content to a defined Filesystem location, which acts as a staging area.

The Organize phase involves assigning Scan Runs into Migration Sets, or migsets for short.

The next 3 phases, Transform, Validate and Correct, work together and involve creating Transformation Rules by which your Source Metadata is Transformed into Target Metadata. The metadata is assigned to Target Type definitions, which can be defined in advance. And based on those definitions the metadata is Validated. If the resulting target metadata is not the desired one, you can reset the objects and repeat the process by correcting or adding transformation rules.

The Import phase, is the last step, and involves creating an Importer, which will connect to the Target System, assigning a migset with Validated Objects to it and starting the import run. You can monitor the progress in the importer run history or directly in the migsets view.

All the migration phases can be done in parallel for different batches of documents that are migrated.

Starting the Client

When you first start the migration-center Client you will see a login window.

The default login user is fmemc and the default password is migration123. From the Database dropdown select the your database instance where you installed the migration-center database component.

Defining a Jobserver

Before you are able to run a scanner you first need to define a Jobserver.

Open to the Jobservers Definition window and enter the hostname of the machine, where the Jobserver component is installed, and the port (default is 9700).

Creating a Scanner

Open the Scanners window and click on the new button on the left:

Fill in the Name of this scanner, select a type and select a Jobserver where you want this scan to run.

After you have completed at least all the mandatory parameters of the scanner configuration you can save it by clicking on OK.

You can run it by hitting Run in the toolbar, or in the Right Click context menu.

Clicking on History allows you to see a list of all Scan Runs performed by the this scanner configuration.

Clicking on View Scanned Objects shows you the Source Objects grid for this scanner or scan run.

Creating a Migset

Open the Migsets window and click on the new button on the left. Enter a name for this migset and select the Migration Path from the Type dropdown.

From the next tab, Filescan Selection, you will see the scan runs corresponding to your chosen migration-path. Select which scan runs you want to include in this migset by double clicking them or by using the down arrow button.

Filtering the objects (optional)

As an optional step before clicking on the Select Objects button, there are 2 filtering options:

Simple Filtering, where you can exclude objects based on their values:

Advanced Filtering, where you can create rules by which to select the objects:

Creating Transformation Rules

With the Migset you have just created selected, click on the Edit Transformation Rules from the toolbar or from the right click context menu.

Regular Transformation Rules

The Rules section in the top left corner lists the Transformation Rules created so far in this migset. You can create a new one using the New button. In the middle there's the Rule Properties section where you can specify the rule Name and if it should return multi-value results.

The Transformation methods section contains a dropdown of all the Functions that you can use inside your transformation rule. These functions take Source Attributes and static values to generate a new value as a Target Attribute. Multiple functions can be linked together by processing the result of a Previous Step:

As you can imaging this is the main strength of migration-center as it allows you to create very complex rules to ensure you get the required results in your Target System.

System rules

On the bottom left corner we have the Rules for system attributes. These function the same as the regular transformation rules, except they have a fixed name and therefore serve a specific purpose during the import. Please refer to the user guide of the Importer you are using for details on what each system rule does.

Associations

On the Associations tab of the transformation rules window you can associate the previously defined Transformation rules to a Target Attribute of an object type.

First you must select a rule which will determine what object type each object will have. This is done from the Get type name from rule dropdown and in most cases there already is a system rule for this purpose. Based on the value this rule returns, each object will be associated with a target type from the list below.

The Available Type Definitions shows you a list of all Object Type Definitions in migration-center and you can select which ones are to be used in this migset. In the screenshot above we have selected opentext_document and opentext_rm_classification.

Clicking through the list of select types will show, on the right side, the current associations between Rules and Target attributes.

Object Type Definitions

To mange the available object types in migration-center go to Manage -> Object Types...

This will open Object Type definition window where you can create new Types and either manually adding each of the type's attributes or importing them from a CSV file. More details are in the Client User Guide.

Transforming and Validating objects

After you have finished writing the necessary transformation rules you can save the migset, and trigger Transformation and then Validation on the migset.

Transformation will apply the rules in the migset on each object individually and will generate the target objects. The objects will move to the Transformed state.

Validation will compare the generated values against the object type definition restrictions to ensure the values fit. If successful the objects will move to the Validated state.

After doing the transformation, the Target Objects can be viewed in the Processed Objects view.

If any issue occurred during transformation or validation, the objects will move to the Error state and can be checked in the Error Objects view.

Creating an Importer

The Importers section is very similar to the Scanners one so we will only cover the differences.

After setting all necessary parameters for your import to function correctly you must go to the Migsets tab which will allow you to select one or more migsets for import. After that you can save the importer and run it.

You can monitor the status of the import either in the the Jobs view, in the importer History or in the Migsets view. Each view will show the progress of the migration in varying levels of detail, with the migsets one showing the most details of the objects being imported.

When the import has finished you can see the status changed to Finished and all the objects marked as Imported. If any errors or warnings occurred you can view them either in the Error Objects view of the migset or by opening the import run log from the history of the importer.

Important Features

Creating a Scheduled Job

You can automate the migration process from Scan to Import by using the Scheduler feature. This is very useful in setting up a continuous migration of active systems where the users are still modifying and creating documents.

How it works: You create a scheduled job and select existing valid scanner, migset and importer configurations. If the Scheduler is set to active and depending on what interval settings are set, the scheduler will automatically perform the following actions: - Start the scanner - Create a copy of your migset and assign the scanned objects to it - Run Transformation and Validation - Assign the migset to the importer - Start the importer - (optional) send an email report if configured

Create a new Scheduler and enter the Name and Description.

Next, on the Configuration tab, you can select your Scanner, Migset and Importer. You can also configure the email reporting feature.

Next, on the Interval tab, you have all the options to configure when your scheduled job will trigger and when it will stop triggering.

You can click on Ok or Apply to save the Scheduler and it will start at the scheduled time.

If you open the History tab you can see the list of all runs of the scheduler along with some information about the status of each run.

Mapping Lists

The mapping lists are a simple and very powerful feature of migration-center. They can be used for a wide variety of scenarios.

A mapping list is just a collection of key - value pairs. You can either create one globally using the Manage -> Global Mapping Lists... menu. This will make the mapping list available for use in any migset.

Or you can create it directly in a migset for use only in that migset.

To use your created mapping list you must use the mapValue() function inside a migset's transformation rules.

The value to be transformed is matched with the values in the Key column of the mapping list. If a value is found then the function returns the equivalent value from the Value column. If the value cannot be matched or the source value is null, the function will trigger a Transformation error on the object or return an empty value (depending if Report missing values is set to 1 or 0).