Migration Tool
The DCM Migration tool aims to provide a programmatic approach to replace your legacy connection strings stored in workflows with DCM-utilizing connections. Simply provide a set of workflow files, review the automatically matched DCM connections for each connection string, and your workflows update automatically.
To launch the DCM Migration tool, select Options > DCM Migration Tool in the Designer main menu.
Start migration by selecting the Browse Files or Browse Folders button.
Choose your workflow files to migrate. You can select multiple files at once or an entire folder, and the tool will then scan the selected folder for supported workflow files.
Define your output.
Should you choose the same folder for the output, you can select to Overwrite Existing Files by the migrated files or to Add Suffix to Each Workflow.
Select Copy Workflows to a Selected Folder to output the migrated files to the desired folder.
Select the Load Files button.
After loading the files, the Migration tool scans each file for supported connection strings, aggregates unique connection strings on each tool type, and tries to find the best DCM match for your workflow connections.
If the DCM connection matches perfectly, it is listed as an Exact match.
If there’s a slight difference between the connection string and the DCM Connection (such as an outdated password, a missing port, etc.), the DCM connection is listed as a Partial match.
If the match isn’t right or if there’s no matching connection available, check the propriety of other connections offered.
By selecting the dropdown menu for connection strings without a match, you can Select Another Connection or Create New connection, which opens the Connection Manager window.
You can then browse the Connection Manager for a suitable connection and select Connect on the right one, just like on the canvas tool configuration.
To create a new connection, choose the data source technology for your connection, fill in the information in the Connection Manager window, select Save and Link, and then Connect.
You can re-run the matching process for each connection by selecting the circular arrows symbol. This will not update the existing selection but will refresh the list of suggested connections.
Select the Migrate button to start the migration.
Upon completion, the tool displays the migration result. You can review warnings and errors.
By selecting Download Log (.ndjson) you can download and save the full migration log in the .ndjson format, with individual migration process steps and a more detailed error description.
Supported Tools and Technologies
Workflow files, including .yxmd (regular workflow), .yxwz (analytic apps), and .yxmc (macros), are supported.
All ODBC connections (both DSN and Quick Connect) in the Input Data and Output Data tools are collected during workflow parsing. User and Gallery aliases are also listed, although automatic DCM connection matching is currently unavailable for these connections.
Other tools, such as In-DB, Download, and Email tools, are currently not supported.