Sync2DB - Synchronize any SQL Database with Microsoft Outlook    
 

Sync2DB Features

This page features the summary of the things you can do with Sync2DB. Here are a few ways Sync2DB makes Microsoft Outlook linking and synchronizing with SQL Database easier than ever.

Data Subscriptions. Microsoft Outlook connected with multiple popular SQL Databases

Sync2DB allows customers to receive access (subscribe) to specific data of any database, maintain and manage it in Outlook in the form of data subscriptions. The simplified subscription procedure to multiple databases ensures a great end-user experience and is similar to the RSS feed subscription. Use Microsoft Outlook as the Data Reader and data management tool. Support for Microsoft SQL, MySQL and Oracle* databases is provided. To set up subscriptions is easy: write XML (how-to is here) or use our tool for field mapping and other subscription setting and publish it on your intranet/Internet web site. And if you are not comfortable with the coding contact us.
Depending on the Sync2DB licensing model you choose, you can create free subscriptions or sell your data feed.
In addition to a simple database using our scripts you can synchronize Microsoft Project, Microsoft Sharepoint Server with Outlook. Sync2DB supports multipe subscriptions to the same and different databases simultaneously (links multiple Outlook folders to different folders or databases). This feature allows synchronizing Outlook items with several databases simultaneously (either in different or the same Outlook folders).

Three-way Outlook-Database synchronization with advanced filters

Sync2DB provides support of the following synchronization types (synchronization directions):
  • Outlook-Reader (Download/Import only)  - download from database to local Outlook only;
  • Outlook-Publisher (Upload/Grab/Export only), - upload from local Outlook to database only;
  • Two-way Synchronization (Download and upload/Export-import) - two-way data exchange between database and local Outlook;
  • In addition Sync2DB provides:
  • One-time transfer or ongoing synchronization.
  • support for both built-in and custom Outlook fields.
  • sync of all Outlook data types, including multi-valued Keywords fields and Attachments
  • Ability to work directly with Outlook data via MAPI without interference with Outlook application (i.e. without opening or starting Outlook in the background).
  • Synchronization filters (customizable for each Outlook folder or for all folders of the same type) which helps developers synchronize or grab the only Outlook data that they want. Synchronization filters can be set for Outlook folder and / or database table.
  • Data transition (i.e. you can see customers' orders from your web site and manage your customers contact information within your Outlook).
  • Equivalent Items detection and management.
  • Customizable mapping between columns/tables in database and fields/items in Outlook for Outlook types of items (Email, Post items, Calendar, Contacts, Tasks, Notes and Journal items).
  • Separate mapping rules for each Outlook folder (in view that there may be items of various types in one folder).
  • Microsoft Exchnage and Public folders synchronization support.

    Ability to synchronize your SQL Database with Microsoft Outlook folders located on a Microsoft Exchange Server, including Public Folders.
    Note: Sync2DB does not directly support the Exchange server and database synhronization. Sync2Db is an application installed on the end-user PC and is used to sync Outlook folders with your selected database. If you want to implement direct-sync please contact us here.

    Manual or auto-synchronization based on scheduler and instant "Push" technology.

    Synchronization starts either automatically on schedule (automatic background synchronization according to the configuration files), or manually by user request. You can also use Push* to deliver all your changes to the server or user Outlook as soon as they appear in Outlook or subscribed database.

    Sync2DB Synchronizer Developers KIT and advanced options

    With free documentation and Sync2DB mapping* tool and KIT* developers can set up Sync2DB subscriptions and advanced settings. I.e.:

  • Create subscriptions with custom mapping and Sync2DB behavior.
  • Integrate Sync2DB into an existing application (sharing and synchronizing Outlook, CRM, ERM, etc.).
  • Stealth mode
  • Choose the silent installation option. The Product distribution kit will allow remote (or administrative) installation of Synchronizer onto users' computers by developer or administrator.
  • Protect the subscriptions settings.
  • Ability to customize the “Help” menu.
  • Two ways of connecting with database supported:

  • Direct connection: Synchronizer connects directly to database.
  • Use of XML Web Services (the presence of web-server needed).
  • Both connections work with the database:
  • via LAN (Local Area Network)
  • via Internet (including VPN - Virtual Private Network).
  • Flexible Sync2DB licensing schemes

  • All licenses are per user (PC user account).
  • The Pro Private license allows Sync2DB users subscribe to any available database without any expences incurred from the side of a database owner. The database owner can create subscriptions for Free and then sell them or allow a free data feed. The management of this license is available from 4Team Server only and can be purchased here
  • The Pro Corporate license is similar to the Pro Private license, when Outlook serves as a Data reader for staff members. It allows them to synchronize their data with any data source. The management of this license is available from 4Team Server or from the owner side. Before purchasing this type of license please contact us.
  • Standard Corporate License: Intra-company usage. The user is allowed to synchronize with one database only. The management of this license is available from 4Team Server or from the owner side and can be purchased here.
    Note: The Standard Corporate License is limited, and allows the users to have enterprise subscriptions only. Free subscriptions require the Pro user license.

    User Privacy protection.

    To provide user privacy protection, a special alerting form is implemented. This will help users avoid subscribing to or uploading the unwanted or private Outlook data.

    Support for mixed Microsoft Outlook and Windows environment

    The Sync2DB application is designed for mixed Microsoft Outlook 2000, 2002, 2003, 2007 and Windows 2000, Windows XP (Home/Pro), Windows Vista and Windows 7 environment.

    Work online or offline

    Synchronize your Outlook data and database automatically when you are online, or edit your data on your Outlook when you are offline, then post your changes to your account whenever you're ready and online.

    Synchronize Outlook with subscribed database without interrupting your work

    Sync2DB makes synchronization automatically without interrupting your actual work, Sync2DB will automatically change (lower) the priority for the synchronization process when your PC is busy with your work. The Program will work even when Outlook is closed, and if any changes have been made on other shared PCs, you will actually see all the updates after opening your Outlook without additional synchronization steps, and without waiting. And if you do not want to see this process running in your PC memory, simply exit* and when you finish you work or game, run Sync2DB process manually.

    *Some functional features are limited in the current version and will be added in the future versions.

    Take the Tour >>

  • Microsoft and Outlook are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.