I've been trying to onboard the Salesforce for a while now. Everything is working properly except for the Accounts import. I'm able to import the account details, custom properties, and even the entitlements associated. However, the accounts are imported and left as orphan accounts despite setting up a User account correlation rule. Not sure what I'm missing.
Here are some useful details about the connection and the endpoint configurations.
Account,Contact,Profile, Group, PermissionSet,Role,PermissionSetGroup,PermissionSetLicense
|User Account Correlation Rule|
users.email equals accounts.customproperty4
Solved! Go to Solution.
select name, (select username from users u where u.email=a.customproperty4)correlation from accounts a where a.endpointkey=123 and a.name ='firstname.lastname@example.org'
Run above query in data analyzer & check
The issue has been resolved.
The connector guide mentioned that there is a default field mapping while also giving the user the opportunity to create a custom field mapping using the Field_Mapping_JSON.
The issue here was if the Field_Mapping_JSON was populated (as I have done in this case), the import job will run both the custom field mapping AND the default field mapping. This results in the job running into a duplicate entry error and crash. (This is definitely a bug that Saviynt should look into and fix)
To resolve this, since My custom field mapping is the same as the default, I had to clear out the Field_Mapping_JSON. This resulted in the import job using the default field mapping and then properly correlate the accounts to the users.