I have used the Oracle ODBC driver in conjunction with ASP scripts to build a simple web
app that queries Intralink for drawings and then views them.  The trick, of course, is figuring
out the Intralink schema.  For example, to find all Adobe PDF files in our Intralink
implementation (including revision, version, mapped files name, etc...) uses this SQL query
(yikes!):
 
SELECT PDM_PRODUCTITEM.PINAME, PDM_PRODUCTITEMVERSION.PIVREV, PDM_PRODUCTITEMVERFILE.PIVFMAPNAME, PDM_PRODUCTITEM.PITYPEID, PDM_PRODUCTITEMVERSION.RLID, PDM_RELEASELEVEL.RLNAME
FROM PDM.PDM_PRODUCTITEM PDM_PRODUCTITEM, PDM.PDM_PRODUCTITEMVERFILE PDM_PRODUCTITEMVERFILE, PDM.PDM_PRODUCTITEMVERSION PDM_PRODUCTITEMVERSION, PDM.PDM_RELEASELEVEL PDM_RELEASELEVEL
WHERE PDM_PRODUCTITEM.PINAME = PDM_PRODUCTITEMVERFILE.PIVFNAME AND PDM_PRODUCTITEMVERFILE.PIVID = PDM_PRODUCTITEMVERSION.PIVID AND PDM_PRODUCTITEMVERSION.RLID = PDM_RELEASELEVEL.RLID AND ((PDM_PRODUCTITEM.PITYPEID=141))
 
I used Microsoft Query (Included with Office) to explore Oracle.  If you paste the SQL from
above into MS Query, you will see a graphical depiction of the schema (obviously a subset). 
 
 
http://www.ptcuser.org/exploder/datamgt/200201/msg00105.html
 
 
This seems to work for a simple application.  I wouldn't want to try and figure out the schema
for bills of material!  Though, if anyone else has done anything similar and figured out some
other useful SQL statements, please share them.