How to open a Microsoft SQL Server Compact Express database file (SDF file) in the TIBCO Spotfire Installed client – Revvity Signals

Date Posted: 2018-05-22
Product: TIBCO Spotfire®

Problem:

How to open a Microsoft SQL Server Compact Express database file (SDF file) in the TIBCO Spotfire Installed client

Solution:

This article will explain how to open a Microsoft SQL Server Compact Express SDF database file in the TIBCO Spotfire Installed client using an OleDb driver.
1) The OleDb provider sqlceoledbxx.dll must be installed on the machine where the TIBCO Spotfire installed client is installed. For that make sure you have Microsoft SQL Server Compact installed on your machine. This installer has the OleDb data provider sqlceoledbxx.dll.

Microsoft SQL Server Compact 4.0 can be installed from here:

https://www.microsoft.com/en-us/download/details.aspx?id=17876

2) Once Microsoft SQL Server Compact is successfully installed, in the TIBCO Spotfire Installed client navigate to File > Add Data tables > Other-> Database > Oledb Data Provider, click the "Configure..." button and enter the connection string. For example:

Provider=Microsoft.SQLSERVER.CE.OLEDB.X.X;Data Source=path-to-sdf-file;

Make the required changes per your configuration. For example:

Update the "X.X" in the example string above to match the installed version. If Microsoft SQL Server Compact 4.0 is installed, then the Provider would be "Microsoft.SQLSERVER.CE.OLEDB.4.0".
Update the Data Source value to point to your SDF database file, like: Data Source=C:\Users\username\Documents\myData.sdf or Data Source=\\myshare\myfolder\myData.sdf

Resulting in:

Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=C:\Users\username\Documents\myData.sdf;

If the SDF requires a password for access, the connection string can be modified as follows:

Provider=Microsoft.SQLSERVER.CE.OLEDB.X.X;Data Source=path-to-sdf-file;SSCE:Database Password=sdf-file-password;Persist Security Info=True;

Note: Only the OleDb supported data types can be imported.

For this to work in the TIBCO Spotfire Web Player, ensure the path used is accessible from the TIBCO Spotfire installed client machines and the Node Manager machine. It is recommended to use UNC paths like:

Data Source=\\myshare\myfolder\myData.sdf

The OleDb provider from Step 1 above must also be installed on the Node Manager machine as well. External: Microsoft SQL Server Compact 4.0

https://www.microsoft.com/en-us/download/details.aspx?id=17876