Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
IMS DB / DB2 simulator for ETL testing on Windows OS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
dejames

New User


Joined: 21 Nov 2019
Posts: 1
Location: Australia

PostPosted: Thu Nov 21, 2019 12:37 pm    Post subject: IMS DB / DB2 simulator for ETL testing on Windows OS
Reply with quote

Experts, Senior Members and Everyone,

Requesting your help on a unique situation we are facing.

We are trying to test a ETL tool. Our end goal is to do ETL process on IMS DB ( extract the data from IMS, Transform it to Relational format and then Load it to MySQL / any other relational database) for analytical purposes. Now the problem in front of us is that we do not have an active IBM mainframe connection. But we do have a ETL tool which is designed to support IMS DB to SQL data transfer. This is the reason why we would like to know whether there is a way to simulate IMSDB on windows OS and test the connection / data transfer. Similarly the case for DB2 as well. Are there any simulators or tools available which can be installed on Windows OS so that we can replicate ODBC connection.

We tried various sources to get this information including forum search but couldn't locate any useful information. Appreciate your help in advance.
Back to top
View user's profile Send private message

sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 632
Location: Maryland

PostPosted: Thu Nov 21, 2019 8:40 pm    Post subject:
Reply with quote

If any sort of IMS DB simulator was running on Windows (what for???), then you would only be able to check connection between two Windows, but not with any zOS…
Isn't it?
12.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Pack to Unpack conversion for sending... A_programmers COBOL Programming 13 Wed Sep 11, 2019 10:46 pm
No new posts Regression testing of date format con... prino CLIST & REXX 0 Fri Jan 11, 2019 5:39 am
No new posts Rexx command to open an another text ... Bharath Vikraman PC Guides & IT News 7 Sat May 12, 2018 4:34 pm
No new posts Date in where clause - Windows Karthikeyan Subbarayan DB2 9 Wed Nov 15, 2017 9:07 pm
No new posts JES2 job size field matching Windows ... SRICOBSAS All Other Mainframe Topics 4 Tue Sep 05, 2017 5:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us