Step-by-Step Guide

Step 1: Access the Data Source section

On the main screen of the Orchestrator, select the Data Sources tool.

Step 2: Create a new Data Source

After selecting Data Sources, a new screen will open where you can see existing connections. To create a new connection, click the + CREATE+ button.

Step 3: Fill out the New Source Form

A new screen will open where you need to enter your database details. Define the connection name, connection type, and your database details based on the properties available in your plan.

📘

NOTE

ARPIA allows you to connect external sources for analysis cubes or data extraction. Currently, databases compatible with ARPIA are:

Database	Live Kube Design	DataPipes Extraction
MySQL	Yes	Yes
PostgreSQL	No	Yes
Amazon RDS (MySQL/PostgreSQL/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 like FiveTran, Hevo, or similar, allowing you to create pipelines from any source to ARPIA.

📘

Enterprise Plan

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

Step 4 (Optional): Check the SSH tunneling option and fill the additional form

In ARPIA, you can use data encryption via SSH tunnels for a secure connection. Simply check the option Use SSH Tunneling for extra security.

After choosing the option Use SSH Tunneling for extra security, an additional tab will open where you must fill in the corresponding information.

For proper use of SSH power and to protect your data when traveling from the source to ARPIA repositories, it's essential to design the SSH tunnel as per the following image:

Step 5: Test the connection

Once you configure your connection, you can test the connection by clicking TEST CONNECTION.

Step 6: Create the New Data Source

After testing the connection, click the CREATE button.

Step 7: Check the listed Data Source

Once your connection is created, you can see it listed in the Data Sources section.

Once the data source is configured, it can be used according to its type, either to create cubes in Kubes Designer or Data Pipes to extract data from this source to the repositories configured in your account. In this View you can also access the Data Sources actions.

• Edit: You can select edit to edit the connection name, type, Server, etc.