Connect to a .SQL file
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
NJ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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…
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just to be clear, I have completed the following steps:
I have downloaded and configured MySQL
In MySQL I have created a user "company@localhost"
then I created a database called "company"
Finally, I granted company@localhost full permissions for company.*
I then loaded the database by targeting the file < data.sql
This database contains various tables which I would now like to be able to access and join through Alteryx… This is where I'm stuck!
I'm sure it's very easy and I'm just being a dolt, so your patience gratefully appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you read @NicoleJohnson's advice with more attention you see we need to select 'all files' NOT 'all data files'. This is located at the bottom of the file list.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
Part time Tableau, Part Time Alteryx. Full Time Awesome
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much for having a crack at my question. Very much appreciated.
I'm not quite there, but I will continue to try and be sure to post a complete answer should I find one.
In the meantime, if anyone can stand on the shoulders' of these giants, very much appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Bingo! Your genius!
So I went back to the MySQL configuration and added the MySQL connector/ODBC
I then went to Alteryx and chose to add a new ODBC connection, specifying the server "localhost" with the user "company"
Hey presto, I have access to all the tables in the data!
Consider this issue solved. Hopefully others will find it useful.
Many thanks to all,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @jonathanogrady Haha! I just got there myself! Glad I could help :::::::) I'd appreciate an accepted solution when you get a moment.
Part time Tableau, Part Time Alteryx. Full Time Awesome
![](/skins/images/03E14B015E5210679CFB65D9FFC7B381/responsive_peak/images/icon_anonymous_message.png)