Configurable Connector Interface for Enterprise Information System Integration

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional approaches lack a suitable framework for integrating various Enterprise Information Systems with application servers, leading to significant time and resource requirements due to non-standard vendor-specific architectures and varying database driver interfaces, making it costly to connect application servers with different information systems, especially when integrating with web-based applications.

Innovation Solution

Implementing a configurable connector interface, specifically a Resource Adaptor packaged as a Generic Resource Adaptor Archive (GRAR) file compliant with JDBC architecture, which can be modified to fit specific interfaces, allowing for a standardized connection between application servers and information systems through a Customized Resource Adaptor Archive (CRAR) file, facilitated by a GUI deployment tool.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If non-standard vendor-specific architectures are used to connect application servers to information systems, then connectivity can be achieved, but integration time and resources increase significantly

Engineering Contradiction:
ImproveconnectivityVSAvoidintegration time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent introduces a universal connector interface that can connect application servers to multiple different information systems through a single standardized interface. This connector acts as an intermediary that adapts to various vendor-specific interfaces while maintaining a consistent interface to the application server, thereby reducing integration time and resources while ensuring reliable connectivity across different systems

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If vendor-specific interfaces are used for each information system, then system-specific requirements are met, but device complexity and integration cost increase

Engineering Contradiction:
Improvesystem compatibilityVSAvoidinterface complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent introduces a connector interface as an intermediary component between the application server and various information systems. This mediator handles the complexity of vendor-specific interfaces internally while presenting a standardized interface to the application server, thereby maintaining system compatibility without increasing visible complexity or integration cost

Inventive Principle:
Principle #24Intermediary (Mediator)

3Adaptability or versatility

If custom database drivers are developed for each database, then database-specific functionality is achieved, but manufacturing precision and consistency decrease

Engineering Contradiction:
Improvedatabase compatibilityVSAvoidinterface consistency
Core Design Contradiction:
Adaptability or versatilityVSManufacturing precision

Solution Approach 1:

The connector interface provides a universal connection mechanism that works with multiple different database drivers through a standardized interface. This ensures consistent behavior and interface patterns across different database connections while maintaining the ability to adapt to database-specific requirements, thereby improving interface consistency without sacrificing database compatibility

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS8266326B2Frameworks for integrating information systems
Publication Date: 2012.09.11 ORACLE AMERICAN INC
  • US8266326B2 patent drawing
  • US8266326B2 patent drawing
  • US8266326B2 patent drawing

AI summary

Techniques for integrating Information Systems with Application Servers are disclosed. The techniques can be used to implement a configurable connector interface that connects to existing interfaces used to access various Information Systems. The configurable connection interface can encapsulate these existing interfaces. Accordingly, the configurable connector interface can serve as a standard interface that can be used to connect an application server to various Information Systems. The configurable connection interface can be implemented as a “Resource Adaptor” that can be modified to fit the requirements of a particular existing interface used to access a particular information system (e.g., a database driver developed for a particular relational database). A Graphical User Interface (GUI) can be used to conveniently modify and deploy the modified Resource Adaptor file. These operations can conveniently be performed by using a deployment tool through a Graphical User Interface (GUI).