SQL and ODBC access to Intralink

[looslib]

Has anyone done any looking at the Intralink data with either an ODBC connection or SQL queries?

We need to look at data cleansing in preparation for migration to PDMLink and it is easier to do the sorting in Excel with exported data. The problem is in getting the data that we need from Intralink itself.


"Wildfires are dangerous, hard to control, and economically catastrophic."
"Fixed in the next release" should replace "Product First" as the PTC slogan.

Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand

 

[pwillia3]

Yes I have done this with a tool called PLSQL Developer from allroundautomations. You just need the schema owner login. This tool let's you browse the tables and see data, procedures, and packages. Or you could just do everything from a sqlplus prompt. It's much easier with a tool however.

Patrick