Third Party Data Connectors

Oracle Fusion Data Intelligence enables you to connect to a variety of data sources and remote applications to provide the background information for reports. Certain data connectors are available as preview features while some are available by default.

Data Connectors Available as Preview Features
Feature Description
AWS S3

This feature enables an administrator to connect to data in Amazon Simple Storage Service (AWS S3).

See Load Data from Amazon Simple Storage Service into Oracle Fusion Data Intelligence (Preview).

  • On – Display the AWS S3 option in the Create Connection dialog.
  • Off – Hide the AWS S3 option in the Create Connection dialog.

Default: Off

Restart Required: No

Azure SQL

This feature enables connecting to an Azure SQL instance to create augmentations using data from that instance.

See Load Data from Azure SQL into Oracle Fusion Data Intelligence (Preview).

  • On – Display the Azure SQL option in the Create Connection dialog.
  • Off – Hide the Azure SQL option in the Create Connection dialog.

Default: Off

Restart Required: No

Azure Storage

This feature enables connecting to an Azure Storage instance to create augmentations using data from that instance.

See Load Data from Azure Storage into Oracle Fusion Data Intelligence (Preview).

  • On – Display the Azure Storage option in the Create Connection dialog.
  • Off – Hide the Azure Storage option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle Autonomous Database

This feature enables an administrator to connect to custom data in Oracle Autonomous Database. You can create up to five connections to different Oracle Autonomous Database instances which are denoted as Oracle Autonomous Database 1, Oracle Autonomous Database 2, Oracle Autonomous Database 3, Oracle Autonomous Database 4, and Oracle Autonomous Database 5.

See Load Data from Oracle Autonomous Database into Oracle Fusion Data Intelligence (Preview).

  • On – Display the Oracle Autonomous Database option such as Oracle Autonomous Database 1 in the Create Connection dialog.
  • Off – Hide the Oracle Autonomous Database option such as Oracle Autonomous Database 1 in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle BI Publisher

This feature enables connecting to an Oracle Analytics Publisher instance to create augmentations using data from that instance.

See Load Data from Oracle Analytics Publisher into Fusion Data Intelligence (Preview).

  • On – Display the Oracle BI Publisher option in the Create Connection dialog.
  • Off – Hide the Oracle BI Publisher option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle Enterprise Data Management Cloud

This feature enables connecting to Oracle Enterprise Data Management Cloud service instance to build a managed data pipeline with data from that instance.

See Load Data from Enterprise Data Management Cloud into Fusion Data Intelligence (Preview).

  • On – Display the Oracle Enterprise Data Management Cloud option in the Create Connection dialog.
  • Off – Hide the Oracle Enterprise Data Management Cloud option in the Create Connection dialog.

Default: Off

Restart Required: No

EPM Financial Close and Consolidation Data Export

This feature enables connecting to an EPM Export Data instance to create augmentations using data from that instance.

See Load Data from EPM Export Data Instance into Fusion Data Intelligence (Preview).

  • On – Display the EPM Financial Close and Consolidation Data Export option in the Create Connection dialog.
  • Off – Hide the EPM Financial Close and Consolidation Data Export option in the Create Connection dialog.

Default: Off

Restart Required: No

EPM Planning and Budgeting Data Export

This feature enables connecting to an EPM Export Data instance to create augmentations using data from that instance.

See Load Data from EPM Export Data Instance into Fusion Data Intelligence (Preview).

  • On – Display the EPM Planning and Budgeting Data Export option in the Create Connection dialog.
  • Off – Hide the EPM Planning and Budgeting Data Export option in the Create Connection dialog.

Default: Off

Restart Required: No

EPM Profitability and Cost Management Data Export

This feature enables connecting to an Oracle EPM instance to build a managed data pipeline with data from that instance.

See Load Data from EPM Export Data Instance into Fusion Data Intelligence (Preview).

  • On – Display the EPM Profitability and Cost Management Data Export option in the Create Connection dialog.
  • Off – Hide the EPM Profitability and Cost Management Data Export option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle E-Business Suite On-Prem

This feature enables configuring remote agent, loading data from on-premises Oracle eBusiness Suite (EBS), and building a complete managed data pipeline with that data.

