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

Top Ideas

Allow us to delete unwanted NSAW pages and watchlists
Right now, OAC offers pre-built pages and watchlists related to NSAW. At our University, we do not need these pages, and we want to delete them entirely. We've been told in response to our SR that all we can do is keep "Access" limited to only the default admin and sysAdmin roles. This prevents regular users from seeing…
Include a "Show Where Used" option on Workbook objects
It would be nice to have a way to right click on an object (subject Area, Column, Calculation, etc.) in the Data Panel and show where that object is referenced in a workbook = canvas, visualization, filter, calculation, data action, etc.) In Workbooks with multiple canvases and multiple subject areas, we are left to hover…
Promote a folder, a single workbook, or multiple workbooks between Oracle Analytics Cloud instances
We want to automate the workbook export to .dva file and import this into another OAC instance using REST API, The goal is an OCI DevOps pipeline that can promote (a) a whole folder, (b) a single workbook, or (c) several workbooks in one run to another OAC instance, and print a status result at the end. Blocker: Export and…
Save AI-detected anomalies and insights as a reportable dataset
When Oracle Analytics AI features find an anomaly, trend or key driver, let authors save those results as a dataset or subject area. Each run would add rows with the metric, the date found, the expected versus actual value, the severity, the main drivers and the filters applied. Authors could then build workbooks, schedule…
Custom snapshot : disable catalog content
We use the snapshot to update AppRoles members. But we would like to disable catalog content to have smaller snapshots and create snapshots faster.