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.
If you intend populating any of your Data Tables 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, use ClearSCADA's Data Access components for that data transfer (see Install Data Access Components on a Third Party ODBC Client in the ClearSCADA Guide to Client Administration).
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, see Server Automation.
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 SQL Guide. (Remember that if you want to include SQL queries in a Logic program, that program has to be a Structured Text program.)