Possible to connect to private SQL Server database?

Niels2 · September 21, 2023, 10:10am

Hi!

Our SQL server database is currently public. However, we will change this to a private network.

Is it still possible with QuickSight to get the data from a Private SQL Server database?

Trying to create a VPC group through Redshift (New analysis) but for the Connection type I can only select ’ Public Network’

Hope you could help me on this.
Many thanks!

Kind regards,
Niels

debapc · September 21, 2023, 3:13pm

Hi @Niels2 - Amazon QuickSight Enterprise edition is fully integrated with the Amazon VPC service. By creating a VPC connection in QuickSight, you’re adding elastic network interfaces in your VPC. These network interfaces allow QuickSight to exchange network traffic with a network instance within your VPC.

Here are few links for your reference:

Configuring the VPC connection in Amazon QuickSight
Post on how to create a private connection from Amazon QuickSight to an Amazon Redshift cluster or an Amazon RDS DB instance that’s in a private subnet
Supported VPC data sources

Let us know if this is helpful. Thanks!

debapc · September 25, 2023, 4:07pm

Hi @Niels2 - Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

Niels2 · September 26, 2023, 9:39am

Hi!

I think this will work.
Will let you if this did not work out.

Kind regards,
Niels