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.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

ODBC returning only 100 Records

JonBlent
6 - Meteoroid
‎02-03-2021 12:20 AM

I have an OpenLink 64bt ODBC connection to as progress 83E database that only returns 100 records. If I use the same ODBC connection with an other application, all records are returned so it seems to be an issue with Alteryx only. Other ODBC connections to other sources that are run at the same time do not have any issues. There are not records limit set. Any help would be great. Thanks Jon

 

JonBlent_0-1612340053971.png

 

JonBlent_1-1612340108673.png

 

Labels:
Reply
0 Likes
1 REPLY 1
TrevorS
Alteryx Alumni (Retired)
‎02-05-2021 07:55 AM

Hello @JonBlent 

Upon looking on the Community, it looks like there is a way to connect.

This post has a discussion about the ODBC connection.

 

"It looks like you have to be Progress customer and login through their progress.com downloads portal. I believe that it was this driver: Progress® OpenEdge® ODBC Connector for Windows 32-bit

 

That we just configured as a Other>32-bit ODBC connection. Note the Visual Query Builder was not compatible but inputting SQL in the SQL Editor worked great."

Can you try to use the 32-bit connection and let me know if that helps?

Thanks!

 

Community Moderator
Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All