Ready to get your SEQTA and Synergetic data syncing?
The first step of the process is to install our sync agent so that we can test a connection and begin syncing data to our warehouse.
- Install our CLI on your school Windows machines. Ensure it has access to Synergetic and SEQTA databases.
- Here's the documentation you'll need: https://docs.intellischool.co/guides/cli-quickstart
- Grant the Windows user account permission to read and write from a folder. The CLI uses a temporary location to store the extracts before uploading it to Intellischool.
- Once you've completed these steps, send us an email to let us know and also provide DB credentials for both SEQTA and Synergetic (in a onetimesecret). Please include the following:
- host: IP address or even a hostname
- post: usually 5432 for SEQTA, 1433 for Synergetic
- database name
- username
- password
- Once we receive your email, we'll generate a deployment-id and secret and provide it to you.
- Store the deployment-id and secret in environment variables
- Set up the CRON job to run the intellicl sync command every 5 minutes
The location of critical data
SEQTA and Synergetic are very flexible applications and share many functionalities. To ensure we’re on the right track, we'll need to jump on a Zoom call with you to work through the following questions.
Assessment
- What grade scales are in use across the sub-schools?
- From which application should we extract the end-of-semester result, or, if we’re calculating it, what assessment category should the final result be based on?
- Which result types should be used and are there scale conversions in the source?
Source mapping
In order to present subject results longitudinally, we need to map subjects to learning domains. This is done in the platform where your timetable is stored.
- Where is the timetable stored?
- Where should we read attendance codes from?
Pastoral records
- Where is pastoral data stored?
Get in touch
Once you've finished installing the sync agent, email us, and we'll set up a time to test the connection and table permissions and walk through the questions listed above.