Setup an MQTT Connection Manager
The MQTT Connection Manager is an SSIS connection manager component that can be used to establish connections with MQTT/WebSphere MQ.
To add a new connection, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted the "Add SSIS Connection Manager" window. Select the "MQTT (KingswaySoft)" item to add a new MQTT Connection Manager.
The MQTT Connection Manager contains 1 page of configuration.
- General
General Page
The General page allows you to specify connection properties and login credentials to MQTT/WebSphere MQ.
- Server
-
The name of the Server that the component will connect to.
- Port
-
The port number of the remote machine.
- Client ID
-
The Client ID used to connect to the service.
- MQTT Protocol Version
-
The MQTT Protocol Version may be selected from the dropdown.
- Authentication Mode:
-
The authentication mode to use. There are two authentication modes: credentials and certificate.
- Username
-
The username of the used to connect to the remote machine.
- Password
-
The password used to connect to the remote machine
- Use TLS
-
This option will determine if to Use TLS.
- Use SSL Protocol
-
From the dropdown you may select the SSL Protocol.
- Client Certificate Location
-
The Client Certificate Location may either be Store or File System.
- Client Certificate Path
-
The Client Certificate Path to the certificate location.
- Client Certificate Password
-
Password set for the Client Certificate.
- Client Certificate Key Path
-
The Client Certificate Key Path to the key location.
- Server Certificate Location
-
The Server Certificate Location may either be Store or File System.
- Server Certificate Path
-
The path to the Server Certificate location.
- Allow Untrusted Certificates
-
This option will determine if to Allow Untrusted Certificates.
- Validate Certificates
-
This option will determine if to Validate Certificates.
- Ignore Certificate Chain Errors
-
This option will determine if to Ignore Certificate Chain Errors.
- Ignore Revocation Errors
-
This option will determine if to Ignore revocation Errors.
- Test Connection
-
After all the connection information has been provided, you may click the "Test Connection" button to test if the user credentials entered can connect to MQTT/WebSphere MQ.
Advanced Settings Page
The Advanced Settings page of MQTT Connection Manager allows you to select the “Retry on Intermittent Errors” option.
- Retry on Intermittent Errors
-
Use this option to indicate if MQTT retry policy will be used. When this option is enabled, a default setup of exponentially increasing retry intervals for messaging operations will be provided. Uncheck this option to effectively disable retries.