Mike Bevan
My name is Mike Bevan. Bevan Engineering was founded in 2004 to provide highly specialized controls and software solutions for manufacturing facilities and OEMs. Many clients - including Fortune 500 companies -  have been using Bevan Engineering  products and services world-wide. I  have been providing controls and software engineering solutions throughout the Miami Valley, Ohio area for over 30 years. 
mike@bevanengineering.com
937-974-0335
Rockwell Systems
Overview
Rockwell's Factory Talk Transaction Manager (FTTM) based PLC database integration is a very robust method to exchange data between your PLC equipment and database server systems while using "off the shelf" products. Furthermore, the skills necessary to implement this type of solution are typically found in-house.

Database information is stored on one to many database servers. Using some unique identifier (usually, a bar code scan), a database transaction is requested. Via the FTTM system, data from the database server is transferred to the PLC. Once operation is complete, information is written back to the database server (if required).

Factory Talk Transaction Manager
Factory Talk Transaction Manager is a Rockwell product used to exchange data with a PLC. This system was formerly called RSSQL or "Rascal". Tags/addresses in PLC equipment are "bound" to FTTM transactions. By triggering these transactions via the PLC program, data can be exchanged between the processor and database without the need of an intermediate computer.

Stored procedures are created in the database with each stored procedure's parameters (both input and output) bound to a tag/address in a PLC. The Factory Talk Transaction Manager is used to bind stored procedure values to PLC registers.

Database
An SQL server database is required for storing data. Bevan Engineering can design this database and all it's associated tables for you. Once it's time to implement your project, your IT department can receive a copy of this database in it's detached form and attach it to your existing system. Alternately, scripts can be provided. Because I was out of manufacturing for several years, I worked as a C++ database programmer for a controlled access security company. I gained expert level skills in relational database design that includes indexes, foreign key contraints, stored procedures, etc.

If data from your existing server system is required, a stored procedure can be provided that will allow that access. This type of support is typically found in-house and minimizes the amount of access required from your administrators.

PLC
Bevan Engineering can modify any existing PLC logic to accommodate information received from your database systems. Conversely, if you choose to have your internal resources perform this portion of the project, FTTM transaction control logic will be provided with a very detailed design spec.

If this is a new process or you choose to replace an older PLC to something more robust and modern, a new PLC program can be written with the transaction handling logic included.

Overview
PC based PLC database integration is a fast, affordable, and very flexible design to exchange data between your PLC equipment and database server systems.

Database information is stored on one to many database servers. An application program called an "interface" is created that will facilitate communication between the database server and PLC. Using some unique identifier (usually, a bar code scan), a database transaction is requested. Data from the database server is transferred to the PLC. Once operation is complete, information is written back to the database server (if required).
PC (Personal Computer)
The computers normally used with this design are usually more robust industrial computers that use a touchscreen. Typically, these types of computers are panel mount devices that reside on the face of an enclosure. However, any computer can be used that fulfills any hardware minimum requirements.

In some cases, one PC and application interface can accommodate more than one PLC. The ability to use this design is determined on a case by case basis. However, this is normally not recommended due to performance and serviceability issues, but in some cases, this may be an adequate design.
Database
A SQL server database is required for storing data. Bevan Engineering can design this database and all it's associated tables for you. Once it's time to implement your project, your IT department can receive a copy of this database in it's detached form and attach it to your existing system.

If data from your existing server system is required, a stored procedure can be provided that will allow that access. This type of support is typically found in-house and minimizes the amount of access required from your administrators.
Database Interface Application
A software application is written (usually in VB.NET) that communicates with both the database server and PLC. All connections require an ethernet connection. If the PLC is not network capable, a NET-ENI device can convert the PLC's serial port to an ethernet port. In some instances, a PLC's serial port can be used directly, but this method is not recommended.

The design of an interface application is almost the same (from a structural standpoint) for any application. First, a unique identifier is required for any production process. Usually, this is a bar code label. This bar code label can contain serial numbers, models numbers, or any other type of information that would allow information to be found in the database.

Once data is received from the database system, it is transferred to the PLC. The application interface will wait for the the process to be complete (pass, fail, abort, etc). Once the process is complete, information is written back to the database server. The amount of data received or transmitted is virtually unlimited. Once this information is in the database, the data can be used for a multitude of reasons - production statistics, error proofing, etc.
PLC
Bevan Engineering can modify any existing PLC logic to accommodate information received from your database systems. Conversely, if you choose to have your internal resources perform this portion of the project, they will be provided with a very detailed design spec stating specifically what needs to happen. "Hooks" will be provided (areas in memory data will be written to and read from) so development and debug activities can be performed in parallel.

If this is a new process or you choose to replace an older PLC to something more robust and modern, a new PLC program can be provided to you.