Oracle Data Source Add User Guide

Oracle Data Source Add User Guide

Oracle

Oracle is one of the external data sources you can use on the Kuika platform. You can integrate an existing Oracle database as a data source into the application you develop in Kuika.

The main difference between Oracle and MSSQL DB is that MSSQL offers SQL Server specific features, while Oracle supports extended SQL commands and functions.

When a project is started with MSSQL DB, there is no migration to the Oracle workspace. Therefore, it is important to choose the right workspace at project startup.

This course consists of the following topics:

  • Add a data source connection to your application with Oracle
  • Configure Oracle connection settings
  • Configure settings via Connection String
Add a Data Source Connection to Your Application with Oracle
  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.
  1. Select the Oracle option and set a name for your data source.
  2. Complete the process by clicking the CREATE button.
Configure Oracle Connection Settings

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.

Configure Settings via Connection String
  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.

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

Other Related Content

No items found.

Glossary

Alt Başlıklar