1. Connecting Oracle Analytics Cloud to Your Data
  2. Reference
  3. Data Sources and Data Types Reference
  4. List of Supported Databases in Oracle Analytics Cloud
  5. SQL Server

SQL Server

You can connect Oracle Analytics to a SQL Server database.

Supported Versions

2014, 2016, 2017, 2019

Prerequisites

In SQL Server, set up a named connection using static port allocation. Dynamic port allocation isn't supported for connecting Oracle Analytics to SQL Server.

Connectivity

Use Data Source With Support Connectivity Options Notes
Datasets Yes
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
 -
Semantic Modeler Yes
  • Standard
  • Remote Data Connectivity
  • System connection
 -
Model Administration Tool Yes
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • System connection
 -
Oracle Analytics Publisher Yes
  • Standard
 -

For more information about this connectivity table, see Key to Connectivity Table.

Other Connectivity Information

  • None.

Useful Documentation Links