Connecting to SQream Using Talend¶
This page describes how to use Talend to interact with a SQream DB cluster. Talend is an open-source data integration platform. It provides various software and services for Big Data integration and management, enterprise application integration, data quality and cloud storage.
For more information about Talend, see Talend.
This page describes the following:
Quick Start Guide¶
Creating a New Metadata JDBC DB Connection¶
To create a new metadata JDBC DB connection:
In the Repository panel, navigate to Metadata and right-click Db connections.
Select Create connection.
In the Name field, type a name.
The name cannot contain spaces.
In the Purpose field, type a purpose and click Next. You cannot go to the next step until you define both a Name and a Purpose.
In the DB Type field, select JDBC.
In the JDBC URL field, type the relevant connection string.
For connection string examples, see Connection Strings.
In the Drivers field, click the Add button.
The “newLine” entry is added.
One the “newLine” entry, click the ellipsis.
The Module window is displayed.
From the Module window, select Artifact repository(local m2/nexus) and select Install a new module.
Click the ellipsis.
Your hard drive is displayed.
Navigate to a JDBC jar file (such as sqream-jdbc-4.4.0.jar)and click Open.
Click Detect the module install status and click OK.
The JDBC that you selected is displayed in the Drivers field.
Click Select class name.
Click Test connection.
If a driver class is not found (for example, you didn’t select a JDBC jar file), the following error message is displayed:
After creating a new metadata JDBC DB connection, you can do the following:
Use your new metadata connection.
Drag it to the job screen.
Build Talend components.
For more information on loading data from JSON files to the Talend Open Studio, see How to Load Data from JSON Files in Talend.
Supported SQream Drivers¶
The following list shows the supported SQream drivers and versions:
JDBC - Version 4.3.3 and higher.
ODBC - Version 4.0.0. This version requires a Bridge to connect. For more information on the required Bridge, see Connecting Talend on Windows to an ODBC Database.