Training · Plant 3D · Autodesk Authorized Training Center
Plant 3D Database Management
For administration: manage project databases and migrate them to SQLSQL – Structured Query Language Query language for databases. “SQL Server” is Microsoft's database system; AutoCAD Plant 3D can store its project data there instead of in SQLite files. Background and sources › Server
Understand and manage AutoCAD Plant 3D project databases: structure of the SQLiteSQLite Database in a single file, without its own server. AutoCAD Plant 3D stores project data this way by default. Background and sources › databases, migration to SQL Server Express, DbConnectDbConnect – dbConnect Manager AutoCAD tool (command DBCONNECT) that links drawing objects to tables in external databases. Background and sources › Manager and analysis with the Report Creator.
Who is the training for?
Target audience
- CADCAD – Computer-Aided Design Computer-aided design and drafting. Background and sources › administrators and IT managers responsible for Plant 3D
- Teams running projects on the network with several people
- You want to analyze project data
After the training, you can …
- Check, back up and repair project databases
- Migrate projects from SQLite to SQL Server Express
- Analyze data with Report Creator and SQLite tools
Contents
- Project databases in Plant 3D
- Migration SQLite → SQL Server Express
- DbConnect Manager
- SQLite and SQLiteStudioSQLiteStudio Free program for viewing and editing SQLite databases. Background and sources ›
- Report Creator
Prerequisite
Plant 3D fundamentals. Suitable preparatory course: AutoCAD Plant 3D Fundamentals.
Process
Four 90-minute blocks per training day with exercises at your own CAD workstation – live online or in Frankfurt. The days are not stretched.
✓ Included: 3 months topic package Plant 3D Administration (online manuals + course manuals)
Upcoming dates
No suitable date? As company training, we adapt to your schedule.
Loading dates …
Dates & quote Request a date by email All training dates
Prices per person, net, plus VAT. A tiered discount applies from two participants – the training calendar calculates it immediately. Registration closes 8 days before the start; the course runs with a minimum of 3 participants.
What participants say
"Very good training, very good instructor – competent, flexible, easy to understand."
Steffen Scheidt, formerly Tebodin Peters Engineering GmbH
"'Impossible' doesn't exist. If a question remained open, it was researched. I can highly recommend it."
Jacqueline Sand, Weber Industrieller Rohrleitungsbau & Anlagenbau
All references
10 voices from plant engineering, industry and water management.
Keep learning
Here's where to go after the training.
Plant 3D Configuration & Data Management
For CAD administration: set up and manage Plant 3D projects centrally
Plant 3D Piping Spec Workshop
For piping spec management: build your own specs and catalogs
Learning path
Four qualification levels, five steps from getting started to project management.
Questions from our training courses
These are the questions participants ask most often – with the answers from the training.
“Remove Filter” in the Data Manager has no effect – what can you do?
A filter in the Data Manager can only be removed at the node where it was set. To do so, select the node (e.g. the higher level Equipment) and right-click Remove Filter there.
How do I jump from the Data Manager to an object in the drawing?
Select the entire row using the field on the far left (not just a data cell) and activate the Zoom button (magnifying glass) – the program then zooms to the object. Other functions: hide empty columns, filter by selection, Refresh (synchronizes drawing and data). You can drag and drop property values into the drawing as annotations. If the Data Manager has "disappeared", it is often auto-hidden at the edge of the screen.
How do I export only the data of one drawing or one area from the Data Manager?
In the Data Manager, select the desired node (e.g. the drawing) and use the option “Active nodes only” when exporting. Then only this data is exported to Excel.
How do I edit P&ID data (many properties at once) in Excel and import it again?
1. In the Data Manager, select the required node, e.g. Equipment, and click Export – "active node only" produces exactly one table; with child nodes, several sheets are created. 2. Change the values in Excel; do not change the column with the internal IDID – Identifier Unique identifier, e.g. the number under which a record is kept in a database. Background and sources › (PnPID), as it is used for matching. If the sheet is protected: Review > Unprotect Sheet. 3. Save the file and close Excel, otherwise it is locked. 4. In the Data Manager, select the same node and click Import. Changed values are highlighted and can be accepted individually or with "Accept All".
When importing from Excel into the Data Manager, the same values are highlighted yellow again with every import – why?
The content is longer than the permitted field length. Plant 3D or P&IDR&I – Piping and instrumentation diagram Flow diagram showing all pipes, valves, equipment and instrumentation of a plant (P&ID, Piping and Instrumentation Diagram). Background and sources › truncates it on import; the Excel list still contains the long text, so every import reports a change. Shorten the text in Excel to the field length.
How do I create custom views in the Data Manager, e.g. nozzles by equipment or order status?
In Project Setup, under the Data Manager configuration, choose "Create View" and define the name and scope (project or drawing). Use "New Level" to build the grouping: first filter the object type (e.g. nozzles), then add further levels by fields such as equipment tag, line tag, manufacturer or a yes/no field "ordered". You will then find the view in the Data Manager under the custom project or drawing views. After changes, reload with the Refresh icon.
Frequently asked questions
When is SQL Server worthwhile instead of SQLite?
As soon as several people work in the same project at the same time or projects become large. In the training, we migrate a project step by step.
Do I need database skills?
No, basic Plant 3D skills are enough. We explain the database tools from scratch.
Where does the training take place?
Preferably live online from your own workstation – efficient, without travel and resource-friendly. For every date you can also attend in our training room in Frankfurt am Main; for company training, we come to you.
How long is a training day?
A training day consists of four blocks of two 45-minute teaching units each. The days are not stretched – a four-day training course lasts four days.
Is there a discount if several people from your team attend?
Yes. A tiered discount applies from two participants; the training calendar calculates the price immediately when you book.
How late can I register?
Registration closes eight days before the start. The course runs with a minimum of three participants – you will receive confirmation in good time.
Can you run the training just for our team?
Yes – as company training with your project data and company standards, live online, in Frankfurt or at your site. We agree on the date and content with you.
Contact us directly
Write to us or give us a call – we'll get back to you within one business day.

