Connector Provider Reference Table

36 min

Refer to the available integration providers and their corresponding parameters.

AMQP SSL

Review an AMQP SSL use case.

Instance Name
Hostname
Port
Virtual host
Username
Password
Exchange
exchangeType
Exchange durable check box
Exchange auto delete check box
Exchange internal check box
Exchange no wait check box
ISO8601 timestamp check box
Routing key
CA Certificate
Certificate
Private key
Throttling limit
Persistent storage check box

AMQP TCP

InstanceName
Hostname
Port
Virtual host
Username
Password
Exchange
exchangeType
Exchange durable check box
Exchange auto delete check box
Exchange internal check box
Exchange no wait check box
ISO8601 timestamp check box
Routing key
Throttling limit
Persistent storage check box

Azure Event Hubs

Review an Azure Event Hub use case.

Instance Name
Connection string
Maximum message size
Parallel connections count
Combine messages check box
Throttling limit
Persistent storage check box

DB - InfluxDB v1.7.x SSL

Instance Name
InfluxDB address
InfluxDB database name
Username
Password
CA Certificate
Certificate
Private key
Throttling limit
Persistent storage check box

DB - InfluxDB v1.7.x TCP

Review an InfluxDB TCP use case.

Instance Name
InfluxDB address
InfluxDB database name
Username
Password
Insert batch size
Insert batch commit time
Throttling limit
Persistent storage check box

DB - InfluxDB v2.x TCP

Instance Name
InfluxDB address
InfluxDB bucket name
Organization
Auth token
Username
Password
Insert batch size
Insert batch commit time
Throttling limit
Persistent storage check box

DB - InfluxDB v2.x+ SSL

Instance Name
InfluxDB address
InfluxDB bucket name
Organization
Auth token
Username
Password
CA Certificate
Certificate
Private key
Insert batch size
Insert batch commit time
Throttling limit
Persistent storage check box

DB - Microsoft SQL Server

Review a Microsoft SQL Server use case.

Instance Name
Hostname
Port
Username
Password
Database
Table
Show mapping check box (see Work with Tables in SQL Connectors (Create Table and Show Mapping))
Create table check box (see Work with Tables in SQL Connectors (Create Table and Show Mapping))
Throttling limit
Persistent storage check box

DB - Microsoft SQL Server SSL

Instance Name
Hostname
Port 1433
SSL Mode
CA Certificate
Username
Password
Database
Table
Create Table check box
Throttling limit
Persistent storage check box

Note: When the Create table check box 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)
)

DB - MongoDB

Review a MongoDB use case.

Instance Name
Hostname
Port
Username
Password
Auth database
Auth mechansim
Database
Collection
Throttling limit
Persistent storage check box

DB - Mongo v4+ (Belden Horizon Data Operations version 3.5.2 and later)

Instance name
Hostname
Port
Username
Password
Auth database
Auth mechanism
Database
Collection
Throttling limit
Persistent storage check box
Queue Mode

DB - MySQL

Review a MySQL use case.

Instance Name
Hostname
Port
Username
Password
Database
Table
Show Mapping check box (see Work with Tables in SQL Connectors (Create Table and Show Mapping))
Create table check box (see Work with Tables in SQL Connectors (Create Table and Show Mapping))
Throttling limit
Persistent storage check box

DB - MySQL SSL

Instance Name
Hostname
Port
CA Certificate
Certificate
Private key
Username
Password
Database
Table
Create table check box
Throttling limit
Persistent storage check box

Note: When the Create table check box is not selected, the table format (columns) that you will create must still adhere to the following format.

#CREATE TABLE IF NOT EXISTS `TABLE_NAME`
(
	id          BIGINT AUTO_INCREMENT 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     TINYINT               NULL,
	PRIMARY KEY (id)
);

DB - Oracle (deprecated for Belden Horizon Data Operations version 3.5.2 and later)

Instance Name
Hostname
Port
Username
Password
Database
Table
Show Mapping check box
Create table check box
Throttling limit
Persistent storage check box

DB - PostgreSQL

Review a PostgreSQL use case.

Instance Name
Hostname
Port
Username
Password
Database
Table
Show Mapping check box (see Work with Tables in SQL Connectors (Create Table and Show Mapping))
Create table check box (see Work with Tables in SQL Connectors (Create Table and Show Mapping))
Throttling limit
Persistent storage check box

DB - PostgreSQL SSL

Instance Name
Hostname
Port
SSL Mode
CA Certificate
Certificate
Private key
Username
Password
Database
Table
Create table check box
Throttling limit
Persistent storage check box

Note: When the Create table check box is not selected, the table format (columns) that you will create must still adhere to the following format.

