Access to Vault database Read Only for comparisson with ERP database

[Tom_de_Graaff]

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.

[CGBenner]

@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.

[ihayesjr]

@Tom_de_Graaff 

Please see the comments in this thread.

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

[jose_oltra]

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)

[Tom_de_Graaff]

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.

[jose_oltra]

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