AS/400 Custom component, studio 7.1

[Anonymous]

HI,

Few questions -

I've built a custom connector which connect to as400, make a program call with a unique key as an input, and return the suitable entity:

1. How can I log each transaction in my IBM db2 (query itself, data which has passed, date-time)? I know the terminal command ,DSPJRN JRN, but how i can use it in talent to connect to the journal?

2. How can I map the specific returned entity (It is complex structure entity) from the as/400 ? I use a function with the @Producer annotation to return it but I really don't know where it return to or how can I catch it in talent studio and use it in my jobs flow.

[Anonymous]

Hello,

Are you using Java Jet approach or talend component Kit to build your custom connector?

Best regards

Sabrina

[Anonymous]

HI @xdshi ,
I'm using talend component Kit

[Anonymous]

@xdshiIs there any idea?

[igorbeslic]

Hi @dani31090 beside AS400 JDBC Driver operations, other complex operations against AS400 programmatically  can be done with IBM Toolbox for Java. However it will require you to write some custom Talend code to provide it with access credentials.

IBM Toolbox https://www.ibm.com/support/knowledgecenter/en/SSPSQF_9.1.0/com.ibm.etools.iseries.toolbox.doc/page1... allows you to execute any terminal command and retrieve results in your code.

Question 2: Every structure from outside system is specific and as I see how Talend works you just apply patterns from documentation or code related to salesforce components (helped me a lot) https://github.com/Talend/connectors-se/tree/master/salesforce/src/main/java/org/talend/components/s...

Btw. AS400 data record format almost matches Talend's Record methodology. I guess you could also use IBM Toolbox to analyze it, or if available via DB2 use table metadata to recreate structure (see salesforce components).

Hope this will help you to make a step