Control-M for Databases Plug-in Migration Tool

The Control-M for Databases Plug-in Migration Tool converts the Control-M for Databases plug-in to Control-M for Snowflake.

Migrating Control-M for Databases to Control-M for Snowflake

This procedure describes how to migrate the Control-M for Databases plug-in to Control-M for Snowflake plug-in.

Before You Begin

• Install Control-M for Snowflake and create a connection profile.

Begin

1. Download the Control-M Migration Tool for Integrations from EPD.

2. Extract the downloaded files into a temporary directory.

3. Export the workspace with Control-M for Databases jobs to a JSON file, as described in Exporting a Workspace.

4. Edit the configuration file with the following steps:

   1. Navigate to the Control-M Migration Tool for Integrations directory that you downloaded.

   2. Open the migration_configuration_file.json in a text editor.

   3. Add the job type, connection profiles, and hosts that you want to convert. See Configuration File Parameters.

5. Do one of the following to run the migration tool:

   • Windows: Run the following command:

     plugins_migration_tool.exe -i <Exported_Workspace_Pathname> -c <Migration_Configuration_File_Pathname> -o <Output_File_Pathname>

     For more information, see Control-M Migration Tool Parameters.

   • UNIX: Do the following:

     1. Run the following command to ensure the migration tool has execution permissions:

        chmod +x plugins_migration_tool

     2. Run the following command:

        ./plugins_migration_tool -i <Exported_Workspace_Pathname> -c <Migration_Configuration_File_Pathname> -o <Output_File_Pathname>

        For more information, see Control-M Migration Tool Parameters.

6. Import the output file with the updated job definitions, as described in Importing a Workspace.

Configuration File Parameters

Control-M Migration Tool for Integrations contains the migration_configuration_file.json file that instructs the Control-M Migration Tool how to handle the different job types in the exported JSON file.

You must edit the configuration file with the job type, connection profiles, and hosts that you want to convert. The Control-M Migration Tool only converts the job types, connection profiles, or hosts that you define in the configuration file.

The following example shows a configuration file to migrate the original Control-M for Databases to Control-M for Snowflake:

[
    {
        "Type": "Job:Database",
        "ConnectionProfile": "{Databases1:Snowflake1},{Databases2:Snowflake2}",
        "Host": "{Databases_Host1:Snowflake_Agent1},{Databases_Host2:Snowflake_Agent2}",
        "Database": "{*:Database_Name}",
        "Schema": "{*:Schema_Name}"
    }  
]

The following table describes the migration_configuration_file.json file parameters.

Control-M Migration Tool Parameters

The following table describes the migration tool parameters.