Table of Contents
- Title and Copyright Information
- Preface
- Part I Getting Started with Connecting Oracle Analytics Cloud to Your Data
-
Part II Connecting Oracle Analytics Cloud to Your Data
-
2
Connect to
On-premises Data Sources
- Overview to Connecting to On-premises Data Sources
- Connect to On-premises Data Sources Over a Private Access Channel
-
Connect to On-premises Data Sources Using Data Gateway
- Typical Workflow to Connecting to On-premises Data Sources with Data Gateway
- Before You Start with Data Gateway
- Install or Upgrade Data Gateway
- Configure Data Gateway for Data Visualization
- Configure and Register Data Gateway for Reporting
- Connect to an On-premises Database from Oracle Analytics Cloud
- Maintain Data Gateway
-
3
Connect to Data
- Manage Connections to Data Sources
- Connect to an Oracle Database
- Connect to Oracle Analytic Views
- Connect to Oracle Autonomous Data Warehouse
- Connect to Oracle Autonomous Transaction Processing
- Connect to Analytic Views in Oracle Autonomous Data Warehouse
- Connect to Oracle Fusion Cloud Applications Suite
- Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM)
- Connect to Essbase
- Connect to NetSuite
- Connect to Oracle Talent Acquisition Cloud
- Connect to a Database Using Delta Sharing
- Connect to Dropbox
- Connect to Google BigQuery
- Connect to Google Drive or Google Analytics
- Connect to Snowflake Data Warehouse
- Connect to OCI Data Flow SQL Endpoints
- Connect to Data from REST Endpoints
- Connect to Remote Data Using Generic JDBC
- Connecting to Data Sources Using Kerberos Authentication
- Connect to Oracle Service Cloud
-
4
Connect to Data for Pixel-Perfect Reports
- Overview to Connecting to Data for Pixel-Perfect Reports
- About Private Data Source Connections
- Grant Access to Data Sources Using the Security Region
- About Proxy Authentication
- Choose JDBC or JNDI Connection Type
- About Backup Databases
- About Connection Creation and Closure Functions
- Set Up a JDBC Connection to a Data Source
- Set Up a Database Connection Using a JNDI Connection Pool
- Set Up a Connection to an OLAP Data Source
- Set Up a Connection to a Web Service
- Set Up a Connection to an HTTP Data Source
- Set Up a Connection to a Content Server
- View or Update a Connection to Data Source
-
5
Manage Database Connections for Modeling Data
- Model Data in an Essbase Cube
- Model Data in Snowflake Data Warehouse
- Model Data in Google BigQuery
- Integrate with Oracle Enterprise Performance Management Platform Business Processes
- DSN Formats for Specifying Data Sources
- 6 Give Data Sources Access to Oracle Analytics Cloud Deployments
- 7 Manage Database Connections for Model Administration Tool
-
2
Connect to
On-premises Data Sources
-
Part III Connecting to Oracle Analytics Cloud From Other Applications
-
8
Connect to Oracle Analytics Cloud from Microsoft Power BI (Preview)
- About Microsoft Power BI Connectivity Support in Oracle Analytics Cloud (Preview)
- Prerequisites for Microsoft Power BI Integration (Preview)
- Configure a Microsoft Power BI Environment for Oracle Analytics Cloud Integration (Preview)
- Connect to Oracle Analytics Cloud from Microsoft Power BI Desktop (Preview)
- Integrate Oracle Analytics Cloud with Microsoft Power BI (Preview)
- Troubleshooting Power BI Connectivity and Performance (Preview)
- Frequently Asked Questions the Connector for Microsoft Power BI (Preview)
-
9
Query Semantic Models Remotely Using JDBC
- Overview to Querying Oracle Analytics Cloud Semantic Models Remotely
- Choosing an Assertion Type for Your JDBC Connection
- Typical Workflow to Query Oracle Analytics Cloud Semantic Models Remotely
- Register the BIJDBC Application Using Resource Owner Assertion
- Generate the Client Private Key and Client Certificate File
- Register the BIJDBC Application using JWT Assertion
- Set Up Refresh Security Token
- Download the JDBC Driver
- Connect to Oracle Analytics Cloud Using a JDBC URL
- Example: Connect to a Semantic Model Remotely Using SQuirrel
- 10 Connect to Databases Deployed on a Public IP Address
-
8
Connect to Oracle Analytics Cloud from Microsoft Power BI (Preview)
-
Reference
-
A
Data Sources and Data Types Reference
-
List of Supported Databases in Oracle
Analytics Cloud
- Oracle Database
- Oracle Analytic Views
- Oracle Applications
- Oracle Autonomous Data Warehouse (ADW)
- Oracle Autonomous Transaction Processing (ATP)
- OCI Data Flow SQL Endpoints
- OCI Object Storage
- OCI Resource
- Oracle EPM Cloud (for Oracle Fusion Cloud Enterprise Performance Management)
- Oracle Essbase
- Oracle Hyperion Planning
- Oracle NetSuite
- Oracle Fusion Cloud B2C Service
- Oracle Talent Acquisition Cloud
- Amazon EMR
- Amazon Redshift
- Apache Hive
- CSV File
- Databricks
- Delta Share
- DropBox
- Google Analytics
- Google BigQuery
- Google Drive
- GreenPlum
- Hortonworks Hive
- IBM BigInsights Hive
- IBM DB2
- Impala (Cloudera)
- Informix
- JDBC (Generic)
- Local Subject Area in Oracle Analytics Cloud
- MapR Hive
- Microsoft Excel File
- Microsoft Azure SQL Database
- Microsoft Azure Synapse Analytics
- MongoDB
- MySQL
- MySQL HeatWave
- OData
- Pivotal HD Hive
- PostgreSQL
- REST API
- Salesforce
- Snowflake
- Spark
- SQL Server
- Sybase ASE
- Sybase IQ
- Teradata
- Vertica
- Key to Connectivity Information
- Databases that Support Incremental Reload for Datasets
- Certification - Supported Data Types
- JSON Examples for Common Data Sources with REST Endpoints
- About the Oracle Applications Connector
-
List of Supported Databases in Oracle
Analytics Cloud
- B Frequently Asked Questions
- C Troubleshoot
-
A
Data Sources and Data Types Reference