The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.
community Alteryx IO Alteryx.com
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
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

IBM DB2 in-Database availability

Status: Under Review Submitted by on ‎10-05-2016 06:48 AM
49 Comments (49 New)

Please include IBM DB2 as an in-Database option. Currently, my primary use of Alteryx is for copying DB2 tables into Teradata for use on that server. Copying large tables and particularly joining several tables and copying the results to Teradata is too slow in Alteryx.

See more ideas labeled with:
49 Comments
Glennv
5 - Atom
‎10-02-2018 05:06 PM

We have over 100 users in our organization using DB2 and at least a third of them are running queries that are taking hours to run.  We would greatly benefit from this.

0 Likes
melissa_m
8 - Asteroid
‎05-22-2019 10:28 AM

Hi, we need DB2 In-DB  in Alteryx!

0 Likes
Q_Ball
7 - Meteor
‎10-15-2019 12:22 AM

Another one for this 

We need DB2 In-DB  in Alteryx!

0 Likes
pbeeram
6 - Meteoroid
‎12-09-2019 08:44 AM

Please make this happen!

0 Likes
pdxsvrider
7 - Meteor
‎07-23-2020 03:19 PM

Yes please.  We need DB2 and/or DB2 BLU in database support.  As stated before, DB2 is in heavy use at many large companies.

0 Likes
kenny101
5 - Atom
‎08-18-2020 12:57 AM

We need DB2 In-DB  in Alteryx

 

IBM db2 is an enterprise grade database - for both OLAP and OLTP. This is definitely needed in atleryx to make it more "enterprise-ready"

0 Likes
pxs132
7 - Meteor
‎09-14-2020 02:07 PM

Now IBM Netezza approaches its end of support, many of Netezza users will migrate to DB2. More than ever we need IBM DB2 in-database option in Alteryx!

0 Likes
tfrendo
6 - Meteoroid
‎10-20-2020 05:20 AM

IBM DB2 In-Database Support please on Server. It works in Designer but not on Server/Gallery. I have raised a separate idea link here... 

https://community.alteryx.com/t5/Alteryx-Server-Ideas/iSeries-In-DB-SQL-Statement/idc-p/650545#M2209

 

The main problem appears to be a semi-colon being added to the SQL which is then rejected by the iSeries with the following error:

 

 
Executing PreSQL: "DELETE FROM "library"."filename";" : [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token ; was not valid. Valid tokens: <END-OF-STATEMENT>.[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL7973 - SQL create package for ALTERYAFJA in QGPL has failed.
0 Likes
TimN
13 - Pulsar
‎04-09-2021 10:17 AM

We need this too, Alteryx!

0 Likes
Labels