Solved

Import Echange 2003 Public folder information into a SQL 2005 DB table

Posted on 2007-03-29
1
172 Views
Last Modified: 2010-03-19
We have an internally developed transaction tracker that is built on a web front end and a SQL back end (Enterprise 2005).  This tracker keeps tracker of deals, contracts in-force, items to be looked at and worked out and then where monthly notices need to be sent to confirm receipt of payments.  The solution works well and integrates with many different database systems that have been purchased or forced on the company.

The function that the developers are trying to implement now is to use a standing address book with contact information containing standard outlook fields and some user defined fields (like "does client get a monthly report" tick yes, blank no).  The contacts are stored in an Exchange 2003 Enterprise Public Folder.

We were looking at a product like "Prophet", which is a full blown low-level CRM system, to pull data from the Public Folders and then push out data into the SQL server, generating a unique GUID for each contact record and such.  

The issue is, it seems a waste to use this system as just a courier between Exchange Public Folder and the SQL DB.

Is there a way to:

1. Do a single export of the public folder to a SQL table, retaining all (or a defined list) of the Outlook fields?
2. Have a schedule event where the data from the PF gets updated to the SQL table, either by a trigger when a change is made or on an hourly time setting?

The developers are not asking for the data to be updated in the web form.  The only place that we need to update the contact information is in the public folder.  A synchronization process is required, as well as the creation a a unique GUID for each contact.

Help on how to do this, being pointed to a KB or white paper or products that might assist are all welcome.

Thank you.
0
Comment
Question by:hglobus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
AbhijeetNigam earned 500 total points
ID: 18819549
Exchange Uses Jet Engine and SQL database use there own. I haven't seen/heard about exporting data from PF directly to SQL however I know that using WMI scripting you can create a tool to export data and from Exchange and put it to SQL database.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question