ODBC Configuration Requirements2019-07-16 11:31:51
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.
You’ll just 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. If necessary, download ODBC as part of the MDAC package from Microsoft. For versions prior to Windows 2000, take a look at http://support.microsoft.com/kb/110093.
Creating an ODBC Data Source
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.
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:
- Create a directory on the UnitySync server, or a mapped drive, in which to store ODBC input file(s). For example, c:\UnitySync\ODBC
- Put the database input file in the directory. For example, c:\UnitySync\odbc\HRUsers.db2
- Open the ODBC Data Source Administrator
- From Administrator Tools, select Data Sources (ODBC)
- Click the System DSN tab, then click Add
- Scroll down and select the appropriate data Source type
- Click Finish
- 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.