1. Set up a connection

Before you can begin transforming your data, you'll need to establish connections to your data destinations - the "L" (Load) in the ELT (Extract, Load, Transform) pipeline. These destinations are where your ingested data will ultimately reside, whether it's a database, data warehouse, or data lake.

The Destinations section in Recurve serves as your centralized hub for managing these crucial connection points. Here you can configure and maintain connections to various data storage systems.

For a simple, first-time connection, we recommend you set up connection to a relational database or a data warehouse, so that the raw tables are ready for data modeling without extra transformation.

Follow these steps:

1. From Recurve left sidebar, select Connections > Destinations.

   
2. In the Destinations page, click + Create Connection.

   
3. Select the connector to your data source and click Set up.

   Each connector has its own set of authentication fields and configuration parameters. You can check out the list of available data sources here: Destinations.

   
4. Provide the authentication details and other necessary information.

   For example, we can connect to a MySQL database:

   
5. Select the target and click Test Connection to make sure the connection is successful.

   For development purposes, we test the connection against the Development environment.

6. Click Create destination.

The created connection will be listed in Destinations.