Connect and read/write data from mainframe z/OS via DB2

One Star

Connect and read/write data from mainframe z/OS via DB2

Hi,
Are there any other options ? Basically, for my use case, I am trying to connect to a mainframe z/OS. One option is to connect to DB2 which is running on z/OS. I am trying to connect from Talend Enterprise ESB. If there is a JDBC adapter or other approach e.g., managed connection to DB2 on z/OS ?
We are currently using both, Sybase DirectConnect as well as DB2Connect. We intend to move out of these product stacks and move into something which is opensource (not looking for community editions).
Also, for an additional requirement I would like to know if translation to/from ASCII and EBCDIC and vice-versa happens only with tFileInputEBCDIC and tFileOutputEBCDIC. Are there any other options. Again I am considering only enterprise editions of Talend.
TIA.
Community Manager

Re: Connect and read/write data from mainframe z/OS via DB2

Hi zerograviti,
Let me investigate your question.
Can you confirm that you're already a Talend Enterprise ESB customer, but you're looking for possible other options in the Talend product range that could meet your requirements which are:
- connect to DB2 on z/OS (or other applications on z/OS)
- connect to DB2Connect
- connect to Sybase DirectConnect
- transform ASCII to EBCDIC and vise versa
Let me know if I understood well. I'll investigate among the Talend Team to give you the best answer.
One Star

Re: Connect and read/write data from mainframe z/OS via DB2

Let me clarify:
No, I am evaluating Talend Enterprise ESB.
I am looking to connect to DB2 on z/OS from TESB. The requirement is to connect + interact (ie data access operations like read/write to mainframe). This usually involves ASCII <-> EBCDIC translation.
We already have (a) DirectConnect and (b) DB2Connect. I am investigating the need to eliminate these (a and b) if we can achieve this in TESB above.
Hope that clarifies.
Employee

Re: Connect and read/write data from mainframe z/OS via DB2

Hi Zerograviti,
The Talend Connectors for DB2/Zos will guarantee through the JDBC driver created/certified by IBM that the data you query will be translated from EBCDIC to ASCII.
It's totally transparent for the end user and do not require the DB2Connect or DirectConnect or any specific transformation.
It's only required the ability to setup the connection through the JDBC driver : hostname, port, username, password, database and schemaname.
So I can guarantee you that you can eliminate both DB2Connect and DirectConnect.
To follow your last post. If you are using the Integration perspective and create a DB2/Zos connection from the Metadata repository wizard; you'll be able to create the link and dig into this DB to retrieve Table definition and then extract or load data in there.
Let me know if you need further information.
Thanks.
One Star

Re: Connect and read/write data from mainframe z/OS via DB2

Hi Cantoine,
Thanks for that update. Wanted to check with you who will provide the JDBC driver ? Can you please explain what you mean by created/certified as I am unsure if these mean the same or something different ?
Also wanted to check with you if there are connectivity options to connect to the z/OS mainframe from Talend Enterprise ESB e.g., with message queuing in pub sub mode.
Thanks.