Replicating Data to Azure Data Lake Storage Gen 1

With Syniti Data Replication, you can replicate relational data to Microsoft Azure Data Lake storage Gen 1 as a flat file. ADLS is currently supported as a target both in refresh and mirroring. Before setting up Syniti DR to replicate data to ADLS, install the packages for Data Lake.

To define a target connection for ADLS:

  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 Azure Data Lake in the Database field.

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

    Output Folder The location of the schema for config files for the ADLS objects
    Domain The name of the domain associated with the Azure Active Directory App used to upload data to Azure Data Lake
    Client Id Client ID in GUID format that identifies the client application
    Client Secret Client secret token used from the client application
    Account Name The name of the Data Lake Storage Gen1 account used to load data
    Target Directory Target location where to load data in Data Lake

  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.