Database Extractors

Extractors import data from external sources and integrate it to the Keboola Connection (KBC) environment. There are a number of extractors for SQL databases.

See our tutorial for help with configuring these extractors. They all are configured in the same way.

On the other hand, the extractor for MongoDB, a NoSQL database, requires a different configuration.

Connecting to Database

The connection to your internal database must be well secured. If you, or your system administrator, want to avoid exposing your database server to the internet, we highly recommend setting up an SSH Tunnel for the connection.

Schema - SSH tunnel

A Secure Shell (SSH) tunnel consists of an encrypted connection created through the SSH protocol connection. You can set up this tunnel to connect to your database server located in your private network that you do not want to be accessed directly from the internet. The SSH connection is encrypted and uses public - private key pair for user authorization.

Find detailed instructions for setting up an SSH tunnel in the developer documentation. While setting up an SSH tunnel requires some work, it is the most reliable and secure option for connecting to your database server.

Note for Azure hosted MsSql Server instances

Mssql Server hosted on Azure will normally have a host name such as [srvName].databases.microsoft.net
The [srvName] is not an instance name, so the instance name should be left blank.
But the username needs to have the suffix @[srvName] as in, for example keboola@srvKeboola