ODBC -- Overview

ListManager may synchronize its data with other databases using ODBC (Open DataBase Connectivity).

To use ODBC, the administrator must first install the correct ODBC 3.51 compliant driver for the datasource on the ListManager server. UNIX users should use unixODBCalong with the vendor-specific ODBC 3.51-compatible driver.

Next, the server administrator must create a Database Connection in Utilities: Administration: Server: Database: Database Connections, specifying the connection string and SQL query to be used to connect to the external database.

Once the database connection has been created, a list, site or server administrator may enable the database synchronization for a particular list in Members: Synchronization Settings, and further specify how ListManager should handle data from the external data source, and with what frequency.

The server administrator may also specify the default frequency for database synchronization in Utilities: Administration: Server: Server Settings: Scheduled Tasks: Synchronize Lists.

Administrators may also opt to have ListManager synchronize data before sending a mailing in Mailings: New Mailing: Recipients, to ensure that ListManager is using the most updated information before sending mail.

See Database: Add Member Column for information about how to add additional columns to the ListManager members_ database.

Important ODBC Notes

• ODBC in ListManager has been tested against Oracle, Microsoft SQL Server, and MySQL. Other databases should also work, but are not supported.
• ListManager checks the entire members_ table each time it synchronizes its data; it does not only look for new or changed data.
• ListManager does not check to see if there is sufficient space in the database before performing synchronizations.
• Synchronization can take a long time. In our internal tests, a synchronization against a list of one million members took three hours. If you are synchronizing large amounts of data, you may opt to use methods other than ODBC to keep it in sync.
• Synchronization requires more space on your ListManager database server. The amount of space depends on how much data your are synchronizing against.
• Do not update the password_ field. The ListManager password_ field is encrypted.

More

1. ODBC

1. ODBC on Unix

2. ODBC on Windows

3. Sample ODBC Connection Strings and Queries

2. Database Connections

1. New Database Connection