Oracle is one of the external data sources you can use on the Kuika platform. You can quickly integrate your existing Oracle database as a data source into the application you are developing in Kuika. The main difference between Oracle and MSSQL DB workspaces is that MSSQL DB offers SQL Server specific features, while Oracle has extended SQL commands and functions. In this course, you will learn how to add Oracle as a data source to your applications.

When a project is started with MSSQL DB, it is not possible to switch to the Oracle workspace; therefore, it is important to choose the correct workspace at project startup.

This training content consists of the following topics:

Adding a data source connection to your application with Oracle.
Configuring Oracle connection settings.

Add a Data Source Connection to Your Application with Oracle

After logging into the Kuika platform, open the project you will work on from the “Apps” screen.
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.

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.

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

Configure Oracle Connection Settings

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.
After making the connection settings, check whether the connection is working correctly by clicking the “Test” button in the upper right corner.
Then you can configure your connection settings by clicking the “CREATE” button.

Configure Settings via Connection String

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.
For Connection String information, enter information in the format “Server= ;Database= ;User Id= ;Password= ;”.
Oracle Server must be open to the internet to provide a connection to an Oracle database you are working on locally.
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.