Connect to a .SQL file

Hello fellow Alteryx fans!

I was looking for some help to connect to a .SQL file please.

I have been provided with some data which users typically connect to installing MySQL and then generating a local database.

At the moment I have saved this .SQL file locally, but the Alteryx input connector does not seem able to "see it".

Perhaps I need to use the in database connection? However, when I look for a connection file it specifies .INDBC type and also cannot "see" my .SQL file.

My first time trying to make this sort of connection. I must be doing something stupid. Any guidance gratefully received!

Many thanks,

Jonathan

Database Connection

Accepted answers

LordNeilLord

Hey @jonathanogrady

If you have already loaded the data into your MySQL database then you need to connect to it via ODBC (rather than a flat file).

You will need to configure the ODBC first which you can do through the ODBC Admin (which appears when you choose ODBC from the "Other Databases" option in the input tool)

Create a new ODBC connection and then you should be able to connect to the data.

I tried to setup a local instant of MySQL but I didn't get very far...but there are lots of guides on how to connect (I think the server will just be localhost)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

All comments

NicoleJohnson

If you change your input tool to allow you to see all files (*.*), you should be able to see the .sql file and then you can bring in the data as a text delimited file. From that point, you can concatenate the data and feed it into a Dynamic Input tool to run your query. Does that point you in the right direction?

Cheers!

jonathanogrady

Thank you so much for taking the time to reply to my question.

Unfortunately, your solution does not help in this case. If I choose all data files, I can still not see the .SQL file.

I believe that this is because the .SQL file is not actually a file but is a package which contains various tables which need to be "constructed" into a database.

This is typically done in MySQL. I have completed this step, but I would now like to connect Alteryx to that local database, but I'm unsure how to proceed.

Very grateful for any other suggestions…

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703