One-to-Many Data Migration

appRules features an unmatched number of options for migrating, replicating and synchronizing data.

Product & Hosting Options

Platform Product Availability

The workflow activities and other modules used in this sample project are available in the following appRules Platform products:

Platform ProductAvailability

appRules Data Migration Engine

appRules Integration & Automation Engine

appRules Enterprise 360

Hosting & Execution Environment

If you are running the On-Premise, Azure Marketplace or AWS Marketplace editions, the following hosting options supported by appRules are recommended for running this sample project:

Hosting OptionRecommended for Project

IIS

appRules Host Service

appRules Desktop

Since the appRules Host Service is automatically installed and ready to go, it is recommended that you use it for evaluating this sample project. Just point your browser to the appRules URL

The completed project is available in the appRules Samples project database. Click the "Open" toolbar button on the appRules home page to select the "Replicate Dynamics365 In Snowflake" project.

The One-to-Many Data Migration sample project demonstrates how to use the appRules MigrateData activity to perform One-to-Many data migrations.

In the sample project, a single activity is configured to load the Customers table from the SQL Database into the Account and Contact tables in Salesforce.

The process is the same not only for Salesforce but for other data sources, such as Dynamics365, Snowflake, etc. and does not require any code or scripts.

You will need to use your own credentials to access Salesforce to run this project.

Drag the MigrateData activity from the Migrate-Replicate-Synchronize module of the toolbox on to the designer and configure it as follows:

Select the default Source, Data Migration Type, and default Target:

Configure the Source Entity, the Primary Target Entity, and Secondary Target Entities:

Complete the configuration of the Target Entities to suit your needs including mapping, etc:

Notice the entries in the SecondaryEntities collection. Configure to suit your needs - mapping etc:

After running the project, you can view the Project Details and Audit Logs records and statistics.

Last updated