topic Re: Extract Information Using SQL Query Analyzer in Inventor Programming Forum

Extract Information Using SQL Query Analyzer

Anonymous — Fri, 22 Jun 2018 17:30:24 GMT

Trying to extract drawing information - data like Author, Part Number, Description and so on - directly from the tables on SQL server using Query Analyzer. I can't find ANY of this information in the tables.

Every table I query that starts with "BOM" is empty. How can I have a Bill Of Materials in Inventor and have the BOMComponent table in the database be empty?

The goal is to get the data in to some SSRS reports

Can anybody point me in the right direction?

Thanks

Re: Extract Information Using SQL Query Analyzer

bradeneuropeArthur — Sat, 23 Jun 2018 05:50:33 GMT

Are you talking about the vault database?

Re: Extract Information Using SQL Query Analyzer

Anonymous — Mon, 25 Jun 2018 14:28:56 GMT

Yes, the Vault database(s).

Re: Extract Information Using SQL Query Analyzer

bradeneuropeArthur — Mon, 25 Jun 2018 14:35:00 GMT

The Bill of material is only updated when Vault-Items are created.

So you cannot rely on that information when it is provided in vault without using items.

So the information is not or partly written to the vault on check in.

I have programmed this too using the Vault API, but it this is not the same BOM as inventor.

if you need further support please let me know.

Tip:

Use the Vault API to do this. because this is safer and supported by autodesk.

reading directly into the tables is not a good idea and will never be supported by Autodesk.

Regards,

Regards,

Autodesk Software: Inventor Professional 2018 | Vault Professional 2018 | Autocad Mechanical 2018
Programming Skills: Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Dimension Component! | Partlist Export! | Derive I-properties! | Vault Prompts Via API! | Vault Handbook/Manual!
Drawing Toggle Sheets! | Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !

Re: Extract Information Using SQL Query Analyzer

Anonymous — Mon, 25 Jun 2018 14:40:40 GMT

It's not only BOM information I'm looking for. Item information - Author, Date Created etc - would also be useful. It's a database, the information has to be in the tables somewhere.

I'm not trying to alter or insert any data - just find it so I can put it on to SSRS forms and reports.

Re: Extract Information Using SQL Query Analyzer

bradeneuropeArthur — Mon, 25 Jun 2018 14:45:39 GMT

You wrote:
"Trying to extract drawing information - data like Author, Part Number, Description and so on - directly from the tables on SQL server using Query Analyzer. I can't find ANY of this information in the tables.
Every table I query that starts with "BOM" is empty. How can I have a Bill Of Materials in Inventor and have the BOMComponent table in the database be empty?"

As I tried to explain this BOM information isn't there and is not updated.

You can read properties and information and the BOM structure ofcourse.
this can be easily don with the Vault API.

Is that what you need?
What version of Vault are you using?
What information do you need to be read?

Re: Extract Information Using SQL Query Analyzer

Anonymous — Mon, 25 Jun 2018 14:58:44 GMT

I don't need BOM information - I was just using that as an example. How can there be no data in the BOM tables? I find this confusing....

I need Item information and I MUST pull that information using an SQL query. NOT the Vault API. When I look for Item information in the tables I find a bunch of empty tables - I don't see how that is possible....

Re: Extract Information Using SQL Query Analyzer

bradeneuropeArthur — Mon, 25 Jun 2018 15:03:20 GMT

Yes that is confusing, but this data isn't available at or is partly available.
It is only updated if you are using items.
The table will be there already, but not filled with data.
I don't excatly know why this is as it is but..

if you are searching for invormation in the Vault, the vault Api is the easiest and the safest way.

Regards,

Re: Extract Information Using SQL Query Analyzer

bradeneuropeArthur — Mon, 25 Jun 2018 15:10:15 GMT

Read this:

http://justonesandzeros.typepad.com/blog/2012/11/the-bom-pipeline.html