Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generic ODBC connection to Data Virtuality is return blank tables

lynnliu1026
5 - Atom

Does anyone have experience using Generic ODBC connector and/or Data Virtuality? I am trying to figure out why I am getting blanks in the data tables. I can see and query the data fields in Data Virtuality. Thanks. 

2 REPLIES 2
BrandonB
Alteryx
Alteryx

Data Virtuality and its generic ODBC connector aren't officially supported sources which may explain why the driver isn't rendering the table views properly. 

 

It does look like they have an API available which would be another option if you are having issues pulling data with the ODBC driver: https://support.datavirtuality.com/hc/en-us/community/posts/115011850046-New-feature-REST-API-Pagina...

lynnliu1026
5 - Atom

I found the solution to this. Instead of using Unicode Driver, I switched to System DSN (image attached). This resolved the issue. I can now pull data from DV. 

Labels