How to set up Azure Hybrid Connection Manager

If you would like to learn about Azure Hybrid Connection Manager, see this article: About Azure Hybrid Connection Manager.

To read data from your Student Management System database, please set up SQL Views as per this article: Setting up SQL Views of your data for imports.

If you would like to convert your existing Direct SQL Connection to an Azure Hybrid Connection - please see this article: https://edsmart.atlassian.net/wiki/spaces/SUP1/pages/1315307530.

What to do if you would like to use HCM:

1. Download the HCM software from https://go.microsoft.com/fwlink/?linkid=841308 and install it on a computer that is always running, can call the internet over HTTPS, and is able to make calls to your SQL server. It is strongly recommended that the software not be installed on the SQL server itself. This is because many Student Management System vendors also install web sites and other software on their database servers, and making changes to the machine (especially modifying TLS settings, as required in the next step) could adversely affect that software.

2. Use the IISCrypto tool available at https://www.nartac.com/Products/IISCrypto/ to apply best practice settings to the machine you have just installed HCM on, and to set that machine’s TLS level to 1.2 only.

3. Contact EdSmart Support and let us know you are ready to go with HCM.

4. We will provide a connection string for you and to enter into HCM, turn our end on, run a test import, and once successful, your ongoing daily & ad hoc imports will run over HCM.