Replicators for ODBC databases
Please follow the general instructions for setting up a replicator on the Replicator Wizard page.
Procedure for Adding a Replicator
- Select the type of data source
Select the ODBC database type.
- Define the credentials under which the data source can be accessed
![](../../../media/info-green.gif) |
Please note that you may NOT access system data sources through a user account.
For ODBC databases, please also note the information on access rights from a system and user context. |
- Settings for the data source (selection of the server, the data structure that should be imported and so forth)
Select the Database
An ODBC data source is defined by the ODBC Connect String. Use the Browse... button to launch the ODBC data source dialog, which represents the ODBC data sources provided by the system. You can choose file data sources or computer data sources. For more information about the file data source or computer data source, see Microsoft's online help, which can be accessed in the ODBC dialog using the Help button.
Select the Table
Once you have selected the database, the table selection dialog will appear. Use it to select the table containing the address information including telephone numbers. Relational address databases are not supported. The telephone numbers must be in the same table as the names.
See also Configuration of an ODBC replicator to connect a Microsoft Access® database.
Enter the SQL Select statement
You may optionally enter an SQL Select statement directly instead of selecting a table. By doing so, you can also filter or join complex data structures.
See also Advanced Configuration of an ODBC Replicator by entering a SQL Select statement.
![](../../../media/info-green.gif) |
If you want to use data from a Microsoft® Excel table, the first row of the table must contain the field labels to which you assign meanings below. Before you include an Excel spreadsheet, you should mark the entire range that contains the data (that is, the entire entries and the first row with the headings) in Microsoft® Excel and declare it a "named range." You can create a named range by inserting/defining name/define. |
- Field mapping - Which source fields are copied to which LDAP fields
- Configuring Contact URL links
- Datasource location settings
- Schedule replication plan
- Defining additional applications to be started
- Assigning a name for the new replicator