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,871 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
987
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
{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,476 Reputation points Microsoft Employee2024-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 987 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