Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview integration with Amazon Redshift

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

3 Replies
marcus_malinow
Specialist III
Specialist III

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

Not applicable
Author

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.

marcus_malinow
Specialist III
Specialist III

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