To enable nightly overnight imports from your school database into EdSmart, Please contact EdSmart Support to request the SQL View Document. you can set up views of your data as detailed in this document, which describes the datasets we can import and the queries we like to be able to run.
Please let us know which Student Management System you use, and whether you want to connect via SQL, Azure Hybrid Connection Manager, or via an API to your Student Management System. In some cases we can also provide example views for your Student Management System.