PostgreSQL Data Source Add User Guide

1. Log in to the Kuika platform and open the project you will work on from the Apps screen.

2. Open the Data Sources module. In this module you can view data sources, actions and tables and add a new data source.
3. Add a new data source by clicking the + icon next to the Sources heading.

4. Select PostgreSQL and enter a name for your data source.
5. Complete the process by clicking the CREATE button.

After clicking the “CREATE” button, fill in the following fields on the screen that opens:

• Server: Enter the address of the server where your database is hosted (localhost or an IP address).
• Database: Enter the name of the PostgreSQL database you want to connect to.
• Authorization:
  
  • User ID: Enter the user name.
  • Password: Enter the password of the user.
• Parameters: You can specify additional parameters for the PostgreSQL connection:
  
  • Key: Name of the connection parameter (ssl, application_name, etc.).
  • Value: The value corresponding to the parameter (true or the name you specified).
• Connection Timeout: The parameter indicating that if the connection cannot be established within the specified time, it will timeout.

After completing the connection settings, check the correctness of the connection by clicking the Test button. After a successful test, click the CREATE button to create your data source.

1. Activate the Use Connection String option.
2. Enter the Connection String for the PostgreSQL database.
   
   • Example format:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

3. Check if the connection works with the Test button.

      4. If the connection is successful, click the CREATE button to complete the process.