DBSync is a powerful tool that simplifies the process of maintaining tag databases for businesses. It compares and synchronizes data from a variety of sources, including AVEVA PI Data Archive Server, Siemens, GE Habitat, OPC, DNP, and Modbus, eliminating the need for time-consuming manual maintenance. With the ability to handle large amounts of data, perform data transformations, and provide recommendations for creating, updating, or editing tags, DBSync streamlines the process and improves accuracy. It also includes a web interface for configuring the tool and reviewing results and supports output in various formats for various databases.
Product Highlights:
- Compares tag databases from various sources such as the AVEVA PI Data Archive Server, Siemens Spectrum, GE Habitat, or OPC with a target PI Data Archive database to provide recommendations to ensure the source is properly represented on the destination
- Eliminates the time-consuming and error-prone process of traditional database maintenance practice
- Ability to handle hundreds of thousands of tags and perform powerful transformations on source tag fields to enforce standards and conventions
Provides recommendations on whether tags should be created, updated, renamed, or retired on the target database while identifying any duplications in the process
- Produces output files in CSV format, ready for you to publish changes to the target database using PI Builder
- Provides a web interface to configure the tool and review the proposed changes
- Any source and/or target databases can be provided in CSV format using a supported schema, and PI Data Archive databases can also use direct read-only connections when allowable by network security
- Currently supports AVEVA PI Data Archive Server as the target database