Synchronizing With SQL
Use these steps to synchronize User or Contact sources with an SQL
From the VMP Administrator, select Users & Groups >
Click the Synchronization icon
In the Reconfigure/Synchronize only window, select
Yes, reconfigure settings. Click
In the User Synchronization dialog, click the Add
primary source with users icon
Configure the Automatic synchronization options, and click
to clear the wireless gateway default selector.
Select MsSqlServer from the Source
type dropdown list. This selection auto-populates the
Title field. You can accept the default title or customize
Enter the Connection Parameters and click
Table 1. SQL connection parameters
||The computer name or IP address of the SQL server.
||The SA login credentials.
||Enter the password a second time to confirm the
||Select the database to import from the dropdown list.
||Use the dropdown list to select any specifc query options for the
In the sources dialog, highlight the SQL source that you have just created, and
The Field Mapping dialog allows for basic field mapping from the source to the VMP
entry. Define the field mappings for your deployment, and click
The synchronization script is generated by the import wizard options selected and
is revealed in a script dialog box. Use the scroll bar to review the script and click
The Script dialog provides the option to manually configure contact options before
running the import script. This dialog is useful for defining device and wireless
gateway assignments. These options can be changed manually at any time after
Click Check All
to confirm the previously
To specify that a user imported using this script is to be given access to the VMP Administrator, select the Admin Access checkbox.
To specify that a user imported using this script is to be given access to the VMP Web Console, select the Web Access checkbox.
Select Export Address Book Entries to Vocera to export a
CSV file containing a list of the VMP users
that do not have a Vocera ID. You can use this file to create address book entries in the
Vocera Voice Server. See Exporting Address Book Entries to the Vocera Voice Server for more information on this
Click Finish to continue.
The synchronization script runs. When the sync is complete, click
OK to close the successful sync dialog, and click
Close to close the script window.