Database Connector for GoldMine

Here, configure the database connector with the parameters to use to connect to GoldMine.  Set the App Folder, GM User, and SQL User first, then hit the Contact DB browse button to select the Contact database to use.

 

 

SQL User: Note this user must be a dbo or have the dbo role in the database.

 

Requirements for GM v8 and Up:

 

- GoldMine v7/8 must be installed locally, on the OmniRush server PC as a GoldMine workstation.

Do not install OmniRush until GoldMine runs properly on the OmniRush PC.

- During initial OmniRush installation, when asked by the wizard, select the network location of GM
- After installation, configure the database connector to point at the local installation of GoldMine

 

Create Simple History Records:  If the track setting does not require that history records be linked to the job document(s), checking this option will cause history records to be created as Other Actions, not as Email.  This has the benefits of being easier to report on, and taking less disk space.

 

Unified SQL database.  Uncheck this if running GoldMine SQL and the GOLDDIR Location of the GoldMine CAL.DBF file (or CAL table on a SQL system). Often specified by the GOLDDIR= tag in GM.INI. On dBase systems, defaults to <SYSDIR>\GMBASE\. and CONTACTDIR GoldMine Contact Directory. Location (or SQL database) where the CONTACT1 and other contact directory tables can be found. are in separate SQL databases.  (When unchecked, an additional selector to set the BDE alias for the GOLDDIR will appear.) Note: In GoldMine v7 and v8, OmniRush requires a unified GoldMine database (e.g. GOLDDIR and CONTACTDIR in a single SQL database).