Running the InfoCenter Migration Tool
Scenario:
You want to use the InfoCenter Migration Tool to migrate custom InfoCenter templates to run in Desigo CC.
The tool supports migration of most report objects. Templates that contain any other controls do not display and those templates must be created manually.
As it is an independent procedure from configuring the InfoCenter extension module in Desigo CC, the migration tool can be run at any time.
NOTE: In Windows 11 and Windows Server 2022 TLSv1.3 network communication protocol has been enforced. Therefore, InfoCenter migration to Desigo CC installed on Windows 11 and Windows Server 2022 OS is not supported.
Reference:
- For background information, see InfoCenter Migration Tool.
- For a list of supported controls, see Supported Report Template Controls.
Workflow diagram:
Prerequisites:
- You have read and met the prerequisites in the ReadMe.txt file in the following folder on the distribution media:
…\InstallFiles\EM\InfoCenter\AddSW\InfoCenter Report Migration Tool. - You have the InfoCenter Server configuration information available to you.
- You have the migration tool default template path and designated an output directory path for the generated templates.
Steps:
1 – Determine Where the Migration Tool is Deployed
- There are two ways to migrate InfoCenter templates using the InfoCenter Migration Tool. Do one of the following, depending on your set-up:
- If you are running the InfoCenter Migration Tool from the Desigo CC management station or any remote computer able to connect to a database: You must configure the InfoCenter Port and the inbound rules. Proceed to Step 2. Configure the InfoCenter Port and Inbound Rules.
- If you are running the InfoCenter Migration Tool from the InfoCenter computer where the InfoCenter database is located: Proceed to Step 3. Run the InfoCenter Report Migration Tool.
2 – Configure the InfoCenter Port and Inbound Rules
- Launch the SQL Server Configuration Manager, and then navigate to SQL Server Network Configuration (32bit) > Protocols for MSSQLSERVER.
- In the right pane, make sure the TCP/IP option is Enabled, and then right-click the TCP/IP option, and from the context menu select Properties.
- In the TCP/IP Properties window do the following:
a. In the Protocol tab, set Listen All to Yes.
b. The IP Addresses tab displays the port numbers and IP address destinations. Configure the settings as needed.
- Navigate to your Control Panel Windows Firewall, and then click Advanced Settings
- The Windows Firewall with Advance Security displays.
- Click Inbound Rules.
- In the Actions pane, under Inbound Rules, click New Rule.
- The New Inbound Rule Wizard displays.
- Select Port, and then click Next.
- In the Protocol and Ports pane do the following:
a. Select TCP.
b. Select Specific local ports, and then type the port number for the InfoCenter database.
c. Click Next.
- In the Action pane, choose the appropriate action that should be taken when there is a connection match, and then click Next.
- In the Profile pane, choose the options that apply for the Inbound/Outbound Rules, and then click Next.
- In the Name pane, type an appropriate Name and Description (Optional) for the rule, and then click Finish.
- The new rule is now listed in the Inbound Rules pane.
3 – Run the InfoCenter Report Migration Tool
- Using a command prompt that has elevated Admin privileges navigate to the location of the migration tool: [Drive location]:\ [File location]>java –jar ReportMigrationTool.jar
- From the keyboard, press ENTER.
- The Report Migration pane displays.
- In the Report Migration pane, enter the following InfoCenter information:
- Server name – The IP address or the host name of the server that hosts the InfoCenter database.
- Database name – The name of the SQL database that contains the templates you want to retrieve.
- Database port – The port number the database uses. The default port is 1433.
- Database username – The user name that has access to the SQL database.
- Database password – The username password for the user.
- Operator ID – The user ID associated with the database username.
- Browse to or enter the correct file path for the migration report tool and the output directory for the migrated templates:
- Default template path – The location of the default.rptdesign.
- Output Directory path – The directory where you want to save the migrated templates: Program Files > Apache Software Foundation > Tomcat 9.0 > WebApps > GMS-BIRT > [Project System ID Number] > GMS_InfoCenter
- Click Next.
- A list of all the available templates in the database display.
- Select the check box next to the templates you want to migrate, or click Select All, to migrate all the templates.
- Click OK to confirm migration.
- The migration process begins and the selected templates are migrated and the rptdesign files for each template is generated in the designated Output directory path.