Executing the DataSplice scripts for Oracle implements the necessary database views, packages, and procedures to allow the DataSplice views to successfully communicate with the MAXIMO® database. In preparation of the script execution, perform the following steps:

Executing the Scripts in a Batch Process

The DataSplice scripts for Oracle can be executed in a batch process. This is the preferred method because it simplifies the number of commands that need to be executed. To execute the scripts in a batch process, follow these steps:

Executing the Scripts Individually

If desired, the scripts can be executed individually. The only conditions are that the dsutility.plsql script is executed first, and that the execution of workorder1.plsql precedes that of workorder2.plsql.

To execute a script individually, enter the following two commands in Oracle SQL Plus:

                connect <schema_owner>/<schema_owner_password>@<oracle_tns>;
                start <directory_path>\dsutility.plsql;

Where the following information is valid:

This process can be repeated in the same manner for the remaining scripts.

Pass Through Authentication Considerations

The last script, dsusers.plsql, is optional. It is only necessary to use if the Pass Through Authentication option is enabled. Pass Through Authentication is a connection profile option in the DataSplice Administration Client to determine the credentials passed to the database. If the Pass Through Authentication option is enabled, the credentials of the logged-in user on the Remote Client will be passed to the database. If the option is not enabled, the user name and password specified in the connection profile will be passed to the database. For additional information about the Pass Through Authentication setting, please see the ADO.NET Data Source Plug-in Configuration section of the DataSplice Administration Client manual.

Note: If the schema owner is not maximo, the dsusers.plsql script will need to be modified to use the correct schema owner prefix. After the dsusers.plsql script has been successfully executed, the DS_USER role can be granted to the desired set of CMMS users. The command to grant the DS_USER role to a CMMS user would resemble the following:

                GRANT DS_USER to CMMS_USER1;

See the contents of the dsusers.plsql script for an example SQL query for generating a script file of GRANT statements using the SPOOL option.

Additional Information

A readme.txt file is included within the Scripts folder. This file contains additional information and examples that may be helpful during the script execution process.