I am thinking currently if it is possible to access a PDMS project data outside PDMS application using some API.
E.g. imagine that I have access to the project location through the file system.
What are the solutions I can use to access the project database from C# code?
There is AVEVA SQLDirect, I think I can setup the data provider using the project location and my credentials, and then use ODBC to work with a PDMS project.
Does SQLDirect supports AVEVA PDMS 21.1.x projects or only PDMS 12.0.x projects?
Are their any limitations or I can access any databases of the project like this (because in SQLDirect documentation I saw it works with the design database only...)?
Are there any alternative solutions for my task?
Thanks a lot in advance for any hints and suggestions!
Yes, U can access data outside PDMS but U will need some AVEVA licence (DESIGN\SHEMATICS\ and other..).
One of the way is to use PdmsStandalone assembly ( ex. http://52.178.132.139/showthread.php?t=17139&highlight=PdmsStandalone).
That will login(periodically) to PDMS, collect all info, save it to your sql\mysql or other dbase.
Thanks for a hint!
No problem regarding the licenses - normally I have enough.
I am just wondering what is the right way to access data in a PDMS project from outside PDMS - and I need "full online" mode because background copying of PDMS data to some external database would complicate the things a lot due to multi-user access:
1. AVEVA SQL Direct API - is it supported currently? It was last mentioned in 12.0.x release notes - did AVEVA stop its maintenance?
2. PdmsStandalone API - I am concerned that it launches a PDMS instance in background, so what would happen if several users try this way simultaneously on the same machine? How much system resources that would require?
3. Any other solutions?
I guess the moth methods would require N PDMS licenses, where N is the maximal number of simultaneous user connections to the PDMS project, right?
Is it possible to compare solutions 1 and 2 in terms of system resources required, API available (e.g. PdmsStandalone gives normal access to AVEVA .NET API while SQL Direct seems to provide SQL access, right?)?
AVEVA told that SQL Direct component is no longer available since PDMS 12.1.
Thus either it is necessary to use some kind of export from PDMS (including e.g. a PDMS add-on that can expose project data through some communication protocols), or PdmsStandalone API can be used.