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:
Select File > Add Data Tables and click Add > Database....
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. |
Allow
saving credentials |
Select this option to allow saving of your credentials. |
See also: