Could someone help show me how to connect to an SQL Server Compact 4.0 .sdf file in Qlik Sense Enterprise. I've attached some sample data, in the case it is an issue with the file.
- i haven't been able to use the connect32 script because qlik sense is requiring me to use lib connect, and we're not able to change to legacy mode. "CONNECTs other than LIB CONNECT are not available in this script mode."
- I think i need to connect via one of the OLE DB, but in the list of OLE DB connections, i can't find one for SQL Compact 4.0 (is there a way to install a specific new OLE DB connector in Qlik Sense for Comapct 4.0
-I have tried to connect via SQL 2008 R2 and SQL 2012, and use the file source as a data source; however i haven't been able to get 2008 R2 to work with compact 4.0 files (compact 3.5 files seem to work just fine). - even after installing sql compact 4.0 data connections. SQL Server 2012 doesn't support compact sdf files.
-or, is there a particular ODBC connector I can install so that Qlik Sense can link to that?
the above are options i've tried and failed at, if someone is successful with the sdf file attached, could you please let me know how you got it to work in Qlik Sense Enterprise.
though they look helpful they only seem to be for compact 3.0 and 3.5, whereas my data is compact 4.0. plus I have to use a qlik sense library connection (so I have to use one of the in built qlik ole dB connectors, or install an old dB connector for compact 4.0 that will be picked up in qlik sense (So far I haven’t been able to find one that works, the Microsoft sql compact 4.0 from this link Download Microsoft SQL Server Compact 4.0 from Official Microsoft Download Center doesn’t seem to add any functionality to qlik sense.
if anyone has used a sdf compact 4.0 file, or can download the attached data in the top post here and tell me how you got it to work that would be fantastic