Our HR system is our gold source for user accounts, employee positions (ie Role), access control, and security within our organization. We have a manual process where an Admin has to look up the data in our HR system and update Salesforce. We would like to automate this for obvious reasons. Any advice or guidance on how to do it?
The HR system is irrelevant as we can't directly interact with it (due to security reasons). We have a nightly load that is dumped into a database that we can pull from that contains the structure we are looking for.
What I've noticed is that only the User Object is exposed to the Object Manager, and as a result, exposed for imports into Salesforce. If I want our HR data to maintain Roles, Permission Sets [Groups], Profiles, Public Groups, and Queues, how do I set that up?
My first thought was to create a custom object with our HR data that we would load, and then have Flows to modify the various Salesforce User Objects (if that is possible).