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

6
●
Defining Data Objects
●
●
●
●
●
89
objects can reference the same database using a connection to the database
system.
Enterprise Database Objects
The following sections describe how to connect to database objects for the
enterprise database connectors.
Oracle Call Interface (OCI) Data Objects
The Oracle Call Interface (OCI) allows you to connect to database objects
from an Oracle server. The OCI Data Object Definition dialog box allows
you to create, modify, or delete FactoryTalk Transaction Manager data
objects. When you create a data object, you must enter a valid connection for
the Oracle OCI server.
FactoryTalk Transaction Manager can communicate with a local or remote
Oracle database via the Oracle network of client tools such as SQL*NET,
Net8, or Oracle Net Services.
You can install SQL*NET/Net8 on the same computer that contains the enterprise
connector and communicate with remote Oracle databases running on any operating
system supported by Oracle.
Microsoft SQL Server Data Objects
The Microsoft OLE DB connector service allows you to connect to database
objects from Microsoft SQL Server 2000, Microsoft SQL Server 2005, and
Microsoft SQL Server 2008 R2. You can browse a Microsoft SQL Server
2000, SQL Server 2005, or SQL Server 2008 R2 database without entering a
DSN.
ODBC Data Objects
The ODBC connector service allows you to connect to database objects
using any ODBC 2.0 or later-compliant server. You must use a valid system