Oracle
UI Bakery allows you to easily connect to an Oracle database with no need for additional layers (APIs or 3rd-party services).

Prerequisites

If your database is hosted behind the Firewall, add the following IP address to the Firewall whitelist:
52.176.109.125

Configuration

To connect your Oracle database, follow the below steps:
  1. 1.
    go to Data sources page - click Connect
  2. 2.
    select Oracle from the list of the available data sources
  3. 3.
    Specify your credentials and click Test connection to ensure, that UI Bakery can connect to your data source:
4. When the connection is successful, click Connect Data source.
UI Bakery will extract the database structure and store column types. This data will be used to suggest the proper table columns and form field types.

Usage

Once the connection between UI Bakery and Oracle database is established, you can interact with the data.
  1. 1.
    Add a new action - SQL query. Specify your query and click Run action to launch it.
Note that pre-defined actions, such as Load Table, Create Row, etc. are not supported for Oracle datasource.
2. Check the Result tab to make sure the data is loaded.
Last modified 2mo ago
Copy link
Outline
Prerequisites
Configuration
Usage