[resolved] execute a query

One Star

[resolved] execute a query

Hi,
I would like to know which component I need to use to execute a SQL query independantly of other component? Because, at the beginning of my job, I need to execute a query to insert one line in a database.
Caro

Accepted Solutions
Community Manager

Re: [resolved] execute a query

Hello
But I just need a component for inserting one line in a database at the beginning of my job and I don't have any input for the component !

If you just wanna execute a insert statement, the txxxRow component can fit your need.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Highlighted
Community Manager

Re: [resolved] execute a query

Hello
Using the txxxInput components for executing a query and the txxxOutput components for inserting data into database.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] execute a query

Hi,
A txxxOutput component needs an input link. But I just need a component for inserting one line in a database at the beginning of my job and I don't have any input for the component !
Caro
Community Manager

Re: [resolved] execute a query

Hello
But I just need a component for inserting one line in a database at the beginning of my job and I don't have any input for the component !

If you just wanna execute a insert statement, the txxxRow component can fit your need.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] execute a query

Exactly the answer I was looking for, thank you! Smiley Happy

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads