Totara Learn Open Discussions

HR Systems

 
Wendy Leversuch
HR Systems
by Wendy Leversuch - Friday, 25 May 2018, 8:50 AM
 

Hi,

We're about to start looking at getting a new HR system and I'm keen to get one that works well with totara.  Does anyone have an HR system that links into totara and automatically creates/updates users?

Any suggestions welcome that I can throw in for consideration.

Thanks

Wendy
Craig Eves
Re: HR Systems
by Craig Eves (Totara Support) - Monday, 28 May 2018, 4:54 PM
Group Totara

Hi Wendy

Totara is able to connect to a variety of external databases that  HR systems use.  Once the databases are connected the fieldnames to be imported into Totara can be mapped to the relevant Totara field . This import can be set to be scheduled at a specified time.

To evaluate an HR system check what fields are being stored that you want to import into Totara (you can add extra user fields in Totara for fields that are stored in HR system that would be useful in Totara).

Check the type of database the HR system uses - you may need to add a database driver for the database if your Totara install doesn't use the HR database.

Also note that the data that is imported into Totara needs to come from one table in the HR system for each Element in Totara. This may need queries to be created to make this happen.

The other option is instead of connecting directly to the HR database is to create a csv file from the HR system with the required data included.

regards

Wendy Leversuch
Re: HR Systems
by Wendy Leversuch - Wednesday, 30 May 2018, 3:48 AM
 

Thanks Craig that's really helpful.

I'm keen to hear about anyone who has put this kind of connection in place.

Thanks

Wendy