topic Load data from locally saved .mdf file in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-locally-saved-mdf-file/m-p/1255073#M2519 <HTML><HEAD></HEAD><BODY><P>Hello again, guys. </P><P></P><P>I have access to a .mdf-file locally on my computer and I would like to import data from it. Can someone please guide me through this? </P><P></P><P>Cheers</P><P></P><P>//Nathalie</P></BODY></HTML> Mon, 16 Jan 2017 13:02:51 GMT 2017-01-16T13:02:51Z Load data from locally saved .mdf file https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-locally-saved-mdf-file/m-p/1255073#M2519 <HTML><HEAD></HEAD><BODY><P>Hello again, guys. </P><P></P><P>I have access to a .mdf-file locally on my computer and I would like to import data from it. Can someone please guide me through this? </P><P></P><P>Cheers</P><P></P><P>//Nathalie</P></BODY></HTML> Mon, 16 Jan 2017 13:02:51 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-locally-saved-mdf-file/m-p/1255073#M2519 2017-01-16T13:02:51Z Re: Load data from locally saved .mdf file https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-locally-saved-mdf-file/m-p/1255074#M2520 <HTML><HEAD></HEAD><BODY><P>I would suggest to create a File DSN on your Qlik Sense Server using compatible SQL Server driver:</P><P><IMG __jive_id="150142" alt="Screen Shot 2017-01-19 at 3.46.22 PM.png" class="jive-image image-1" src="/legacyfs/online/150142_Screen Shot 2017-01-19 at 3.46.22 PM.png" style="height: 448px; width: 620px;" /></P><P>Than create a QS Connector based on this File DSN.</P><P></P><P>This should give you an option to add data via Script Editor or Data Manager.</P><P></P><P>Regards,</P><P>Vlad</P></BODY></HTML> Thu, 19 Jan 2017 21:49:10 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-locally-saved-mdf-file/m-p/1255074#M2520 vlad_komarov 2017-01-19T21:49:10Z Re: Load data from locally saved .mdf file https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-locally-saved-mdf-file/m-p/1255075#M2521 <HTML><HEAD></HEAD><BODY><P>You have to install SQL server client and mount that MDF file. Then you can create DSN out of that. </P></BODY></HTML> Sat, 28 Jan 2017 01:04:14 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Load-data-from-locally-saved-mdf-file/m-p/1255075#M2521 Anonymous 2017-01-28T01:04:14Z