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

JeffK 61

Top Ideas

Oracle Analytics Server (OAS) Roadmap for LLM-Based AI and Conversational Assistant Features
Does Oracle have any plans to introduce LLM-based AI features in a future release of Oracle Analytics Server (OAS) on-Premises? In particular, is there a roadmap for bringing capabilities such as the Oracle Analytics AI Assistant or an LLM-powered conversational chatbot, currently available in Oracle Analytics Cloud, to…
Support Attribute-Driven X-Axis and Custom Formula-Based Endpoints in Native OAC Waterfall Charts
Summary of the Enhancement We request two key enhancements to the native Waterfall visualization in OAC Workbooks to support standard financial bridge reporting: Attribute-Driven Category Axis: Allow standard categorical attributes (with custom sorting) directly on the X-axis, removing the current dependency on Date/Time…
Enable API based/programmatic application role creation and configuration in OAC
Currently in OAC, although we can create application roles in the OCI application (e.g Service Administrator), there is no way to programmatically create and configure custom application roles in OAC itself. This has to be done via the console system settings manually in OAC. We are running a large scale OAS > OAC…
Enhancement request for OAC dataset storage management under the 250GB limit
Currently, in Oracle Analytics Cloud (OAC), there is a 250GB storage limit for datasets, but there are no practical management features to operate within this limit. This makes day‑to‑day operations very inconvenient.I would like to request the following enhancements for dataset storage management: Configurable storage…
SQL Passthrough (?) option for manual query datasets
I'm not very technical so if this is a non-starter or there's a solid workaround that already exists, please advise. We have users that query SQL data sources directly in other tools, but then would like to bring that query as a dataset to OAS. Ideally they could create the view in the database and reference that object…