Community
Vault Forum
Welcome to Autodesk’s Vault Forums. Share your knowledge, ask questions, and explore popular Vault topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Vault SQL queries

5 REPLIES 5
Reply
Message 1 of 6
Anonymous
638 Views, 5 Replies

Vault SQL queries

Is it possible to extract information from the vault by sending it a SQL query? Is it also possible to set up a ODBC connection to the vault? Where can I get more information on this concept?
5 REPLIES 5
Message 2 of 6
Anonymous
in reply to: Anonymous

While this is possible, it's neither documented nor recommended. The
reason is that any modifications to the database schema that may be made
in future updates or releases may break any queries written.

Of course, you should NEVER attempt to modify data in the database via
direct SQL/ODBC access.

Could you describe some of the kinds of information you're looking to
extract? Perhaps we already have, or could provide in the future,
instructions and/or "productized" ways to get this data.

Thanks,
Jeff

ohunome wrote:
> Is it possible to extract information from the vault by sending it a SQL query? Is it also possible to set up a ODBC connection to the vault? Where can I get more information on this concept?
Message 3 of 6
Anonymous
in reply to: Anonymous

I'm only interested in extracting information from the Vault. I would like to setup a linked table inside of access that can do further analysis with while maintaing data integrity with information from the vault. I would like to extract "iproperties" such as custom properties, vendor name, cost... from the parts and assemblies in the vault.
Message 4 of 6
Anonymous
in reply to: Anonymous

Take a look at the PropertyDef and Propery tables. These relate to
entries in the Entity table. Many types of "objects" are "entities",
based on their EntityClassID (EntityClass table). Files, for example,
are rows in the FileIteration table.

Again, this is not well documented, so it will be a bit of "hunt and
peck". These table structures *will change* in any subsequent
update/release.

A better way to go might be to utilize the Web Service API, which is
documented as a technology preview in the SDK folder of the release
media. This interface, while not absolutely stable, will be relatively
more stable.

Jeff

ohunome wrote:
> I'm only interested in extracting information from the Vault. I would like to setup a linked table inside of access that can do further analysis with while maintaing data integrity with information from the vault. I would like to extract "iproperties" such as custom properties, vendor name, cost... from the parts and assemblies in the vault.
Message 5 of 6
ADN0148
in reply to: Anonymous

Where is the SDK folder for Vault 4.1 I installed and did not get the SDK folder. Do you need to do something special
Message 6 of 6
Anonymous
in reply to: Anonymous

Sorry, maybe it's not on the release media. See this link for attached
information:

http://discussion.autodesk.com/thread.jspa?threadID=406672

Jeff

ADN0148 wrote:
> Where is the SDK folder for Vault 4.1 I installed and did not get the SDK folder. Do you need to do something special

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report