Hi everyone, I’m Soumitra Dutta, an Oxford-based entrepreneur and photographer. Glad to be here! I’m running into some syntax issues while working with CData drivers and was hoping to get your advice.
Some of my queries are either throwing errors or not behaving as expected, especially when using things like JOINs, filters, or ORDER BY clauses.
Would really appreciate any suggestions or examples from your experience.
Regards
Soumitra Dutta
Hi
The SQL behavior you're seeing is mostly down to how CData's engine handles queries differently depending on what the underlying data source can actually do. When you submit a query, CData parses it and evaluates which parts can be pushed down to the source API directly, and which parts it needs to handle client-side.
If you're hitting a particular error or unexpected behavior, sharing the following will help us give you a precise answer:
- The exact SQL queries you're running
- The full error message
- The data source you're connecting to (e.g., Salesforce, MySQL, HubSpot)
Once I learn more on the above I will be happy to share a few examples with you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.