Create Databases - Intergraph Smart 3D - Installation & Upgrade

Intergraph Smart 3D Installation

Language
English
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
11 (2016)

Administrative privileges are required to create databases. Do not proceed unless you are an administrator on the database server computer and in the database provider software.

Understanding the Databases

Smart 3D uses seven databases: Site, Site Schema, Catalog, Catalog Schema, Model, Reports, and Reports Schema. These databases must be created before running Smart 3D.

The Site database and Site Schema database are containers for the other databases. The Site database stores work-breakdown and user access for the model. A Site database can have multiple Model and Catalog databases. Typically, there is one Site database set for each location. For information about Site databases, see the Project Management Help.

The Catalog database contains reference data, which includes part dimensions and industry standards. The Catalog database contains the non-graphical information derived from the reference data (in the form of Excel workbooks) delivered with the software. You can modify the delivered reference data by editing and bulk loading Excel workbooks. You also can use your own custom Excel workbooks and custom symbols, to create a new Catalog database specifically for your project. For more information about customizing the delivered reference data, refer to the Smart 3D Reference Data Help available from Help > Printable Guides.

You can create a starting Catalog database and schema using the database template file delivered with the software. The catalogdb.dat, sm_shipcatalogdb.dat, and mhe_catalogdb.dat files are a backup of a sample Catalog database and contains the definition of a sample catalog of objects, including specific sizes of pipes, pipe specifications, steel section sizes, and so forth. After the Catalog database is created, you can then bulkload your customized piping specifications into the Catalog database as needed. For more information about creating the required Catalog database for SQL, see Create the Site, Catalog, and Schema Databases for SQL. If you are using Oracle, see Create the Site, Catalog, and Schema Databases for Oracle.

The catalogdb.dat, sm_shipcatalogdb.dat, and mhe_catalogdb.dat template files contain sample Smart 3D reference data and, while the templates contains many useful examples, they are not certified for production use.

The Model database contains all instances of parts in the physical representation of the model. The Catalog and Model databases share the same schema. A model is all three databases used together: Catalog database, Catalog schema database, and Model database.

The Reports database and schema interact with the other five databases to generate tabular reports from Smart 3D data. For information about reports, see the Reports Help and Drawings and Reports Reference Data available from Help > Printable Guides.

The Catalog contains two hierarchies. The first is a Site database hierarchy made up of catalog permission group folders and permission groups. To view the Site database hierarchy for the Catalog, start the Project Management task. The second hierarchy is an object hierarchy made up of equipment, piping, and so forth. To view the hierarchy and its contents, start the Catalog task. For more information about the functionality in these tasks, refer to the Project Management Help and the Catalog Help files. These help files are delivered in C:\Program Files (x86)\Smart3D\Documentation\Help on the workstation computer.

For creation date and size information on each database, in Microsoft SQL Server you can open the SQL Server Enterprise Manager. This software also provides further technical details about the relational tables in each database.

The following illustration shows the relationships of the databases:

(A) - Reports Database
(B) - Site Database
(C) - Model Database
(D) - Catalog Database
(E) - Site Schema
(F) - Catalog Schema
(G) - Reports Schema

These databases are created on a central server using the on a workstation computer on which the Project Management and Server Connectivity options are installed.

Using Linked Servers

If your Site/Catalog/Model database server is different from your Reports database server, you can use linked servers for communication between the data sources. However, if linked servers are not configured correctly, the login can fail when you run queries against the linked server.

For linked servers to work correctly, ensure that the following conditions exist:

  • The database link is created on the Site/Catalog/Model database server, not the Reports database server.

  • The linked database server supports Windows Authentication or database user authentication modes.

  • The user is connected to SQL Server using the same database authentication mode (Windows Authentication or database user authentication) on both database servers.

  • Security account delegation is available on the client and the sending server.

For more information about setting up linked servers, see the Microsoft SQL Server documentation and Linking Servers.

See Also

Create the Site, Catalog, and Schema Databases for SQL
Create the Site, Catalog, and Schema Databases for Oracle
Assign Access Permissions for SQL