To begin configuring your Engage integration, you will need to create a new DB user and grant select on the following tables:
AttendanceBreaks
AttendancePeriods
AttendancePeriodStructure
BatchMaster
ClusterMaster
ContactEmailInformation
ContactMaster
ContactTelephoneInformation
CurrentStaff
LookupDetails
PeriodNames
PupilCareAuthority
PupilContacts
PupilCurrentSchool
PupilMedicalInformation
PupilPhoto
PupilSubjects
SchoolSiteBlock
SchoolSiteBlockRooms
SchoolTerms
StaffEmailInformation
StaffPersonalDetails
StaffTelephones
SubjectMaster
TimeTableTermCalendar
TimetableClassRoom
TimetableClassStaff
TimetableMaster
TimetableMatrix
TimetableParameters
VLContact
VLContactAddress
VLContactEmail
VLContactTelephone
VLPupilContact
VLPupilDetails
VLStaff
V_PupilBasicInformation
YearGroupSubjectDivision
To setup the Edumate connection in Schoolbox, navigate to Administration > Settings > External DB and :
- Select Doublefirst as Connector
- Enter Doublefirst database name
- Enter Database Host
- Enter Database User
- Enter Database Password
Be careful when configuring your data cache time-out as this may impact the performance of your system during peak times.
If you are finding issues with your Edumate connector, click on the health check will show you if the correct permissions have been setup within Edumate.