Connecting Data Sources.

Explanation of the functionalities of connecting external sources.

Connect DataKubes with external data sources:

27062706

DataKubes allows you to connect external sources to perform data extraction or analysis cubes. Currently, the databases supported by DataKubes are:

DataBase SourceKubes Design (Live)DataPipe Extraction
MySQLYesYes
PostgreeNoYes
Amazon RDS (MySql / Posgree / Redshift)PartialYes
SingleStoreYesYes
MSSQL (Microsoft)NoYes
CSV, TAB, JSON (Direct URL Pull)NoYes
ODBCNoYes

If your database is not listed here, you can use integration services such as FiveTran , Hevo , or similar, which allow you to create pipelines from any source to DataKubes.

📘

Enterprise Plan

Remember that you must have contracted the Enterprise plan to use the external data pipeline services since they require external credentials to send the data to the repositories in your private cloud.

Creating and Editing Data Sources.

To create a new data source, go as an administrator user to the "Data Source" section, which will show you a list of data sources and create new ones.

When creating new connections, press the "+ Create" button, which will open the following screen:

10461046

Here, you only have to define the connection name and the type of connection according to the properties available in your plan.

Encryption SSH
Currently, DataKubes allows data encryption through SSH tunnels which are very easy to configure and use. To use a secure connection, you have to put a hook on Use SSH Tunneling for extra security , and it will enable an option like the one in the following screen:

10081008

For proper use of the power of SSH and to protect your data when navigating from the source to the DataKubes repositories, it is crucial to capture the SSH tunnel design according to the following image:

12931293

Once you configure the data source, it can be used according to the type, either to create Cubes in Kubes Designer or DataPipes to extract the data in this source to the repositories configured in your account.