How to connect to DB2 instance in Amazon Web Service (AWS)

[Balkrishnan]

What is the best practice to connect DB2 hosted in AWS Cloud

[v-frfei-msft]

Hi @Balkrishnan,

In Power BI Desktop, you can use Amazon Redshift connector to connect to the instance.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-redshift

Regards,

Frank

[Balkrishnan]

Can we install Gateway in AWS - VPC (Virtual Private Cloud) and connect to DB2.

[v-frfei-msft]

Hi @Balkrishnan,

Based on my research, the gateway could not be installed on cloud-computing platform. Actually, you can install and configure gateway on any other machines that have access to the data source. But gateway should be installed on a physical machine.

Regards,

Frank

[v-frfei-msft]

Hi @Balkrishnan ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[v-frfei-msft · Accepted solution]

Hi @Balkrishnan ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,

Frank