Create

A new configuration may be based on a new database or on an existing database. When you create a new database configuration, you may select a database that contains equipment , network and project data or select separate ones (equipment, network and project) CYME allows you to choose among three database types to create your databases: Microsoft Access, Microsoft SQL Server, and Oracle.

Select the menu command Database > Create or click on the icon in the Database Manager dialog box (see 6.2) or click on the “Create” item in the Databases Tab (see 2.3.1) of the Explorer Bar.

This will display the Database Mode section of the CYME Database Wizard. Select if you wish to create a single database connection or a connection to separate equipment and network databases.

6.3.1 Single Database Configuration

Select Single database and click the Next button to display the Database Type dialog box. Make your selection among Microsoft Access, Microsoft SQL Server or Oracle and click Next again to enter the details of the configuration.

For Microsoft Access

• Type in the file name in the Database File (.mdb) field including the full path or click on the Browse button to locate it and select it. This enables the Next button. Click on it.

CYME 5.02 – Reference Manual

For Microsoft SQL Server

• Select from the list or type in a valid Server Name and type in a unique Database Name. You may check the Use Windows Authentication checkbox or enter a Username and a Password (check with your database administrator about the type of log in to use). Click on Next.

For Oracle

• CYME detects automatically which version of Oracle Client is installed. Select from the list or type in a valid Service Name from the list and type in a unique Database Name. Enter and confirm your Password. Note that for Oracle, the password is mandatory. Click on Next.

The following dialog box displays a summary of the configuration. To make modifications, click on the Back button. To go ahead with the creation, click on Next.

Note: When you are creating a new configuration, it may happen that CYME finds incompatibilities with a database and prompts for a supplementary action before proceding with the creation. Whenever you click on No to a prompt, the wizard remains on the current dialog box.

A few examples:

• The database was created with a prior version of CYME: the program will ask if you wish to update it to the current version.

• The database was created with a more recent version of CYME or the server (SQL or Oracle) does not exist: the program will remain on the current dialog box; click on Back to review the information entered.

• The database does not exist: the program will request to create that database. In the case of SQL server or Oracle, you will be required to enter a Username and Password with administrative rights.

After your configuration is created, the wizard will display the Database Configuration Created dialog box where you will be able to specify (if needed) the directory where the studies based on that configuration will be saved. Click on Finish to dismiss the wizard.

Note: Whenever you are required to type in or select a configuration name, if that name already exists, the program will propose a unique name composed of the name in question with the characters “_1” at the end.

Note: You will find the information about each of the configuration created in the Databases Tab list (refer to 2.3.1).

These are the properties of the configurations as created that you can edit at any time. See 6.2 Database Manager where you will find further information about this.

6.3.2 Single Database (Equipment Only) Configuration

Select Single database (Equipment Only) and click the Next button to display the Database Type (Equipment database) dialog box. Make your selection among Microsoft Access, Microsoft SQL Server, Oracle or XML and click Next again to enter the details of the configuration. The next dialog box will be the same one as for the single database as explained in the previous sections.

For Microsoft Access, Microsoft SQL Server and Oracle, along with few details about the connection creation process, see 6.3.1 Single Database Configuration.

For XML – Type in the file name in the XML File (.xml) field including the full path or click on the Browse button to locate it and select it. This enables the Next button. Click on it.

The properties of the configuration will be displayed in the next dialog box. Click on Back to edit them or click on Next to continue. The program will proceed by creating the equipment database.

After your configuration is created, the wizard will display the Database Configuration Created dialog box where you will be able to specify (if needed) the directory where the studies based on that configuration will be saved. Click on Finish to dismiss the wizard.

6.3.3 Separate Databases Configuration

In the Database Mode section of the Database Creation Wizard, select Different databases and click the Next button.

You will be presented with a Database Type selection dialog box for your Equipment database. Select the type among Microsoft Access, SQL Server and Oracle. The next dialog box will be the same one as for the single databases as explained in the previous sections.

Once the parameters of the Equipement database are selected, click on Next. You will be presented with a Database Type selection dialog box for your Network database. Select the type among Microsoft Access, SQL Server and Oracle. The next dialog box will be the same one as for the single databases as explained in the previous sections.

Once the parameters of the Network database are selected, click on Next.

CYME 5.02 – Reference Manual

If you have the optional CYME Advanced Project Manager module installed, you will be presented with a Project Type selection dialog box for your Project database that have been previously generated with CYME. Proceed the same way than for the Equipment and the Network databases and click on Next.

The properties of the configuration will be displayed in the next dialog box. Click on Back to edit them or click on Next to continue. The program will proceed by creating the equipment database, then with the network database.

See the Notes in the previous 6.3.1 Single Database Configuration for a few details about the connection creation process.

After your configuration is created, the wizard will display the Database Configuration Created dialog box where you will be able to specify (if needed) the directory where the studies based on that configuration will be saved. Click on Finish to dismiss the wizard.

6.4 Delete

The Delete command operates in two stages. First, it deletes the currently active database configuration. Second, a prompt will ask you if you want to delete the database itself.

You may disable the second step; thus the user will not be provided the option to delete the database and it will be left on the disk after removing the connection to it. See File >

Preferences, Database tab (see 4.15.6) to set this command. Note that for SQL and Oracle databases, you need to have the proper administrative rights for the deletion.