You are not logged in.
Thank you for your reply, I may be using in a wrong way the control you say, because it requires a single table field to map the record set, and I need to process a whole table. Can you give me some input about it?
Stored procedures return a "recordSet" object -- Try using a tParseRecordSet component to "unroll" the SP response into a Talend Row
good morning, sorry if this was posted before, didn't find a case to suit my needs with search engine, hope I didn't use it in a wrong way.
I have a mysql stored procedure that takes data from a database and inserts them on a staging database for an ETL process. the stored procedure is created in databse and it's working, already tested it from the mysql IDE. In my Job I have a tMysqlConnection object to store the connection parameters from an external file, used a tmyslsp component to call the stored procedure form the database and a tmyslouput to write data inside. I added a screenshot of the job.
The tmysqlsp and tmysqloutput have built-in schemas, made with the same structure of the staging database table where the data will be inserted, and they use the stored connection in the tmysqlconnection object for it. However when I run the job, I get empty values. What am I doing wrong? Any input would be appreciated, thank you very much.