[resolved] execute a query

Highlighted
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
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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

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