Rockwell Automation FactoryTalk Historian Classic for Batch User Guide - Manual (Page 3)

Table of Contents
Chapter 1
Features And Benefits .................................................................................. 7
Types Of Users ............................................................................................... 8
Where Can I Go for Help? ......................................................................... 8
Chapter 2
Initializing the RSBizWare Database On Oracle 9i ............................ 12
Initializing the RSBizWare Database On SQL Server ....................... 15
Migrating Batch History Data From an Oracle 8i Database To
Oracle 9i ........................................................................................................ 17
Migrating Batch History Data From SQL Server ............................... 18
Updating the Database GMT Offset Value .......................................... 21
Instructions for Daylight Savings Time (SQL Server Only) ....... 21
Manually Updating the GMT Offset Value .................................... 22
Creating a Data Source For FactoryTalk Historian for Batch ......... 22
Updating the Database Connection String ..................................... 23
Verifying the Database Connection String ...................................... 23
Batch Archiver Event Filters ..................................................................... 23
FactoryTalk Batch Event Filters ......................................................... 24
FactoryTalk Batch Material Manager Event Filters ...................... 24
Batch Reporting Values For Optimum Performance (SQL Server
Only) .............................................................................................................. 24
Recommendations for Optimum Data Access ............................... 25
Using FactoryTalk Historian for Batch in a Multiple Batch Server
Environment ................................................................................................ 26
Initializing Ranges For CreateIDs ..................................................... 26
Using Incremental Archiving .............................................................. 26
Establishing Incremental Ranges ........................................................ 26
Event Filter Recommendations For Multiple Batch Server
Environments .......................................................................................... 27
Chapter 3
FactoryTalk Historian for Batch Architecture .................................... 29
FactoryTalk Historian for Batch Tables and Fields ............................ 30
Sample Data ............................................................................................ 30
BHBatchHis Table ................................................................................ 31
Welcome to FactoryTalk
Historian for Batch
Configuring FactoryTalk
Historian for Batch
Collecting Batch Data
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 3