Read data from Intralink database

[vince74]

Hi,
I would like create a web application (ASP.NET) that can read data directly inside the Intralink database, but from a computer with no PTC product (Intralink and Proe).

Find a single information, like only one field, in the oracle database is easy : just an SQL request.

But , in my case, I would create for a assembly, the list of the component with the quantity.

Can I make this with the free package J-Link or Web.Link ?

Thanks for all

 

[williaps]

vince74,


Yes this is possible and I have done it. However it is quite complicated due to the nature of the API that is required to access data from a Pro/INTRALINK 3.X database. This API is a C API and requires a large set of environment variables to exist. The API is called the Pro/INTRALINK Toolkit.

 

[JamesM]

This may be a stupid question, but is the Toolkit an add-on to Pro/INTRALINK or is it included?

 

[williaps]

The Pro/INTRALINK Toolkit is on a separate CD than the client. You must also have at leat 1 ILINK_TK_ACCESS_LICENSE to execute a Pro/INTRALINK Toolkit application. In the aforementioned application design where many users could potentially be viewing the web page that queries the Pro/INTRALINK database, you would need 1 ILINK_TK_ACCESS_LICENSE per user request. Otherwise the request will fail.

 

[rcamp]

There's Intralink scripting, but it requiresintralink. In intralink, press ctrl-s and it brings up the Intralink Java compiler. Records actions and fully java compatible. I am developing a script know to load data into my ms access pdm database.


http://www.profilesmagazine.com/p39/reddy.html
Edited by: rcamp

 

[JamesM]

I am developing a script know to load data into my ms access pdm database.

I would be interested in hearing more about this. I'm attempting something similar - I have a script that runs periodically to produce a text file for another database (FileMaker Pro) to use to update a part number list. I know of no way to let the Intralink script directly access the FileMaker database. Are you able to do this with your MS Access database?

 

[rcamp]

This is where I found the code that I adapted for my purposes:


http://forums.devx.com/archive/index.php/t-157631.html

 

[JamesM]

This is where I found the code that I adapted for my purposes:


http://forums.devx.com/archive/index.php/t-157631.html

This is interesting - unfortunately I can't make it work. Anyone have experience doing this with a FileMaker Pro data source? Specifically I'm curious how the


String database = "jdbcdbcriver={Microsoft Access Driver(*.mdb)};DBQ=";


should look with a FileMaker (.fp7) database. My attempt was


String database = "jdbcdbcriver={FileMaker Pro Driver (*.fp7)};DBQ=";


but doesn't work.

 

[rcamp]

http://forums.sun.com/thread.jspa?messageID=2608753