Database Wizard - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
10.1(2014R1)

The Database Wizard utility is external to Project Management. It plays a very important role in working with databases because prior to using the software, you must create the site, site schema, catalog, and catalog schema databases using the Database Wizard.

The Database Wizard is located at Start > All Programs > Intergraph Smart 3D > Database Tools > Database Wizard and is only available when the Server Connectivity option is installed on the computer.

The site database and schema are containers for the other databases. The site database stores user access for the model. A site database can have multiple model and catalog databases. Typically, there is one site database set for each customer location. The catalog database contains reference data, which includes part dimensions, specifications, and industry standards.

You can create a starting catalog database and schema with the data file delivered with the software. After creating the catalog database, you can modify the delivered reference data by editing the delivered Excel workbooks and then using the Bulkload utility to update the catalog database. You also can use your own custom Excel workbooks and custom symbols to create a new catalog database specifically for your project. In addition, you can edit catalog data directly through the catalog user interface.

After you create the databases for site, catalog, and their associated schemas, you can use the Database > New > New Model command to create the model database. Use Edit > Regenerate Reports Database to create the Reports database.

For more information about editing reference data, see the Catalog User's Guide. For more information about editing and bulkloading the Excel workbooks, see the Smart 3D Reference Data Guide.

Creating Databases for the Site, the Catalog, and their Schemas

When you are satisfied with the settings you have defined for the site and catalog databases, click Create DB. If you want to make changes, click Back, make your changes, and click Create DB.

Create DB - Executes the process for creating the site, site schema, catalog, and catalog schema databases.

After the wizard successfully creates the required databases, you can view a summary page that displays the name and server location of each of the databases you created. You should verify that the folder location you specified for the symbols and custom program files has been shared and assigned with the appropriate access permissions.

When using an Oracle Linux environment, the .bcf file must be on a Windows-based computer and the database template location must be on the Linux computer where the Oracle service is running. The account used to run the Oracle service must have write permission to the template location. Linux is a case sensitive environment. The database template names must be typed as case sensitive. You must type the Linux folder location. The Browse feature is not available for navigating to Linux folder locations.

Creating the Model and Reports Databases

After you create the site and catalog databases, along with their respective schema databases, you can create the model and reports databases using tools in the Project Management task. First, click Finish to close the Database Wizard, and then open Project Management. Do one, or more, of the following:

See Also

Create new database objects for SQL
Create new database objects for Oracle
Create Site Database from an Existing Catalog for SQL
Create site database from an existing catalog for Oracle
Change the active site database
Change the name generator server for the active site
Restore a site database
Upgrade the site and site schema databases