Oracle
Information noteIndustry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.
Supported Oracle versions
The followings data versions are supported:
-
11g
-
12c
-
18c
-
19c
Supported Oracle data types
The following Oracle data types are supported by the Oracle Connector.
- Binary_Double
- Binary_Float
- BFile
- Char
- CLOB
- Date
- Decimal
- Double Precision
- Float
- Integer
- Nchar
- Number
- Nvarchar2
- Real
- RowID
- Timestamp With Local Time Zone
- Timestamp With Time Zone
- Timestamp
- URowID
- VarChar
- Varchar2