Creating and populating the Opportunity Detect system tables

If you have not allowed the installer to create and populate the system tables during the installation process, use your database client to run the Opportunity Detect SQL scripts against the appropriate database.

Design environment tables

Run the OpDetectDesignSchema.sql script against your design time database.

The script is located in the /OpDetection/database/database_type/DesignTime directory under your Opportunity Detect installation.

Run Time environment table

Run the opDetectRunTimeSchema.sql script against your run time database.

The script is located in the /OpDetection/database/database_type/RunTime directory under your Opportunity Detect installation.