Qlik Community

QlikView Connectors

Not applicable

Salesforce.com Connector Issue with Case Object?

Hello friends -

I just downloaded and installed the QV Salesforce.com connector for QV10. For most things I've tried so far, it works great. I've even made some dashboards out of opportunity and account data. Revealed some helpful stuff right away. But I cannot make it extract case data. Here is the error text I'm bumping into:

SQL##f - SqlState: 37000, ErrorCode: 10179, ErrorMsg: [QlikTech][ODBC QlikView SalesForce Connector driver][Salesforce SQL]Syntax error in SQL statement. syntax error line 2 at or after token <Case>.[10179]
SQL SELECT *
FROM Salesforce.Case

My guess is that Somewhere it thinks that 'case' is a reserved word here. However, I'm just trying to extract help desk type data from SFDC.

Has anyone bumped into this before? Can you help?

Eric Carlson

Sioux Falls, SD USA

1 Solution

Accepted Solutions
stephen-a_redmo
Valued Contributor II

Salesforce.com Connector Issue with Case Object?

Hi Eric,

You are correct, "Case" is a reserved word for SQL. Just means you need to employ some square brackets or double-quotes:



Case:
SQL SELECT * FROM "Case";




2 Replies
stephen-a_redmo
Valued Contributor II

Salesforce.com Connector Issue with Case Object?

Hi Eric,

You are correct, "Case" is a reserved word for SQL. Just means you need to employ some square brackets or double-quotes:



Case:
SQL SELECT * FROM "Case";




Not applicable

Salesforce.com Connector Issue with Case Object?

Thank you Stephen, that worked perfectly!

Community Browser