ODBC Configuration Requirements

UnitySync can use an Open Data Base Connectivity Data Source (ODBC) to synchronize directories. As long as the non-LDAP Source has an ODBC driver, information can be synchronized from the Source to an LDAP directory.

NOTE: If you have a simple delimited text file, we recommend you use UnitySync’s CSV Source template, rather than this ODBC Source template. Refer to Importing directly from a CSV data file for instructions on using the CSV Source template.

Configuration Requirements

Note: You must use 64-bit ODBC

First, You’ll need to install the correct database driver for the Source and make it available in the ODBC Data Source Administrator of the UnitySync server. Default drivers installed with ODBC include SQL Server, Text Files, Access, Excel, etc. You can find more help on this topic on Microsoft Tech Forums

Creating an ODBC Data Source

The ODBC Source template allows you to read data from a database file via a configured ODBC Data Source.

To create an ODBC Data Source Name (DSN) for your database:

1. Create a directory on the UnitySync server, or a mapped drive, in which to store ODBC input file(s). For example, c:\UnitySync\ODBC
2. Put the database input file in the directory. For example, c:\UnitySync\odbc\HRUsers.db2
3. Open the ODBC Data Source Administrator
4. From Administrator Tools, select Data Sources (ODBC)
5. Click the System DSN tab, then click Add
6. Scroll down and select the appropriate data Source type
7. Click Finish
8. Name the new data source - for example, UnitySyncInput or HRUsers, etc.

The next set of configuration steps depend on the database type. Just follow the prompts to identify the Source database to continue on from this point.