ETL

How To Rename Mapping Job In Informatica Cloud

Mappings are where all the magic happens in Informatica Cloud. When I started using it, it took me a while to work out how to rename a mapping job. Since then, a few people asked me the same question. So, I decided to write about it. This is probably the …

AWS

How To Launch Postgres RDS With AWS Command Line Interface (CLI)

Now that we can launch a bootstrapped EC2 (How To Launch EC2 With Bootstrapping in AWS) with AWS CLI, let’s explore how to launch Postgres RDS with AWS CLI. As in the previous post, we can basically code infrastructure and resources in AWS. This is a step toward coding up …

AWS

How To Launch EC2 With Bootstrap in AWS

When you launch an AWS resource (EC2 or RDS), you will have an instance with a default configuration. Then, you have to install software and do custom configuration to bring it to a certain state. Bootstrapping enables you to script software installation and configuration and execute it while launching the …

Data Science

How To Create Your Own Personal Data Science Computing Environment In AWS

Running a training algorithm is such a time-consuming task when you are building a machine learning application. If you are developing it with your computer, you cannot do anything else for a long period of time (hours and maybe days) on that machine. Especially when we do parallel processing using …

AWS

How To Configure Network Access Control Lists (NACLs) and Security Groups in AWS

After setting up VPC, Internet Gateway, Subnets, Route Tables (see here), we need to set up Network Access Control Lists (NACLs) for the subnets and Security Group for EC2 and RDS. This is a step in How To Create Your Personal Data Science Computing Environment In AWS. NACLs are at …

AWS

How To Launch RDS Instance In a Specific Subnet

Let’s launch a Postgres RDS in AWS. You will get 750 hours of Amazone RDS Single-AZ db.t2.micro instance as part of 12 month free tier. You also have a bit of options (MySQL, MariaDB, or SQL Server). I am choosing Postgres here. Amazon RDS makes it easy to set up …

AWS

How To Launch an EC2 Instance From AMI in AWS

Let’s launch an Linux EC2 Instance From AMI. In this example, I am launching Linux Centos 7 from Amazone Machine Image. You can choose whichever OS you want for the use case we’ve been working on here. As a reminder, this is the plan. We are going to launch EC2 …

AWS

How To Attach EBS Volume to EC2 Linux Instance In AWS

Let’s create Elastic Block Store (EBS) volume and attach it to Linux. An EC2 instance comes with a storage. But, this storage only persists with the instance. If you need to terminate the instance and start a new one, you will loose the data. If you keep the data in …

AWS

How To Create and Configure VPC and Subnets In AWS

To create VPC, you first need to specify IP range. Each subnet takes IP range within the IP range of VPC. Before you decide the IP range, it is a good practice to plan first. You need to use CIDR notation for IP range. There is a cool tool to …

AWS

How To Create Admin User In AWS

After you create an AWS account, the best practice is to lock away the root account credential (which you used to create the account) and never use it to do your daily tasks. Instead of using the root account, you should create an admin account with all access. To create …