Configure Data Source Connection – OLE DB


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.

  1. Select File > Add Data Tables and click Add > Database....

  2. In the Open Database dialog, click to select the OleDb Data Provider.

  3. Click Configure....

load_configure_data_source_oledb.png

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:

Opening Data from a Database

Details on Open Database