Connecting Plant 3D to MSSQL

[sedong.hwang]

I have connected the Plant3D data to Mssql using PnPProjectMaintenance.exe.

Does Plant3D synchronize with MSSQL in real-time so that changes made to the data in MSSQL are applied to Plant3D? For example, if the length of a pipe is 1000, and I change the value in MSSQL to 100, will the length of the 3D pipe model in Plant3D change to 100?

[h_eger]

@sedong.hwang ,

No, unfortunately this does not work.
We write all data to the DB regardless of MSSQL or SQLite.
Only graphical changes must be made in P3D and not in the DB.

[sedong.hwang]

Thank you for your reply.

Is there a way to create, modify, and delete 3D models without using Plant3D, by utilizing an SQL database? Developing algorithms in SQL and executing them through queries would be a typical example.

[h_eger · Accepted solution]

@sedong.hwang ,

No, this is not planned in the development of P3D.
Please contact Autodesk at the Idea Station where you can ask such questions.

[sedong.hwang]

Thank you for your reply.

Why can't geometry data be modified in MS SQL, and why can it only be changed in P3D? Does MS SQL not have geometry data?

Additionally, if there is geometry data in a DWG file, can it not be included in MS SQL? Or is it not possible to access the DWG file to retrieve the geometry data?

[h_eger]

Correct, the geometry data is NOT written to the database (SQLite, MS SQL etc).

Are you from E3D or why this question?

To my knowledge it was never the intention of Autodesk to have a database based 3D model.
The basis was Autodesk AutoCAD and therefore linked to the dwg format.