Ready to get started?


Learn More

Automated Continuous Dynamics GP Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Dynamics GP replication to Amazon Redshift.

Always-on applications rely on automatic failover capabilities and real-time data access. CData Sync integrates live Dynamics GP data into your Amazon Redshift instance, allowing you to consolidate all of your data into a single location for archiving, reporting, analytics, machine learning, artificial intelligence and more.

Configure Amazon Redshift as a Replication Destination

Using CData Sync, you can replicate Dynamics GP data to Amazon Redshift. To add a replication destination, navigate to the Connections tab.

  1. Click Add Connection.
  2. Select Amazon Redshift as a destination.
  3. Enter the necessary connection properties. To connect to Amazon Redshift, set the following:
    • Port: Set this to the port of the cluster.

    You can obtain these values values in the AWS Management Console:

    1. Open the Amazon Redshift console.
    3. On the Configuration tab, obtain the properties from the Cluster Database Properties section. The connection property values will be the same as the values set in the ODBC URL.

  5. Click Save Changes.

Configure the Dynamics GP Connection

You can configure a connection to Dynamics GP from the Connections tab. To add a connection to your Dynamics GP account, navigate to the Connections tab.

  1. Click Add Connection.
  2. Select a source (Dynamics GP).
  3. Configure the connection properties.

    To authenticate set the User and Password connection properties.

    To connect set the URL to the Web services endpoint; for example, http://{servername}:{port}/Dynamics/GPService. Additionally, set CompanyId; you can obtain this value in the company setup window: Click Tools -> Setup -> Company.

    By default, data summaries are not returned to save performance. Set LookupIds to true to return details such as line items; however, note that entities must be retrieved one at a time.

  5. Click Save Changes.

Configure Replication Queries


Replicate Entire Tables


Customize Your Replication


Schedule Your Replication


Once you have configured the replication job, click Save Changes. You can configure any number of jobs to manage the replication of your Dynamics GP data to Amazon Redshift.