How to query Eloqua ODBC table?

[marlline141]

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 solution]

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

[marlline141]

@Jerod 

Thank you so much for your suggestion Jerod! I have already emailed CData team.