Replicating Data to Amazon S3

With Syniti Data Replication, you can replicate relational data to an Amazon S3 bucket as a flat file. Amazon S3 is currently supported as a target both in refresh and mirroring. Before setting up Syniti DRto replicate data to S3, install the AWS Toolkit for .NET and set up access keys.

To define a target connection for Amazon S3:

  1. In the Metadata Explorer, choose Targets, then Add New Connection from the right mouse button.

  2. In the Add Target Connection wizard, type a name for the connection and choose Amazon S3 in the Database field.

  3. In the Set Connection String screen, enter values for the following properties:

    Output Folder Local path to temporarily store replication output files
    S3 Access Key The Access Key from your AWS login ID.
    S3 Secret Key The Secret Access Key from your AWS login ID.
    S3 Bucket Name The bucket must already exist. It can either be a bucket that you are already using, or one you have created for this purpose.
    AWS SDK S3 Assembly Path The pathname to AWSSDK.S3.dll installed with the AWS .NET SDK.
    AWS SDK Core Assembly Path The pathname to the AWSSDK.Core.dll installed with the AWS .NET SDK.

  1. Complete the fields in the Target Connection wizard. Use the the User Guide available from the Management Center Help menu or the Setup Guide, available for download in the Help Center as needed.

    2. In the Select Tables screen, if tables already exist, choose the tables to use in replication. Note that you can also create tables, or add them at a later time.

  2. Click Next to display the Actions screen.

  3. Optional. Select the next wizard that you would like to run.

  4. Click Next to display the summary, then click Finish to create the connection.

  5. The next step is to add target output representation to the Metadata Explorer. This will be represented as relational tables.

Now you can set up replications from whichever source connection you have defined.

 

Copyright
Privacy Policy
Trademarks
Terms of Use