Key to Connectivity Information

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:
    • Public means that the data source host is accessible via the public Internet.
    • Private means that the data source host isn't 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.

        When you connect to a private data source in Oracle Analytics Cloud, you must specify the Fully Qualified Domain Name (FQDN) of your private data source in the connect dialog. You can’t use IP addresses to connect to private data sources.

      • 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.

          When you connect to a private data source in Oracle Analytics Cloud, you must specify the Fully Qualified Domain Name (FQDN) of your private data source in the connect dialog. You can’t use IP addresses to connect to private data sources.

        • 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.
    • In data flows, you can read data from remote data sources connected with Data Gateway. However, you can't write data to remote data sources connected with Data Gateway.
    • 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. See About Semantic Model Data Source Connections. 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 can support Transport Layer Security (TLS) for 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.
  • Your use of third-party data sources is governed by the data source vendor's terms and agreements, and you're responsible for complying with these terms and agreements.