Setting up Redshift

In case your data is huge we recommend using destination batch mode. Redshift in batch mode requires configured S3.

Creating your Redshift instance

  • Locate Amazon Redshift under the Database section in your AWS portal.

  • Make sure the region is closets to where you want to deploy Event Native and click Create Cluster.

  • Select your Node Type, for a basic setup of EventNative one node dc2.large will suffice. You can always resize this late. To learn more about scaling your deployment and EventNative uses storage see our Scaling Documentation.

  • During setup please make sure to take note of the following values, you'll need them to setup EventNative:



Cluster Identifier

How the cluster is referenced in AWS.

Database Name

Redshift creates a database with the following name.

Database Port

Used for connecting to the database.

Maser username

Primary user of the database.

Master password

Make sure this is secure!

  • During setup make sure to toggle additional configurations away from defaults.

  • Make the following modifications to the default Redshift settings under Network and Security so its accessible by EventNative:

    • Enhanced VPC Routing: Enabled

    • Publicly Accessible: Yes

    • Elastic IP Address: None

Network and Security Settings
  • Under VPC Security Group, make sure to add a group that permits your Redshift native database to be accessible externally so EventNative can connect. For more information on this see Configuring VPC.

  • Click Create Cluster and after the process is done it will appear under Clusters.

  • Click the cluster you've created and make note of the URL under Endpoint in the General Information section, you'll need this for configuring EventNative.

Configuring VPC

  • When creating your Redshift cluster you'll be prompted to select a Security Group which limits who can access your database. To do this locate VPC under Network & Content in your AWS Portal.

  • In the left hand navigation bar under your VPC Dashboard click on Security Groups. Make sure your Region matches where your Redshift cluster is and then click on Create security group.

  • After creating your secutiy group click on the Group ID you've create and update your Inbound Rules to have the IP address of the server hosting EventNative and any machine you'd like to connect to your RedShift on port 5439. For a test setup you can set a source of Anywhere rather than a specific IP, however this is not recommend.

Security Group Settings