GIS synchronization (SQL Server)

GIS synchronization for Oracle will be generally available in a future update.

These tools are used to synchronize data between Infor Public Sector and your GIS. You can import location-based records such as addresses and parcels, and you can compare records that exist in both databases to make sure they match.

Synchronization is based on mappings that you create using the new Create GIS Mapping form. Each mapping specifies an Infor Public Sector component and the corresponding GIS layer, and indicates how specific fields in each dataset are mapped to each other. For example, the StreetNumber field of the Address component might be mapped to the STRNO field in the GIS Addresses layer, and so on.

After you create your mappings, you can use the new GIS Feature Synchronization task in the Batch Manager to synchronize your data. The task compares records in the two datasets and identifies inconsistencies such as data mismatches and orphans. Based on these findings, the task can then synchronize data in either direction.

The task creates detailed records so you can track the results. These records include sync batches, which are the primary records used to manage the synchronization process; sync audits, which compare individual records and report on the results; and sync integrations, which track the movement of data between the two systems. New lookups and InfoViewers are included so you can review and process these records.