Synchronizing With SQL

Use these steps to synchronize User or Contact sources with an SQL database.

  1. From the VMP Administrator, select Users & Groups > Users .
  2. Click the Synchronization icon in the Users view.
  3. In the Reconfigure/Synchronize only window, select Yes, reconfigure settings. Click Next.
  4. In the User Synchronization dialog, click the Add primary source with users icon (under Sources).
  5. Configure the Automatic synchronization options, and click to clear the wireless gateway default selector.
  6. Select MsSqlServer from the Source type dropdown list. This selection auto-populates the Title field. You can accept the default title or customize the title.
  7. Enter the Connection Parameters and click OK.
    Table 1. SQL connection parameters
    Parameter Description
    Address The computer name or IP address of the SQL server.
    Login The SA login credentials.
    Confirm Password Enter the password a second time to confirm the credentials.
    Database Select the database to import from the dropdown list.
    Query Use the dropdown list to select any specifc query options for the import.
  8. In the sources dialog, highlight the SQL source that you have just created, and click Next.
  9. 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 Next.
    Note: For more information about field mappings, see Editing User Fields and Defining Contact Fields.
  10. 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 Close.

    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 deployment.

  11. Click Check All to confirm the previously configured values.
  12. To specify that a user imported using this script is to be given access to the VMP Administrator, select the Admin Access checkbox.
  13. To specify that a user imported using this script is to be given access to the VMP Web Console, select the Web Access checkbox.
  14. Click Next.
  15. 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 capability.

    Click Finish to continue.

  16. 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.