connecting to DB2 from .net core application deployed in azure app services

Question

Hi all,

I have one .net core web api which we will deploy on azure app services.
this web api will connect DB2 database for accessing data, is there any package/service we need to enable in azure app services for accessing DB2 or Nuget package for DB2 is enough

Answer 1

@azure architect with .net expereince , We were awaiting for your response. Adding to sadomovalex 's response (as clearly pointed this out- thank you)

As mentioned in this IBM docs – “The IBM.Data.DB.Provider is available as a NuGet package. For more information see: .NET Provider for Cloud. This package is supported on Azure App Services (Windows Web Apps for Full .NET Framework).”

On App Service, at runtime, connection strings are available as environment variables, prefixed with the following connection types:

SQLServer: SQLCONNSTR_
Custom: CUSTOMCONNSTR_ [ in your case]

-Just sharing as additional info || using Azure Logic Apps service to access IBM DB2.

Access and manage IBM DB2 resources by using Azure Logic Apps

• "The DB2 connector includes a Microsoft client that communicates with remote DB2 servers across a TCP/IP network.
  You can use this connector for accessing cloud databases such as IBM DB2 for Windows running in Azure virtualization. You can also access on-premises DB2 databases after you install and set up the on-premises data gateway."

---
To benefit the community find the right answers, please do mark the post which was helpful by clicking on ‘Accept Answer’ & ‘Up-Vote’.

Answer 2

Hi. @azure architect with .net expereince

Where are you hosting DB2?

If you have a private Azure Virtual Machine, you'll need to enable the App Service's VNET integration feature and connect to your VNET resources. (Not required if public access is available)

Alternatively, if you are hosting DB2 on your on-premises server, you should have a hybrid configuration.