You can translate the question and the replies:

Is Denodo TO Azure Data Factory possible?

Is it possible for Azure Data Factory to connect to Denodo **after** Denodo has materialzed or virtualized a view? If yes, what are the connection details to accomplish that?
user
09-03-2022 10:26:03 -0500
code

1 Answer

Hi, I believe that you need to connect to the Denodo Platform from Azure Data Factory. If so, you could use the Linked Services Connection available in Azure Data Factory. As a prerequisite to connect Denodo from Azure Data Factory, you could create the [Self-hosted Integration Runtime machine](https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?tabs=data-factory) as described in the Microsoft Documentation and install the Denodo ODBC Driver.You could also refer to the Knowledge Base article to create [DSN configuration for ODBC connections to VDP](https://community.denodo.com/kb/en/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP). After successful configuration of the Integration Runtime machine, you can create a Linked Service to connect Denodo over the ODBC driver installed in the Integration Runtime machine. Make sure the ODBC connection string for the linked server is as below: ``` DRIVER={DenodoODBC Unicode(x64)};DATABASE=<DATABASE_NAME>;SERVER=<SERVER_NAME>;PORT=<PORT_NO>; ``` You can refer to the following Microsoft Document [Create a linked service to an ODBC data store using UI](https://docs.microsoft.com/en-us/azure/data-factory/connector-odbc?tabs=data-factory#create-a-linked-service-to-an-odbc-data-store-using-ui) for detailed information. Hope this helps!
Denodo Team
11-03-2022 06:28:54 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here