Migrate a large set of accounts from one database instance to another. This application leverages the Batch Module. This batch job is divided into the Process and On Complete stages.
You can use this template for free with the Mule Runtime Enterprise Edition, Runtime Manager/CloudHub, or as a trial in Anypoint Studio. This Template serves as a foundation for the process of migrating accounts from Database A to Database B, and provides filtering criteria when an account already exists in the Database B.
During the Input stage the Template selects all existing Accounts that match the filtering criteria from Database A. This template requires two databases to work correctly. The template also provides an SQL script to create the database table that the template uses. The SQL script files can be found in src/main/resources/.
This template is customized for MySQL. To use it with different SQL implementation, some changes are necessary:
The last step of the Process stage creates and updates the accounts in Database B. In addition, the application also performs a lookup and assigns account representatives based on the zip code of the source Account.
The Template shows the statistics of the data migration in the Studio console and sends a notification email with the results of the batch execution.
Read through the Documentation to learn how to run this application.
The latest version includes MUnit Integrations tests that are packaged in the project folder. You can leverage these tests to better understand best practices in testing Mule flows using the built-in features in Anypoint Platform.
|Published on||Aug 6, 2018|