School Passport supports Secure Data Sync with a wide range of the district's student information systems (SIS). One of them is Veracross SIS. Veracross uses one single database and an integrated school management system to serve the district's entire campus and integrates seamlessly with a number of third-party solutions.
Configuration of data sync with Veracross SIS consists of two steps:
- Adding the Global Grid 4 Learning as the Integration Partner in Veracross Portal;
- Configuration of Veracross App in School Passport.
- To add GG4L as the Integration Partner, please follow the instructions below:
- Log in to your Veracroos Portal, and from the Identity & Access Management homepage, add GG4L as the Integration Partner. For more details, follow the Veracross instruction by this link.
- Once the above step is complete, please copy API credentials (Client ID, Client Secret, School Route)
Note: API requests can be made for various data points, controlled by different scopes. However, to establish a connection with Veracroos API V3, we need to have access to the following scopes:
“students:list”
“courses:list”
“people.relationships:list”
“classes:list”
“academics.enrollments:list”
“staff_faculty:list”
“contact_info:list”
“households:read”
“summer.enrollments:list”
"academics.config.grading_periods:list"
"academics.classes.meeting_times:list"
- To configure the Veracross data sync app, please follow the instructions below:
- Log in to your School Passport profile, and navigate to the Connect (Data-Sync) module;
- Go to the Application Gallery section, and find the Veracross app. Once identified, click ACTIVATE button. You will be redirected to the configuration section.
- Insert copied credentials (Client ID in the Username field, Client Secret in the Password field, School Route in the School Abbreviation field, and choose API Version) in the corresponding fields of the Delivery Config tab:
There are also Advanced Settings present here. Press the following button to open a drop-down list:
You will be offered to populate checkboxes related to additional settings. There are four checkboxes responsible for the following settings:
- Bulk upload mode. The system will detect deleted records based on a comparison with the last upload.
- Data will be uploaded from multiple data sources (for example, from the SIS and the Active Directory). Do not check the box if you plan to upload data from a single data source (e.g. only from the SIS).
- Compare records accordingly to the Domains of Uniqueness.
- Preview of data upload (you will have to approve every data sync). Your new data will be not available until you accept the changes.
- There is the ability to set up a “Sync hold threshold”. If the system detected significant changes, updated data would not be available for export until you approve changes.
Also, you can set up the SIS prefix field. The prefix is used mainly for multiple Data Sources of the same type to avoid merging entities with equal SIS IDs.
After making all required settings, you can test the connection with Veracross SIS by clicking the corresponding button:
- In the Schools Mapping step, select all or individual schools’ data you want to be synced with School Passport. To choose an individual school just drag the button slider to the right in front of the school you need. To select all, click on the AUTO MAPPING button.
- In the Attributes Mapping step, you can configure under what attributes, data of a separate entity from Veracross will be synchronized to School Passport.
Note: You can finish the configuration of the Veracross in this step. To complete the configuration, click the corresponding button at the top-right corner of the screen.
- In the Data Requirements step, you can configure what actions should be taken if some data attributes are missed. There are two options here: Report if Missing; Skip if Missing.
- In the Filter Rules step, you can set up data filtering by different entity types. There are seven entity types: student, contact, teacher, course, class, calendar, and admin. To make the filtering process easier to use, ready-made templates are provided. The additional attributes for more accurate filtering are present in the ready-made templates. Also, you can add a Custom Filter where custom attributes and conditions can be used.
- Domains of Uniqueness define parameters that require to be unique. The main goal of Domains of Uniqueness is to avoid duplicates in the data system. There are seven entities you can set DoU for: Student, Contact, Teacher, Course, Class, Calendar, Admin. First Name, Last Name, and Email attributes are set by default in DoU to be unique, but you can also select (add) others: birth date, gender, grade, phone number, etc.
- Master Fields step: data to a district account can come from multiple data sources. One data source may not have a complete list of required data, or this data might be inaccurate. In order to avoid duplication of data from different data sources, the user can configure which attributes from which data source will be the main ones. This configuration occurs in Master Fields.
Note: For more details about Master Fields click here.
- In the Sync Schedule section, you can set up periodicity (daily, weekly) and the exact time for the sync. You can also choose the date when data sync will be expired.
- In the last "Done" step, click the FINISH button to finalize the configuration.
- Once the configuration is complete, you can force data sync by clicking on the RUN IMPORT button.
If you have any questions about the Veracross App configuration, please reach out to GG4L Customer Support.