Connecting from Oracle Analytics Cloud to Azure hosted SQL database. What driver is underneath ODBC, JDBC, ADO.Net ?

MOHAMMED, MUSHTAQ SIDDIQUE 0 Reputation points
2023-05-02T21:15:45.2966667+00:00

Good Afternoon,

We are connecting from Oracle Analytic cloud (OAC) BI reporting platform to Azure hosted SQL database.

OAC provides Azure Synapse Analytics connection type and we are able to connect successfully.

But, i am curious to understand what connection driver is used internally?

ODBC, JDBC , SQL Connection, ADO.Net ... ?

Appreciate if someone could kindly provide some insight.

Thank you

Mushtaq

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,565 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,311 Reputation points Microsoft Employee
    2023-05-03T07:04:45.2+00:00

    Hi MOHAMMED, MUSHTAQ SIDDIQUE,

    Thank you for posting query in Microsoft Q&A Platform.

    It depends on your OAC instance configuration settings for synapse you used I believe. If OAC synapse connection type does not expose configuration details underneath then kindly consider reaching OAC support team to understand more about the Synapse connection type and how it developed behind scenes under OAC.

    Kindy consider checking with your system administrators as well.

    Hope this helps. Please let me know if any further queries.


    Please consider hitting Accept Answer button. Accepted answers help community as well.