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.
5,373 questions
Additional connection properties for the ODBC Oracle Wire Protocol driver
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pmscorca
1,052
Reputation points
Hi, for an ADF pipeline, when I use an Oracle connector for a linked service I could specify an additional connection property. Which are the possible connection properties for the ODBC Oracle Wire Protocol driver? Thanks
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator2024-02-29T22:29:53.22+00:00 Hello @pmscorca , Thanks for the using Microsoft Q&A .
At the time you can get all the connectors details supported by ADF here : https://learn.microsoft.com/en-us/azure/data-factory/connector-odbc?tabs=data-factory We do see ODBC and few Oracle connectors but not the ODBC oracle connector. I do not have an instance to test it.Thanks
Himanshu -
pmscorca 1,052 Reputation points
2024-02-29T23:43:24.7966667+00:00 Hi, the Oracle connector is based on an ODBC driver
So, I repeat my question: which are the possible additional connection properties for the ODBC Oracle Wire Protocol driver? Thanks
Sign in to comment
Sign in to answer