community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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
Comet

I found something calles SILQ on Syncsort web site.

Alteryx Partner

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

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

Alteryx Certified Partner
Alteryx Certified Partner

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.

Alteryx
Alteryx
Status changed to: Not Planned

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