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

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

book

Article ID: KB0081870

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

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.
 

Issue/Introduction

This article will explain how to open a SDF file in Spotfire Installed client using OleDb

Resolution

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.

Additional Information

External: Microsoft SQL Server Compact 4.0
Powered by Wolken Software