Oracle 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 on the “+” (2) icon next to the “Sources” heading on the left side of the Data Sources module.

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

1. After clicking the “CREATE” button, configure the connection information on the screen that opens:some text
   • Host: Enter the address of the Oracle server.
   • SID: Enter the name of the Oracle database instance.
   • User ID: Enter your Oracle database username.
   • Password: Enter your Oracle database password.
   • Parameters: Enter the required special parameters as key-value pair by clicking the “Add parameter” button.
2. After making the connection settings, check whether the connection is working correctly by clicking the “Test” button in the upper right corner.
3. Then you can configure your connection settings by clicking 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. Oracle Server must be open to the internet to provide a connection to an Oracle database you are working on locally.
4. After entering the information, test whether the Oracle connection is working or not via the “Test” button above. If the Oracle connection is working, create the Datasources connection by clicking the “CREATE” button.

Sample Oracle 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.