In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

ODBC Database Connection through VPN pulls table with empty text fields

Schero
5 - Atom

Hello,

 

i try to access data from a database. I am working from home with a vpn connection.

I can actually pull data, and i also see some number/date values. However, all the text fields are replaced with a single whitespace character.

This behavior doesn't occur when using the same workflow in the office without vpn. There i can see the text fields normally.

 

I can also see the text fields, When using an excel file to fetch the same query. (also using vpn)

 

I selected generic connection > ODBC > and choosed the DNS connection (Driver: Adaptive Server Enterprise) stored in my ODBC administration sources.

1 REPLY 1
TimN
13 - Pulsar

Total guess but could be some sort of data redaction in place for PII.  I would check with your Database Administrator. 

 

Good Luck,

Tim

Labels
Top Solution Authors