The Microsoft tools Excel and MS Access can be used to access SQL data sources. If the SQL Option is installed on a CA IDMS mainframe, they can also be used to access the data residing there. However, several steps must be taken to accomplish that access.
For both MS ACCESS and MS EXCEL, you will need to create a FILE DSN (Data Source) in IDMS Server in order to connect to the IDMS mainframe.
These are the basic steps to accomplish that:
You can hit the TEST button to see if the configuration is successful; the CV must be up for this to work. The test will open a logon window asking for your mainframe credentials in order to sign you on. When you click OK, it will test the data source connection.
Once the above steps are complete, the data source has been defined through which MS Excel and MS Access can access the mainframe. Next, in MS EXCEL or MS Access, from the top panel select Data:
There are several prerequisites to the above steps:
If the above steps are not successful, review these prerequisites to determine if one of them may causing the lack of success.