See Load Data from On-premises E-Business Suite into Fusion Data Intelligence (Preview).

  • On – Display the Oracle E-Business Suite On-Prem option in the Create Connection dialog.
  • Off – Hide the Oracle E-Business Suite On-Prem option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle Eloqua

This feature enables connecting to an Oracle Eloqua instance to bring in business-relevant marketing and sales campaign data to build a managed data pipeline with data from that instance.

See Connect with Your Oracle Eloqua Data Source (Preview).

  • On – Display the Oracle Eloqua option in the Create Connection dialog.
  • Off – Hide the Oracle Eloqua option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle EPM - Enterprise Data Management

This feature enables connecting to an Oracle EPM instance and building a complete managed data pipeline with that data.

See Load Data from Enterprise Performance Management into Fusion Data Intelligence (Preview).

  • On – Display the Oracle EPM - Enterprise Data Management option in the Create Connection dialog.
  • Off – Hide the Oracle EPM - Enterprise Data Management option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle EPM - Financial Close and Consolidation

This feature enables connecting to an Oracle EPM instance and building a complete managed data pipeline with that data.

See Load Data from Enterprise Performance Management into Fusion Data Intelligence (Preview).

  • On – Display the Oracle EPM - Financial Close and Consolidation option in the Create Connection dialog.
  • Off – Hide the Oracle EPM - Financial Close and Consolidation option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle EPM - Planning and Budgeting

This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data.

See Load Data from Enterprise Performance Management into Fusion Data Intelligence (Preview).

  • On – Display the Oracle EPM - Planning and Budgeting option in the Create Connection dialog.
  • Off – Hide the Oracle EPM - Planning and Budgeting option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle EPM - Profitability and Cost Management

This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data.

See Load Data from Enterprise Performance Management into Fusion Data Intelligence (Preview).

  • On – Display the Oracle EPM - Profitability and Cost Management option in the Create Connection dialog.
  • Off – Hide the Oracle EPM - Profitability and Cost Management option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle JD Edwards On-Prem

This feature enables connecting to the various data sources in the on-premises JD Edwards instance and building a complete managed data pipeline with that data.

See Load Data from On-premises JD Edwards into Fusion Data Intelligence (Preview).

  • On – Display the Oracle JD Edwards On-Prem option in the Create Connection dialog.
  • Off – Hide the Oracle JD Edwards On-Prem option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle JDBC

This feature enables the remote agent-managed connectivity to an Oracle database using JDBC. You can create up to five connections and they're denoted as Oracle JDBC 1, Oracle JDBC 2, Oracle JDBC 3, Oracle JDBC 4, and Oracle JDBC 5.

See Load Data from Oracle Database Using JDBC into Fusion Data Intelligence (Preview).

  • On – Display the Oracle JDBC option such as Oracle JDBC 1 in the Create Connection dialog.
  • Off – Hide the Oracle JDBC option such as Oracle JDBC 1 in the Create Connection dialog.

Default: Off

Restart Required: No

MongoDB

This feature enables connecting to a MongoDB instance to build a managed data pipeline with data from that instance.

See Load Data from Mongo Database into Fusion Data Intelligence (Preview).

  • On – Display the MongoDB option in the Create Connection dialog.
  • Off – Hide the MongoDB option in the Create Connection dialog.

Default: Off

Restart Required: No

MySQL Cloud

This feature enables connecting to a MySQL Cloud instance to build data augmentation with data from that instance.

See Load Data from MySQL Cloud Database into Fusion Data Intelligence (Preview).

  • On – Display the MySQL Cloud option in the Create Connection dialog.
  • Off – Hide the MySQL Cloud option in the Create Connection dialog.

Default: Off

Restart Required: No

MySQL On-Prem

This feature enables connecting to a MySQL on-premises instance to build data augmentation with data from that instance.

See Load Data from On-premises MySQL Database into Fusion Data Intelligence (Preview).

  • On – Display the MySQL On-Prem option in the Create Connection dialog.
  • Off – Hide the MySQL On-Prem option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle PeopleSoft On-Prem - Campus Solutions

This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data.

See Load Data from On-premises PeopleSoft into Fusion Data Intelligence (Preview).

  • On – Display the Oracle PeopleSoft On-Prem - Campus Solutions option in the Create Connection dialog.
  • Off – Hide the Oracle PeopleSoft On-Prem - Campus Solutions option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle PeopleSoft On-Prem - Financials

