Connecting to DB2 on an AS400?? Help!

Highlighted
One Star

Connecting to DB2 on an AS400?? Help!

I've been using MySQL very successfully for a while now but we've got DB2 on an AS400 mainframe that
I'd like to start pulling data from. In our current dev environment all the programmers have to have DB2 Connect
installed on their pc. I've never used it before but I think the issue is you have to log in to the AS400 first then
log into DB2. How do I set that up to create a connection in Talend so I can get to these tables?
One Star

Re: Connecting to DB2 on an AS400?? Help!

Ok, now someone out there has to be running a mainframe. Smiley Happy
Six Stars

Re: Connecting to DB2 on an AS400?? Help!

You just need as400 components provided out of the box by Talend to access DB2/400 on a midrange (as400 isn't a mainframe) iseries.
You need a user on the as400 system and then just connect natively via Talend components (no need of db2 connect); the drivers that talend uses are created by IBM anyway.
WRKUSRPRF to create profiles.
STRSQL to do some sql commands.

bye

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch