Can Exchange 2007 be queried from within SQL 2008 server?

Question

Hello,

I am in the midst of the project that has the following requirements:

- Enable my SQL 2008 server to periodically connect to Exchange 2007 server;
- Retrieve any mail sitting in the INBOX of a specifis account;
- Parse email messages into separate fields (date, subject, body of the message, attachments);
- Store the data parsed in a table of the SQL server.

Does anyone know if it is possible to have Exchange 2007 server made a linked server to SQL server? If yes, how to do this (SQL server does not have the Echange data provider).
Is it also theoratically possible to use SQL to query against Exchange INBOX?


If this approach is not possible... any other ideas how to arrive at the result described above?

Thank you all in advance.

Yuri

PS.. I was told of the OLE DB Provider for Echange, however (as i understand it), the OLE DB Provider for Echange will only work when SQL and Exchange Web Store are located on the same computer. In my case, they are on two separate boxes, and Exchange 2007 server is not under my control.

Answer 1

 Yuri,

Here is a link on OLE DB Provider for Exchange .

Though non-specific to 2007, hope it is helpful.

---

Kalman Toth, SQL Server 2008 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com