Skip to main content
Software und Anwendung für AutoCAD Plant 3D · Autodesk Authorized Training Center · Frankfurt am Main Deutsch · Español · +49 69 9450725-0 · vertrieb@seitz-ingenieure.de

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.

1day
ATCATC – Autodesk Authorized Training Center Training center authorized by Autodesk. A. Seitz Ingenieur GmbH has been an Autodesk ATC since 2011. Background and sources ›Autodesk Authorized Training Center
online+ Frankfurt & on site
from 2 peopleVolume discount

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.

References ›

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.

All 671 questions from practice in the Infobase

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.

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