Skip to content

Data Source Support

Oracle Connector

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. The following table lists the versions that have been tested in the lab setup:

Platforms Version
Linux
  • Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - AWS
  • Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production - GCP

Note

  • User on source database must select privileges
  • User on target database side must have all privileges and SELECT_CATALOG_ROLE.

Supported Data Types

The following are the different data types that are tested in our lab setup:

  • VARCHAR
  • VARCHAR2
  • NUMBER
  • FLOAT
  • DATE
  • TIMESTAMP(default)
  • CLOB
  • BLOB(with text)

Note

Hyperscale Compliance restricts the support of the following special characters for a database column name: 

~!@#$%^&*()\\\"?:;,/\\\\`+=[]{}|<>'-.\")]