topic Re: Equivalent component in Talend for External Source in Datastage in Talend Studio

Equivalent component in Talend for External Source in Datastage

Anonymous — Fri, 26 Jun 2020 12:50:34 GMT

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

vapukov — Fri, 26 Jun 2020 14:23:49 GMT

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