2. Create a project

Once you've configured your connections in Destinations, the next step is to create a project. A project in ReOrc serves as a collaborative workspace where your team can organize and manage all data workflows, models, and transformations relevant to a specific data development goal.

Here you also select the connections created in the previous step and assign them to your project as project connection. This setup defines the data sources needed for building your data transformation workflows.

About project connections

Project connections are data connections linked to a specific project in ReOrc. For each project connection, you can define the connection type and specify separate target databases for development and production environments. This setup provides smooth transitions when promoting changes from development to production.

While a project can have multiple project connections, only one connection can be set as the primary database at a time. This primary database, also called the analytics database, is optimized for reading and aggregating data in large volumes. All models in your project will be executed and built under the analytics database.

Set up a project

Follow these steps:

1. From ReOrc left sidebar, select Data development -> Data design hub.

   This opens up the Data design hub, where all projects are listed.

   
2. Click +Add Project.

3. Provide the necessary information for the new project.

1. General information

Provide the name, tags, and description to help organize your project.

2. Set up environments

A project must have a pair of development and production environments.

In the current beta release, environment setup is limited to the default development and production environments only.

3. Project connections

Click +Add and specify the connection for the project. Use the connection that you set up in 1. Set up a connection.

Only development environment connection is required.

Set analytics database

Next, you need to check the connection as the analytics database:

1. Click Create.

The new project will be displayed in the Data development dashboard.