Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
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.

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

reverse engineering existing SQL code and transform it in alteryx widgets and workflows

Could you please assess the idea of reverse engineering existing SQL code (in special inside DataWarehouse's code, thousands of LOCs filled with SELECT and JOINS) and replace it with Alteryx widgets?

Doing this will accelerate penetration rate of Alteryx products in large companies and dismantle IBM Cognos and their cousins.

5 Comments
Cristian
9 - Comet

I found something calles SILQ on Syncsort web site.

Atabarezz
13 - Pulsar

It's a visionary idea indeed...

Probably there needs to be a parser just acts like NLP API's and

translate the SQL code to alteryx workflow xml file... Probably this is itself doable as an Alteryx workflow Robot Indifferent

Cristian
9 - Comet

I found this commercial sql parser

http://www.semdesigns.com/Products/FrontEnds/PLSQLFrontEnd.html?Home=FrontEnd

 

Alteryx could purchase the rights to use that tool and incorporate it in current products.

 

Regards,

Cristian

adrianloong
11 - Bolide

Definately would be a game changer given a lot of big corporates have thousands of lines of legacy SQL code which is not documented. The business case for Alteryx could broaden to regulatory complaince which is easier to justify.

ARich
Alteryx Alumni (Retired)
Status changed to: Not Planned

We're not planning on implementing this, but thanks for the interesting idea!