cSQLConnection Standard properties - Cloud - 8.0

Database (Mediation)

Version
Cloud
8.0
Language
English
Product
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components (Mediation)
Data Quality and Preparation > Third-party systems > Database components (Mediation)
Design and Development > Third-party systems > Database components (Mediation)

These properties are used to configure cSQLConnection running in the Standard Route framework.

The Standard cSQLConnection component belongs to the Connectivity family.

Basic settings

Driver Class

Enter the class name for the specified driver between double quotation marks.

Driver JAR

Complete this table to load the driver JARs needed. To do this, click the [+] button under the table to add as many rows as needed, each row for a driver JAR, then select the cell and click the [...] button at the right side of the cell to open the Module dialog box from which you can select the driver JAR to be used.

For more information, see Importing a database driver.

JDBC URL The JDBC URL of the database to be used.
Authentication

Select this check box to enter the database user authentication data. The User Id and Password fields appear when this check box is selected.

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.

Specify a data source alias

Select this check box and in the Data source alias field displayed, specify the alias of a data source created on the Talend Runtime side to use the shared connection pool defined in the data source configuration. This option works only when you deploy and run your Route in Talend Runtime.

Advanced settings

Initial Connections

Specify the maximum number of initial connections.
Max Connections Specify the maximum number of connections.
Min Idle Connections

Specify the minimum number of idle connections (connections not used).

Max Idle Connections Specify the maximum number of idle connections (connections not used).
Set Timeouts Select this check box to set the timeout options.
  • Query Timeout (sec): Set a timeout period for the query in seconds. A value of -1 means that no timeout is set.
  • Max Connection duration (sec): Set a maximum duration of the connection in seconds. A value of -1 means that no timeout is set.
Use validation query Select this check box to validate the database connection using a query.
  • Validation Query Timeout (sec): Set a timeout period for the validation query in seconds. A value of -1 means that no timeout is set.
  • Validation query: Enter an SQL SELECT statement to validate the connection.
Use SQL Initialization Select this check box to initialize the database server by entering a query in the Init Query box.

Usage

Usage rule

cSQLConnection can be added directly in a Route without any input or output component linked.

Limitation

 n/a