SQL: Creating the Database Connector

Setting up the demo database is easy. To connect OmniRush to a SQL database:

1. Create a new database in your database server using the server management tools (Enterprise Manager for SQL Server)

2. Create the tables and stored procedures in the database

3. Test the stored procedures from ISQL and/or the OmniRush OpenDBIO_Debug.exe utility (OpenDBIO_Debug.exe lets you pass parameters to and from stored procedures).

4. Configure the OmniRush database connector (see below)

Note that steps 2 and 4 can be reversed, but in any event, the connector cannot be used until all these steps have been done.

In a production environment, the steps are:

1. Working in a test copy of your production database, adapt the OmniRush stored procedures to your database structures

2. Create any needed user interfaces or other mechanisms in your application to create the OmniRush job records

3. Configure OmniRush to run against your development database  (see below)

4. Test and tune operation

Then when ready to go live:

1. Create the needed stored procedures in the production database

2. Check that the production application has been updated with any new UI elements (as noted above)

3. Stop the OmniRush database connector module and change the ADO connection string to point to the production database

4. Start the OmniRush database connector

5. Test for proper operation

Configuring the Database Connector

Create a new database connector module, and set it for ADO (for Microsoft SQL Server) or Oracle.

For SQL Server installations, go to the "Open API ADO" tab and configure an ADO connect string (press the Create/Modify button to use the ADO wizard to create the connection string).  Note that you must save the password with the connection string.  Click here for Connection String details.

For Oracle installations, complete the fields in "Open API Oracle" (Package is optional, depending on how you created the needed Stored Procedures.  Here is a description of the connection string.