If you haven’t already, please read my first post on where and how to download a trial version of User Management Resource Administrator, developed by tools4ever.

Download Trial Version of UMRA > http://www.tools4ever.com/download/

UMRA – Student Information Sync

What is a Student Information System (SIS) Sync you may ask? A SIS sync is linking up your Student Information System’s Database to a UMRA Automation project and having the UMRA run a set of projects on a hourly, daily, or a chosen interval to make sure your Active Directory is in sync with your Student Information System. How is this possible you ask? UMRA has the ability to connect to any ODBC valid database, if UMRA does not have direct access, you can also get a SQL View or CSV of data, and have that replicated and put into a Database on a daily basis. Many of our clients are looking for this exact procedure; they need the student’s accounts, email, and home folders created quickly, and keep Active Directories data integrity unpolluted. So below I will go over a quick way to get such a sync setup. Below will be a more a high lever overview, since each environment is always going to be different, you should be able to take these same steps with UMRA and get your Student Information in Sync with Active Directory.

UMRA – Student Information Sync Steps

First you will need to get a “View” created in your current Student Information System, or create your own custom query to get the data needed to run the UMRA Automation project. Once your data is set, now you can setup a UMRA foreach action on your table, if you need help with this, please see my other posts on how to loop through table data. In your UMRA foreach action you will now do a search in Active Directory for the users based of criteria from your “View” of data, or direct database connection. If the users IS in Active Directory, go to your compare project. Your compare project will check information such as, firstname, lastname, description, or any other Active Directory Attribute you need to check. If the users IS NOT in Active Directory, go to a create user project, or insert this data into a database etc. This is the highest level of a Student Information System Sync, keep coming back later to see more in detail some of the tips and tricks of such a UMRA Automation project.