Hi Team,
I’m facing an issue when using the Input Data tool with an ODBC connection.
When I run my SQL query directly in Rapid SQL, it returns full data correctly — including alphanumeric fields (e.g., issueId, productName, etc.).
However, when I connect using Alteryx → Input Data → ODBC, the same columns only show numeric values. Any character / string values appear as blank or null.
What I’ve tried so far:
- Changed field type in Alteryx to V_String → still the same.
- Explicit CAST to varchar in the SQL query → still only numeric values appear.
- Verified ODBC driver settings → all look correct.
- Confirmed that the exact same query returns full alphanumeric data in Rapid SQL.
- Verified schema names, column names, and permissions.
Still, Alteryx reads only numbers and drops the characters.
Environment details:
- Tool: Alteryx Designer
- Connection: ODBC (Sybase ASE)
- Issue: Character fields load as blank / only numeric characters appear
- The workflow used to work earlier — this issue started recently
Request:
Could you please help me understand why Alteryx is not picking up character values over ODBC, even though the database shows them correctly?
Is this related to driver encoding, field metadata, or an Alteryx ODBC limitation?
Any guidance on what to check or fix would be really helpful.
Thanks in advance!
