I don't know of a direct connection, but IDMS does have an ODBC driver you can use and then you can use SQL Statements or Stored Procedures, and get the data in an ODBC result set. You will have to configure ODBC on the server and set and define the datasourse before you use SQL.
Dig Deeper on Domino Resources - Part 7
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response. Continue Reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead. Continue Reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ... Continue Reading