February 10, 2012 at 7:57 am
Has anyone ever used SSIS to pull data from IDMS? I don't have any knowledge of IDMS, and can't find much info doing a google search. Are their special IDMS drivers? If so, does anyone know where I can get it?
February 13, 2012 at 12:42 am
If there's an ODBC driver for IDMS, you could use that one to connect to the IDMS system.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 13, 2012 at 1:36 am
I think you're referring to the IDMS product from Computer Associates. There's some information at http://www.ca.com/us/products/detail/CA-IDMS.aspx that states it does support ODBC, but I have no specific knowledge of connecting to an IDMS data source.
Dave
February 14, 2012 at 5:50 am
I think for IDMS (an a lot of other IBM mainframe datbases - Adabas, VSAM, IMS, etc) you need to use a third-party ODBC driver to access the data. We always use tcACCESS from BOSSoftware, but there are others out there as well. tcACCESS (and I'm guessing other ODBC drivers as well) require some setup work on the mainframe, so you will probably need to involve the IDMS DBA in your project.
Chris
February 17, 2012 at 3:08 pm
Thanks everyone for your responses. I really appreciate it.
April 23, 2012 at 12:01 pm
I have over 30 years experience with IDMS and have been migrating IDMS sites to SQL Server for a decade. Please contact me offline for further details.
Bob
boblentz4 @gmail.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply