Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

Connecting Qlikview to snowflake datawarehouse

Hi All,

Could you please suggest how to connect QlikView with a snowflake data warehouse.

Is there any connector available for this.

Is Qlik supports the connectivity for this?

Please suggest.

 

Thanks,

Kishor.

 

3 Replies
marcus_sommer

Qlik could connect to the database (either with standard odbc/oledb or any custom driver) which host your datawarehouse and then you could pull all tables with all fields and all records - one after another and/or you used any queries which pull certain data from any tables. For everything you will need to use sql-statements like you would apply directly in the database.

Most often it's not very sensible to pull all data and it's quite likely that it needs multiple adjustments (renaming from fields and de-normalizing the data - not everything is a must but it's recommended to consider it) to create an useful datamodel in Qlik.

Therefore, yes it's possible to get all needed data from the datawarehouse but it might not so easy as you hoped for.

- Marcus

Brett_Bleess
Former Employee
Former Employee

Kishor, see the following Help link:

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Snowfl...

You may need to go back up a level to get the details on the package for QlikView.

Here is that link, likely want to start with this one and then use the other one etc.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Introd...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
BinayKumarSah
Contributor III
Contributor III

Thanks for explanation.