ESB Document 6.x

Parsing addresses against Loqate – Docs for ESB 6.x

Parsing addresses against Loqate Document get from Talend https://help.talend.com Thank you for watching.

Closing the Snowflake connection – Docs for ESB 6.x

Closing the Snowflake connection Configure the tSnowflakeClose component to close the connection to Snowflake. Double-click the tSnowflakeClose component to open the Component tab. From the Connection Component drop-down list, select the component that opens the connection you need to close, tSnowflakeConnection_1 in this example. Document get from Talend https://help.talend.com Thank you for watching.

Configuring input and output components – Docs for ESB 6.x

Configuring input and output components Document get from Talend https://help.talend.com Thank you for watching.

Configuring the input data and the preparation – Docs for ESB 6.x

Configuring the input data and the preparation Document get from Talend https://help.talend.com Thank you for watching.

Opening a connection to access Amazon SQS – Docs for ESB 6.x

Opening a connection to access Amazon SQS Configure the tSQSConnection component to open a connection to access Amazon SQS. Double-click the tSQSConnection component to open its Basic settings view. In the Access Key and Secret Key fields, specify the authentication information required to access Amazon SQS. Select an AWS region available for Amazon SQS from…

Scenario: Inserting data in mother/daughter tables – Docs for ESB 6.x

Scenario: Inserting data in mother/daughter tables The following Job is dedicated to advanced database users, who want to carry out multiple table insertions using a parent table id to feed a child table. As a prerequisite to this Job, follow the steps described below to create the relevant tables using an engine such as innodb:…

Scenario: Removing and regenerating a MySQL table index – Docs for ESB 6.x

Scenario: Removing and regenerating a MySQL table index This scenario describes a four-component job that removes a table index, applies a select insert action onto a table then regenerates the index. Document get from Talend https://help.talend.com Thank you for watching.

Scenario: Combining two flows for selective output – Docs for ESB 6.x

Scenario: Combining two flows for selective output In this scenario, a flow generated by tFixedFlowInput is combined with a flow from the Mysql database. The source flow contains id and age fields while the Mysql table contains id and name. We want to retrieve the age data of the source flow and combine it with…

Connecting to Snowflake – Docs for ESB 6.x

Connecting to Snowflake Configure the tSnowflakeConnection component to connect to Snowflake. Double-click the tSnowflakeConnection component to open its Basic settings view. In the Account field, enter the account name assigned by Snowflake. In the User Id and the Password fields, enter the authentication information accordingly. Note that this user ID is your user login name….

Scenario: Reading data from databases through context-based dynamic connections – Docs for ESB 6.x

Scenario: Reading data from databases through context-based dynamic connections In this scenario, MySQL is used for demonstration purposes. We will read data from database tables with the same data structure but in two different MySQL databases named project_q1 and project_q2 respectively. We will specify the connections to these databases dynamically at runtime, without making any…