Ingest Data from Wonderware Historian

Many industrial teams rely on Wonderware Historian (now known as AVEVA Historian) to collect years of operational data from SCADA, HMI, and other systems. But as analytics requirements grow and cloud adoption accelerates, organizations increasingly need more scalable, cost-efficient, and open ways to store and analyze time-series data. TDengine TSDB provides a modern alternative, offering high-performance ingestion, standard SQL, and a much lower total cost of ownership. This guide will walk through how to pull data from Wonderware Historian and ingest it into TDengine, either migrating from Wonderware or synchronizing existing data, enabling you to modernize your architecture without disrupting existing operations.

Ingest Data from Wonderware Historian to TDengine TSDB

In this procedure, you can choose to migrate or synchronize data from Wonderware to TDengine TSDB.

1. Log in to TDengine TSDB-Explorer, open the Data In tab, and click Add Source.

   

2. Configure basic information as follows:

   1. Name: Enter a unique name for the data replication task.

   2. Type: Select AVEVA Historian.

   3. (Optional) Agent: If needed, select an existing agent from the dropdown menu or click Create New Agent.

   4. Target: Specify the TDengine database to which you want to write data from Wonderware Historian. If you do not have a database prepared, click Create Database.

   

3. Under Connection Configuration, enter the hostname and port number of the SQL Server for your Wonderware Historian.

   

4. Under Authentication, enter the username and password with which you want to connect to the SQL Server for your Wonderware Historian.

   

   Then click Check Connection to verify that you can obtain data from the source MySQL database.

5. Configure the Collect section to migrate data to TDengine TSDB, synchronize historical data to TDengine TSDB, or synchronize real-time data to TDengine TSDB.

   • To migrate data, select migrate from the Collection Mode dropdown list.

     • In Tags, fill in the list of tags to migrate, separated by commas (,).
     • In Tag List Size, fill in the size of the tag group.
     • In Begin Time, fill in the start time of the data migration task.
     • In End Time, fill in the end time of the data migration task.
     • In Time Window, fill in a time interval, the data migration task will divide time windows according to this interval.
     

   • To synchronize historical data, select synchronize from the Collection Mode dropdown list. Then in the Table field, select Runtime.dbo.History.

     • In Tags, fill in the list of tags to migrate, separated by commas (,).
     • In Tag List Size, fill in the size of the tag group.
     • In Begin Time, fill in the start time of the data migration task.
     • In Time Window, fill in a time interval, the historical data part will divide time windows according to this interval.
     • In Retrieve Interval, fill in a time interval, the real-time data part will poll data according to this interval.
     • In Tolerance, fill in a time interval, data that enters the database after this time during real-time data synchronization may be lost.
     

   • To synchronize real-time data, select synchronize from the Collection Mode dropdown list. Then in the Table field, select Runtime.dbo.Live.

     • In Tags, fill in the list of tags to migrate, separated by commas (,).
     • In Retrieve Interval, fill in a time interval, the real-time data part will poll data according to this interval.
     

6. Fill in the data mapping related configuration parameters in the Data Mapping area.

   • Click the Retrieve from Server button to fetch sample data from the AVEVA Historian server.
   • In Extract or Split from Column, fill in the fields to extract or split from the message body, for example: split the vValue field into vValue_0 and vValue_1, select the split extractor, fill in the separator as ,, and number as 2.
   • In Filter, fill in the filtering conditions, for example: enter Value > 0, then only data where Value is greater than 0 will be written to TDengine.
   • In Mapping, select the supertable in TDengine to which you want to map, as well as the columns to map to the supertable.
   • Click Preview to view the results of the mapping.
   

7. Click Submit to create the data ingestion task from Wonderware Historian to TDengine TSDB, and return to the Data Source List page to view the task execution status.