SingleStore Managed Service

Connecting StreamSets to SingleStore DB via Fast Loader

StreamSets can be connected to SingleStore DB via Fast Loader by creating different types of pipelines. This document provides the connection details for the following pipelines:

  • Hadoop

  • Kafka

  • Filesystem

Perform the following steps first, then follow the specific instructions for your respective pipeline below.

  1. Open the following URL: http://< IP Address of the server running the StreamSets service >:18630/

  2. Enter the username and password to log in. The default is admin/admin

  3. On the Get Started page, click + Create New Pipeline to create a new Pipeline.

  4. Add a title and description for the new pipeline and click Save.

Pipeline from Hadoop Source to SingleStore DB Using the Fast Loader
  1. Under Select Origin on the right hand side panel, select Hadoop FS Standalone.

  2. Provide the Origin Name and select Send to error for the On Record Error field.

  3. On the connections tab enter the Hadoop File system URI in the following format: hdfs://<IP Address of the server running the Hadoop system>:9000/

  4. Click on the Fields tab and provide the Hadoop file system details.

  5. In the Data Source tab, provide the data source details.

  6. From the right pane select SingleStore DB Fast Loader as the destination type and configure as below:

    General

    • Name: Name of destination

    • On Record Error: Sent to error

    JDBC

    • JDBC Connection string

    • Schema Name and Table Name

    NOTE: Do the Field to column mapping for all the columns present in the target table.

  7. Connect Hadoop FS Standalone origin to SingleStore DB Fast Loader destination.

  8. Start the pipeline and data processing will start.

You are now ready to move the data.

Pipeline from Kafka Source to SingleStore DB Using the Fast Loader
  1. Under Select Origin on the right-hand side panel, select Kafka Consumer as the origin type and configure as below:

    General

    • Name: Name of Origin

    • On Record Error: Sent to error

    Kafka

    • Broker URI: ip-< IP address of the machine running Kafka >:9092

    • Zookeeper URI: ip-< IP address of the machine running Kafka >:2181

    • Consumer Group: < Name of the consumer group >

    • Topic: < Name of the Kafka topic >

    Data Format:

    • Data format: Delimited

    • Delimiter Format Type: Default CSV (ignore empty lines)

    • Header line: No Header Line

  2. From the right pane select SingleStore DB Fast Loader as the destination type and configure as below:

    General

    • Name: Name of destination

    • On Record Error: Sent to error

    JDBC

    • JDBC Connection string

    • Schema Name and Table Name

    • Field to Column Mapping: < Do mapping of all columns where data is going to load >

    • Default Operation: Insert

    Credentials:

    • Username: < DB user >

    • Password: < DB password >

    NOTE: Do the Field to column mapping for all the columns present in the target table.

  3. Connect Kafka Consumer Origin to SingleStore DB Fast Loader.

  4. Start the pipeline by clicking on the option present above the left pane.

You are now ready to move the data.

Pipeline from Filesystem Source to SingleStore DB Using the Fast Loader
  1. Under Select Origin on the right-hand side panel, select Directory as the origin type and configure as below:

    General

    • Name: Name of Origin

    • On Record Error: Sent to error

    Files

    • File Directory: < Directory path where file exists >

    • File Name Pattern: *.csv

    Data Format:

    • Data format: Delimited

    • Delimiter Format Type: Default CSV (ignore empty lines)

    • Header line: With Header Line

  2. From the right pane select SingleStore DB Fast Loader as the destination type and configure as below:

    General

    • Name: Name of destination

    • On Record Error: Sent to error

    JDBC

    • JDBC Connection string

    • Schema Name and Table Name

    • Field to Column Mapping: < Do mapping of all columns where data is going to load >

    • Default Operation: Insert

    Credentials:

    • Username: < DB user >

    • Password: < DB password >

    NOTE: Do the Field to column mapping for all the columns present in the target table.

  3. Connect Directory Origin to SingleStore DB Fast Loader.

  4. Start the pipeline by clicking on the option present above the left pane.

You are now ready to move the data.