Before you go …
Don't miss any training dates, C³ invitations and news on AutoCAD Plant 3D and P&ID.
Our newsletter only arrives when there's something important – concise and with tips from practice.
Terms, background and sources 9 terms on this page
Brief explanations for reference. They do not replace the standard or code itself.
- SQL – Structured Query Language
Query language for databases. “SQL Server” is Microsoft's database system; AutoCAD Plant 3D can store its project data there instead of in SQLite files.
- SQLite
Database in a single file, without its own server. AutoCAD Plant 3D stores project data this way by default.
- DbConnect – dbConnect Manager
AutoCAD tool (command DBCONNECT) that links drawing objects to tables in external databases.
- ATC – Autodesk Authorized Training Center
Training center authorized by Autodesk. A. Seitz Ingenieur GmbH has been an Autodesk ATC since 2011.
- PDF – Portable Document Format
File format for documents that looks the same on every device and can be printed – e.g. the piping class sheet.
- CAD – Computer-Aided Design
Computer-aided design and drafting.
- SQLiteStudio
Free program for viewing and editing SQLite databases.
- ID – Identifier
Unique identifier, e.g. the number under which a record is kept in a database.
- R&I – Piping and instrumentation diagram
Flow diagram showing all pipes, valves, equipment and instrumentation of a plant (P&ID, Piping and Instrumentation Diagram).
Symbols and drawing rules: DIN EN ISO 10628-1 and -2. Identification letters for instrumentation: DIN EN 62424 or ISA-5.1.
Sources and origins
- Microsoft Learn: SQL Server (for SQL)
- SQLite (for SQLite)
- Autodesk Help (for DbConnect)
- Autodesk – Training and Certification (for ATC)
- Wikipedia: Portable Document Format (German) (for PDF)
- Wikipedia – Computer-aided design (for CAD)
- SQLiteStudio (for SQLiteStudio)
- Wikipedia: Identifier (for ID)
- ISO – International Organization for Standardization (for R&I)
- IEC – International Electrotechnical Commission (for R&I)