tCassandraConnection - 6.3

Talend Open Studio for Big Data Components Reference Guide

Talend Open Studio for Big Data
Data Governance
Data Quality and Preparation
Design and Development
Talend Studio


tCassandraConnection opens a connection to a Cassandra server.


tCassandraConnection enables the reuse of the connection it creates to a Cassandra server.

tCassandraConnection properties

Component Family

Big Data / Cassandra


Basic settings

Property type

Either Built-In or Repository.

Built-In: No property data stored centrally.

Repository: Select the repository file where the properties are stored.


Use existing connection

Select this check box and in the Component List click the relevant connection component to reuse the connection details you already defined.

  DB Version Select the Cassandra version you are using.

API type

This drop-down list is displayed only when you have selected the 2.0 version of Cassandra from the DB version list. From this API type list, you can either select Datastax to use CQL 3 (Cassandra Query Language) with Cassandra, or select Hector to use CQL 2.

Note that the Hector API is deprecated for the 2.0 or later version of Cassandra, but it is still available for use in the Studio so that you can be flexible about the version of the query language to be used with Cassandra 2.0.0.



Type in the IP address or hostname of the Cassandra server.



Type in the listening port number of the Cassandra server.

Required Authentication


Fill in this field with the username for the Cassandra authentication.



Fill in this field with the password for the Cassandra authentication.

To enter the password, click the [...] button next to the password field, and then in the pop-up dialog box enter the password between double quotes and click OK to save the settings.

Advanced settings

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

Global Variables

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio User Guide.


This component is generally used with other Cassandra components, particularly tCassandraClose.


If you are using a subscription-based version of the Studio, the activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User Guide.

For more information on the log4j logging levels, see the Apache documentation at



Related scenario

For a scenario in which tCassandraConnection is used, see Scenario: Handling data with Cassandra.