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: