PostgreSQL Data Source Add User Guide

1. After logging into the Kuika platform, open the project you will work on from the “Apps” screen.

2. Go to the “Data Sources” (1) module. In the Data Sources module, you can view the data sources, actions and tables in the application you have developed, add a new data source, a new action and a new table.
3. To add a new data source to your application, click the “+” (2) icon next to the “Sources” heading on the left side of the Data Sources module.

4. Select “PostgreSQL” (1) as the Data Sources data source type and enter a name (2).
5. Then click on the “CREATE” (3) button.

1. After clicking on the “CREATE” button, configure the connection information on the screen that opens:

• Server: Specify the address (for example, localhost or an IP address) of the server where your database is hosted.
• Database: Enter the name of the PostgreSQL database you want to connect to.
• Authorization: Enter the user information required for the authentication method:
  
  • User ID: Enter the username you are using to connect to the database.
  • Password: Enter the user's password.
• Parameters: You can specify additional parameters for the PostgreSQL connection:
  
  • Key: Type the name of the connection parameter you want to add (for example, ssl or application_name).
  • Value: Enter the value corresponding to the parameter (for example, true or a custom name).
  • Connection Timeout: A parameter in the PostgreSQL connection that indicates that the operation will time out if the connection cannot be established within the time you specify.

2. After setting the connection settings, click on the "Test ” button in the upper right corner to check if the connection is working correctly.
3. Then you can configure your connection settings by clicking on the "CREATE ” button.

1. Turn on the “Use Connection String” switch and enter the “Connection String” information of the database you want to connect to on the screen that appears.
2. For Connection String information, enter information in the format “Server= ;Database= ;User Id= ;Password= ;”.
3. After entering the information, test whether the PostgreSQL connection is working or not via the “Test” button above. If the PostgreSQL connection is working, create the Datasources connection by clicking the “CREATE” button.

Example PostgreSQL Data Source

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

This connection will work smoothly when the user information is entered correctly in the “myServerAddress”, “myDataBase”, “myUsername”, “myPassword” fields.

‍