This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(73.60000000000001, 32%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Usually, if we want to connect to a Database (SAP, SQL, Oracle etc.) using python for example, we need to install drivers in our machines and make the connection. For example using pandas.read_sql
But a machine or a VM is a full environment with everything. Anything you need you can put there. Azure Function (as far as i know) is not a complete environment like a VM. So how to handle drivers (that need a installation on the machine/VM) in Azure Functions?
If i said anything wrong, please feel free to correct me and give me a class :)
@Anonymous Since these drivers are just packages, you can include them in the requirements.txt file for your project and publish it to azure.
If you need even more control over the environment in which your function runs, you could opt to use a custom container instead as well.
Hey, thanks for answering. But i still in doubt... Can you show or demonstrate an example of how a HANA driver would be in the requirements txt.?
@Anonymous Apologies for the delay here. Looks like the HANA Driver is called hdbcli on pypi.
Assuming you are using pip for installing packages, you can run the following to generate a requirements.txt file.
pip freeze > requirements.txt
If you are using the default deployment option, ensure this file is included in the package, which the remote build system should pick up and install.
In case the installation fails due to native dependencies though, then your only option would be to use a custom container.
![](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(233.6, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi i am trying the same from DataDirect 7.1 Driver and facing the same issue for C# .net Azure Function hosted on cloud, its working in local though. Any Solution found for this ?
Well im my case when i asked this question i needed a driver to connect to an Azure SQL database and execute some code there using Azure Function. And i didn't use Azure Function. First i changed to an Azure Automation Account, and them to Control-M. In my case there was other solutions. Did you try the solution proposed? I dont understand C#, but i think there should be a "requirements.txt" for C#. You can try to migrate your C# Function to an Automation Account maybe, i think it is easier to manage. And lastly, use a VM xD