Building a Cluster Database and Creating a Repository

Before you start using Astera Data Warehouse Builder client, a repository must be set up on the server. Astera Data Warehouse Builder supports SQL Server and PostgreSQL for building cluster databases, which can then be used for maintaining the repository. The repository is where job logs, job queues, and schedules are kept.

Video

Overview

Go to Server > Configure > Step 1: Build repository database and configure server.

The first step is to point to the SQL Server or PostgreSQL instance where you want to build the repository and provide the credentials to establish the connection.

Note: Astera Data Warehouse Builder will not create the database itself, just the tables. A database will have to be created beforehand or an existing database can be used. We recommend that you make a new (empty) database for this purpose.

Building a Repository on SQL Server

1. Go to Server > Configure > Step 1: Build repository database and configure server.

2. Select SQL Server from the Data Provider drop-down list and provide the credentials for establishing the connection.

3. From the drop-down list next to the Database option, select the database on the SQL instance where you want to host the repository.

4. Click Test Connection to test whether the connection is successfully established or not. You should be able to see the following message if the connection is successfully established.

5. Click OK and the following message will appear. Select Yes to proceed.

6. The following message will indicate that the repository is successfully built.

The next step is to log in using your credentials. To learn how you can do that, click here.

Building a Repository on PostgreSQL

1. Go to Server > Configure > Step 1: Build repository database and configure server.

2. Select PostgreSQL from the Data Provider drop-down list and provide the credentials for establishing the connection.

3. From the drop-down list next to the Database option, select the database on the PostgreSQL instance where you want to host the repository.

4. Click Test Connection to test whether the connection is successfully established or not. You should be able to see the following message if the connection is successfully established.

5. Click OK and the following message will appear. Select Yes to proceed.

6. Following message will appear, which will indicate that the repository is successfully built.

The next step is to log in using your credentials. To learn how you can do that, click here.

This concludes our discussion on building a cluster database and creating a repository in Astera Data Warehouse Builder.