A method for information synchronization between oracle EBS database and Rabbit MQ server

Abstract

The invention relates to the technical field of databases, discloses a method for information synchronization between an Oracle EBS database and a Rabbit MQ server, comprising the steps of: (1) configuring the operating environment; (2) sending data requests: writing program packages and programs in Oracle EBS data The package is used to call the JSP middleware, call the Python program code through the middleware, and send a data request to the RabbitMQ server; (3) data processing. The invention has the advantages of low coupling, high efficiency, and instant response. The EBS system is directly connected to the RabbitMQ server without Http connection, without network delay, and has high availability, simple code, extremely low error probability, easy configuration, and easy expansion. : The configuration file is set in the EBS system, and different configuration information can be set for different systems without changing the code, and the expansion of future system docking can be realized through configuration. Errors are easy to track, which is helpful for statistical analysis of business data and regular tracking.

Description

Technical field [0001] The present invention relates to the field of database technologies, and in particular, a method of synchronizing an Oracle EBS database and a Rabbit MQ server information. Background technique [0002] Oracle EBS is a product of Oracle decades. The core value is the management and norm of enterprise processes, but its system architecture and technology have gradually could not meet the development of growth. [0003] The EBS system is also a data set, almost other systems have data interactions with EBS, deal with invoice data, payment data, data, inventory data, journal, fixed assets, employee data, etc., these external systems, They are all implemented in a variety of different technical architectures, and the interface provided is also very diversified, and the main development language of Oracle EBS is the SQL language. It is very difficult to connect these systems. Usually, the external system package interface, provide one The HTTP service is called ...

AI Technical Summary

Problems solved by technology

[0002] Oracle EBS is a product of Oracle Corporation decades ago. Its core value is the management and standardization of enterprise processes. However, its system architecture and technology have gradually failed to keep up with the ever-changing development.

[0003] The EBS system is also a place where data is attributed. Almost other systems have data interaction with EBS, such as invoice payable data, payable payment data, receivable data, inventory data, journals, fixed assets, employee data, etc., and these external systems, They are all implemented with various technical architectures, and the interfaces provided are also very diversified. The main development language of Oracle EBS is SQL language. The http service is called by the EBS system, and the coupling degree is very high. If one system fails, it will affect the other system, making it very inconvenient to use

Images