Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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
kevinbird15
9 - Comet
‎12-07-2015 11:15 AM

I am pulling DB2 data into a workflow and I have a lot of joins that are slowing it down a lot.  For the SQL stuff I am doing, I can use in-db to fix this issue, but with DB2, in-db is not yet supported so the joins take a lot of time to all be pulled together.  I also think that just focusing on the in-DB tools in general would be a good thing.  These tools really can be game changers when it comes to large datasets.  

JCR
Alteryx Alumni (Retired)
‎12-30-2015 10:27 AM
Status changed to: Not Planned

At this time we haven't planned to support DB2 as we focus more on analytic databases such as Netezza. Please keep the feedback coming as we regularly revisit our priorities.

 

Thanks
JC

0 Likes
kevinbird15
9 - Comet
‎12-30-2015 11:56 AM

I would be interested in knowing how many people use Netezza vs how many people use DB2.  Do you guys collect that kind of information on the regular input tool?  

0 Likes
AT_Eadens
5 - Atom
‎04-25-2016 11:50 AM

 JCR, does this mean Netezza is supported within In-DB? I ask because I've not been able to get it to connect.

0 Likes
Atabarezz
13 - Pulsar
‎08-13-2016 01:40 PM

http://db-engines.com/en/system/DB2%3BNetezza%3BOracle

Nice link here, DB2 seems a little old school. No R support etc... But obviously very popular in enterprises...

0 Likes
davidh
5 - Atom
‎10-10-2016 07:15 PM
I would find this feature useful as well.
0 Likes
rdalley
6 - Meteoroid
‎10-27-2016 06:38 AM

This lack of native DB2 support in Alteryx seems to be a product management blind spot for Alteryx.  There is a tremendous amount of ongoing legacy data within large corporate DB2 databases.  These databases are not going away anytime soon. frenemy Tableau gets this.  If not good old DB2, perhaps Alteryx will add support for IBM DB2 BLU?

0 Likes
Falreign
6 - Meteoroid
‎11-03-2016 09:49 AM

DB2 BLU is getting headway in the corporate environment. Don't miss this one Alteryx!

0 Likes
Falreign
6 - Meteoroid
‎11-03-2016 09:50 AM

Companies need this!

0 Likes
ndp427
5 - Atom
‎11-11-2016 05:23 AM
Having this capability is critical to our decision to use Alteryx in our Dist Ntwk maintenance processes.
0 Likes
Labels