Document Metadata from DB?
Posted: Tue Jun 18, 2019 9:19 pm
Hello,
I'm trying to work out if I can link uploaded documents to metadata stored in a different DB?
For example I'm uploading Works Orders into the DMS. Each WO has a unique ID which can be linked in this case to an ERP system on SQL where we have a lot of data about that works order.
If I could look upto the SQL DB (Table or View) and pick the WO number, it would populate date, product, qty etc from the SQL DB rather than having to key it in again.
Cheers
Steve
I'm trying to work out if I can link uploaded documents to metadata stored in a different DB?
For example I'm uploading Works Orders into the DMS. Each WO has a unique ID which can be linked in this case to an ERP system on SQL where we have a lot of data about that works order.
If I could look upto the SQL DB (Table or View) and pick the WO number, it would populate date, product, qty etc from the SQL DB rather than having to key it in again.
Cheers
Steve