SQL Data Sources
Many organizations use
SQL databases to store critical contact information. In most cases, SQL databases can be queried and reports can be generated using the pulled information. However, there is no easy way to extract specific contact details and have that information synchronize with users' handheld devices. The
itrezzoAgent EPS solution provides the capability to use SQL databases as alternate contact source (ACS) and synchronize stored contacts with employees smart phones.
Setting up SQL Databases as an Alternate Contact Source
- Open the itrezzoAgent Administrator
- Expand the EPS Container
- Right Click on Alternate Contact Sources
- Select Add Data Source
- Type in the Name you would like for this Alternate Contact Source
- Select the Edit button
- Left Click the Connection Type dropdown and select the appropriate data connection type
- For SQL Server you will enter the Server Name or IP
- Enter the database name
- Choose the security method for connection (Integrated or Supplied Identity)
- Select OK
- You may optionally select the Test button to test your connection
- Enter your Query String for the data you wish push with itrezzAgent EPS.
- Select Run to view the results of your SQL query
- Select OK
Setting a SQL data sources as a Mandatory Contact List
- Open the itrezzoAgent Administrator
- Expand the EPS Container
- Expand Alternate Contact Sources
- Right Click the (added) SQL Data Source
- Select Make Mandatory Contact List
- Select the Target button
- Select from the Global Address List (GAL) users or Active Directory (AD) distribution lists you would like to push the public folder contacts to
- Select OK
Note – It may be important for an Admin to select the “Include contacts with no email address” option when using a Alternate Data Sources as a
Mandatory Contact List. There may be instances where there is no primary email address and contacts will still need to be pushed to users.
See Also