Configuring a dynamic SQL address book

You must configure the SQL connection settings to use the dynamic SQL database for contacts.

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, perform one of the following options:
      • Click the address book name. 
      • Click Manage to open the Address Book Administration page and then double-click the address book.
   3. In the left pane of the Address Book details page, 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 External Address Book Configuration: Dynamic SQL page, complete the following fields:
   
   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 appropriate option: 
      • Sql Server
      • Postgres
   4. If you select Database Type as Sql Server, in the External DB Security Type field, select an appropriate option:
      • For non-encrypted connection: None

      • For encrypted connection: SSL Connection (Default certificate)
        
        

        To complete the encrypted connection configuration, on the Java tab (C:\Program Files\Apache Software Foundation\Tomcat 7.0\bin > Tomcat7w.exe), you must enter the -Djsse.enableCBCProtection=false parameter and restart the Tomcat service.

   5. In the Database field, type the name of the default database for this address book.
   6. In the Server User ID and Server Password fields, enter the credentials for logging into this server.
6. Click Connect.
   The system attempts to connect to the SQL database server. If the connection 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. To map the SQL source fields to the Footprints Address Book Fields, click an entry in the SQL Fields column and select 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. To implement your changes, in the breadcrumb trail, click the Address Book link, and then click Save and Publish.

Next steps

Configuring-contact-items

Configuring-Master-Contact-records

Related topics

Configuring-address-books

Creating-address-books