Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Add Microsoft Azure SQL Data Warehouse Connector

Delivered
133
Views
5
Comments
Benjamin Arnulf-Oracle
Benjamin Arnulf-Oracle Admin
in Oracle Analytics Cloud and Server Idea Lab

Description

Add Microsoft Azure SQL Data Warehouse Connector

Use Case and Business Need

Add Microsoft Azure SQL Data Warehouse Connector

Original Idea Number: 0b97b07545

Tagged:
5
5 votes

Delivered · Last Updated

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    Existing SQL Server connector is compatible with Azure SQL Server. 

  • vkm
    vkm Rank 5 - Community Champion

    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
    Gabby Rubin-Oracle Admin

    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
    RamC Rank 1 - Community Starter

    We are moving our warehouse on SQL server to Synapse.

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    Coming soon. I Will update once out.