You are not allowed to add your own tables to an EPDM database. However, you can create your own database and add tables, etc.
Also, look into using a Linked Server.
I've also used Joy's recommended solution. Works great. BTW, I don't recommend altering one's EPDM database based on voiding support, I don't recommend it based on the damage you could quickly render to your company's data management system which may be unrecoverable.
Joy, I have worked with our ERP contractor to create a linked server to tie in our ERP data directly into EPDM data. Working on connecting the inventory and labor to the EPDM data being used in the shops.
Hi Tim -
You should do a presentation at SolidWorks World about how you linked EPDM/ERP.
I like linked servers because it simplifies the queries. I'm also looking at tools like SnapLogic for this sort of work.
Create another database on the same server and use dot notation to access it in your queries. For example, if your vault database is EPDM and your external db is Publications, you can do a query like the following;
SELECT * FROM EPDM.dbo.Documents d
JOIN Publications.dbo.Products pp ON pp.id = d.DocumentID
WHERE Filename = '123-456789'
You could execute that query from either "database". (It really comes down to what catalog you specify in your connection string, if you're using one.)