Following are the steps to create HVR instance for AWS:
- In the AWS portal, create a VM in the AWS console AWS -> EC2 --> Launch Instance type T2.micro – Red Hat 64bit for the agent. In the advanced configuration, have it created in the same VPC as your Redshift cluster(Step 3) and create /use a security group allowing connections on port e.g. 4343 from your on-premise environment (Step 6) (let Amazon auto detect your IP range).
- Then install the HVR software on that VM as an agent by following the installation steps 1,2 and 5 in section Installing HVR on Unix or Linux on the same port (eg 4343) as you just opened in the secuity group.
- Also in the VM, install the Redshift ODBC driver. This is actually the Postgres 8 ODBC driver for Linux. First use yum install to install packages unixODBC, unixODBC-devel and postgresql-libs automatically and then download (with wget) and install package postgres-odbc v8.04 manually to overwrite the Postgres9 components with Postgres 8 components.
- Finally, in the AWS portal, check your Redshift and EC2 instances are in the same VPC and in a security group allowing port e.g. 4343, check AWS -> VPC -> security group -> inbound rules -> 4343 or add it.