Astra Schedule VII interfaces with Colleague on UniData through the creation of SQL tables and virtual attributes for use as a translation layer between Astra Schedule and the Colleague UniData database files. A .NET library provided by Rocket Software called UniObjects is utilized for making SQL queries for imports and performing updates during export.
The creation of the SQL tables and configuration of virtual attributes must be performed by an administrator at the institution prior to the implementation of the interface. This task can be achieved using VSG to convert UniData files to SQL base tables.
For details on creating virtual attributes, you may want to reference the following UniData Documentation:
•Creating Virtual Attributes - UniData Documentation V7.3.0/UniData Manual Set: UniData Commands, Concepts, and Query Languages/Using UniData/Chapter 5: Creating Virtual Attributes
NOTE: Make sure to assign single or multivalued fields as noted below. Also, make sure virtual attribute notation and syntax matches the help examples exactly (ex: STU_TYPES instead of STU.TYPES).
The following steps must be performed to configure the interface between Colleague on UniData and Astra Schedule:
1.Create the required SQL base tables from UniData files.
The creation of the base tables can be achieved using VSG.
See Astra Schedule Tables and/or Platinum Analytics Tables for a list of the tables and fields that must be created.
NOTE: The following columns must be explicitly made multi-value in UniData to work correctly with the import spokes. All other columns should be single value.
2.Create the required virtual attributes.
The table detail provided in step 1 includes the virtual attributes that must be created for each table.
Following is an example for the virtual attribute called “ASTRA_SEC_ACTUAL_ENROLLMENT” for the COURSE_SECTIONS table:
:AE DICT COURSE_SECTIONS ASTRA_SEC_ACTUAL_ENROLLMENT
Top of "ASTRA_SEC_ACTUAL_ENROLLMENT" in "DICT COURSE_SECTIONS", 9 lines, 147 characters.
004: ACT. ENROL.
3.Install Astra Schedule. During the installation process you will select Colleague UniData as the SIS Type and provide the following connection information:
•Host Name (ex: datatel.school.edu)
•Account (directory of account)
•Service (ex: udcs)