---
title: Connector Provider Reference Table
slug: bhdo/connector-provider-reference-table
createdAt: 2022-08-19T15:24:43.000Z
---

Refer to the available integration providers and their corresponding parameters. &#x20;

## AMQP SSL

Review an [AMQP SSL](https://public-docs.litmus.io/bhdo/amqp-ssl) use case.&#x20;

- 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](https://public-docs.litmus.io/bhdo/azure-event-hub) use case.&#x20;

- 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.&#x20;

- 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&#x20;
- Auth token
- Username
- Password
- Insert batch size
- Insert batch commit time
- Throttling limit
- Persistent storage check box&#x20;

## 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](https://public-docs.litmus.io/bhdo/microsoft-sql-server) use case.&#x20;

- Instance Name
- Hostname
- Port
- Username
- Password
- Database
- Table
- Show mapping check box (see [Work with Tables in SQL Connectors (Create Table and Show Mapping)](https://public-docs.litmus.io/bhdo/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)](https://public-docs.litmus.io/bhdo/work-with-tables-in-sql-connectors-create-table-and-show-mapping))
- Throttling limit
- Persistent storage check box

## DB - Microsoft SQL Server SSL&#x20;

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

:::hint{type="info"}
**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.&#x20;
:::

```sql
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](https://public-docs.litmus.io/bhdo/mongodb) use case.&#x20;

- 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](https://public-docs.litmus.io/bhdo/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)](https://public-docs.litmus.io/bhdo/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)](https://public-docs.litmus.io/bhdo/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

:::hint{type="info"}
**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.&#x20;
:::

```mysql
#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](https://public-docs.litmus.io/bhdo/postgresql) use case.&#x20;

- Instance Name
- Hostname
- Port
- Username
- Password
- Database
- Table
- Show Mapping check box (see [Work with Tables in SQL Connectors (Create Table and Show Mapping)](https://public-docs.litmus.io/bhdo/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)](https://public-docs.litmus.io/bhdo/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

:::hint{type="info"}
**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.&#x20;
:::

```pgsql
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](https://public-docs.litmus.io/bhdo/google-cloud-pubsub) use case.&#x20;

- 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&#x20;
- Topic
- Throttling limit
- Persistent storage check box

## Kafka TCP

Review a [Kafka TCP](https://public-docs.litmus.io/bhdo/kafka-tcp) use case.&#x20;

- 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)](https://public-docs.litmus.io/bhdo/aws-amazon-web-services) use case.&#x20;

- 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](https://public-docs.litmus.io/bhdo/send-data-to-azure-iot-hub-with-a-device-certificate) and [Receive Data from Azure IoT Hub with a Device Certificate](https://public-docs.litmus.io/bhdo/receive-data-from-azure-iot-hub-with-a-device-certificate) use cases.&#x20;

- 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](https://public-docs.litmus.io/bhdo/send-data-to-azure-iot-hub-with-an-sas-key) and [Receive Data from Azure IoT Hub with an SAS Key](https://public-docs.litmus.io/bhdo/receive-data-from-azure-iot-hub-with-an-sas-key) use cases.&#x20;

- 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:

- [Generic MQTT-TCP Using HiveMQ](https://public-docs.litmus.io/bhdo/generic-mqtt-tcp-using-hivemq)
- [Generic MQTT-TCP Using Mosquitto](https://public-docs.litmus.io/bhdo/generic-mqtt-tcp-using-mosquitto)
- [Generic MQTT-TCP Last Will and Testament Configuration](https://public-docs.litmus.io/bhdo/generic-mqtt-tcp-last-will-and-testament-configuration)



- 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](https://public-docs.litmus.io/bhdo/generic-mqtt-over-ssl-using-mosquitto) use case.&#x20;

- 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](https://public-docs.litmus.io/bhdo/mindsphere) use case.&#x20;

- 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&#x20;
- Throttling limit
- Persistent storage check box&#x20;

## 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)](https://public-docs.litmus.io/bhdo/work-with-tables-in-sql-connectors-create-table-and-show-mapping))
- Throttling limit
- Persistent storage check box
- Queue Mode

## Splunk

Review the [Splunk](https://public-docs.litmus.io/bhdo/splunk) use case.&#x20;

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

