Data Sources Available for Use in Datasets

Learn which data sources you can use in datasets. You can use most data sources to create datasets that contain multiple tables.

Oracle Data Sources

You can use one of more of these Oracle data source connections to create a dataset containing multiple tables.
  • Oracle Analytics Local Subject Areas
  • Oracle Fusion Cloud Applications Suite (Use the Oracle Applications connection type)
  • Oracle Autonomous Data Warehouse
  • Oracle Autonomous Transaction Processing
  • Oracle Database
  • Oracle NetSuite
  • Oracle Service Cloud

Other Data Sources

You can use one or more of these data source connections to create a dataset containing multiple tables.
  • Amazon EMR
  • Amazon Redshift
  • Apache Hive
  • DB2
  • Dropbox
  • Files (XLSX, XLS, CSV, and TXT)
  • Google Drive
  • GreenPlum
  • HortonWorks Hive
  • IBM BigInsights Hive
  • Impala (Cloudera)
  • Informix
  • MapR Hive
  • Microsoft Azure SQL Database
  • MongoDB
  • Pivotal HD Hive
  • PostgreSQL
  • Salesforce
  • Snowflake
  • Spark
  • SQL Server
  • Sybase ASE
  • Sybase IQ
  • MySQL

Data Sources Not Available for Multiple Table Datasets

These data source connections aren't available to create or include in a dataset containing multiple tables.
  • Oracle Fusion Cloud Enterprise Performance Management (EPM)
  • Oracle Essbase
  • Google Analytics