Building Data Integration Solutions

Appendix A. Setting Up the Data Integration Solution Example

Here, we’ll build a part of the initial state of the example batch solution. We’ll set up Ubuntu and a PostgreSQL database via an Amazon EC2 Instance. We’re providing this setup so that the example solution may be replicated.

Ubuntu Linux and PostgreSQL

As covered earlier, there are some good reasons to consider commercial versions of Linux, but for this example integration, open source works fine. Several versions of Linux are available in the AWS marketplace, and the example should work with many of them.

Setting Up Ubuntu AWS EC2 Instances

We first need to create an Ubuntu Linux AWS EC2 Instance. To do so, navigate to the Amazon EC2 dashboard and click the “Launch instance” button, as shown in Figure A-1.

Figure A-1. Amazon EC2 dashboard

Name the instance. I’m using the name “PostgreSQL Database 01 (Ubuntu Linux),” as shown in Figure A-2.

Figure A-2. Name the instance

Scroll down to “Application and OS Images (Amazon Machine Image)” and select Ubuntu under the Quick Start tab, as shown in Figure A-3.

Figure A-3. Application and OS images

Then select the desired AMI from the drop-down menu. Here, we’ll leave it set ...