Connect

Oracle Analytics connects to many data sources, both Oracle and non-Oracle, including other cloud providers (e.g., Azure and Google), social feeds, IoT sources, data lakes, and more. Connected data sources can include cloud, on-premises, or self-service data sets. Use self-service to blend third-party or personal sources for a complete business view.

• Topics
  • Native connectors
  • Integration with data lakes
  • Direct query and data caching
  • Datasets and local files

Native connectors

Get started quickly with 40 out-of-the-box native connectors that provide connections to dozens of applications including Oracle Autonomous Database, Enterprise Performance Management, Fusion Applications (HCM, ERP, CX, and more), Oracle Database Analytic Views, and non-Oracle sources, such as Google Big Query, Salesforce, Amazon Redshift, Azure Synapse Analytics, Snowflake, and more. Connect to any Java Database Connectivity-based (JDBC) data source.

See all supported data sources

Figure 1: Native connectors to popular data sources

Integration with data lakes

The data required to make informed decisions comes from many data sources and includes a wide variety of different data types, such as structured, semi-structured and unstructured. Oracle Analytics provides the flexibility to connect data lakes (Oracle Cloud, Azure, AWS, and Google Cloud) through OCI services, such as OCI Data Catalog and Oracle Autonomous Database, to ensure all relevant data is available to users. Data does not need to be moved or replicated to support business analytics. Whenever possible, functions are shipped to and processed by the data source servers.

Figure 2: Integrating analytics with the data lakehouse

Direct query and data caching

The Oracle Analytics platform provides both direct query and caching options. Direct query enables data to be ingested into the analytics layer directly from the data source itself at query time. Choose a custom balance between direct query and caching depending on the analytics use case. Analytics queries are automatically optimized for each data source for best performance. Oracle Analytics does not require any third party or proprietary data store to be preloaded with data before users’ analytics activities can begin.

Direct or live connections

Direct query is an essential need as identified by Gartner in their Critical Capabilities for Analytics and Business Intelligence Platforms report. This ensures the most accurate representation of the data in the visualization layer but can potentially place a lot of analytics compute load on the data source systems.

Data set caching

Frequently accessed query results can optionally be cached by Oracle Analytics (both OAC and OAS) to boost performance and reduce the analytics workloads on the source systems. Caching analytics data sets also helps to reduce data source processing loads.

Figure 3: Oracle Analytics Cloud in-memory engine

Data sets and local files

Upload local or personal data sets, such as spreadsheets and comma-separated value (CSV) files. Analyze these data sets alone or combine with any connector-based data source or governed enterprise data model.

Figure 4: CSV upload data preview