Forum Discussion

gg433's avatar
gg433
New Contributor III
6 years ago

Redshift and SnapLogic

We are trying to stand up a new Redshift environment and want to be able to connect and run pipelines with SnapLogic.

Corporate security rules require us to launch the Redshift cluster in a private subnet, no NAT or Internet Gateway, all access through firewall rules. Do we absolutely have to use a Groundplex, can we do it in a cloudplex? If we have to use a Groundplex, can we use an existing Groundplex already running in our SnapLogic account?

Thanks!

redshift

3 Replies

  • mina's avatar
    mina
    Employee
    6 years ago

    Hi Gary, if the cluster allows whitelisted addresses, you could whitelist our Cloudplex ips to allow access.
    And yes you can use your existing Groundplex.
    Thanks,
    Mina

  • gg433's avatar
    gg433
    New Contributor III
    6 years ago

    Do we need to whitelist both directions (inbound and outbound), from VPC to SnapLogic and SnapLogic to VPC?

    • mina's avatar
      mina
      Employee
      6 years ago

      Hi Tony, If the Cluster is Publicly accessible,
      just whitelisting SnapLogic Cloudplex ips on VPC side.
      If using the Groundplex, on the VPC, you will also need to
      add a new rule with Redshift as the type, TCP as the protocol, the port 5439 (the default) and the Groundplex nodes’ ip
      to allow them to access.
      If Publicly accessible is false, It can only be accessed from within the VPC.