This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data.

See Load Data from On-premises PeopleSoft into Fusion Data Intelligence (Preview).

  • On – Display the Oracle PeopleSoft On-Prem - Financials option in the Create Connection dialog.
  • Off – Hide the Oracle PeopleSoft On-Prem - Financials option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle PeopleSoft On-Prem - Human Resources

This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data.

See Load Data from On-premises PeopleSoft into Fusion Data Intelligence (Preview).

  • On – Display the Oracle PeopleSoft On-Prem - Human Resources option in the Create Connection dialog.
  • Off – Hide the Oracle PeopleSoft On-Prem - Human Resources option in the Create Connection dialog.

Default: Off

Restart Required: No

Oracle PeopleSoft On-Prem - Learning Management

This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data.

See Load Data from On-premises PeopleSoft into Fusion Data Intelligence (Preview).

  • On – Display the Oracle PeopleSoft On-Prem - Learning Management option in the Create Connection dialog.
  • Off – Hide the Oracle PeopleSoft On-Prem - Learning Management option in the Create Connection dialog.

Default: Off

Restart Required: No

QuickBooks Online

This feature enables connecting to a QuickBooks Online instance to create augmentations using data from that instance.

See Load Data from QuickBooks Online into Oracle Fusion Data Intelligence (Preview).

  • On – Display the QuickBooks Online option in the Create Connection dialog.
  • Off – Hide the QuickBooks Online option in the Create Connection dialog.

Default: Off

Restart Required: No

Remote Agent

The Remote Agent application helps bring data from on-premises applications like E-Business Suite and JD Edwards into Oracle Fusion Data Intelligence.

See Set up the Remote Agent to Load Data into Fusion Data Intelligence (Preview).

  • On – Display the Remote Agent option in the Create Connection dialog.
  • Off – Hide the Remote Agent option in the Create Connection dialog.

Default: Off

Restart Required: No

SFTP

This feature enables connecting to a Secure FTP source and building a complete managed data pipeline with that data.

See Load Data from a Secure FTP Source into Fusion Data Intelligence (Preview).

  • On – Display the SFTP option in the Create Connection dialog.
  • Off – Hide the SFTP option in the Create Connection dialog.

Default: Off

Restart Required: No

Shopify

This feature enables connecting to a Shopify instance and building a complete managed data pipeline with that data.

See Load Data from Shopify into Fusion Data Intelligence (Preview).

  • On – Display the Shopify option in the Create Connection dialog.
  • Off – Hide the Shopify option in the Create Connection dialog.

Default: Off

Restart Required: No

Snowflake

This feature enables connecting to a Snowflake instance and creating augmentations using that data.

See Load Data from Snowflake into Oracle Fusion Data Intelligence (Preview).

  • On – Display the Snowflake option in the Create Connection dialog.
  • Off – Hide the Snowflake option in the Create Connection dialog.

Default: Off

Restart Required: No

SQL Server This feature enables connecting to the SQL Server instance to create augmentations using data from that instance.

See Load Data from SQL Server into Oracle Fusion Data Intelligence (Preview).

  • On – Display the SQL Server option in the Create Connection dialog.
  • Off – Hide the SQL Server option in the Create Connection dialog.

Default: Off

Restart Required: No

Taleo

This feature enables connecting to a Taleo instance and creating augmentations using that data.

See Load Data from Taleo into Fusion Data Intelligence (Preview).

  • On – Display the Taleo option in the Create Connection dialog.
  • Off – Hide the Taleo option in the Create Connection dialog.

Default: Off

Restart Required: No

Preview features are disabled by default but administrators can enable them for use. See Make Preview Features Available.

Data Connectors Available By Default
Feature Description
Google Analytics

This feature enables connecting to a Google Analytics instance and building a complete managed data pipeline with that data.

See Load Data from Google Analytics into Fusion Data Intelligence.

Oracle Object Storage Service

This managed pipeline connects to Oracle Object Storage to ingest datasets into Oracle Fusion Data Intelligence followed by data augmentation.

See Load Data from Oracle Object Storage into Fusion Data Intelligence.

Salesforce REST

This feature enables an administrator to connect to a Salesforce SaaS source and build a complete managed data pipeline with that data.

See Load Data from Salesforce into Fusion Data Intelligence.