In order to connect your on-premises databases to the Intellischool Data Platform, the Intellischool Sync Agent will need to be installed on a local Windows server.
Intellischool Support will also use the server selected for remote access to provide support for database connectivity and syncing.
The server used can be an existing machine, or you may wish to provision a new virtual machine. You can safely opt for an existing SQL server as the resource overhead for the Sync Agent is minimal.
➡️ Minimum system requirements
- A current version of Windows Server (Core mode is supported)
- At least 8GB RAM
- At least 25MB disk space on the primary system drive (usually C: drive) for software installation
- At least 50GB disk space for swap/temporary storage (usually on C: drive, but can be configured to an alternative drive)
➡️ Firewall requirements
If the machine the Sync Agent is installed on is behind a firewall, you will need to whitelist certain domains for it to function.
Additionally, the machine will require access to your internal databases - so if you have internal firewalls configured, you will need to ensure that appropriate rules are configured to enable connectivity between the agent and the database service.
The Sync Agent does not support SSL inspection. You must ensure that traffic between the agent and Intellischool's systems are not subject to SSL inspection.
➡️ Supported database services
The Sync Agent supports a number of local database services, including:
- Filemaker Pro (with appropriate ODBC license from Filemaker)
- MariaDB
- Microsoft Access
- Microsoft SQL Server (2016 or later)
- MySQL
- PostgreSQL
- SAP HANA
- Teradata
At this stage unstructured (NoSQL) database services are supported on a case-by-case basis.
🤔 Need further support?
We're ready to help anytime. Reach out at help@intellischool.co.