SQL SELECT Query

xdumontnti — Thu, 24 May 2018 09:50:56 GMT

Hello,

The original official statement from Autodesk is: All SQL access is prohibited.

But today I found a new post and I ask you (an Autodesk employee) to clarify the situation.

This one explain it's prohibited to access directly the SQL database. But in the samples, nothing about SELECT queries. => SELECT prohibited YES or NO?

https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/Autodesk-Vault-Manually-editing-a-database-contained-in-the-AUTODESKVAULT-SQL-instance.html

This one explain that Autodesk Support don't provide SQL Query and you need to create it by yourself.

Then it's allowed to do a SQL query?

https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/Can-Autodesk-Support-generate-Microsoft-SQL-queries-to-be-run-on-Vault-databases.html

Thanks in advance to clarify this.

Re: SQL SELECT Query

ihayesjr — Tue, 29 May 2018 14:01:14 GMT

It is not allowed to perform any operations that directly access the Vault databases. You must use the APIs to perform the needed operations.

topic Re: SQL SELECT Query in Vault Customization Forum

SQL SELECT Query

Re: SQL SELECT Query