SOLVED
Loading MDF File
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
prateekrastogi
5 - Atom
‎04-14-2017
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is it possible to load MDF file and update it using Alteryx? I thought I found a way as seen in attached file but it didn't work. Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Database Connection
2 REPLIES 2
Alteryx Community Team
‎04-14-2017
01:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@prateekrastogi at this time, Alteryx does not support MDF files.
xwang2018
5 - Atom
‎09-23-2020
05:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What I did with the latest version of 2020.2:
(1) move the MDF file and the accompanying log file to my SQL "DATA" folder
C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS2014\MSSQL\DATA
(2) open my SSMS and attach that MDF file as a new database.
(3) Once it is attached and shows up under my list of SQL databases, I can then use Alteryx Input (Quick Connect from SQL Server) to bring the embedded data table into Alteryx.
