Product Features
...
Integration Connectors
Databases
DB - Microsoft SQL Server SSL
2min
review the microsoft sql server ssl integration guide docid 6hm4xgpbxqil6yrefbty8 overview microsoft sql server ssl integration enables an edge system to connect with an mssql database using ssl authentication supported communication outbound (edge to sql server) yes inbound (sql server to edge) no configurations variable detail required name enter a name for the connector y hostname ip address or hostname of mssql server (must be reachable from the edge system) y port mssql server port y ssl mode if disable is selected, data sent between client and server is not encrypted if true is selected, data sent between client and server is encrypted if false is selected, data sent between client and server is not encrypted beyond the login packet (default is disable) y ca certificate ssl ca certificate (default certificate will be used if this field empty) n username user name (optional) y password user password (optional) y database database name y table table name y show mapping data from a predefined table could be mapped into a custom one example {"from" "to"} where "from" is a column from predefined table, and "to" is a column from destination table see work with tables in sql connectors (create table and show mapping) docid\ arn eb7jkou2tcnsnyqnw to learn more create table if selected and table doesn't exist, the table is created with the necessary format see work with tables in sql connectors (create table and show mapping) docid\ arn eb7jkou2tcnsnyqnw to learn more n commit timeout transaction commit timeout (ms) n max transaction size maximum number of messages before a transaction is committed regardless of timeout n bulk insert count to enable this option, enter the number of messages to group together and send as one bulk insert statement enabling this option can improve how quickly data is processed when dealing with high volumes of tags n throttling limit set a limit on the number of outbound messages per second if sending data to a server that has restrictions on the rate of incoming messages, this ensures that no messages are lost n persistent storage persistent storage if enabled, messages in the outbound queue are stored on disk if there are interruptions in connection or power loss, messages will be retained and eventually sent when the connection is restored n queue mode select the sequence of data transfer fifo or lifo selecting fifo (first in first out) will send the earliest message first selecting lifo (last in first out) will send the latest message first n note when the create table checkbox is not selected, the table format (columns) that you will create must still adhere to the following format if not exists(select from sysobjects where name = '"table name"' and xtype = 'u') create table "table name" ( id bigint identity(1,1) not null, record uuid char(36) not null, arrived at datetime not null, device id varchar(64) null, register id varchar(64) null, tag name varchar(64) null, datatype varchar(32) null, value text null, success bit null, primary key (id) )