Adding new connectors

When adding new connectors to SQL Stream Builder, you need to specify the property list, data types and must upload the connector JAR file to the Console.

Select Connectors on the main menu.
Click Register Connector.
Provide a name for the connector as Type.
Select a data format to be supported for the connector from the Supported Formats.
Provide properties that are mandatory or optional for the connector.
1. Add a name to the property.
2. Add a default value to the property.
3. Add a description to the property.
4. Check the Required checkbox to make a property mandatory.
5. Click Add.
You can specify as many properties as needed for the connector.
Upload the connector JAR file.
note
When uploading a JAR file larger than 1 MB, you need to set the server.tomcat.max-swallow-size in Cloudera Manager using the following steps:
1. Open your cluster in Cloudera Manager.
2. Select SQL Stream Builder from the list of services.
3. Select Configuration.
4. Search for Streaming SQL Engine Advanced Configuration Snippet (Safety Valve) for ssb-conf/application.properties in the search bar.
5. Add server.tomcat.max-swallow-size=2000MB to the Safety Valve.
6. Click Save.
7. Restart the SQL Stream Builder service.
Click Save changes.
The newly added connector is listed on the Connectors page.