Microsoft SQL Server

You can connect Oracle Analytics to a Microsoft SQL Server database.

Supported Versions

2014, 2016, 2017, 2019

Prerequisites

In Microsoft SQL Server, set up a named connection using static port allocation. Dynamic port allocation isn't supported.

Connectivity

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

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

Other Connectivity Information

• Supports incremental refresh for datasets based on this database type. See Configure a Dataset to Load Incrementally.

Useful Documentation Links

• Create a Connection to a Data Source
• Manage Connections to Data Sources
• Manage Connections Using REST APIs