Oracle 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 the data sources, actions and tables in your application and add a new data source.
3. Add a new data source by clicking the + icon next to the Sources heading.

4. Select the Oracle option and set 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:

• Host: Enter the address of the Oracle server.
• SID: Type the name of the Oracle database instance.
• User ID: Enter the username that will be used to access the Oracle database.
• Password: Enter your Oracle database password.
• Parameters: Click the “Add parameter” button to add the required custom parameters as key-value pair.

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

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

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

To connect to an Oracle database you are working on locally, the Oracle Server must be open to the Internet.

3. Check if the connection works with the Test button.
4. If the connection is successful, complete the process by clicking the CREATE button.