# Oracle

Through the Oracle (opens new window) connector, Ontop is able to construct VKGs on external Oracle databases.

# Limitations & Exceptions

  • Ontop cannot perform inference based on nested data types in Oracle.
  • Ontop represents the "big integer" datatype as NUMBER(19).

# Database Connection

The following shows the content of a sample .properties file that can be used to connect Ontop to Oracle:

jdbc.url = jdbc:oracle:thin:@//localhost:49161/defaultcontainer
jdbc.user = user
jdbc.password = password
jdbc.driver = oracle.jdbc.OracleDriver

# Nested Type Support

Ontop does not implement explicit compatibility with nested datatypes in Oracle. However, Ontop allows the usage of the flatten lens over string columns that contain JSON-encoded arrays. The output type of the flattened result column cannot be inferred.

To use the flatten lens with Oracle array types, they must first be converted to JSON strings.

In case the flattened column is still a nested structure after the flatten operation is performed (e.g. for arrays of objects), Oracle's JSON functions (opens new window) can be used to further work with them.

WARNING

Accessing object fields using the "dot operator" is not supported. Please use SQL JSON functions instead.