Rockwell Automation FactoryTalk Transaction Manager User Guide - Manual (Page 67)

4
●
Understanding FactoryTalk Transaction Manager Services
●
●
●
●
●
67
ODBC
The ODBC enterprise database connector allows you to interface with
virtually any ODBC-compliant database including Microsoft Access,
Microsoft SQL Server 2000 or later, IBM DB2, and Sybase.
The ODBC enterprise connector requires a system data source name (DSN)
to connect to an ODBC data source. When you create an ODBC database
connection, you must enter a valid system DSN for the ODBC server. A
system DSN is available to all users and Microsoft Windows
2003/XP/Vista/2008 R2 services.
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 in FactoryTalk Transaction Manager, you need to install SQL*NET
2.3x or later, Net8, or Oracle Net services (all from Oracle) locally. You can
then connect to an Oracle database versions 9i through 11g.
Microsoft OLE DB
The Microsoft OLE DB enterprise database connector should be used only
for interfacing with Microsoft SQL Server 2008 R2, Microsoft SQL Server
2005 Standard (Service Pack 3) or Microsoft SQL Server 2000 (Service
Pack 4). The Microsoft OLE DB connector allows you to browse a
Microsoft SQL Server 2008 R2, 2005 or 2000 database without a DSN.
Enterprise Application Connectors
The enterprise application connector services (Microsoft COM+,
Time-series Data Compression, or FactoryTalk Metrics) manage
FactoryTalk Transaction Manager's interaction with the enterprise
application connectors (Microsoft COM+, Time-series Data Compression,
or FactoryTalk Metrics), and the Transaction Control Manager service or
FactoryTalk Transaction Manager service.