Skip to main content
Version: v3


Step 1: Create data sources

You can create a data source through the following two operations. The first is to click the "+" button on the sidebar Data Source or click the Create a Data Source button on the Overview page to create.


Step 2: Set connection information

In the pop-up form, fill in and set the connection information, and click Submit to send.


  • Name: database name, for display, can be modified later
  • Data Source Type: database type, please select Oracle
  • URL: Please fill in <hostname>:<port> format, for example,
  • Username: Username used for connection
  • Password: Password used for connection
  • Content Type: use SID or SERVICE_NAME connection
  • SID or Service Name: According to the selected Content Type, you can further input SID or Service Name
  • Default Scale and Number Rounding Mode: If the Table contains floating point types, such as Double, Float, and the data also has decimal point values, you need to set these two fields
  • Explore Timeout: If the database contains a large number of Tables, it is recommended to increase this parameter so that the Explorer can wait for a longer time
How to set Default Scale and Number Rounding Mode
  • Default Scale: How many digits to deal with the decimal point
  • Number Rounding Mode: If it exceeds the number of digits specified by Default Scale, how to deal with the excess
    • Unnecessary: If the number of digits is exceeded, an error will be thrown directly to make the Query fail
    • Up: Round away from zero
    • Down: Round towards zero.
    • Ceiling: Round towards positive infinity.
    • Floor: Round towards negative infinity.
    • Half Up: Round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up.
    • Half Down: Round towards "nearest neighbor" unless both neighbors are equidistant, in which case round down.
    • Half Even: Round towards the "nearest neighbor" unless both neighbors are equidistant, in which case, round towards the even neighbor.

The following examples encounter different values. When Default Scale = 0, different Number Rounding Mode actually get the value

5.56565656throw ArithmeticException
2.53232322throw ArithmeticException
1.62121222throw ArithmeticException
1.12121111throw ArithmeticException
-1.1-2-1-1-2-1-1-1throw ArithmeticException
-1.6-2-1-1-2-2-2-2throw ArithmeticException
-2.5-3-2-2-3-3-2-2throw ArithmeticException
-5.5-6-5-5-6-6-5-6throw ArithmeticException

Step 3: Complete the build

After submitting, the Oracle data source will show up in the sidebar in a few moments, and you can click to enter the data source details page.