Add a

SQL Server

application

To add the first application, select

Add Application

.

To add a subsequent application, select

Add

.

Application Name.

Defines the application name.

Server Name

. Defines the name or IP Address of the server host.

SQL Server Instance Name.

Enter the name of the

SQL Server

instance.

The SQL Server Browser service must be running anytime the SQL Server instance name is the connection method. If you enter information in both SQL Port and SQL Server Instance Name,

FactoryTalk Edge Gateway

uses the SQL Server instance name. To configure and debug the SQL Server, see Microsoft SQL Server technical documentation.

SQL Port.

Enter a port number for

SQL Server

if not using the standard 1433 port number.

Database Name.

Indicates the communication port between the

SQL Server

and the gateway.

Table Name.

Enter the name of a table already in use by

FactoryTalk Edge Gateway

or enter the name of a new table. If the table does not exist,

FactoryTalk Edge Gateway

creates the table. Only use tables that

FactoryTalk Edge Gateway

creates.

Domain.

Enter domain or workgroup name to connect to

SQL Server

by using

Windows

authentication. Leaving this field blank uses

SQL Server

authentication.

Username

. Enter the specific username for the database. Recommended practice is to create a username with the correct access and permissions for the database to use with the

FactoryTalk Edge Gateway

SQL Server endpoint.

Password.

Enter the password associated with the username.

Encrypt.

Encrypt the connection to the SQL server.

Enable Fire Insert Trigger.

Enable the execution of database triggers on bulk insert of data to SQL table from

FactoryTalk Edge Gateway

.

Store and Forward.

Enables the storage of data entering the application in a database on the gateway. This setting also functions as a buffer for data entering the store database at higher speeds than the data is forwarded to the application. At each configured Fetch Interval, a maximum amount of data fetched from the store database is 256 KB.

Select

Store and Forward

to enable the

Maximum store size (bytes)

and

Fetch Interval (ms)

settings.

In case connectivity is lost to the external application, having

Store and Forward

enabled prevents periods of lost data to

SQL Server

.

Store and Forward

stores data in the database until the connection is restored.

Aggressive Database Cleaning

. Select to delete 50% of the oldest data from the store when maximum store size is exceeded.

Maximum store size (bytes)

. This setting defines the maximum size of the store database on the gateway, in bytes. When the maximum store size is reached, the oldest data is deleted to make space for new application data. Select

Store and Forward

to enable this setting.

Fetch Interval (ms).

This setting defines the interval of time to egress (that is, forward) data from the store database, in milliseconds. Data continues to be egressed to the

ThingWorx

application until the store database is empty. When egress fails, the data remains in the store database. Select

Store and Forward

to enable this setting.

Domain.

Enter to connect to

SQL Server

using

Windows

authentication. The default value is

SQL Server

authentication. This field is optional.