New Source Type: ODBC (Open Database Connectivity)
ODBC is an API for accessing database management systems, which allows OneSync to connect to and import from your database directly. You can import one table per source and will need your database username, password, and schema name. The host IP will be the database's IP address. If you are running it from your local machine the IP will be "127.0.0.1". For the query, input "SELECT *FROM [yourTable]" with the desired table's name. You can download drivers for ODBC here.
Handling Disabled Users
OneSync has changed a number of policies for handling disabled users. These include the following:
- You can now disable destination users manually via Correlation. First run a Correlation on the desired destination and choose the OU's in which the desired selection of users are located. You can then choose to manually disable individual users in the Disable Users tab of Correlation.
- On export, disabled users are no longer added to destination and enabled users are added if necessary.
- On disable action, edited mappings are no longer processed for disabled users. However, "disable" flags and the "user is disabled" actions for events and triggers will still be processed.
- On disable, you can decide whether or not users shoulder be removed from groups using the Advanced Options tab in a destination. See below for more details.
Destination Advanced Options
To better organize the destination user interface, we've moved some features to a new tab in destination details. These features include Event and Triggers Email Settings, extensions and custom attributes, and setting toggles. The email settings define the email address that notifications are sent from when using the Email event and trigger. The extensions are custom fields that you can define within your destination and then apply in OneSync. The setting toggles include:
- On disable action, disable users in destination?
- Auto-resolve non-unique username conflicts?
- On disable action, remove a user from all groups in this destination?
We have defined three new destination text transformation functions to randomly generate hashes for fields such as passwords. These functions include Hash_Alpha, Hash_Num, and Hash_AlphaNum for alphabetical strings, numerical strings, or a combination of both, respectively. You can provide a string to any function and the desired length of the result string to generate a hash for any string type.
OneSync now provides email notifications for finished imports. These notifications will detail the number of adds, edits, enables, disables found in an import, as well as any exceeded thresholds that you may have set for a specific source. You can list the emails to which you want to receive notifications in the Settings page.
GSuite Custom Attributes
You can now add your own custom attributes to GSuite destinations. To effectively do so, you must first create a custom attribute category and custom field in your GSuite admin console. You can then map to your custom field in OneSync. The custom fields will be listed in the mapping dropdowns in the format "[CustomAttribute.CustomField".