How to query Eloqua ODBC table?

Question

Hi Guys,

I was able to connect to Eloqua ODBC using CData ODBC Driver and I can see the tables. However when I tried to use SQL querying out the fields I want. I ran into following error message:

Here is my SQL code:

select top 10 *
from CData.OracleEloqua.Activity_EmailSend

And here is how I connect to Eloqua ODBC using CData driver.

Any of your suggestion will be appreciated!

Thank you!

Mary

Jerod · Accepted Answer

Hi Mary,

This like an issue specifically with the CData ODBC Driver (full disclosure, my employer). Your best option here will be to reach out to our Support Team (https://www.cdata.com/support/submit.aspx). I'll try to track the conversation on my end and post whatever solution they provide (for the benefit of others). Unless you post it first!

Jerod