topic Re: Extracting data from Salesforce - Customized tables in QlikView

Extracting data from Salesforce - Customized tables

daniel_f — Thu, 27 Dec 2012 09:53:17 GMT

hi all,

Can someone advise if there is any guide that can i find the tables names of the salesforce to let the QV connect and extract data?

I mean to customazed tables in salesforce.

I've downloaded the template model which include some tabs like 'case' leads' opportunities' etc but i can't see and dont know the tables names where the customized fields in salesforce store the data.

Thanks in advance,

Daniel

Re: Extracting data from Salesforce - Customized tables

chrisbrain — Thu, 27 Dec 2012 11:31:44 GMT

You might be interested to take a quick look at our Saleforce Connector:

http://www.qvsource.com/wiki/Salesforce-Connector-for-QlikView.ashx?HL=salesforce http://www.qvsource.com/wiki/Salesforce-Connector-for-QlikView.ashx

Where we have instructions on how to construct any SOQL query or SOSL search.

If you lke I could take a look at it with you in the new year to check you can access your custom tables and other data you need.

Re: Extracting data from Salesforce - Customized tables

daniel_f — Thu, 27 Dec 2012 11:47:22 GMT

Thank you Chris,

I already saw it but it's don't like a Qlikview connector,

apparently I'm not familiar with this connector.

Is this the place to download the above connector ?:

Re: Extracting data from Salesforce - Customized tables

chrisbrain — Thu, 27 Dec 2012 11:59:44 GMT

If you go to our main website:

http://www.qvsource.com/

And click the 'Sign Up Now' button at the bottom you should receive an email with a free trial with all of our (many) Connectors including Salesforce.

Re: Extracting data from Salesforce - Customized tables

daniel_f — Thu, 27 Dec 2012 12:24:06 GMT

Why "free trial" ?

It's not a QV integrally free connector?

Re: Extracting data from Salesforce - Customized tables

chrisbrain — Thu, 27 Dec 2012 12:28:35 GMT

No it's not free, it's a commercial supported and actively developed product.

Re: Extracting data from Salesforce - Customized tables

daniel_f — Thu, 27 Dec 2012 12:31:06 GMT

Ok, i'll check the profitability of this connector

Chris, thank very much for the guidance

Re: Extracting data from Salesforce - Customized tables

chrisbrain — Thu, 27 Dec 2012 12:32:28 GMT

My pleasure - I just wanted to make sure you knew it was an option. And as I say I can offer to spend some time on a screen share with you if you like to make sure it allows you to get the data you need.