[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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads