1. Connecting Oracle Analytics Cloud to Your Data
  2. Reference
  3. Data Sources and Data Types Reference
  4. List of Supported Databases in Oracle Analytics Cloud
  5. Key to Connectivity Table

Key to Connectivity Table

Use this guidance on connectivity options to connect Oracle Analytics to your data.

Key

  • Version Numbers:
    • "1.x" means any version starting with a 1 (for example, this includes version 1.4.3 but not version 2.0).
    • "2.0.x" means any version starting with 2.0 (for example, this includes version 2.0.4 but not version 2.4).
    • "1.6+" means any version starting with 1 and is greater than or equal to (>=) 1.6 (for example, this includes version 1.8 but not version 2.4).
  • A "Yes" (Yes) in the Support column means that you can connect to this type of data source using one or more of the options listed in Connectivity Options.
  • Connectivity Options:
    • Standard means that the data source host is accessible via the public Internet.
    • Private access channel means that Oracle Analytics Cloud can access data on a private host over a private access channel. You can use a private access channel to connect to private data sources that are within your virtual cloud network (VCN) on Oracle Cloud Infrastructure or other networks peered to the VCN such as your corporate network. See Connect to Private Data Sources Through a Private Access Channel.
    • Remote Data Connectivity:
      • For datasets, this means that if your administrator has set up and enabled remote data connectivity, you can visualize on-premises data. You’ll see a check box named Use Remote Data Connectivity on the Create Connection dialog that you select to indicate that the database is on-premises. See Configure Data Gateway for Data Visualization.
      • For Semantic Modeler or Model Administration Tool, this means that if your administrator has set up and enabled remote data connectivity, you can model on-premises data of that type. See Configure and Register Data Gateway for Reporting.

      Notes:

    • In data flows, you can add data from remote databases using a remote connection with Data Gateway. However, you can't save data to datasets that use remote connections.
    • Data Access options:

      Live only means that in a dataset, the table can only get its data directly from the data source.

      Cache only means that in a dataset, the table can only load or reload its data into cache.

      Live or Cache means that in a dataset the table can access its data in either live mode or cache mode.

      See Specify Whether a Dataset Table Is Cached or Live.

    • System Connection means that data modelers can connect to a semantic model using connection details copied from an Oracle Analytics Cloud connection. For supported data sources, data modelers copy the Object ID from the Inspect pane into Semantic Modeler. If you're using Model Administration Tool, copy the Object ID into the Connection Pool dialog. See Connect to a Data Source Using a Data Connection.
  • When Oracle Analytics is deployed as part of other services such as Fusion Analytics Warehouse or NetSuite Analytics Warehouse, you can't connect to the semantic model. Therefore you can ignore the Semantic Modeler options.
  • Oracle Analytics Cloud supports Transport Layer Security (TLS) for all data sources.
  • In addition to the connections types listed on the Connections page, you can connect remotely to other on-premises data sources using generic JDBC. See Connect to Remote Data Using Generic JDBC.