Skip to main content

Create an Oracle Data Source

This guide explains how to configure the connection settings for this data source in NineData.

Before you begin​

  • The server IP address of NineData has been added to the data source allowlist. The server IP address can be viewed by selecting the target region in Access Region on the Create Datasource page.

    server_ip_address

  • Make sure data source quota is available; otherwise, the data source cannot be added. Check the remaining quota in the NineData Console header.check_quota

Procedure​

  1. Sign in to the NineData Console.

  2. On the left navigation pane, click Datasource > Datasource.

  3. Select the Datasource tab, and then select Create Datasource. In the data source type selector, choose Database > (the type of data source to be added). On the Create Datasource page, configure the parameters based on the table below.
    tip

    If you make a mistake during the operation, select the arrow_down icon at the top of the Create Datasource page and choose again.

  1. Configure the data source parameters:
ParameterControl type and requirednessDefault and optionsDescription
ConnectionSingle-select group; requiredThe public network path is selected initially.Select a database connection path. The selected path determines which configuration fields appear.
HostRequired host fieldDisplayed only for direct and gateway-forwarded connectionsEnter the Oracle database host.
  1. After completing the configuration, follow the connection-test and creation flow shown in the current form, and use the page response to determine the next step.