Alteryx Designer Ideas

Share your Designer 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

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.

49 Comments
Glennv
5 - Atom

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.

melissa_m
7 - Meteor

Hi, we need DB2 In-DB  in Alteryx!

Q_Ball
7 - Meteor

Another one for this 

We need DB2 In-DB  in Alteryx!

pbeeram
6 - Meteoroid

Please make this happen!

pdxsvrider
7 - Meteor

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

kenny101
5 - Atom

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"

pxs132
7 - Meteor

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!

tfrendo
5 - Atom

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.
TimN
8 - Asteroid

We need this too, Alteryx!