topic Re: Sense to AWS connection in Connectivity & Data Prep

Sense to AWS connection

michaeldburt — Fri, 19 Feb 2016 19:42:30 GMT

Hi Everyone- I am trying to set up a new connection in Qlik Sense to a database being stored in SQL on AWS. I tried the standard OLE DB with no success. I've been trying to find a forum here, or on the AWS forums, that discusses this but I cannot find anything. Has anyone successfully done this and/or have any documentation on how to accomplish it? Thanks for any help!

Mike

Re: Sense to AWS connection

Michael_Tarallo — Fri, 19 Feb 2016 20:26:06 GMT

Hi Michael.

Do you know what errors you are getting?

I can only imagine it is a firewall security policy issue on AWS - I assume Qlik Sense and SQL ARE NOT on the same machine, I assume Qlik Sense is on 1 machine in your on premise environment and SQL is on AWS outside your environment, which would be the case. Do you have access to AWS console to check the inbound / outbound port rules on AWS?

I think starting there would be your best bet.

You may also need to configure your SQL Server on AWS to use TCP/IP and make sure Dynamic IP is not checked either, you do this in the network connection settings for the SQL Server.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Re: Sense to AWS connection

Michael_Tarallo — Fri, 19 Feb 2016 20:30:07 GMT

kha‌ - hey man (Karl) tapping into your AWS expertise for one of our fellow members. Can you validate my reply in regards to this situation? Sounds to me like firewall, inbound / outbound security port rules.

Mike

Re: Sense to AWS connection

michaeldburt — Fri, 19 Feb 2016 20:53:47 GMT

Thanks for the replies. I will take a look into this today and over the weekend to figure it out.

Re: Sense to AWS connection

Karl_Humma — Sat, 20 Feb 2016 18:36:56 GMT

This does sound like the appropriate ports in the aws security group attached to the instance hosting sql are not open. If the location of where qliksense is running has a static external ip then i'd recommend narrowing the scope of the security groups specific ports to that IP then you will not expose your database access publicly.

Hope this helps.

/karl

Re: Sense to AWS connection

michaeldburt — Mon, 22 Feb 2016 15:24:06 GMT

Karl-

What are al of the ports that need to be opened up for Sense to run properly?

MIke

Re: Sense to AWS connection

Karl_Humma — Mon, 22 Feb 2016 18:07:49 GMT

at the minimum :

443,4244,4248

for a complete list of ports used by Qlik Sense Server please refer to Ports overview ‒ Qlik Sense . Hope this helps.

/karl

Re: Sense to AWS connection

michaeldburt — Mon, 22 Feb 2016 19:24:51 GMT

Thanks for helping out. I was able to connect, after the server was added to the correct security group. on a side note, the only situation that gave me trouble was the AWS to AWS server connection.

Re: Sense to AWS connection

elifapa — Thu, 25 Nov 2021 10:27:15 GMT

Hello @michaeldburt, were you able to connect from QS with OLEDB?