nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Add Microsoft Azure SQL Data Warehouse Connector

Benjamin Arnulf-Oracle

Description

Add Microsoft Azure SQL Data Warehouse Connector

Use Case and Business Need

Add Microsoft Azure SQL Data Warehouse Connector

Original Idea Number: 0b97b07545

Find more posts tagged with

Delivered

Data Connectivity

Data Modelling and Datasets

Status: Delivered

Comments

Gabby Rubin-Oracle

Existing SQL Server connector is compatible with Azure SQL Server.

vkm

can you please point me to a place where I can find the details of how to implement Azure SQL database connection in OAC?

Thanks,

Vaishali

Gabby Rubin-Oracle

The SQL Server connector in OAC works with Azure SQL Server database. However, I change the idea to 'Planned' as I'm not sure if you refer to Azure SQL Server or Azure Synapse. When it comes to Synapse, the move from Azure SQL DW to Synapse some connectivity settings had changed which are not accounted for by the OAC SQL Server connector. Due to that we are working on a Synapse specific connector. Note that RPD access will probably work as you will have access to parameters which are not exposed via the DV connector UI.

RamC

We are moving our warehouse on SQL server to Synapse.

Gabby Rubin-Oracle

Coming soon. I Will update once out.

Top Leaders

Tarik Branković 45

User_IG5IB 32

Michal Zima 32

Siva Pratap Nellipudi-Oracle 29

SantoshChandrasekaran 18

Top Ideas

Increasing Report Results limit from 5000 to the full report results data set
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Provide proactive notification of bug fixes/patches that change API response behavior, before deploy
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
Granular permission for Session and Query Logs (Manage Sessions) independent of BI Service Administr
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
OAS Certified Data Source (DB2) Enhancement Request
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
MCP restriction/ tool restrictions to OAC user groups
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.