Supported Oracle Server Versions

10g, 11.2.x, 12.1.x, 12.2.x

Encoding Support

Automatic encoding conversion, no configuration supported.

Connection Preview Support

Supports all tables with read permissions.

Please Note

We will filter out tables owned by system users. The tables to be connected cannot be under the names of system users. System users include "OUTLN", "CTXSYS", "SYSTEM", "RDSADMIN", "DBSNMP", "GSMADMIN_INTERNAL", "XDB", "APPQOSSYS", "SYS", "MDSYS", "OLAPSYS", "ORDDATA", "ORDSYS", "WMSYS", "LBACSYS", "DVSYS", "AUDSYS", "OJVMSYS", "FLOWS_FILES", and users starting with "APEX_".

SQL Query Dataset Support for SQL

Only SELECT statements are supported, with all SELECT-related features supported by the connected Oracle server. Users need to ensure the syntax complies with Oracle standards.

Oracle Server Connection Authentication Support

Supports direct connection with username and password, does not support Proxy Authentication.

Unsupported Field Types

The following types of columns in Oracle server tables cannot be processed correctly. If other fields of this table are needed, you can input a SELECT statement in the SQL query, excluding this field.

• BINARY_FLOAT
• BINARY_DOUBLE
• BFILE
• XMLType
• UriType
• Object
• user-defined datatypes