Sinolta has its own built-in Big Data Historian. It does not require any external database or historian.

Yes. There are two steps:
Set up a Modbus scan-interval to your desired frequency (Windows time resolution is about 20 milliseconds so you may not get 1-millisecond accuracy. To be tested).
From point configuration wizard, go to the Data logging tab and enable the data logging feature.
Ensure the Advanced properties are checked. Enable SOE Logging. This feature allows you to log all point changes to the SOE log database as fast as the Modbus can read the values.

Open the HMI Builder.
Select Library pane at the bottom of the HMI Explorer window.
Select the Advanced Objects tab. You can drag the XY Chart object from this tab and drop it on your screen.
From right-click menu options, select custom properties to set up pens and chart properties.
Sinolta Tutorial –HMI basic features and HMI scripts projects provide good examples on how to set up these charts with or without VB scripts.

Yes. You can use the SQL function block from Automation to connect and send SQL queries to any external SQL server.

Yes. Use Sinolta Historian SQL function block to send an SQL statement to Sinotla Historian.

Snapshot data logging is the only database that allows users to read and update old values.
First, from the Database builder, enable the Snapshot logging for the desired points.
The Snapshot read and write functions are only accessible from the Automation Snapshot function blocks.
Use the automation function block for snapshot logging to write a set of points with a specific time (in the past) to the Sinolta Historian database.
Using a snapshot custom view, you can view or edit stored data. Furthermore, you can add a comment for every cell value that you changed.
Sinolta Snapshot Audit Trail prebuilt view allows you to see the history of changes, username for the users that change the values and any comments that they may have added.

Historical Trend is a periodic data logging feature that can be configured with specific logging parameters for each point. Users can not change the content of the Historical Trend database.
Snapshot logging is designed to store a set of data with a current timestamp or a timestamp in the past. For example, you can build logic to create previous day average and total values for a set of points at 10:00 AM , but store this information in the database for 8:00 AM timestamp.
You can use Automation to collect and convert data to create the final dataset. You can then use the Automation Snapshot Write function block to store this information for 8:00 AM.
You can repeat writing the same dataset multiple times. Snapshot database stores all instances of the values you sent to it and use the latest entry as the value to show unless you want to see the previous values from the Snapshot Audit Trail page.

Sinolta can log all its alarms, Sequence of events, Periodic Trend logging, Periodic Report logging, Audit Trail, online configuration changes and system error messages to its own built-in historian. Please refer to the EVENTA Historian task properties to specify the location of the Sinolta historian files.