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
I found some old notes so here is the recipe to be able to create the right LIB connection.
With your ProductionStorage.sdf I was able to load 70 lines of data:
THE STEPS TO CREATE A CONNECTION:
First create a connection by selecting MS DataShape:
Then fill in the right connection string which is:
Give it an appropriate Name and press Create - DO NOT press Test connection or Load.
Then edit the connection again to correct the connection string which has been mangled when we saved it to include some additonal MS DataShape related stuff that needs to be removed...
Remove the first stuff of the connection string which says "Provider=MSDataShape;Data Source=" and leave the rest which should be the correct complete connection string. Save it again.
Then your'e good to go.
I tested it with the regular Qlik Sense Desktop but I see no reason why it shouldn't work on Qlik Sense Enterprise also.
The "Select Data" works also after having a working LIB Connection: