Select [Edit database connection settings] from the [Tool] menu.

Click the [Add] button in [Setting name].

Optionally set the setting name.
Here, enter "SQL Server" and click [OK].

Select "SQL Server" from the list of items in [Database].
* "OLEDB" is selected for [Type], and "SQLOLEDB 1" is selected for [OLEDB provider].

Set the IP-address of the access point to [Data source] as desired.
Here, enter the IP address "192.168.1.10".

Set [Initial catalog] to the desired databasename to connect to.
Here, enter the databasename "IoTDB".

Set [User ID] and [Password].
Here, enter the user ID "IoTDBUser" and password "dnSQLP@ss" defined
in SQL Server.

Click the [Connection] button.
* Confirm the connection with the database.

Note

Typical examples of database connection errors

• Cannot find a host.
• The IP of the access point is wrong.
• Host name is wrong.
• The user name and password are wrong.

etc.

Click the [OK] button.

This completes "Registering database connection information".

Select a controller to which you want to add the trigger action.

Select [Trigger action setting] from the right-click menu.

Note

In addition to the right-click menu,
you can also select the trigger action settings from the toolbar buttons.

Click the [Action] button.

Select [Database control] from the action list.

Set [Action name] as desired.
Here, enter "Save to SQLServer" and click the [Settings] button.

Note 1

When adding a trigger action, you can leave the action name as the default, but if you add multiple actions of the same type, they will have the same action name, so it is recommended to change it to any name you want.

Note 2

You can also open the settings screen for each action by double-clicking the selected action.

Select the database connection information registered in Step1 "SQL Server"
from the [Database connection settings] list.

Select [INSERT] from the [Query category] list.

Set the [Table name].
Click the [Get table names] button. Select the table name "dbo. Table1"
from the displayed list.

Note 1

Click the [Get table names] button to connect to the database server and obtain the name of the defined table and display it in the list.

Note 2

You can also enter the name directly in [Table name].

Click the [Add all columns] button.
The columns "Item_value" and "Item_datetime" are added to "dbo.Table1".

Note

You can add any column with the [Add] button or delete unnecessary columns with the [Delete] button.

Select the column "Item_value", and click the [Edit] button.

Note

You can also set items by clicking the [...] button next to [Item name].

Click the [...] button of [Item name], and select the item "I10" from the displayed tree.
Select "Value" from the [Property] list.

Note

The data type of the selected item may not be saved unless the data type of the database column matches the data type of the column.
In such a case, an error will not occur at the time of setting. However, if the project is started as it is, an error will occur at the time of execution.

Select the column "Item_datetime", and click the [Edit] button.

Click the [...] button of [Item name], and select the item "I10" from the displayed tree.
Select "DateTime" from the [Property] list.

Click the [OK] button.

Note

You can check the SQL query from [Preview] at the bottom of the setting.
However, the data below "VALUES{...}" is replaced by the value at runtime and cannot be viewed in the preview.

Click the [OK] button.

This completes "Setting up data insertion to a SQL Server using trigger actions".