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

In Database for MySQL

Status: Implemented Submitted by on ‎06-15-2017 09:14 AM
6 Comments (6 New)

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

See more ideas labeled with:
6 Comments
Atabarezz
13 - Pulsar
‎06-18-2017 10:40 AM

+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

 

 

 

0 Likes
ARich
Alteryx Alumni (Retired)
‎12-07-2017 02:37 PM
Status changed to: Accepted

Hi All,

 

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

 

Best,

Alex

0 Likes
ARich
Alteryx Alumni (Retired)
‎01-10-2018 01:15 PM
Status changed to: Under Review
 
0 Likes
ARich
Alteryx Alumni (Retired)
‎07-10-2018 04:26 PM
Status changed to: Implemented

This was released in 18.2

0 Likes
PeterGoldey
11 - Bolide
‎07-30-2018 06:35 AM

Awesome!!!

0 Likes
Cedric
8 - Asteroid
‎12-06-2022 09:49 AM

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?

0 Likes
Labels