Qlik Load Over SSH

Connecting via SSH, create an ODBC connection and using the SSH connection.

A client of mine kept their PostgreSQL database locked away behind an SSH connection. As in most situations, convincing the IT department to change security rules for one dashboard was not a hill I was willing to climb. Instead, I used some old techniques I’d used to connect to my home servers back when I had such a thing.

I use SSH rarely now so I make use of a Chrome extension called Secure Shell for the occasional SSH connection. For this blog post, I’m going to be using the Chrome extension, but the same technique will work with PuTTY or any other SSH tool.

Connecting via SSH

In the image above, a connection was established to the PostgreSQL database through the SSH client. The connection was then routed through a port on the local machine.

  1. The username to connect via SSH to the PostgreSQL database.
  2. The address of the PostgreSQL server.
  3. -L is a flag used in Linux that tells the SSH client to forward the connection. Depending on the client you are using, the flag may not be necessary.
  4. The local port being used by the data connection we will set up next.
  5. The local address being used by the data connection we will set up next.
  6. The open port on the PostgreSQL database that is listening over SSH.

Create an ODBC Connection

Once the SSH connection was set up, I created a System DSN that connected to the PostgreSQL database by routing through the local port. (The numbers below correspond to the numbers in the image above.)


Once the connection was set up, using it was relatively simple.

  1. I connected to the database through through my SSH client.
  2. I opened Qlik.
  3. I created a data connection using the ODBC connection.

Once the connection string was created, selecting tables was the same as connecting to any other database. The only annoyance is having to connect via the SSH client before reloads.

This article originally appeared on the Unconventional QlikView blog. 

Analytics and big data. It's what we do.


Contact Us

National Office Telephone | Mon-Fri 8:30am-5:30pm CT

Data Strategy Session

To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.

Learn More →

Fill out this form to get a 30-minute Data Strategy Session with one of our analytics experts.

Cloud Strategy Session

In one hour, get practical advice that you can use to initiate or continue your move of data and analytics workloads to the cloud.

During your free one-hour cloud strategy session, we will:

  • Review how the cloud fits into overall corporate strategy
  • Review how the cloud fits into data and analytics strategy
  • Review existing cloud assets
  • Discuss data and current analytics solutions to prioritize what components should be moved to the cloud

Fill out this form to get a one hour Cloud Strategy Session with one of our analytics experts.