Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

In Database for MySQL

Not sure what detail needs to be added.  This is obviously a widely used RDBMS.

6 Comments
Atabarezz
13 - Pulsar

+1

Good point, MySQL ranks second more popular than MS SQL Server..

Looking forward for In-db addition, basic queries can already be prepped as push through and

there already is an R package for accessing Mysql from R...  https://www.r-bloggers.com/accessing-mysql-through-r/

 

Picture1.png

 

 Ref: https://db-engines.com/en/ranking

 

 

 

ARich
Alteryx Alumni (Retired)
Status changed to: Accepted

Hi All,

 

Thanks for the feedback. We're hoping to get this in H1 next year.

 

Best,

Alex

ARich
Alteryx Alumni (Retired)
Status changed to: Under Review
 
ARich
Alteryx Alumni (Retired)
Status changed to: Implemented

This was released in 18.2

PeterGoldey
11 - Bolide

Awesome!!!

Cedric
8 - Asteroid

So, I have found that there is INDB support for MySQL, and I'm attempting to use it, but I'm plagued with syntax errors if I use any INDB tool other than a SELECT. Sample tools, formula... everything I've tried on a very simple connection all result in a syntax error. 

I'm using a native MySQL 8 driver (that I got on Alteryx's driver site (which I think directed me to mySQL directly)); I also have a version using the Simba driver. Either way, I get the same error: 
"Error: Connect In-DB (11): Error SQLPrepare: [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.12]No database selected" I see this error in a INDB Browse tool.

Of course I have tested using the browser with a normal input tool; that works fine. I have also tested the query in a SQL window--that works fine too (nut it is a different driver, unfortunately). 

That mysqld-5.7.12 makes me itchy--is it looking for a MySQL 5 driver?

Does anyone know why I can't use INDB functionality within MySQL?