Using datasources and connection pooling in Talend Runtime - Cloud - 8.0

Talend ESB Container Administration Guide

Version
Cloud
8.0
Language
English
Product
Talend Cloud
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 ESB
Talend Runtime
Content
Administration and Monitoring
Design and Development
Installation and Upgrade

About this task

Once the driver installed into the Talend Runtime Container(for more information, see Installing JDBC drivers into the Talend Runtime Container), you will be able to use the datasource in your database component in your Talend Job to deploy it in the Talend Runtime Container.

Procedure

  1. Use the DataSource Name defined in the table below in the Data source alias field of your database connection component:

    DataSource Name

    Database

    ds-derby Derby
    ds-h2 H2 Engine
    ds-mysql MySQL 5.x
    ds-mysql8 MySQL 8.x
    ds-oracle Oracle
    ds-db2 IBM DB2
    ds-sqlserver SQL Server
    ds-postgresql PostgreSQL
    For example, for the MySQL datasource:

    Example

  2. Now you can deploy your Job into the Talend Runtime Container.