Reading data from Microsoft Exchange

TormodKojen — Mon, 14 Jan 2019 14:40:31 GMT

I want to read data from a spesific Microsoft Exchange account into a SAS table. Typical fields are sender, receiver, date, subject,

I know that is possible from the 32 bit version of Enterprise Guide.

But the question is: Is this possible in SAS DI Studio (version 4.903) ? And how can this be done?

Re: Reading data from Microsoft Exchange

ChrisHemedinger — Tue, 15 Jan 2019 16:15:56 GMT

Hi @TormodKojen,

SAS Enterprise Guide manages this by using your local Windows components to read data from Exchange, then transform it into a SAS data set. It works...but it relies on that Windows-specific connection and it's sensitive to bit architecture (as you mentioned). No SAS code is at play here, so it cannot be automated outside of the SAS Enterprise Guide app.

If you're using Microsoft Office 365, you can use REST APIs to accomplish the task. This requires a little bit of setup for authentication/access, but then the process can be automated in code.

I have an example that uses these APIs to read and write to Microsoft OneDrive. One of my readers commented and said he managed to adapt the technique to read from his e-mail. Can a SAS-driven auto-response bot be too far behind?

Chris

topic Reading data from Microsoft Exchange in SAS Data Management

Reading data from Microsoft Exchange

Re: Reading data from Microsoft Exchange