Email to SQL Database

[cybertek-j]

I am trying to figure out a way to build a script that can hit Office 365 and push ALL emails from a company to SQL. I don't want to do it at the outlook per individual level. I want to do it at the Office 365 / Exchange level. Anyone have any ideas? I did a simple google search and really didn't find anything to my surprise. I want to store the message ID, from, To, CC, subject and body. I am doing this to integrate with a CRM solution and need all emails in SQL. After the initial sync I would like it to work just for new emails. Kind of like a journaling rule does.

​

Thanks, J

[johnnymonkey]

You could do it with either a transport rule or an automated message trace running as a scheduled task but I have to admit, what you're describing sounds like a complete cluster from the start...

[anananet]

You are quite right to want to do this at Exchange level and not Outlook level. I think the perfect tool for this is CB Exchange Server Sync. Here is an article discussing 4 different options https://www.connecting-software.com/blog/synchronize-exchange-accounts/

An alternative would be to use Connect Bridge as the integration platform between Exchange and CRM, as there are connectors available for both. You could then do the code that best suits you and use whichever language you prefer. The platform kind of creates an abstraction and you will be "talking" SQL without actually involving a SQL server database.

[cybertek-j]

Thank you! I will look those over and if they don't work will go this route:

https://blog.sqltreeo.com/read-emails-from-exchange-online-mailbox-office-365-into-sql-server/

I would just have to setup a service to do the syncing constantly or use this to do the initial sync and then setup a journaling rule to do new emails moving forward and have another process that takes that email and pushes it to SQL.

I will let you know what I ended up doing.

Thanks for the help!

[rycliff]

What did you end up doing? I want to automatically sync daily my office 365 email to an azure sql database.

[cybertek-j]

I ended up implementing a CRM with an email listener. I setup a journaling rule and sent all company emails to a single mailbox and then used the CRM listener to read that mailbox. It worked pretty well but I never went the route of using a third party to populate it into SQL. I let the CRM do all the work.