topic Re: Stored Procedure to csv file on a remote server in Talend Studio

Stored Procedure to csv file on a remote server

NAdams1602707007 — Sat, 16 Nov 2024 01:15:45 GMT

Hey everyone,

I want to make sure I'm doing this right, I have a stored procedure that I want to run and put the results into a csv file. Is it as simple as using tDBSP to tFileOutputDelimited? Also the folder destination for the tFileOutputDelimited component will be going onto a remote server and a shared drive. Is there a component I need to use in a prejob to make that connection?

Re: Stored Procedure to csv file on a remote server

Prakhar1 — Wed, 21 Oct 2020 03:42:47 GMT

Yes you can use tDBSP to run the stored procedure and can store the result in output parameter and write the values in the tFileOutputDelimeted.

If you are thinking of using shared drive then it will work as target only in your Talend Studio, but if you want to run it also in the TAC server then you need to use the tSamba component. It is a user defined component which you can find in the Talend Exchange