Data Sources Supported for Semantic Models
Before you create or migrate a semantic model, it's important to understand which data sources are supported by Semantic Modeler and which are supported by Model Administration Tool.
For complete information about data connections and data sources, see Certification - Supported Data Sources.
Supported Data Sources
| Data Source/ Connection Type | Use in Semantic Modeler | Use in Model Administration Tool |
|---|---|---|
| Oracle Analytic Views | No | Yes |
| Oracle Autonomous Data Warehouse | Yes | Yes |
| Oracle Autonomous Transaction Processing | Yes | Yes |
| Oracle Database | Yes | Yes |
| Oracle Fusion Cloud Enterprise Performance Management (Oracle EPM Cloud) | Yes* | Yes* |
| Oracle Essbase | Yes | Yes |
| Oracle Hyperion Financial Management | No | Yes |
| Oracle Hyperion Planning | No | Yes |
| Amazon Redshift | Yes | Yes |
| Apache Hive | Yes | Yes |
| Apache Spark | Yes | Yes |
| Aster | No | Yes |
| Google BigQuery | Yes | Yes |
| Hortonworks Hive | Yes | Yes |
| IBM BigInsights Hive | Yes | No |
| IBM DB2 | Yes | Yes |
| Impala (Cloudera) | Yes | Yes |
| Informix | Yes | Yes |
| JDBC (Generic) | Yes** | No |
| MapR Hive | Yes | Yes |
| MongoDB | Yes | Yes |
| MySQL | Yes | Yes |
| MySQL Heatwave | Yes | Yes |
| Pivotal HD Hive | Yes | Yes |
| PostgreSQL | Yes | Yes |
| Snowflake | Yes | Yes |
| SQL Server | Yes | Yes |
| Sybase ASE | Yes | Yes |
| Sybase IQ | Yes | Yes |
| Teradata | Yes | Yes |
| Vertica | Yes | Yes |
* Oracle Analytics supports these Oracle EPM Cloud business processes: Financial Consolidation and Close, FreeForm, Planning and Planning Modules, Profitability and Cost Management, and Tax Reporting. Oracle Analytics doesn't support Account Reconciliation, Enterprise Data Management Cloud, and Narrative Reporting. Note that Oracle Analytics doesn't support Oracle EPM on premises applications.
** You can use Semantic Modeler with data sources that use a generic JDBC connection. Although the generic JDBC connection type is certified, Oracle can't guarantee to resolve issues with uncertified data sources that you connect to using the JDBC connection type. Make sure that you fully test data sources and database features before deployment to production.