Loftware Connector for Oracle®: Link your
Oracle-based applications with your label
printing infrastructure.

The Loftware Connector for Oracle serves as a high-speed ‘connectivity bridge’ between Oracle-Based Applications and the Loftware Print Server®. As a part of the Loftware Enterprise Label Management Solution, it enables Business and Information Technology Managers to:

• Centralize control of the Oracle label printing function
• Easily integrate Oracle-Based Applications with the label printer infrastructure
• Improve label production throughput with no coding changes to the label originating Oracle-Based Application
• Ensure fast and reliable label production utilizing Loftware capabilities to support load dividing, automatic failover, and automatic notification of label printing failure
• Deliver increased labeling productivity without disrupting current business operations or retraining the existing end-users
• Offload the resource intensive task of creating and printing labels from business-critical Oracle-Based Applications to deliver better system performance
• Eliminate maintenance programming by keeping current with changing labeling business logic requirements by using menu-driven configuration tools

Enterprise Connectivity for Business-Critical Oracle Systems

The Loftware Connector for Oracle, working with the Loftware Print Server (or multiple Loftware Print Servers), sends the right label with the right data to the right printer at the right time. This combination enables Oracle-Based Applications to generate labels across large networks of printers and empowers companies to comply with current and future barcode label and RFID specifications.

High Throughput Label Production

The Loftware Connector for Oracle speeds the processing of label print requests via its ‘High Speed’ Queuing System to support label printing on a ‘large to massive’ scale — 100’s to 1000’s of printers.

Triggering Label Printing from Oracle-based Applications

Label print requests can be triggered via any defined Business Flow or Transaction within Oracle WMS or Oracle MSCA such as ‘Receipt’, ‘Ship Confirm’, ‘Pick Load’, etc. Label requests can also be triggered via stored procedures, database triggers, or a PL/SQL call from any Oracle-Based Application.

Intelligent Data Filtering and Decision-Making Tools

The Loftware Connector for Oracle includes Filters that address all of the special business logic associated with corporate marking systems without having to change Oracle-Based Applications through additional programming or customization. The basic function of a Filter is to find and add missing data to a request coming from a Label Print Request transaction. Filters makes it possible to:

• Get up and running in a shorter time frame
• Concentrate label output management and Business Logic in one place
• Remain flexible and readily adapt to changing business requirements
• Maintain Business Logic via configuration and not programming

From a single Label Print Request, the Loftware Connector for Oracle enables you to print multiple label formats, use multiple printer types, and automatically determine which label or labels to print and where to print them.

Integration With Oracle WMS and Oracle MSCA Reduces Time To Production

The Loftware Connector for Oracle installs directly into the Oracle Database (in its own schema) as a stored procedure through Oracle’s ‘Synchronous Mode’ application program interface (API). This integration is seamless with no programming effort required. The Loftware Connector for Oracle sets up all labels with associated data elements and target devices using the configuration program in Oracle WMS and Oracle MSCA. It also automatically updates the Oracle WMS label printing interface for printing via the Loftware Connector for Oracle (Oracle MSCA does not have a separate setup but uses Oracle WMS profiles for Label Print Mode).

Integration With Other Oracle-Based Applications

The Loftware Connector for Oracle is readily configurable to support any Oracle-Based Application. A setup routine creates all the required database objects in the Oracle database to operate and administer the Loftware Connector for Oracle in the PL/SQL environment. In addition, related files, sample code, and documentation are installed.

Configuring the Loftware Connector for Oracle is made easy through the Loftware Connector Console, a browser-based application that is installed separately and serves as the menu-driven interface to all of the Loftware Connector for Oracle settings.

Loftware also provides implementation services through its Professional Services Group.