question Near/real-time Outlook email ingestion in Archives of Support Questions (Read Only)

Near/real-time Outlook email ingestion

NAITTOU — Fri, 16 Sep 2022 13:49:52 GMT

Hello everyone,

I have a task that requires email ingestion as soon as is received in outlook, then extract some information by doing a search based on keywords and store the extracted information in hive :

Near/real-time email ingestion ---> extract value --> Store into hive

I read that NIFI can do the job but isn't included in Cloudera.

My question is there any Cloudera service (Flume/Kafka/Spark ....) that can connect to outlook capture emails that satisfy certain criteria, or do I have to make a python code using imaplib and run it using Cron on each time interval.

any given hint is appreciated.

Re: Near/real-time Outlook email ingestion

RobertM — Mon, 11 Mar 2019 22:55:19 GMT

You might have a look here: https://dzone.com/articles/how-to-ingest-email-into-apache-hadoop-in-real-tim

Re: Near/real-time Outlook email ingestion

DennisJaheruddi — Mon, 06 May 2019 11:42:13 GMT

Since the question was asked, the situation has changed. As soon as Hortonworks and Cloudera merged, NiFi became supported by Cloudera.

Shortly after the integrations with CDH were also completed, so that NiFi is now a fully supported and integrated component.

Hence the question already contains the answer: Please look into NiFi for solving this usecase.

Re: Near/real-time Outlook email ingestion

DennisJaheruddi — Mon, 06 May 2019 11:47:17 GMT

This seems relevant:

In Python 2, unicode objects can only be printed if they can be converted to ASCII. If it can't be encoded in ASCII, you'll get that error. You probably want to explicitly encode it and then print the resulting str:

print post.text.encode('utf-8')

Re: Near/real-time Outlook email ingestion

NAITTOU — Mon, 06 May 2019 14:33:46 GMT

Hello guys,

Yeah, that was a long time ago,I managed to get the job by using the following framework :

Logstash -> Kafka -> Spark