A DSS way to import SQL tables through ssh ?

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
Hi,

Is there a way to import the tables of a distant sql database through ssh connection ?

Many thanks,

Mikael.

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options
    Hi,

    This is not a feature of DSS, however if you have a SSH connection to a machine hosting a database, you can make a SSH tunnel.

    You'll find a lot of good reads on that topic, but if your database is running on host MYDBHOST and port MYDBPORT (but MYDBHOST:MYDBPORT is not reachable from the DSS machine), run the following from the DSS machine:

    ssh MYDBHOST -L 25000:localhost:MYDBPORT

    And in DSS, create a new connection to host: localhost and port: 25000 (25000 is just an example, you can replace it by any port above 1024). You have to keep the SSH connection open as long as you want to use the database in DSS.
  • mkoutero
    mkoutero Registered Posts: 2 ✭✭✭✭
    Options
    Hi Clément,

    Many thanks this confirms what I felt like being the way to go. Tunnels and network connections are rather maintained outside of DSS.
    Finally, it seems I will have a VPN connection to keep open and not even an ssh tunnel.

    Mikael.
Setup Info
    Tags
      Help me…