Connecting Data Sources.
Explanation of the functionalities of connecting external sources.
Connect DataKubes with external data sources:

DataKubes allows you to connect external sources to perform data extraction or analysis cubes. Currently, the databases supported by DataKubes are:
DataBase Source | Kubes Design (Live) | DataPipe Extraction |
---|---|---|
MySQL | Yes | Yes |
Postgree | No | Yes |
Amazon RDS (MySql / Posgree / Redshift) | Partial | Yes |
SingleStore | Yes | Yes |
MSSQL (Microsoft) | No | Yes |
CSV, TAB, JSON (Direct URL Pull) | No | Yes |
ODBC | No | Yes |
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:

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:

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:

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.
Updated about 1 year ago