Skip to main content

Create PolarDB for Oracle Data Source

NineData supports adding various types and environments of data sources to the console for unified management. You can use database DevOps, backup and recovery, data replication, and database comparison features for data sources that have been added. This article introduces how to add Alibaba Cloud PolarDB for Oracle data source to NineData.

Prerequisites

  • 已将 NineData 的服务器 IP 地址添加到数据源白名单。服务器 IP 地址的获取方式请参见下图。

    server_ip_address

  • 具备空闲的数据源额度,否则无法录入数据源。您可以在 NineData 控制台页面右上方快速查看剩余配额。check_quota

Operation Steps

  1. Log in to the NineData console.

  2. In the left navigation bar, click .

  3. Click the tab and click on the page. In the pop-up data source type window, select Alibaba Cloud > PolarDB Oracle. On the page, configure the parameters according to the table below.

    tip

    If you make a mistake in the operation, you can click the arrow_down icon at the top of the page to reselect.

  4. Configure the parameters for the data source:

    Parameter
    Description
    Enter the name of the data source. To facilitate subsequent search and management, please use meaningful names.
    Select the access method for the data source. Supports access through , SSH Tunnel.
    • : Access the data source through the public network address.
    • SSH Tunnel: Access the data source through an SSH tunnel.
    selection of configuration items: The public network connection address and port of the data source.
    selection of SSH Tunnel configuration items
    • : Enter the public IP or domain name of the server where the target data source is located, and the corresponding port number (the default port number for SSH service is 22).
    • : Select the SSH authentication method.
      • : Connect through (i.e., the server's login name) and (i.e., the server's login password).
        • : Enter the login username of the server where the target data source is located.
        • : Enter the login password of the server where the target data source is located.
      • (recommended): Connect through and .
        • : Enter the login username of the server where the target data source is located.
        • : Click to upload the private key file, which is a key file without a suffix.
        • : Enter the password set when generating the key file. If you did not set a password during the key generation process, leave this field blank.
    • Note: After the SSH configuration is completed, you need to click the on the right, and there may be the following two results:
      • Prompt : Indicates that the SSH Tunnel has been established.
      • Prompt error message: Indicates a connection failure. You need to troubleshoot the cause of the error and retry.
    • : Can be written as localhost (data source on the local machine) or the internal IP of the host where the data source is located.
    Enter the database login username.
    Enter the database login password.
    Define the character encoding used by the application to generate and parse text data (such as GBK, UTF8), NineData will base this encoding to perform bidirectional transcoding between the application and the database to avoid garbled text during reading and writing.
    Define the time zone information of the application, NineData will convert the stored data to the defined time zone when reading date and time fields without time zone information and return it. For example, if your application is located in Shanghai, fill in +08:00.
    Select the region closest to the location of your database host to effectively reduce network latency.
    Choose according to the actual business purpose of the data source, as an environmental identifier for the data source. Default provides and environments, and supports you to create custom environments.
    Whether to use SSL encryption to access the data source (default off). If the data source enforces SSL encrypted connections, this switch must be turned on, otherwise the connection will fail.
    Click the switch on the right to turn on or off encrypted transmission. Click the > on the left side of to expand detailed configuration.
    : Supports the following four methods.
    • Prefer: Automatically detect the SSL status of the server, if the server has SSL enabled, connect through SSL first, if the server does not have SSL enabled, connect through non-SSL.
    • Require: Always connect to the data source through SSL, if the server does not support this method or cannot establish an SSL connection for other reasons, the connection will fail.
    • Verify-CA: Upload the CA certificate to verify whether the server's service certificate is issued by a trusted institution to prevent man-in-the-middle attacks. At the same time, according to the needs, upload the client user certificate and key to verify your identity and encrypt the communication with the server.
    • Verify-full: On the basis of Verify-CA, check whether the subject of the server certificate (such as hostname, IP address) matches the actual server connected to ensure the security of the connection.
  5. After all configurations are completed, click on the right side of to test whether the data source can be accessed normally. If prompted with , you can click to complete the addition of the data source. Otherwise, please recheck the connection settings until the connection test is successful.