In order to synchronise data from TASS, you'll need to grant access to your TASS SQL database.
Intellischool Analytics is capable of synchronising data from TASS for schools who have purchased an appropriate license.
➡️ Credentials
It is best practice to configure a separate username and password for Intellischool to connect to your TASS database. These credentials must be configured using SQL native authentication, not Windows authentication.
➡️ Table access
You may wish to restrict the tables that Intellischool can access depending on the types of data you wish to synchronise with the Intellischool Data Platform.
➡️ Minimum access
The Sync Agent must be given permission to create temporary tables in your TASS database. These tables are used for query efficiency and are deleted automatically at the end of each sync session. They are not visible to other database users.
Read-only access to the following tables/views is required at a minimum for all types of integration, with those marked with an asterisk * being required for assessment import.
| absreason | studsub | ⚠️ If you have users that need to be onboarded that are not stored in the staff, teacher or student tables you will also need to grant access to the below: |
| abstype | subcat | |
| campus | subdept | |
| company | subobject* | |
| house | suboutline | |
| resultprd | subtab | |
| rollsubmit | subtab* | family |
| srarptobjgrp* | subtype | persondefs |
| srastudent | tchsub | telemf |
| srasubassess* | teacher | |
| srasubassval* | tel_name_archive | |
| srasubresfmt* | ttcalendar | |
| srasubtab | ttdays | |
| staff | ttdefs | |
| studabsent | ttmast | |
| studenrol | ttperiod | |
| student | ttyearid | |
| studresult* | year_admin |
🤔 Need further support?
We're ready to help anytime. Reach out at help@intellischool.co.