Data source overview

Installing the
FactoryTalk® Batch
 Server and Client software configures the Data Source name (DSN) and creates the ODBC Connect String.
FactoryTalk Event Archiver
 uses the Connect String to locate the database.
Once created, the Connect String is stored in the
Database connection string
 property in the
Batch Reporting
 tab of the
FactoryTalk Batch Services Properties
. This property is configured in the
FactoryTalk® Administration Console
. This Data Source name serves as an alias for the database.
After installation, configure
FactoryTalk Administration Console
 for Incremental Archiving or End of Batch Archiving. To enable an archiving method for a new server, add the server in
FactoryTalk Administration Console
Explorer
. To add a new server, right-click an application or area where you want to add a server to archive and select
Add New Server
FactoryTalk Batch Server
. Then, right-click the new server or an existing server, and select
Properties
. Select the
Incremental Archiving
 or
End of Batch Archiving
 option in the
FactoryTalk Batch Services Properties
dialog by selecting the
Batch Reporting
 tab and then
Archive method
 from the dropdown list.
Make sure to configure user accounts according to the following:
  • If using
    Incremental Archiving
    , make sure the user account assigned to the
    FactoryTalk Event Archiver
     service has login access to SQL Server and has permission to insert data into the BHBATCHHIS table.
  • If using
    End of Batch Archiving
    , make sure the user account assigned to the
    FactoryTalk Batch
     Server has access to the BatchHistoryEx database on the SQL Server and has permission to insert and execute data into the BHBATCHHIS table.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal