Syncing certificates (base64 encoded) from ODBC/CSV to AD

As of UnitySync v2.7, base64 formatted certificate strings can be synced from ODBC or CSV to set an Active Directory (AD) usercertificate.

In order for the Discovery to read the base64 format data correctly, you’ll need to use a optional raw config option:

field-base64

When set to identify the base64 column, the discovery can read the value and include it in the ldif.txt as base64 encoded format.

For example, let’s say your column containing the base64 string is named CertBase64.

In your source data, the value looks similar to BB4CCBqygAw….etc.

Perform the following steps:

1. On the Custom tab, click Raw Config.

   • Add this parameter and click Save:

     field-base64=CertBase64

2. Create a custom object map file if you don’t already have one in use.

   • Add the mapping:

     userCertificate=^CertBase64^

   • Click Save on the custom object map, then Save again to save the selection of the new map file.

3. Run Discovery.

   • The ldif.txt should include a double colon in the column name:

     CertBase64:: BB4CCBqygAw....etc.

4. Run Sync. On the destination AD, you should see a valid certificate has been synced.