Instruction Manual

Table of Contents
Tuning the Oracle database for FactoryTalk Historian Classic
265
Improving the performance of your RSBizWare Oracle
database 265
Preparing to run the Oracle database ........................................ 267
Appendix C
Benefits of using the data compression ............................................... 269
How the data compression works ........................................................ 270
Compression ratio .................................................................................... 271
Viewing compressed data ........................................................................ 271
Preparing the SQL Server uncompress view ................................. 272
Querying the SQL Server uncompress view ................................. 273
Data compression considerations ......................................................... 274
Appendix D
Setting the real-time clock in a ControlLogix processor using
FactoryTalk Transaction Manager ...................................................... 278
In the processor ................................................................................... 279
In the database ..................................................................................... 279
In FactoryTalk Transaction Manager ............................................ 281
Getting date/time information from a ControlLogix processor to a
database ....................................................................................................... 281
In RSLogix 5000.................................................................................. 281
In FactoryTalk Transaction Manager ............................................ 282
Special considerations for a distributed Microsoft COM+
application .................................................................................................. 283
Enabling network COM+ access for COM+ connectors in
FactoryTalk Transaction Manager ...................................................... 284
Configuring the Oracle 10g Instant Client for FactoryTalk
Transaction Manager .............................................................................. 284
Configuring FactoryTalk Transaction Manager Connectivity to
SQL Server using Windows authentication ...................................... 285
Configuring the SQL Server authentication ................................ 285
Configuring the Windows-only authentication .......................... 286
Configuring FactoryTalk Transaction Manager for connections
with SQL Server .................................................................................. 287
Data compression
Application notes for
FactoryTalk Transaction
Manager
8 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014