Access to a Database with a VPN

Isaac Emmanuel
Isaac Emmanuel Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 18 ✭✭✭

Hello everyone

I am trying to connect to an Oracle DB through a VPN, my Dataiku instance is installed in a Linux server in AWS, to connect to a database do you recommend to connect to the VPN in the terminal of my linux server, if so do you know a way to do it?, in the other hand is it recommended to connect to the VPN through the AWS console? Which option is better?

Thank you!

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,399 Dataiker

    Hi @IsaacChavez
    ,

    Where is the database located
    1) is it within AWS in a Private subnet or another account?
    2) Or is it on-prem

    You would likely want to establish a site-to-site VPN instead. This would be easier to maintain.
    https://docs.aws.amazon.com/vpn/latest/clientvpn-admin/scenario-onprem.html

    If the database is also in AWS then use https://aws.amazon.com/privatelink/ or VPC Peering

    If you have a VPN client you may be able to install on the AWS Linux which will largely depend on your VPN solution. For example for Cisco AnyConnect.

    If it's just for testing you could use an SSH tunnel to bastion host with a public IP from which the database can be accessed. DSS simply connect to the bastion host IP/port configured.

Setup Info
    Tags
      Help me…