Create and manage replication connection

Data Integrity Suite
Product
Spatial_Analytics
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2025

After you create a continuous replication data connection, you can edit, delete, or view the connection.

Create a replication connection

  1. Navigate to Configuration > Replication Connections.
  2. Click + Add Data Connection. Opens New Replication Connection window.
  3. Specify properties depending on your connection type.
  4. Select the appropriate engine while configuring the connection. The replication engine establishes connections and manages tasks like monitoring data flow, ensuring consistency, and handling errors. It ensures real-time updates from the source to the target, enhancing the reliability and efficiency of data replication.
  5. Click Test. If the connection is successful, a confirmation message is displayed.
  6. Click Save to return to Replication Connections page. The new connection has been added to the connections table.

Test a replication connection

  1. Navigate to Configuration > Replication Connections.
  2. Click the ellipsis next to the data connections and select Test. If the connection is successful, a confirmation message is displayed.

Catalog replication connection

The catalog step in a data replication organizes and documents data assets in a centralized repository for easy access. You can search for assets by the name or type, view respective columns and fields. Cataloged assets can also be integrated into data replication processes, enhancing overall data management through improved organization and accessibility.

  1. Navigate to Configuration > Replication Connections.
  2. Click the ellipsis next to the data connections and select Catalog from the menu.
  3. Opens the catalog window, where you can perform the following actions:
    • Start Cataloging: Initiates the process of cataloging or organizing data. Cataloging involves creating a structured inventory of the available data assets, including databases, tables, files, and other data sources.
    • Stop Cataloging: Halts the process of organizing the data. This action is performed when the user needs to pause or cancel the cataloging process for any reason.
    • Remove Catalog information: Information about your data will be removed from the Data Integrity Suite data catalog and will no longer be available to use within the Data Integrity Suite.Your data is not affected. To confirm, click Remove.

Selective Cataloging

Schemas are cataloged completely, regardless of the number of tables used from that schema. With the new feature, you can now replicate only selected tables from a large schema. Use the filtering option to catalog only the tables you require.

Note: The Selective cataloging is only available with Db2 i and SQL server data connection.
  1. Click the ellipsis next to the Db2 i or SQL server data connection, then select Catalog. This will open the Catalog page.
  2. Click All datasets next to the schema name to open the Datasets to Catalog dialog. In the dialog, choose either All or Specific datasets.
    1. If All is selected, the entire schema will be cataloged.
    2. If specific datasets is selected, only the specified tables will be cataloged. Use the Search function to filter the catalog by entering the table name(s) in the text field, separating multiple table names with commas.
      Note: According to Oracle's behaviour, if you create a table and use quotes around its name, Oracle will keep the case as you typed it. But if you don't use quotes, Oracle will automatically change the table name to uppercase. So, when you're specifically choosing tables in Oracle, make sure you type the table name correctly in the input box for selective cataloging. For more details, you can visit Database Object Names and Qualifiers.

  3. Click Save to return to the Catalog page.

  4. Select the newly created schema and click Start Cataloging to begin the cataloging process.

Edit replication connection

  1. Navigate to Configuration > Replication Connections.
  2. Click the ellipsis next to the data connections and select Edit. This action opens the Edit Data Connection window.
  3. If a description was not provided during configuration, enter a brief description in theDescription field.
  4. Depending on your connection type, modify properties as needed.
  5. Click Test to ensure that your credentials are valid for the properties entered.
  6. Click Save to update the connection.

Delete replication connection

  1. Navigate to Configuration > Replication Connections.
  2. Click the ellipsis next to the data connections and select Duplicate. This action opens the Delete Connections window.
  3. To confirm, click Delete to remove the selected connections.

View details of a replication connection

You can view the replication data connection details for information on the current statuses and time interval between when data changed on the source and when it was captured. For example, not all details are valid for copy replication data connection.

  1. Select Configuration > Replication Connections.
  2. Click the ellipsis next to the data connections and select Details. The Data Connection Details page opens.
  3. Click Refresh to see the latest statistics, details, and statuses.
  4. Click Close.