Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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