Replicating Data to an XML File

With Syniti Data Replication, you can replicate relational data to an XML file. This type of replication is currently supported as a target both in refresh and mirroring.

To define a target connection for XML:

  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 Files - XML in the Database field.

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

    Output Folder Local path to store replication output files
    Catalog Folder The path to a directory to contain the XSD schema files
    Root XML Schema Element Name The name of the root element of the output XML file
    Represent Database Columns As Choose Element or Attribute to determine how source table columns will be organized in the output XML files. This field sets the default value that will be applied to all the columns of each table in this target connection. When completing the Create Target Table Wizard (Define Columns screen), you can change the value for each column.

  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.