Data Tables are designed to be populated automatically.
Use whichever supported application is suitable for populating your Data Tables with the records that they are to store.
Your ClearSCADA system might, for example, include Data Tables that are configured to store the values of custom calculations that are running in Logic programs, or that store data values from third-party applications, with the Data Tables enabling operators to view the data from those applications, while logged on to ClearSCADA.
Be aware that if any of your Data Tables are to be populated with data from a third-party application, and that application is to transfer its data to ClearSCADA using Open DataBase Connectivity (ODBC) data transfer standards, your ClearSCADA system needs to be running the ClearSCADA ODBC driver. For information on transferring data to ClearSCADA using ODBC, see the ClearSCADA Guide to the ODBC Driver (as with other drivers in ClearSCADA, your system will require a license to run this driver).
Server Automation is a programming interface that enables external programs to interface with ClearSCADA. You can use Server Automation to automatically populate Data Tables with the records that they are to store. For further information on Server Automation, see the online Server Automation technical reference.
You can use Logic and/or SQL to automatically populate Data Tables with the records that they are to store. For an example that uses a Structured Text Logic program to call an SQL query in order to populate a Data Table, see Example Configuration. For further information on using Logic, see the ClearSCADA Guide to Logic. For information on the SQL commands that are supported by ClearSCADA, see the online SQL Technical Reference. (Remember that if you want to include SQL queries in a Logic program, that program has to be a Structured Text program.)