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.
|