OLEDB Provider Overview

This manual is intended for those who analyze Historian™ data and prepare reports with data retrieved from the Historian product archive.

This manual provides descriptions of all the tables and columns in the Historian OLE DB provider and specific operating procedures for performing common tasks.

OLEDB is the primary tool to access and move data within applications, and provides support for non-Excel based reporting such as Seagate® Crystal Reports™. The Historian OLE DB provider is a data access mechanism that allows Historian data to be directly queried using Structured Query Language (SQL) statements.

This manual assumes that you are familiar with the Historian product, standard SQL-92 conventions, and relational database concepts, such as table, column, and row structures.

The Historian OLE DB provider is a data access mechanism that allows you to query Historian product data using Structured Query Language (SQL) statements or other client reporting tools.

The Historian OLE DB provider gives regulated industries the ability to create reports using applications such as Seagate® Crystal Reports™. It also allows current Historian product users to integrate with other databases such as SQL Server, and other third party OLE DB-compliant applications.

The OLE DB provider has read-only access. You cannot insert, update, or delete data in archives using the OLE DB provider.

OLE DB is a collection of standard COM-based interfaces defined by Microsoft that abstract standard SQL commands into native API access for any data source. OLE DB adds tremendous value to the Historian product by providing simple access to data from within the SQL environment, without the need for complex scripting.

For more detailed information on the Microsoft® OLE DB 2.0 Provider, refer to Microsoft's web site:

http://www.microsoft.com/data/oledb/prodinfo.htm