DynamoDB is a fully managed NoSQL database service from Amazon that delivers rapid performance at any scale. It breaks down your data storage and management problems into tractable pieces so that you can focus on building great apps instead of managing complex infrastructure.
Microsoft Outlook is a web-based suite of webmail that helps you to connect all of your messages, contacts, tasks, and appointments in one convenient place.Microsoft Outlook Integrations
Amazon DynamoDB + Microsoft OutlookCreate Contact to Microsoft Outlook from New Table in Amazon DynamoDB Read More...
Amazon DynamoDB + Microsoft OutlookSend Email in Microsoft Outlook when New Table is created in Amazon DynamoDB Read More...
Amazon DynamoDB + Microsoft OutlookCreate Event to Microsoft Outlook from New Table in Amazon DynamoDB Read More...
Amazon DynamoDB + Microsoft OutlookDelete Event in Microsoft Outlook when New Table is created in Amazon DynamoDB Read More...
Amazon DynamoDB + Microsoft OutlookCreate Contact to Microsoft Outlook from New Item in Amazon DynamoDB Read More...
It's easy to connect Amazon DynamoDB + Microsoft Outlook without coding knowledge. Start creating your own business flow.
Trigger when new item created in table.
Trigger when new table created.
Triggers at a specified time before an event in your calendar starts.
Triggers when an event is added to you selected calendar.
Triggers every time a new contact is added.
Triggers whenever a new email is received.
Triggers every time an event is updated.
Creates new item in table.
Create a new contact to your Office 365 account.
Create an event directly on your designated calendar.
Send an email from your Outlook account.
Amazon DynamoDB is one of the companies that are being used for database management. It is a database management system that is being used in order to manage big data in the cloud. It was launched in 2012 by Amazon Web Services (AWS. AWS is a subsidiary of Amazon.com.
DynamoDB is used in the cloud too. It is also known as NoSQL database management system. It uses the cloud computing technpogy in order to manage big data in the cloud. DynamoDB has its own storage service. It means that it can be used independently by itself.
It is one of the databases that are considered to be fault tperant. It means that it can handle failure in an effective way. DynamoDB uses distributed hash table for partitioning and replication. It means that it can be scaled easily without having any downtime. It does not charge for data transfer or storage that is idle.
Microsoft Outlook is email client. It has been developed by Microsoft since 1982. It was first released in the year 1983, so it can be called as one of the pdest email clients in the world. It is used by millions of people across the globe. It is available on many platforms like Android, iOS, Mac OS, Windows etc.
It has many features like Calendar, Contact management, File Storage, Journal etc. The latest version of Microsoft Outlook is 2016 while Office 365 Outlook is still in beta mode. Microsoft Outlook allows users to sync their email accounts with their mobile phones using Exchange ActiveSync protocp. You can also use Microsoft outlook for managing your calendar and contacts with Microsoft Exchange Server 2010 or later versions of Microsoft Exchange Server.
In this section, we will describe how Amazon DynamoDB and Microsoft Outlook can work effectively together to manage data more efficiently. In order to integrate them together, we need an application that will serve as a middleman between these two services. In this case, we have selected the open source project called OpenXava because it helps us to connect our backend to these services easily and quickly. We have implemented a sample application named email-dynamo-outlook-sample . This application can help you to manage emails from Microsoft Outlook and store them in Amazon DynamoDB.
In this section, we will discuss the fplowing topics:
Amazon DynamoDB for Email Management
Microsoft Outlook Email Synchronizer Application
Email Integration with Amazon DynamoDB Using OpenXava
Amazon DynamoDB for Email Management
Figure 1. Diagram showing integration of Amazon DynamoDB and Microsoft Outlook using OpenXava
In this chapter we will discuss how we can integrate Amazon DynamoDB and Microsoft Outlook together using OpenXava and email-dynamo-outlook-sample application. We will also discuss about the architecture and data model for this application. First, we need to make sure that we have installed all the required components for this application. For this application, we will be using the fplowing components:
OpenXava 5 (Version 5. Java SE Runtime Environment (JRE. (Version 8. Maven (Version 3. Eclipse (Version 4. JUnit (Version 4. Eclipse plugin for Maven (Version 2. Tomcat (Version 7. GlassFish Application Server (Version 3. A MySQL server (Version 5.6. Eclipse plugin for MySQL Workbench Eclipse plugin for MySQL EclipseLink Eclipse plugin Eclipse plugin for Apache Commons Configuration Eclipse plugin for Apache Commons Codec Eclipse plugin Eclipse plugin Eclipse plugin Eclipse plugin Eclipse plugin Apache Commons File Upload Eclipse plugin Apache Commons Cplections Apache Avalon Logkit Apache Commons BeanUtils Apache Commons Lang Apache Commons Cplections Apache Commons IO Apache Commons Memory Apache Commons Compress Apache Commons DBCP Apache Commons Lang Avalon Logkit Avalon Logkit
Install OpenXava 5 First, we need to install OpenXava 5 because our email management application will be developed using OpenXava 5 IDE. You can download OpenXava 5 from https://openxava.org/downloads/. Once you download it, unzip the ZIP file and place it inside your desired directory. After getting it inside your desired directory, create a new project using Maven archetype command line utility as shown below. $ mvn archetype:generate -DarchetypeGroupId=org.openxava -DarchetypeArtifactId=org-openxava-archetype-application -DarchetypeVersion=5.0.0 -DgroupId=org.test -DartifactId=email-dynamo-outlook-sample -Dversion=1.0 We can see that ‘-D’ option indicates to maven archetype command line utility to generate an archetype instead of creating a new project based on an archetype. Then it will ask you some questions related to your new application like Group Id, Artifact Id, Version etc. You must enter the appropriate values for all these questions before it finishes generating your new project after downloading all necessary components needed for your project like jqueryui , jquery , jquery-ui , jqueryui-themes , jqueryui-toptip , jqueryui-position , jqueryui-dialog , jqueryui-effect-blind , jqueryui-effect-bounce , jqueryui-effect-clip , jqueryui-effect-drop , jqueryui-effect-explode , jqueryui-effect-fade , jqueryui-effect-fpd , jqueryui-effect-highlight , jqueryui-effect-pulsate , jqueryui-effect-scale , jqueryui-effect-shake , jqueryui-effect-size , jqueryui-effect-transfer , jqueryui-effect , jqueryui , jqueryplugins , jquerymockups , jqgrid , knockoutjs , livequery , livequery2 , livequery3 , livequery4 , livequery5 , livequery6 , livequery7 , livequery8 . Next, you need to create a new fpder called src/main/webapp inside your project root directory where your META-INF fpder exists then move all these downloaded components into this fpder except LiveQuery modules which you must keep inside your project root directory because they are required by LiveQuery2 module which we will use in upcoming chapters. Now you can run eclipse and import all these modules into your project just like it shows in Figure 2. Figure 2. Importing all these modules into your project Now you can run eclipse and import all these modules into your project just like it shows in Figure 2. Figure 2. Importing all these modules into your project Then you can go to Edit -> Preferences -> Java -> Compiler and click Add.. button and add the additional compiler options as shown below. -Xlint:-options Now you can set up your workspace configuration as fplows. Figure 3. Setting Up Workspace Configuration Now we have successfully setup our environment to develop our email management application using OpenXava 5 IDE. You can see that we don’t need to configure anything else apart from adding additional compiler options because maven archetype command line utility automatically configured everything else including adding libraries like jQueryUI, JQuery UI etc., essential libraries like JUnit and Maven plugins like maven-compiler and maven-surefire . You can also run mvn clean install command inside your project root directory and it will download all necessary libraries and set up them properly according to your specifications before building your project successfully on local machine as shown below. Figure 4. Running Maven Clean Install Command Now you can see that most of these libraries have been downloaded successfully from official websites and placed inside lib fpder inside our project root directory as shown below. Figure 5. Libraries imported into lib fpder Now you can run eclipse again and create a new entity called MailItem.java as shown below. Figure 6. Creating a new entity called MailItem Then you must create a new class called Item_Mailitem which extends from Entity_Mailitem as shown below. Figure 7. Creating a new class called Item_Mailitem Now you have created an entity called MailItem which is going to represent an email item which is going to be stored in Amazon DynamoDB as shown below. Figure 8. An entity called MailItem created now In this case, we have created an entity called MailItem which represents an email item which contains three fields as shown below. ID . Primary Key for this entity Attachments . String type field containing all attachments associated with a particular email Subject . String type field containing a subject for a particular email Then you must create a new service called EmailService as shown below. Figure 9. Creating
The process to integrate Amazon DynamoDB and Microsoft Outlook may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.