There are numerous tools on the net which will help you to access a MS SQL CE database.
Even PowerShell can do the job, but it is not the same as have a full blown BI Reporting Tool under you fingertips.
So let’s look at QlikView to be able to access the .sdf database.
I used the Northwind.sdf example database
When creating a new report you need to select the data source for a Compact Ed. Database.
But as you can see it it not available in the list
Just type in the connection string yourself like this.
OLEDB CONNECT32 TO [Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=”C:\Northwind.sdf”];
and complete with the SQL statement
SQL SELECT * FROM Customers;
SQL SELECT [Order ID],LOWER(Freight) as Freight, [Customer ID] FROM Orders;
Refresh and you are done.
PS: If it does not work make sure you have installed the MS SQL CE framework in your PC.