Passing MySQL Stored Procedure parameter value

One Star

Passing MySQL Stored Procedure parameter value

Before I get too deep into troubleshooting this issue Smiley Happy
When you create a stored procedure in mysql and have a parameter to pass (a date for example), how
do you collect that parameter in TOS? In a software app I realize you'd collect the data value of an object and
pass it on the method call. How does TOS handle getting that parameter value from the user at runtime?
One Star

Re: Passing MySQL Stored Procedure parameter value

Hi,
1) use an TSO Input component where you need to define a schema; and define a schema according to the input structure in the input component..
2) use tMySqlSP component and connect to the already placed input component; and mention the stored procedure name needs to be called in the "SP Name" of tMySqlSP component apart from declaring the other database credentials.
3) select one or many defined field in the schema as parameter ( in the tMySqlSP component). select the type of parameter as Input/output etc. Define the stored procedure on the database also.
This is for calling a stored procedure from TSO job.
But your question looks like little different like calling TSO job from stored procedure. Is it this you need to do?
Hope it helps
Thanks and Regards,
Pravu Mishra.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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