IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

IMS DB / DB2 simulator for ETL testing on Windows OS


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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: 924
Location: Maryland

PostPosted: Thu Nov 21, 2019 8:40 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Excel VBA integration with AS400 Macr... All Other Mainframe Topics 1
No new posts Call a transaction simulator froma st... IMS DB/DC 0
No new posts Pack to Unpack conversion for sending... COBOL Programming 13
No new posts Regression testing of date format con... CLIST & REXX 0
No new posts Rexx command to open an another text ... PC Guides & IT News 7
Search our Forums:

Back to Top