tCassandraConnection Standard properties

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 drop-down list, select the desired connection component to reuse the connection details you already defined.

Server

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

Port

Type in the listening port number of the Cassandra server.

Datacenter

Enter the name of the Cassandra datacenter.

Required authentication

Select this check box to enable the database authentication.

Username

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

This field is only available when you select the Required authentication check box.

Password

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

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

This field is only available when you select the Required authentication check box.

Use SSL connection

Select this check box to enable the SSL or TLS encrypted connection.

Then you need to use the tSetKeystore component in the same Job to specify the encryption information.

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 more information about variables, see Using contexts and variables.

Usage rule

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