Configuring a dynamic SQL address book

Before you can use an external dynamic SQL database for contacts, you must configure the connection settings.

To configure an address book for using dynamic SQL

1. Open the address book and contact item that you want to configure:
   1. Click the Administration tab.
   2. In the Address Books section, click the address book name, or click Manage to open the Address Book Administration page. Then, double-click the address book.
      The Address Book details page appears. 
   3. In the left pane, click Contacts.
   4. Double-click the contact item that you want to configure.
2. In the left pane, click Address Book Options.
3. Select Dynamic SQL.
   The Configure External Source button becomes active.
4. Click Configure External Source.
5. In the Source Configuration: SQL Database section:
   
   1. In the Server Address field, enter the name or IP address of the SQL server for this address book.
   2. In the Server Port field, enter the port number for the server.
   3. In the Database Type field, select the type of database.
   4. In the Database field, type the name of the default database for this address book.
   5. In the Server User ID and Server Password, enter the credentials for logging into this server.
6. Click Connect.
   The system attempts to connect to the SQL database server. If the system is successful, the mapping section becomes active.
7. In the Table or View field, select the table or view that contains the fields for this address book.
8. Map the SQL source fields to the Footprints Address Book Fields by clicking an entry in the SQL Fields column and selecting the matching field.
   For more information, see Working-with-mappings.
9. Click Save.
   After you save this record, the Server User ID and Password fields become read-only.
10. To modify Server User ID and Password, click Change Credentials.
    You can return to this page at any time to update the server credentials.
11. Publish the address book to implement your changes:
    1. In the breadcrumb trail, click the Address Book link.
    2. Click Save and Publish.
       A confirmation message appears.

    3. Click Yes.

       The Publication Succeeded message appears, showing the number of errors and warnings.

Next steps

Configuring-contact-items

Configuring-Master-Contact-records

Related topics

Configuring-address-books

Creating-address-books