Note: It is recommended to use a data connection or an information link to retrieve your data rather than the data provider access described below, if possible.
An OLE DB data provider allows native access to data, such as an SQL Server or an Oracle database. Using an OLE DB data provider, Spotfire can retrieve data from a wide variety of data sources, not just relational databases. The connection string provided should specify the OLE DB driver that is designed to work with your data.
The following providers are included with the Microsoft data access components:
Microsoft Jet 3.51 OLE DB Provider
OLE DB Provider for Oracle
OLE DB Provider for SQL Server
OLE DB Provider for ODBC Drivers
Note: For more information about OLE DB providers, see the OLE DB Programmer's Reference. This documentation is available in the Microsoft Data Access SDK. For more information about advanced initialization properties, see the documentation provided with your OLE DB provider.
To reach the Configure Data Source Connection dialog:
On the authoring bar, click Files and data .
In the Files and data flyout, click Other. and then click Load Data with ODBC, OLE DB, or ADO.NET data provider.
In the Open Database dialog, click to select the OleDb Data Provider.
Click Configure....
Option |
Description |
Connection
string |
Should provide information about which OLE DB driver to use, which data source to connect to, etc. The connection string would normally be acquired from your database administrator. |
Save
credentials in analysis |
Select this option to save your credentials (username and password) in the analysis file. Caution: When this is option is enabled, username and password are stored unencrypted in the analysis file. Anyone with access to the file can obtain the credentials. |