Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Hope all are doing good. I need a detailed information on Qlikview integration with Amazon Redshift. Please find the folloing options
Option 1) Qlikview resides on local server and connects to Amazon redshift over VPN over internet
Option 2) Qlikview is installed on Amazon servers and connects to Amazon Redshift on Amazon Cloud. The end users connect to Qlikview server using VPN over internet
I need a information on how both options can be achieved, what will be the performance and issues and challenges. Al so the effort required for this activity.
Please help me Friends. Its urgent.
Many Thanks in Advance.
Regards
Nirmal
Hi Marcus,
Thanks you for your valuable reply. I need detailed info about that. And also what will be the performance, issue and challenges. Al so effort required for this activity.
Hi Nirmal,
I have some experience of both scenarios, and they are both very simple to achieve.
Connecting to Redshift is pretty much the same as connecting to any other PostGreSQL database, it's just that the endpoint is in the cloud. It's worth noting that the ODBC driver for this isn't the latest version.
Marcus
Hi Marcus,
Thanks you for your valuable reply. I need detailed info about that. And also what will be the performance, issue and challenges. Al so effort required for this activity.
Hi Nirmal,
I've personally found performance to be pretty good. As with any other data loads keep your queries tight, maybe consider incremental loading, and you should have no real issues.
No real challenges either. Not too sure about initial set up of the VPN, but once this is out of the way, it works just the same as any other PostGreSQL environment.
Marcus