Email to SQL

Hello,

I'm hoping someone maybe able to assist me. I want to connect to a O365 mailbox, download the emails and store them in a database table.
Once i get the emails into SQL I'm in a happy place. I've looked at the controls in ETL but they aren't making much sense to me, I'm not being asked the configuration questions id expect.

Does anyone know how to do this?

Many thanks in advance

G

Hi.

There are multiple options available depending on your needs

Yes you can download the emails and store them in a database table
this can be done as a batch using transformation

Or you may want to process emails one by one:
Eg:
Read email
Save attachments into the folder
Load data from the attachments into the database
Move email message into the processed folder

The most important step is to connect to the mail server.
This can be done by using IMAP4

Can you try the following, please
Download and install Advanced ETL Processor Enterprise.
Create a new IMAP4 connection and confirm that it is working.

Here is the article with connection details
www.etl-tools.com/wiki/knowledgebase/con...osoft-email-servers/

This however might not work for you, in this case, please create Office 365 connection instead and confirm that it is working
www.etl-tools.com/wiki/advanced-etl-proc...ons/email/office365/

Once confirmed we can have a short remote session where one of us will help you with the transformation

Please watch introduction video to get started

Thanks for the quick response Mike.

I looked at www.etl-tools.com/wiki/advanced-etl-proc...ons/email/office365/

But I don't understand the fields its asking. If you could point me to where i find the client ID, Application ID and Secret I maybe able to work this out.

G

You would need to login into MS Azure to get them
We do not use it here.
When we added this functionality those details were provided to us by one of our customers so we can do the testing

I did some google search and found this video.

Hi. This is the correct path to take. Basically, you need to setup OAUTH authentication and permissions for a registered "application". Doing this process will result in a ClientID, Tenant ID and a Secret.

The "Email" is the email address of the Mailbox that you need to collect messages from.

One thing to be cautious of is the "Client Secret" once it is generated and you have a copy of it, when you leave that screen in the Microsoft Azure AD setup you cannot see it again. So, you need to make sure you keep a copy of it so it can be pasted into the AETL O365 Connection dialog box. You can generate a whole new one by creating a new Application registration.

The other thing to be mindful of is the permissions or scope assigned. Without the correct permissions messages may be read but you may not be able to move, delete or flag them as being read.

The video should cover this but you may also find the following links helpful.

How to register your app for Office 365 with OAuth 2.0 authentication