Configure Database Connections
The "Configure Database Connections" functionality enables us to either modify an existing connection or establish a new one by specifying the Hostname, Port, Username, and Password details.
Driver - Select a driver option from the dropdown. (Ex: MySQL, Oracle, etc) that enables communication between the application and the database.
In case MySQL is chosen as a driver, there will be no option to select schema. However, if a database other than MySQL is selected, then the option to select Schema will be available.
Database Name - Select the name of the database that you want to connect to.
Connection Name - a unique identifier for the connection that you are configuring.
Host Name - the server or IP address where the database is hosted.
Port - the port number that the database is listening on.
Username - the username that is used to authenticate the connection.
Password - the secret key or phrase that is used to authenticate the connection.
After the user has completed all the mandatory fields, they can click on "Test Connection" to verify the connection with the database. If everything is correct, a success pop-up message will appear, indicating that the connection has been successfully established.
Upon clicking the Save button, the newly created Database connection will be saved and the page will be automatically redirected to the Setup job page.
Once the database is added, the user has the option to choose the database from the "Select Connection" dropdown menu.
Upon selecting the desired database, proceed to the "Assign Synthesis Strategy" page by clicking on the "Select Tables" button.
When configuring database connections, if all the required fields are filled in and the "Test Connection" button is clicked, and the information provided is incorrect, an error pop-up will appear stating that the test connection has failed and indicating the reason for the failure.
Last updated