CREATE TABLE IF NOT EXISTS "TABLE_NAME"
(
    id BIGSERIAL NOT NULL,
    record_uuid UUID NOT NULL,
    arrived_at  TIMESTAMP WITH TIME ZONE NOT NULL,
    device_id   VARCHAR(64)    NULL,
    register_id VARCHAR(64)    NULL,
    tag_name    VARCHAR(64)    NULL,
    datatype    VARCHAR(32)    NULL,
    value       VARCHAR NULL,
    success     BOOLEAN        NULL,
    PRIMARY KEY (id)
);

Google Cloud Pub/Sub Connector

Review a Google Cloud Pub/Sub use case.

Instance Name
Service Account Key (.json)
The project ID of the cloud project
Integration Topic
Parallel Publish Count
Publish byte threshold
Publish count threshold
Publish delay threshold
Throttling limit
Persistent storage check box

Kafka SSL

Instance Name
Brokers list
SASL mechanism
Username
Password
CA Certificate
Certificate
Private key
Insecure Skip Verify check box
Topic
Throttling limit
Persistent storage check box

Kafka TCP

Review a Kafka TCP use case.

Instance Name
Brokers list
SASL mechanism
Username
Password
Topic
Throttling limit
Persistent storage check box

Loopback Connector

Instance Name
Throttling limit
Persistent storage check box

MQTT - Amazon AWS IoT Core over SSL

Review the AWS (Amazon Web Services) use case.

Instance Name
Hostname
Port
Certificate
Private key
Client ID
QoS
Parallel Publish Count
Integration Topic
LWT topic
LWT Payload
LWT payload type
LWT QoS
LWT retained
Throttling limit
Persistent storage check box

MQTT - Azure IoT Hub using Device Certificates

Review the Send Data to Azure IoT Hub with a Device Certificate and Receive Data from Azure IoT Hub with a Device Certificate use cases.

Instance Name
Hostname
Port
Device ID
Certificate
Private key
Parallel Publish Count
Integration Topic
LWT topic
LWT Payload
LWT payload type
LWT QoS
LWT retained check box
Throttling limit
Persistent storage check box

MQTT - Azure IoT Hub using SAS Key

Review the Send Data to Azure IoT Hub with an SAS Key and Receive Data from Azure IoT Hub with an SAS Key use cases.

Instance Name
Hostname
Port
Device ID
SAS Key
Parallel Publish Count
Integration Topic
Token TTL (minutes)
LWT topic
LWT Payload
LWT payload type
LWT QoS
LWT retained check box
Throttling limit
Persistent storage check box

MQTT Generic

Review the following use cases:

Instance Name
Hostname
Port
Client ID
Username
Password
QoS
Parallel Publish Count
Integration Topic
LWT topic
LWT payload
LWT payload type
LWT QoS
LWT retained check box
Throttling limit
Persistent Storage check box

MQTT - Generic over SSL

Review the Generic MQTT Over SSL Using Mosquitto use case.

Instance Name
Hostname
Port
CA Certificate
Certificate
Private key
Client ID
Username
Password
QoS
Parallel Publish Count
Integration Topic
LWT topic
LWT payload
LWT payload type
LWT QoS
LWT retained check box
Throttling limit
Persistent Storage check box

MQTT - IBM Watson over SSL

Instance Name
Hostname
Port
CA Certificate
Organization ID
Device Type
Device ID
Token
QoS
Parallel Publish Count
Integration Topic
LWT topic
LWT payload
LWT payload type
LWT QoS
LWT retained check box
Throttling limit
Persistent storage check box

MQTT - System Protobuf SSL

Instance Name
Hostname
Port
CA Certificate
Client ID
Username
Password
QoS
Parallel Publish Count
Integration Topic
Throttling limit
Persistent storage check box

MQTT - System Protobuf TCP

Instance Name
Hostname
Port
Client ID
Username
Password
QoS
Parallel Publish Count
Integration Topic
Throttling limit
Persistent storage check box

MindSphere PSK

Review the MindSphere use case.

Instance Name
Agent boarding configuration
Aspect name
Throttling limit
Persistent storage check box

NATS

Name
Hostname
Port
NATS Username
NATS Password
Default topic name
Enable TLS secure connection check box
Insecure skip verify check box
Throttling limit
Persistent storage check box

Rest (Belden Horizon Data Operations version 3.5.2 and later)

Instance Name
Method
Endpoint
Show headers check box
Show params check box
Parallel Publish Count
Show Mapping check box (see Work with Tables in SQL Connectors (Create Table and Show Mapping))
Throttling limit
Persistent storage check box
Queue Mode

Splunk

Review the Splunk use case.

Instance Name
Hostname
Port
Use SSL check box
Endpoint
Token
Throttling limit
Persistent storage check box