Creating an Empty Reporting Database

After installing FlexNet Manager for Engineering Applications Reporting for the first time, you must create a FlexNet Manager for Engineering Applications Reporting database. For this procedure you need the user name and password of an administrative user in the DBMS who has privileges to create a database. Additionally, parameters that you supplied through the Reporting Configurator are used.

Important:The scripts that create the flexnetreporting database and its tables will create a completely new database. As a result, any data in an existing database of the same name will be lost when you run the scripts.

To create the Reporting database:

1.

If FlexNet Manager for Engineering Applications Reporting is running, stop it. It cannot be running when you run the command (loaddb) to create the database.

•

To stop Reporting from the command line, navigate to the Reporting installation location, then type the command: flexnet stop

•

If you configured Reporting to run as a Windows service, you can stop the service from the Windows Services pane.

2.

Start the database server if it is not already running. Refer to documentation provided by the database server vendor. Ensure that the user who starts the database server has the same locale as the user who creates the database (see User Account Requirements (for Installing and Using FlexNet Manager for Engineering Applications)).

3.

If you are using an Oracle database, a tablespace of the name specified during installation in the Reporting Configurator must be created before proceeding to the next step. See Configuring Oracle in Configuring Database Servers for FlexNet Manager for Engineering Applications for guidelines.

4.

At the command line, change to the directory reporting_install_directory and run the following command:

flexnet loaddb

5.

Specify whether you want to partition the usage-related tables by typing yes or no. (Before specifying that you want to use database partitioning, verify that the database version your enterprise is using supports partitioning.)

Important:If you type yes here, the usage-related tables will be partitioned. To partition the remaining data warehouse tables, you must run the database-specific partitioning script as specified in the section, Partitioning the Remaining Database Tables (Data Warehouse Tables). The FlexNet Manager for Engineering Applications server will not start if some tables are partitioned, while other tables are not.

6.

To create the flexnetreporting database and to add the flexnetreporting database user, you must initially connect to the DBMS as a database administrator.

7.

When prompted, enter the name and password of the database administrative user. Depending on the database, sa (MS SQL Server) or system (Oracle) user account will be required to run flexnet loaddb.

8.

If you want to use partitioned tables, follow the process outlined in the following section, Partitioning the Remaining Database Tables (Data Warehouse Tables).

The database-creation script drops the database (if it exists), creates the database, creates tables, adds the flexnetreporting DB user, adds a FlexNet Manager for Engineering Applications user, and adds configuration data.

When the FlexNet database is created, the following FlexNet Manager for Engineering Applications Reporting user is created automatically and assigned the system administrator role:

•

User Name: admin

•

Password: admin