The User Management Resource Administrator (UMRA) has a powerful script action called the Generate Generic Table action. This action is responsible for reading from various sources of data. There are three main choices; Database query, File (text, csv), or an LDAP Query. When working with an information system such as Skyward, we choose the Database query option.
Before you are able to configure the generic table, you must make sure that you have the proper ODBC driver in place. Skyward utilizes the Progress OpenEdge driver. This must be purchased and licensed from Skyward.
When configuring the generic table, we need to then select the DSN connection that is in place to connect to either the Finance or the Student database depending on your scope. We typically set up two separate automation projects, one for staff and one for students.
Be sure to enter the user name and password for the account that has rights to run select statements to the Skyward databases.
From there the next step is to write a select statement that pulls the correct information that you need to perform a sync with Active Directory. Once your statement is set, you now have the information in the table ready for your For-Each action. Some of the columns we are after for staff accounts are:
NAME.NAME-ID
NAME.LAST-NAME
NAME.FIRST-NAME
NAME.MIDDLE-NAME
BUILDING.HAABLD-DESC
This is only a small example of the information available in Skyward. Depending on your goals for the sync, you may need to pull more information.
No comments:
Post a Comment