ORACLE Connectivity Suite - August 2008
 The Software Toolbox TOP Server OPC Server now contains a unique analysis plug-in specifically designed for ORACLE customers.
Is your business demanding higher throughput, intelligent scheduling, reduced inventories and information automation to reduce errors and enhance productivity?
If so, then this can only be accomplished by connecting your manufacturing automation systems with enterprise business systems.
The new ORACLE plug-ins fulfill this purpose. ORACLE business and operations management solutions can be connected, in real
-time, with equipment and operations on the plant floor, by leveraging the TOPServer's suite of communication products combined
with analytic and connectivity tools tailored for ORACLE business solution products. These products include the Oracle MES
(Manufacturing Execution System) and the ORACLE MOC (Manufacturing Operation Center).
Software Toolbox offers several products and options that can be combined to offer the exact solution you need today, while
delivering a scalable architecture to meet future requirements. The foundation for the Oracle Connectivity Suite is TOP Server, providing over 130 manufacturing protocols (Drivers).
TOP Server works on both Workstation and Server Operating Systems from Microsoft, including NT 4, 2000, XP, Vista and Server 2003.
KEY FEATURES:
- Connectivity to 1,000s of Devices with over 130 existing protocol drivers:
- Data Aggregation
- Data Analytics
- Basic RDB Connectivity
- Oracle MES Connectivity
ORACLE MOC Connectivity to plant floor data, that abstracts the user from all the details – protocol, data addresses, scaling etc.
needed to acquire the result. Tags deliver real-time performance data right from the machine to your application.
Raw Data is NOT Information
Your machines may not deliver all the data you need for proper operations assessment. Variables such as Cycle Time, Maximum
Temperature, Downtime Reasons etc. may not exist, yet are essential for operations analysis. For this reason, the TOP Server solution offers an option called Advanced Tags which deliver a variety of Analytics.
Advanced Tags deliver an array of mathematical and logical operators enabling the generation of new data, or the aggregation of
existing data into information suitable for higher level archival and analysis. Through Advanced Tags users can measure the
duration of operations, totalize events, perform averages over a group of sensors, set trigger conditions for data acquisition and
combine machine conditions to generate an overall machine state, valuable for future Analytics.
Advanced Tags are similar to I/O Tags. Advanced Tags enable you to create an expression, browsing from existing data tags, and
combining them with math and logic operators to generate a new result.
Building a Transaction for your higher level Analytics
Many MES, ERP or OPM solutions require their input data in the form of predefined Transactions of relevant information. For example, the result of a machine cycle might deliver a Machining Center ID, Part ID, Operator ID, Cycle Time, Number of Downtime Transitions
, Total Downtime, Machine Speed, Tool Life, etc. This array of data can be made up of a combination of values and logic states, all
bundled into one Transaction. While Advanced Tags deliver the mechanism to create the variables and events to define relevant data
, another mechanism must provide the function of transaction assembly. This is the function of the Complex Tag.
Complex Tags assemble the transaction for higher level systems by providing the definition of data to collect and the definition of
collection triggers for each value. Some values are simply a measurement, such as the count of parts generated during a run cycle.
Other values might be correct at a moment in time, such as the maximum pressure reached at a point in a press cycle. Complex
Tags define the details of the collection and a transaction. Complex Tags support the wide variety of collections that may exist for
your plant manufacturing environment and are the mechanism used to interface with the Manufacturing Operations Center.
Oracle Connection Options
Several mechanisms are available to share information with higher level systems. They include:
- Writing Transactions to a Relational Database Table
- Writing Data to the Oracle MES Transaction Table
- Writing Data to the Oracle MOC Transaction Table
Need to log the OPC Data? The new ORACLE connectivity suite provide the following:
- ORACLE MES Logging – Writing Data to the Oracle Manufacturing Execution System is accomplished via the ORACLE MES
(OMES) option for TOP Server. This option enables selected I/O or Advanced Tags to be written to the appropriate ORACLE MES Interface Table on either a time or event basis.
- ORACLE MOC Logging – Writing data to the ORACLE Manufacturing Operations Center is accomplished via the ORACLE
MOC (OMOC) option for TOP Server. This option enables Transactions of data, defined by a Complex Tag, to be written to the MOC Interface Table on a time or event basis.
How do you get started?
|
