Equivalent component in Talend for External Source in Datastage

[Anonymous]

I'm new to Talend, my design includes an External Source component in IBM Datastage, for which I need to find an equivalent in Talend.

Here are the details for the said component.

External Source : ES********

Outputs to Transformer stage XYZ123 

Keep File Partitions:	False
Reject Mode:	Continue
Source Method:	Specific Program(s)
Source Program:	sed 1,2d #$******_****#/XYZ/inbox/#FILE****#_#FIELD****#*.txt | sed 's/^[^|][^|]*|//'
Format:	final_delim=none, delim='|', quote=double

Output Columns

XYZ_1	VarChar(20) nullable
XYZ_2	Integer(10) nullable
XYZ_3	Char(2) nullable
XYZ_4	VarChar(20) nullable
XYZ_5	VarChar(50) nullable

[vapukov]

Hi,

here no direct analog for external stage

in theory, you can pass data as variable to tSystem and read output from tSystem also thru variable, but it is not the same

when I need to process data with an external script I use files (CSV, XML, etc)

• prepare file with Talend (export, download, etc)
• run script/program with tSystem with output redirected to a local file in knowing format
• read the file with Talend

cheers

[vapukov · Accepted solution]

Hi,

here no direct analog for external stage

in theory, you can pass data as variable to tSystem and read output from tSystem also thru variable, but it is not the same

when I need to process data with an external script I use files (CSV, XML, etc)

• prepare file with Talend (export, download, etc)
• run script/program with tSystem with output redirected to a local file in knowing format
• read the file with Talend

cheers

[Anonymous]

Thank you, that should do the job.

[Anonymous]

Thank you, that should do the job.