Destination

To set the destination credentials navigate to the settings tab in the Bold ETL. Bold ETL supports four different destinations:

1. PostgreSQL
   
2. Apache Doris
   
3. SQL server
   
4. MySQL
   

We can configure multiple data store destinations with the same server type and load data into them. This is common in scenarios where we might have multiple databases of the same type (for example, multiple MySQL or PostgreSQL databases) for different environments like development, testing, staging, or production, or for different segments of business operations.

• Step 1 : Click on the settings.

• Step 2: Choose the Connection Type.

New: Choose this option if you are creating a new connection to a destination for which you have not previously created credentials.

Existing: Select this option if you are updating or modifying the credentials or settings of a connection that you have already set up.

• Step 3: Choose the destination where you want to move the data.

• Step 4: Enter the credentials for the respective destination.

• Step 5: Click on Save to save the credentials from the Bold Reports Data Store. If all the given credentials are valid, the “Datastore settings are saved successfully” message will appear near the save button.

PostgreSQL

Enter the following credentials for PostgreSQL:

• Server name / Host name.
• Port number(default port number is 5432).
• Maintenance Database : The maintenance DB is a default database for users and applications to connect to. On PostgreSQL 8.1 and above, the maintenance DB is normally called postgres.
• Username
• Password
• Check the SSL (Secure Sockets Layer) checkbox if needed.
• Database name : If the data wants to be moved to an existing database in the server click on the existing database radio buttons and give database name in the textbox or click on new database to create a new one and enter the database name in the textbox.

Apache Doris

Enter the credentials for the Apache Doris:

• Click on Save to save the credentials.
• If all the given credentials are valid, the “Datastore settings are saved successfully” message will appear near the save button.

SQL Server

Enter the following credentials for SQL Server:

• Server name/Host name
• Username
• Password
• Check the SSL (Secure Sockets Layer) checkbox if needed.
• Database name : If the data wants to be moved to an existing database in the server click on the existing database radio buttons and give database name in the textbox or click on new database to create a new one and enter the database name in the textbox

MySQL

Enter the following credentials for PostgreSQL:

• Server name/Host name
• Port number (default port number is 3306)
• Username
• Password
• Check the SSL (Secure Sockets Layer) checkbox if needed.
• Database name : If the data wants to be moved to an existing database in the server click on the existing database radio buttons and give database name in the textbox or click on new database to create a new one and enter the database name in the textbox