Loading MDF File

[prateekrastogi]

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!

[DanM · Accepted solution]

@prateekrastogi at this time, Alteryx does not support MDF files. 

[xwang2018]

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.