The business rules performed by the DataSplice Server are provided by stored procedures in the database. We also provide views that perform common CMMS tasks and are linked to the provided stored procedures. Between the stored procedures and the views, these provide the actual CMMS functionality available in DataSplice, such as Inventory or Work Orders.

Installing the Oracle Add-On Packages

If your installation uses SQL Server instead of Oracle, skip to the next section.

Using Oracle SQL*Plus, login as the CMMS schema owner (usually MAXIMO), and execute the PL/SQL Script MAX411_SCRIPTS.SQL. If installing from the CD, the script files will be located in the \Scripts subdirectory. If installing using the downloaded zip file from the web, the scripts will reside in the target directory used during file extraction. For the following example, we will assume we have extracted all of the script files to the C:\Temp\Scripts directory. The SQL*Plus screen will look like the following after logging in and entering at the SQL prompt the shortcut command to execute the MAX411_SCRIPTS.SQL file.

The MAX411_SCRIPTS.SQL file will, in turn, execute the following list of scripts in the following order:

1. DSUTILITY.PLSQL
2. EQUIPMENT.PLSQL
3. INVENTORY.PLSQL
4. WORKORDER1.PLSQL
5. WORKORDER2.PLSQL
6. WORKPLANS.PLSQL
7. TOOLTRANS.PLSQL
8. DSUSERS.PLSQL

If needed, the scripts can be executed individually, as long as DSUTILITY.PLSQL is run first, WORKORDER1.PLSQL is run before WORKORDER2.PLSQL, and DSUSERS.PLSQL is run last.

Example:

SQL> connect maximo/maximo@oracle_tns
SQL> start c:\temp\scripts\dsutility.plsql;
        

After the DSUSERS.PLSQL script has successfully run, grant the DS_USER role to the desired set of CMMS users:

GRANT DS_USER to CMMS_USER1;
        

See the DSUSERS.PLSQL script for example SQL query for generating a script file of GRANT statements using the SPOOL option.

Installing the SQL Server Add-On Packages

Using Query Analyzer, login as the DBO (or System Administrator), and execute the supplied TSQL Scripts in the following order:

1. DSUTILITY.TSQL
2. EQUIPMENT.TSQL
3. INVENTORY.TSQL
4. WORKORDER.TSQL
5. WORKPLANS.TSQL
6. TOOLTRANS.TSQL
7. DS_PERMISSIONS.TSQL
8. DS_ADD_USERS.TSQL

For example:

1. Open the DSUTILITY.TSQL file in Query Analyzer.

1. Click the run button to execute the TSQL script. The first time executing the script files, it is normal to encounter "Can Not Drop Object" errors. These errors occur because the scripts have been setup to drop objects before they are recreated. Since it is the first time running the scripts, there are no objects to initially drop.

Installing DataSplice Views

After all available database procedures have been installed the associated views need to be installed so the DataSplice Server can access them. DataSplice views are XML files (.xml extension) and will either be found in the \Views subdirectory of the install CD or in a downloaded zip file.

Location the install directory for DataSplice - this will be C:\Program Files\DataSplice unless you changed the option during install. Create a Views subdirectory in the install directory if it does not already exist.

Copy all the view XML files into the Views subdirectory (C:\Program Files\DataSplice\Views) so they will be available for the DataSplice Server.