Salesforce qlikview Best practices and Performance improvement

[gunjesh0310]

Hi,

I need Best practices for Qlikview Salesforce.How to improve performance for loading data from Salesforce to Qlikview.

Facing network issue or loading of data while loading data from salesforce to Qlikview.

Please help.

regards,

Gunjesh Joshi

[vishsaggi]

Do Select yourfieldnames or if less fields coming from table do a Select * from SalesForce tables and try to store them onto QVDs. Then load these QVDs using another qvw file and do transformations and create a model out of it. Then using Binary load this qvw file into a new qvw file and build your UI.

[gunjesh0310]

Thanks a lot Vishwarath Nagaraju...

if any documentation for Best Practices on Sales Force and QLikview that would be great.

How indexing on Salesforce will help in performance and How I can implement?

regards,

Gunjesh Joshi

[vishsaggi]

I am not that good at salesforce side. In general, any indexing to source database tables will always help in performance. I am not sure if there is any specific documentation on best practices, but if you can tell us what issues you are facing, we can try to help. As you know, using your salesforce connector you can connect to salesforce tables and pull information.