Product: TIBCO Spotfire®
How to open a Microsoft SQL Server Compact Express database file (SDF file) in the TIBCO Spotfire Installed client
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:
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
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