DataSplice Releases Mobile Integration Suite 3.0
Executing the DataSplice Scripts for SQL Server
Executing the DataSplice scripts for SQL Server 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:
- Copy the
Scriptsfolder included in the add-on package zip file to a convenient location, such asC:\temp. - Log in to SQL Query Analyzer.
- SQL Server - The database to connect to.
- Login name - The user name to connect with. This should be the database owner or system administrator, such as sa.
- Password - The password corresponding to the given user name.
- Click OK.
Executing the Scripts Individually
The script files for SQL Server should be executed individually. To execute a script for SQL Server:
- Click the Load SQL Script button
. - In the resulting dialog box, select the script to execute and click Open.
- The script contents are then displayed in the query window.
- To run the script, click the Execute Query button
. - The first time each script is executed, it is normal to encounter a "Cannot drop" object error.
- These errors occur because the scripts have been set up to drop objects before they are recreated. Since it is the first time running the scripts, there are no objects to initially drop. The scripts will run successfully the first time, even though the error is generated. If the scripts are executed again, which is not required, it should complete without any errors.
- This process can repeated in the same manner for the remaining scripts. The scripts should be executed in the following order:
dsutility.tsqlequipment.tsqlinventory.tsqlworkorder.tsqlworkplans.tsqltooltrans.tsqlds_permissions.tsql- This script is optional. See the explanation in the Pass Through Authentication Considerations section below for more information.add_ds_users.tsql- This script is optional. See the explanation in the Pass Through Authentication Considerations section below for more information.
Pass Through Authentication Considerations
The last two scripts, ds_permissions.tsql and add_ds_users.tsql, are optional. They are 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.
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.
Last modified 2006-05-26 01:58 PM
