Shortcuts

Support
Issue Tracker
[Services]
Questions
[uAchieve Applications]
Transferology
TES
[Training & Conferences]
Accessibility

Skip to end of metadata
Go to start of metadata

The Connector depends on the DARS daemon and server to provide degree audits.

Three database connections are required to successfully produce degree audits through the Connector via DARwin, as indicated below:

  1. DARS server (i.e., Cobol program)
  2. DARS daemon (i.e., Java program)
  3. Connector

Keep the following points in mind to minimize degree audit troubleshooting when installing the Connector:

  • The Connector must interact with the same JOB_QUEUE_xxx tables as the DARS daemon and server.
  • Degree audits for Transferology do not use the STU_xxx tables. Therefore, those tables do not need to be accessible by the DARS server, daemon, and Connector.

The database user for the DARS daemon (Java program) must have the following permissions:

  • Select, insert, update, and delete on the JOB_QUEUE_xxx tables

The database user for the DARS Server (Cobol program) must have the following permissions:

  • Select, insert, update, and delete on the JOB_QUEUE_xxx tables
  • Select permission on the following DARwin tables:

    CHART_CATEGORIES
    COM
    CRS_CONVERT
    DPROG
    DPROG_REQ
    GMASTER
    MASTREF
    MASTREF_ADDRESS
    MASTREF_SEG
    REPEAT
    REQ_MAIN
    REQ_TEXT
    REQ_XY
    STRING
    STRING_CRSE
    SUB_REQ
    SUB_REQ_AR
    SUB_REQ_TEXT
    TCA_MASTER
    TCA_RULE
    TCA_SOURCE
    TCA_TARGET
    

Isolating the Connector from your Existing DARwin Audit Data

Some schools want to prevent the Connector from accessing the audit data contained in the JOB_QUEUE_xxx tables used by their existing DARS server. This is accomplished in the following tasks:

  • Creating new JOB_QUEUE_xxx tables
  • Creating a new DARS server and daemon
  • Make sure the database user for the Connector has select, insert, update, and delete permissions on the newly created JOB_QUEUE_xxx tables
  • Make sure the database user for the DARS daemon has select, insert, update, and delete permissions on the newly created JOB_QUEUE_xxx tables
  • Make sure the database user for the DARS server (i.e., Cobol) has select, insert, update, and delete permissions on the newly created JOB_QUEUE_xxx tables as well as select permissions on the tables listed above

See OWL-14766 for the Oracle scripts.