Read the MX-Sync Overview
Products > MX-Sync > Overview

MX-Sync is a bi-directional synchronization utility which synchronizes data between standard Microsoft Outlook / Exchange Server Public Folders and a Microsoft SQL Server database.

It is useful in situations where Outlook users are updating Public Folder information which must be constantly synchronized back to a SQL database, and/or want to use Outlook to interact with data that is stored in a SQL Server back-end ERP, accounting or web database system.

A common scenario is a web site SQL database where customers are registering, logging on, etc. that needs to be kept in sync with an Outlook/Exchange Contacts folder that is used for profiling these customers in more detail and e-mailing them information relating to requests logged on the web site.

Another example is where you want to keep Outlook Companies and Contacts folders synchronized with a SQL Server-based ERP or accounting system such as Great Plains, so that again the sales and marketing personnel can easily interact with these customers using standard Outlook functionality.

MX-Sync can be used in conjuction with MX-Contact, which is a fully comprehensive Outlook-based CRM system. However, MX-Sync does not require MX-Contact, and can synchronize to standard Exchange Server Public Folders, either discrete (i.e. non-related folders), or linked folders that form part of any Outlook-based Contact Management or CRM system.

MX-Sync can synchronize all 5 types of Outlook folders to and from a SQL Server database, namely Contact-type folders, Calendar, Task, E-Mail and Journals folders. It supports Outlook custom fields, so key ID fields that exist in the SQL tables can be synchronized to custom fields in the corresponding Outlook folders so that the relationships between the tables in SQL can also be maintained in the Outlook folders. That is, these same ID fields can be used as linking fields between the Outlook items, or used to build standard Outlook object links between items.

Learn more about the synchronizing Outlook Data to/from SQL. Download our white paper on "Outlook Synchronization between Exchange Server and SQL Server".