![]() Provision an EC2 instance in the public us-west-1a subnet. Remove all outbound rules for the RDS security group. The default outbound rules should be fine.Ĭreate a security group for the Postgres RDS instance to be provisioned in the private us-west-1b subnet.Īuthorize inbound traffic from the public subnet over port 5432. On the Route Tables tab of the VPC Dashboard, create a new route table.Īdd a route to the route table for the Internet gateway.Ĭreate a subnet in the us-west-1a availability zone.Ĭhange the route table for the previously created subnet from the main route table to the custom route table.Ĭreate a subnet in the us-west-1b availability zone.Ĭreate a security group for the EC2 instance to be provisioned in the public us-west-1a subnet.Īuthorize inbound SSH traffic from your local IP address. On the Internet Gateways tab of the VPC Dashboard, create a new Internet gateway.Īttach the gateway to the newly created VPC. ![]() Navigate to the VPC Dashboard in the AWS Management Console and create a new VPC. Finally, we will SSH into the EC2 instance, install the Postgres client psql, create a table on the RDS instance, and install and set up an SSH tunnel. An EC2 instance will be provisioned in the public subnet with an attached security group that only allows inbound SSH traffic from your local IP and all outbound traffic. A Postgres RDS instance will be provisioned in the private subnet with an attached security group that only allows inbound traffic on port 5432 from the public subnet. The public subnet will have a custom route table that includes the local route as well as a route directing all other traffic over the Internet gateway. The VPC will have an Internet gateway attached, however the main route table will contain only a single local route that enables communication within the VPC. We will create a VPC with 2 subnets in the us-west-1 region 1 public subnet in the us-west-1a availability zone and 1 private subnet in the us-west-1b availability zone. The following diagram depicts what our final architecture will look like. This allows you to connect Chartio to a database in your private VPC subnet without modifying its route table or security groups. If you're syncing to your database, you probably chose a schema like hubspot to sync the data to.In this tutorial, we will walk through setting up an Amazon RDS instance inside a private VPC subnet and connecting to it using an SSH tunnel.Ī reverse SSH tunnel makes an outbound encrypted connection from within your VPC to Chartio’s servers. Step 4: Then name your TablePlus connection and click Create. Step 3: Copy and paste the Connect URL from Sequin into the Connection URL in TablePlus then click Import. Step 2: Click the Import from URL button. Step 1: After connecting, open TablePlus and click Create a new connection. You might use a SQL client like TablePlus to connect to your database and get a feel for how your HubSpot data is organized: While the backfill can take a while, you can connect to your database and start querying right away. We'll email you when your backfill is complete. Depending on how much data is in your HubSpot account, this process can take a while. Or, you can try Sequin out by syncing to a Postgres database we host for you (on Amazon RDS).Īfter you click Create, we'll connect to HubSpot and begin back-filling all your data. We'll sync to a new schema in your Postgres database. Step 6: Connect the destination database you want to sync your data to. While we are in alpha for HubSpot, we will only sync the following tables plus any custom tables in your account. Click the gear icon next to the table to open up the column mapping modal: Step 6: You can configure which columns you want to sync for each table. You can adjust which tables you sync at anytime. By default, we'll sync all tables supported by Sequin. Step 5: Select the tables you want to sync. We can help you sort out which permissions your users needs to connect HubSpot to Sequin. If you receive an error that says "You don't have permission to connect this app" please contact us. Step 4: This will open a new window for you to log in with your HubSpot credentials. Step 3: Under the "Add Key" section, select "Add new API key" from the drop-down and then "Connect to HubSpot". Step 2: Select HubSpot as the platform you want to sync. In just a couple of minutes, you'll have your HubSpot data syncing to your Postgres database. This guide walks you through setting up HubSpot on Sequin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |