Setting up a connection

Daana works by reading data from a data source, transforming it, and writing it to a data target. As it's all about your data, let us start our journey here.

Step-by-step

1. Go to the Connections tab in the interface.

2. Click either Add source or Add target.

3. Select the provider for the database connection (e.g., BigQuery, PostgreSQL) and click Next.

4. A form will open with all the information we need to successfully connect to your database. Take your time to fill in all the required fields. If you are unsure about any of the fields, consult your database administrator or SRE team.

5. Once all information is filled in, test the connection using the Test connection button. This will verify that the details you entered are correct and that a connection can be established.

6. Once the connection has been successfully tested, press Create connection to save the connection.

The connection should now appear in the corresponding list of sources or targets. You may edit the connection at any time by clicking on the button marked with a pen icon.

Common pitfalls

• Spell check: The most common pitfall is that pesky typo that you just can't seem to find. Double-check all the information you entered to ensure it is correct.

• SSH Tunnel: If your database requires an SSH tunnel, you will need to check the box for SSH Tunnel and fill in the required information. This is common for databases hosted on cloud providers like Google Cloud Platform or Amazon Web Services. If you are unsure, consult your database administrator or SRE team.