Rockwell Automation FactoryTalk Historian Classic User Guide - Manual (Page 24)

Chapter 3 Collecting FactoryTalk Historian Classic Data
The FactoryTalk Transaction Manager interfaces with the database
via an enterprise connector. An enterprise connector is a Windows
service that receives data from the FactoryTalk Transaction
Manager and logs it to a database.
The following are the types of enterprise connectors that you can
use:
Item Description
ODBC The ODBC enterprise database connector allows you to interface
with virtually any ODBC-compliant database including Microsoft
Access, Microsoft SQL Server 6.5 or later, IBM DB2 or Sybase.
Oracle OCI The Oracle Call Interface (OCI) enterprise database connector allows
you to connect to database objects from an Oracle server. If you are
using Oracle OCI, you need to install locally SQL*NET 2.3x or later,
Net8, or Oracle Net services (all from Oracle). You can then connect
to an Oracle database versions 9i through 11g.
Microsoft OLE DB The Microsoft OLE DB enterprise database connector should only be
used for interfacing with Microsoft SQL Server. Microsoft OLE DB
allows you to browse an SQL Server database without a data source
name (DSN) and is the preferred method of connection.
Microsoft COM+ The Microsoft COM+ enterprise application connector allows you to
interface with Microsoft COM+ application components. These
components must be integrated into a Windows 2000 COM+
environment. RSBizWare-only applications do not support this
connector. It is for use only with FactoryTalk Transaction Manager
Professional installations.
FactoryTalk
Metrics
The FactoryTalk Metrics enterprise application connector is used
only with FactoryTalk Metrics. The connector stores data in the
RSBizWare database.
SAP The SAP enterprise application connector allows you to interface
with SAP R/3 systems modules. RSBizWare-only applications do not
support this connector. It is for use only with FactoryTalk
Transaction Manager Professional installations.
Enterprise Connectors
24 Rockwell Automation Publication HIST-UM001K-EN-E-June 2014