Connection Options
Hevo offers you different ways to connect to your Source account for ingesting the data. These include:
-
Direct Connection: You can use database login credentials, API Keys, or OAuth to directly connect to your database or SaaS application. Refer to the respective Source documents for the steps to configure such Sources.
-
Secure Shell (SSH) Connection: Hevo allows for both SSH and Reverse SSH connections to database Sources. To connect to an SSH tunnel server, you must allowlist Hevo’s IP address of the region where your account is created. However, this type of connection introduces latency in the Pipeline due to encryption and tunneling. Read Connecting Through SSH and Connecting Through Reverse SSH Tunnel for the steps to set up the SSH and Reverse SSH connections, respectively.
Note: SSH connections are available only for database Sources.
Selecting the Optimal Connection Option for Database Sources
In the case of database Sources, you can consider the following parameters while deciding the connection type:
-
Data Sensitivity: If your database does not contain any sensitive data, you can establish a direct connection between Hevo and the database for optimal data replication. However, for sensitive data, an SSH connection is recommended due to its enhanced encryption and tunneling.
-
Database accessibility: If your database is:
-
Hosted on-premise or on a public cloud network, you can directly connect it to Hevo.
-
Not publicly accessible over the internet, you can set up an SSH connection.
-
Optimizing the Data Replication for Database Sources
To optimize the Pipeline performance and data replication efficiency for your SaaS or database Source, you can verify that your Source database is either geographically closest or colocated to the region where you create the Hevo Pipeline. For example, create your Pipeline in the US region if your database is present in the US region.
Note: Since the data ingestion takes longer than loading, the account is usually set up where your data lies. However, you can optimize on the Source or Destination location or select a different region altogether.
- Articles in this section