topic Re: Access to Vault database Read Only for comparisson with ERP database in Vault Forum

Access to Vault database Read Only for comparisson with ERP database

Tom_de_Graaff — Mon, 11 Sep 2023 10:26:52 GMT

Hi,

In order to compare the data in the Vault with the data in the ERP (Ridder) database, I want to look into the Vault database. I know changing is off limits. I only want to read the data.

The way the tables are set up is not very transparent. Does anyone have figured out the right tables to access for file related data?

The reply from my local Autodesk contact was "use a search in Vault Client and export that data to Excel". I know how this works, safe, but very slow.

End goal is to use a PowerBI to compare the data and manually edit the Vault data via de Vault Client.

Kind regards, Tom de Graaff.

Re: Access to Vault database Read Only for comparisson with ERP database

CGBenner — Mon, 11 Sep 2023 12:34:30 GMT

@Tom_de_Graaff

Hi Tom, I believe that the SQL database in the ADMS is encrypted for security, and cannot be directly accessed even for Read Only purposes. I'm going to tag in @ihayesjr to confirm and maybe offer more information.

Re: Access to Vault database Read Only for comparisson with ERP database

ihayesjr — Mon, 11 Sep 2023 13:15:28 GMT

@Tom_de_Graaff

Please see the comments in this thread.

Vault Extract Item Data (BOM) - Autodesk Community - Vault

Re: Access to Vault database Read Only for comparisson with ERP database

jose_oltra — Wed, 13 Sep 2023 10:04:54 GMT

Could you elaborate more on "Related data"?

Are you talking about BOMs for a design?

Or are you talking about true relationships , like the "where used" tab? (which includes attachments)

Re: Access to Vault database Read Only for comparisson with ERP database

Tom_de_Graaff — Thu, 14 Sep 2023 14:23:49 GMT

I'm thinking of all kinds of data, things like workflow state (not all things obsolete in ERP are obsolete in Vault jet). Or a BOM structure, a number of parts in the BOM, anything releated to ERP.

Old stuff from our old ERP system and old Vault are mixed in the live ERP system, so sometimes data is out of date. We want to fix this.

Re: Access to Vault database Read Only for comparisson with ERP database

jose_oltra — Thu, 14 Sep 2023 14:41:16 GMT

Your safest bet is to use the Vault API to access the data.

Particularly using

Autodesk.Connectivity.WebServices > DocumentService >FindFilesBySearchConditions

From the Files[] retrieved you will be able to get the file lifecycleState:

File > FileLfCyc > LfCycStateName

And the BOM:

Autodesk.Connectivity.WebServices > DocumentService > GetBOMByFileIds

All of these are well documented on the Vault API