SQL Server - Precisely Data Integrity Suite

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
2026

Set up SQL Server as a data connection for replication pipelines in the Data Integrity Suite.

Before you configure SQL Server as a replication connection, ensure you have the following:

  • SQL Server database server hostname or IP address
  • Database name
  • User credentials (username and password)
  • An agent configured to access the database
  • A replication engine selected or available to add

SQL Server can be configured as both a source and target for replication. You can set up continuous replication to keep data synchronized in real-time or near-real-time.

  1. In the Data Integrity Suite, navigate to Datasources.
  2. Click Add Datasource or select an existing SQL Server datasource
  3. Complete the basic data connection configuration fields. For detailed information about configuring other fields, refer to SQL Server datasource documentation.
  4. Enable replication by toggling the replication option ON. And choose the replication engine from the dropdown list
  5. Click Test Connection to verify that the connection is configured correctly.
  6. Click Save to save the SQL Server replication connection.

You've successfully configured SQL Server as a replication connection. The connection is now available for use in replication pipelines. You can now create or edit replication pipelines that use this SQL Server connection as a source or target.