Source data configuration

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

Once connections are established, you will configure the source data by selecting specific tables or datasets for replication. Here, you can define conditions to refine your data selection, ensuring that only relevant information is transferred and optimizing performance.
  • Log reader: For IBM i data connections, the Log reader for journal drop-down list displays. Log readers may already exist. If not, you can autogenerate one. Click Configuration to open the Log Reader Configuration window, and make edits as needed.
  • Schemas (Libraries): Displays all schemas available for the selected data connection. Connect to the source datastore and extract the tables for replication. Schema registry can be configured in different modes:
    • backward compatibility: When you have a version, you can only delete in the mode.
    • forward compatibility: In this mode, you can only add new rows or modify information in the Target fields.
    • full mode: In this mode, you can add, remove, and modify information in the Target fields.
  • Tables
    • The Journal column shows the name of the journal associated with the tables in the schema.
    • If you are autogenerating a new log reader, the Journal column is filtered to show All Journals. You can filter the list by entering some or all of the name in the search field and clicking the Filter button. Ensure you select tables that use the same journal.
    • If you selected an existing log reader, the Tables and Journal columns are filtered to show only those items associated with the log reader.
    • Advanced table selection: Use the Advanced Search to quickly locate and select multiple tables when working with large datasets. Click Advanced Search above the Tables pane to open the filter dialog. You can enter:
      • A CSV list, comma-separated list of table names to match and select multiple tables at once. Example: CUSTOMERS, ORDERS, SALES_DATA.
      • A regular expression (RegEX) pattern to match table names dynamically. Example: ^sales_[0-9]{4}$ matches tables like sales_2020, sales_2021.
      Matching tables are automatically selected. If any entries do not match, an inline error is shown.
  • Columns: The Column and Data Type columns open showing the name of each column in the table and each column's data type (for example, DECIMAL, VARCHAR, and so on) and the content of the table with the schema applied.