We use PPM for issue requesting and Microsoft Office SharePoint Server 2007 as document library. We would like to get an integration between these applications.
If we create a requist with PPM we can attach documents, these documentsdata is stored at the PPM Server. The problem we get is that the PPM Server get very slow because the many data, but PPM is not a for document library use. So we want to store the documents in MOSS 2007.
Is it posible to get a integration between these applications? And how? by using links or .....
As such you can sure use PPM as document library through HP PPM Document Management. If your organization is ok with doing away with MOSS, then you can do it in PPM as well. That way, you won't need to do any kind of integration with MOSS and both your requests and documents remain at one place also. Through Document Management you can also do the same things like check-in, check-out, version control etc. Ofcourse this is not the solution for MOSS integration but just an alternate solution. Also, the documents/attachments in PPM are not stored in the database but on the file system, so it should not slow down the PPM performance. If the performance of your PPM is slow then it may be due to other reasons also. You can refer DocMgmt.pdf guide for further reference or if you want to suggest using Document Management in your organization for the document management through PPM.
Also, if you use SharePoint to maintain the documents then two possible options,
1. In PPM requests, you may use the URL field type or the read-only text field by encapsulating the SharePoint document link in the doc_link. This way you will have all the actual documents in SharePoint and only the links to document in PPM.
2. Can you check if SharePoint stores all documents in SQL Server database or on file system? I am not sure about that. If it stores on the file system (same as PPM) then you may be able to access the documents directly from PPM by giving read-only access to the SharePoint folders to the ppm o/s user, which should then allow the end users from requests to open/read the documents directly. This is some test you may have to do and check if that will work, but again if SharePoint stores on file system. Otherwise option 1 should sure work.
I believe that may be possible. But this is something you will need to test. The other thing is you will need to give the read access to the file system of the SharePoint to the ppm o/s user to make this work. Otherwise the documents may not load from ppm application when the user clicks on the document link from requests.