February 9, 2012 at 8:49 am
I have been scouring the web for references to using SSIS to do ETL from a NOMAD database as the datasource without much luck. We currently have a lot of legacy data and application running on our aging IBM mainframe systems. More importantly, we have a VM sub-system on our mainframe that is hosting a database management system called NOMAD. besides being a self-contained DBMS, it also has internal (green) screen appications and stand-alone executables. NOMAD, for the mainframe environment, is sort of like having super-users hosting Microsoft Access soulutions in the network enviornment.
We are in the process of upgrading the NOMAD data and applications to SQL Server and ASP.NET solutions. However, the most important step is migrating the data to SQL Server using SSIS. It sure would be a lot easier if I could find some way to directly access the NOMAD data with an ODBC connection of some sort. Since, NOMAD is a fully relational 4GL DBMS, there should be a way to use an ODBC connection to access the database, much the same as can be done with DB2 on the mainframe. However, I have not found out to do it. Our only recource is to write a bunch of cumbersome time consuming scripts in NOMAD to export each table a network .CSV file and then use SSIS to do the ETL with the .CSV files as the datasource.
Please, has anyone know how to directly access the NOMAD data or know someone who has done this?
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
February 10, 2012 at 1:37 am
The only thing I found is this:
http://www.decosta.com/Nomad/cgiseries/cgipart1.html
It talks about using visual basic to extract data from Nomad, but it's also talking about Windows 95, so I'm afraid it is a bit outdated.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 27, 2012 at 4:19 am
Hi Ron,
I'm still working with NOMAD under z/VM and I've installed the rexx files (written by Don Decosta) and webshare from Rick Troth as described on Decosta's homepage;
passing data from NOMAD and displaying them in browser works fine.... and writing Nomad Server Pages are no problem.
Now I'm also interested how I can do an access to NOMAD data via VB or C#.
The question is: How I do the ADO connection which is NomadGateway in the VB code example.
I'm able to manage every ADO connection between VB MS Access or MS SQL.... but not to NOMAD running under z/VM....
TCP/IP is installed and NOMAD data can be reached through http//myaddress:8080/local/..
... but how to manage via ADO ... I've no idea!
Maybe, you got any information in the meantime?
Dieter
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply