Bridge between SQL database and Outlook

Assign table

GeniusConnect enables synchronization between Outlook folders and any SQL database with ODBC support, e.g., MS Access, MySQL, SQL Server, Oracle, PostgreSQL, DB2, SQLite, Sybase, FileMaker, etc.

A folder can be linked to a database table or view. You can use your own table structure and define conversions for columns with data type's that are not compatible with Outlook fields. It is possible to synchronize multiple Outlook or Exchange / Office 365 folders and multiple databases.

Synchronization directions

  • 1 way: Outlook to >> SQL database
  • 1 way: SQL Database to >> Outlook
  • 2 way: Outlook <<>> SQL database
    It is possible to define Conflict resolution rules: Outlook overrules Database, Database overrules Outlook, most recent modification time overrules older changes
Outlook folder selection
Outlook folder selection
Outlook to DB columns mapping
Outlook to DB columns mapping
Sync options
Sync options
Conflict resolution
Conflict resolution
SQL Commands
SQL Commands
Start End commands
Start End commands
Generic settings
Generic settings
Synchronize schedule
Synchronize schedule

Folder types

Microsoft® Outlook® 2002/2003/2007/2010/2013/2016/2019/2021
  • Calendar
  • Contact
  • Mail
  • Task
  • Journal
  • Note 
Configurations


Outlook stand-alone: Outlook with personal folder files(.pst)
Outlook on Microsoft Exchange / Office 365 Mailbox
Many other servers have been reported to work with GeniusConnect

Technology


GeniusConnect is an Outlook Add-In and becomes an integral part of Outlook after installation.

GeniusConnect Ribbon
Features and Requirements
Demo: Save Outlook email to SQL Server