GeniusConnect 6.0.2.0

Overview

GeniusConnect is a way to integrate different versions of Outlook with a relational database system (RDBMS) to create a more robust, more searchable email and personal information manager. It is an Outlook Add-on which can also work with Exchange server.

The software can access either Outlook or the more advanced Exchange server. Using the ODBC connection method it is possible for the software to access a number of different SQL-based database system like Oracle, Access, MySQL, SQL Server, PostgreSQL, SQLite, DB2, Sybase, FileMaker, and others. Queries can be run through these database systems on all informational items stored like address books and appointment calendars, and also with the email stored.

Individual categories of information stored in Outlook or Exchange can be synchronized inside a SQL database. Calendars, Contacts, Drafted emails, Notes, Outbox, Sent Items and Custom folders can all be individually-selected for syncing to the SQL database with a specific database table being assigned to collect the data.

Creative and in-depth queries can be created to compare information within the email database with other information across customer databases comparing email addresses with customer names, and so forth. Different email folders can be synchronized across multiple databases. Information can be massaged to fit non-conforming database table configurations. There is a great deal of application for this type of software for businesses who wish to keep their information current.

The software will work across many versions of Outlook. This includes Microsoft Outlook 2000, XP, 2003, 2007, 2010 and 2013. Several versions of Exchange server are also compatible.

Installation

The free or trial version is restricted to 49 records, has auto-sync disabled and lacks folder options. The trial runs for 30 days.

The installation went smoothly and completed quickly. The SQL database has to be configured and then accessed through the GeniusConnect Add-on so the software can begin to store Outlook or Exchange server records inside the database.

A full installation will include a Microsoft Access example, MySQL example and a Microsoft SQL Server example.

No malicious software was added.

Interface

The interface of GenuisConnect is a compact way to manage the syncing of data from Outlook or Exchange to a SQL-enabled database system. There are useful tabs across the top which allow access to Options, Database, Synchronize Schedule, Register, Add ons, and About & Contact information.

A lot is packed into the interface including small buttons with small text that you have to look at for a second to read clearly.

Pros

• Add-on for Outlook and Exchange server which enables syncing emails and organizer data to a SQL database
• Run SQL queries on the data
• Run JOIN queries matching results between more than one database, like comparing customer records with customer Information stored in Outlook or Exchange server

Cons

• For advanced users only.

Conclusion

GeniusConnect is a useful package to turn Outlook or Exchange into a SQL resource that can secure the data and place it in a far more usable format to permit extensive comparative searches.