CN103914526B - A kind of interface method and device for SAP ERP systems and ORACLE ERP systems - Google Patents
A kind of interface method and device for SAP ERP systems and ORACLE ERP systems Download PDFInfo
- Publication number
- CN103914526B CN103914526B CN201410120656.7A CN201410120656A CN103914526B CN 103914526 B CN103914526 B CN 103914526B CN 201410120656 A CN201410120656 A CN 201410120656A CN 103914526 B CN103914526 B CN 103914526B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- target
- service
- source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of for SAP ERP systems and the interface method of ORACLE ERP systems, including：Data pick-up step, the corresponding data of the first business are extracted from source database, determine the corresponding first source data code of the data；Data conversion step, is first object data code by the first source data code conversion based on default transformation rule；Data transmission step, first object data code is sent to target database, to target database in the corresponding data of the first business be updated；Wherein, source database is one of SAP ERP systems database and ORACLE ERP system databases, and target database is another one；Transformation rule includes data corresponding for the first business, from the first source data code to the mapping relations of first object data code.Using the data syn-chronization of the achievable two big ERP systems of the present invention.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to an interface method and device for an SAP ERP system and an ORACLE ERP system
Background
An erp (enterprise Resource planning), which is an enterprise Resource planning system, is a management platform that provides decision-making operation means for an enterprise by using a systematic management idea, and integrates customer requirements, manufacturing activities inside the enterprise and manufacturing resources of suppliers together to form a complete supply chain of the enterprise. ERP mainly aims at integration of human resource management, logistics management, financial management, information management and the like.
SAP ERP is an ERP solution for products produced by SAP companies, and an SAP ERP system comprises a person 4 resource management module, a material management module, a financial management module, a production planning module, a sales and distribution module and the like. SAP ERP is one of ERP software that is currently widely adopted worldwide.
The ORACLE ERP is an ERP solution produced by ORACLE corporation, and the ORACLE ERP system mainly comprises a financial module, a distribution module, a manufacturing module and the like.
In comparison, both the SAP ERP system and the ORACLE ERP system are dedicated to providing enterprise-level management solutions for enterprises in various industries around the world, and due to different design concepts, the adopted data architecture models, data validation rules and other aspects have different performances, and the service complexity degree is greatly different.
At present, because different ERP systems used by different enterprises exist, and even different ERP systems used by different subordinate companies of the same enterprise are different, the business requirements are used as guidance, and it is hoped to realize data interaction between the SAP ERP system and the ORACLE ERP system and realize data synchronization. However, due to the performance difference between the SAP ERP system and the ORACLE ERP system, no data interaction processing scheme between the SAP ERP system and the ORACLE ERP system currently exists.
Disclosure of Invention
In view of this, the present invention provides an interface method and device for an SAP ERP system and an ORACLE ERP system, which implement data synchronization between the two systems.
In one aspect, the present invention provides an interface method for an SAP ERP system and an ORACLE ERP system, comprising: a data extraction step, namely extracting data corresponding to the first service from a source database and determining a first source data code corresponding to the data; a data conversion step of converting the first source data code into a first target data code based on a preset conversion rule; a data transmission step, namely sending the first target data code to a target database and updating data corresponding to the first service in the target database; the source database is one of an SAP ERP system database and an ORACLERP system database, and the target database is the other; the conversion rule contains a mapping relation from the first source data code to the first target data code for the data corresponding to the first service.
Preferably, the data conversion step is performed in a middle library server, and the middle library server is connected with the ORACLE ERP system in an ORACLE database DBLink database linking mode and is also connected with the SAP ERP system in a JDBC database linking mode.
Preferably, if the first service exists in both the source database and the target database, the method further comprises: after the data extraction step, storing the first source data code in a source data architecture model corresponding to a source database; after the data conversion step and before the data transmission step, storing the first target data code in a target data architecture model corresponding to a target database; the data architecture of the source data architecture model is the same as that of the source database, the data architecture of the target data architecture model is the same as that of the target database, and the source data architecture model and the target data architecture model are arranged in the intermediate database server.
Preferably, if the first service exists in the target database and the first service does not exist in the source database, the method further includes: before the data extraction step, suspending the data extraction step and the data conversion step, triggering the preset data extraction step, and extracting data corresponding to at least one preset service from a source database, wherein the at least one preset service is related to a first service; a data analysis processing step, namely acquiring data corresponding to the first service according to the extracted data corresponding to the at least one service, and determining a first target data code corresponding to the data corresponding to the first service; storing the first target data code in a target data architecture model corresponding to a target database; the data architecture of the target data architecture model is the same as that of the target database, and the target data architecture model is arranged in the intermediate library server.
Preferably, after the data extracting step and before the data converting step, the method further comprises: a data verification step, namely verifying the extracted data corresponding to the first service based on a preset verification rule, and when the data does not accord with the verification rule, giving up the data transmission and recording the verification error information; and the check rule comprises a data information constraint condition of the first service in the target database.
Preferably, in the data transmission step, the first target data code is sent to the target database through a middleware system, the middleware system including SAP PI middleware or ORACLE middleware.
Preferably, the method further comprises: viewing and/or maintaining data in the intermediate library server through an operation interface provided by the full-flow control application system; wherein, full flow control application system is located middle storehouse server, includes: the interface system is provided with a maintenance interface, a viewing/maintenance conversion rule interface, a viewing/maintenance verification rule interface, a synchronous task viewing interface, an error data viewing interface and a synchronous time control interface.
Preferably, the synchronization time control interface divides the synchronization time into the following two types: firstly, fixed time synchronization is carried out, and periodical synchronization is carried out at unit time intervals of minutes, hours, days or months; and secondly, time synchronization is appointed, and synchronization is carried out at a pre-appointed time.
In another aspect, the present invention further provides an interface device for an SAP ERP system and an ORACLE ERP system, comprising: the data extraction module is used for extracting data corresponding to the first service from a source database and determining a first source data code corresponding to the data; the data conversion module is used for converting the first source data code into a first target data code based on a preset conversion rule; the data transmission module is used for sending the first target data code to a target database and updating data corresponding to the first service in the target database; the system comprises a source database, a target database and a target database, wherein the source database is one of an SAP ERP system database and an ORACLE ERP system database, and the target database is the other; the conversion rule contains a mapping relation from the first source data code to the first target data code for the data corresponding to the first service.
The invention has the beneficial effects that: the invention realizes the data synchronization of the two ERP systems on the field level by carrying out code conversion on the basic information fields of the SAP ERP system and the ORACLE ERP system.
Drawings
Fig. 1 is a flowchart of an interface method for the SAP ERP system and the ORACLE ERP system according to an embodiment of the present invention.
FIG. 2 is a diagram of a middleware server architecture according to an embodiment of the present invention.
Fig. 3 is a schematic diagram of a human event service module in the SAP ERP system according to an embodiment of the present invention.
Fig. 4 is a flow chart of an interface method according to an embodiment of the present invention.
Fig. 5 is a schematic structural diagram of an interface device according to an embodiment of the present invention.
Detailed Description
The technical solution of the present invention is described in detail below by referring to the accompanying drawings and embodiments.
In each business application architecture of the ERP system, a business entity of each business application corresponds to related data, and generally consists of information element fields of the most basic layer, for example: "employee basic information" is a business entity, and gender, age, ethnicity are information element fields. The invention aims to synchronize basic information element fields of an SAP ERP system and an ORACLE ERP system.
Fig. 1 is a flowchart of an interface method for the SAP ERP system and the ORACLE ERP system according to an embodiment of the present invention, including:
s101, data extraction processing, namely extracting data corresponding to the first service from a source database, and determining a first source data code corresponding to the data.
S102, a data conversion processing step, namely converting the first source data code into a first target data code based on a preset conversion rule.
S103, data transmission processing, namely, sending the first target data code to a target database, and updating data corresponding to the first service in the target database.
When data of the SAP ERP system is expected to be synchronized to the ORACLE ERP system, the database of the SAP ERP system is used as a source database, the database of the ORACLE ERP system is used as a target database, and vice versa, and the data can be selectively set according to actual requirements of an enterprise.
The following describes a specific implementation for synchronizing data of the ORACLE ERP system to the SAP ERP system, that is, the ORACLE ERP system (hereinafter, referred to as "O party") is used as a source system, and the SAP ERP system (hereinafter, referred to as "S party") is used as a receiver.
In a practical application scenario, firstly, the service data of interest is extracted from the O-party database, such as extracting the "academic" field in the "education background" service of the employee, the code corresponding to the subject in the O-party academic is "30", the code corresponding to the master is "40", and so on.
For data conversion, a conversion rule is established, and the mapping relation of the field data of each entity business from the O-side code to the S-side code is specified. For the "academic" business, a mapping transformation relationship as shown in table 1 can be established:
| calendar business | O-square code | S square code |
| Special section | 20 | ZK |
| This section | 30 | BK |
| Master's soldier | 40 | SH |
| Doctor (Rooibos) | 50 | BO |
TABLE 1
And then, converting all codes of the extracted O-party scholarly calendar data into codes corresponding to the S-party scholarly calendar according to the mapping relation of the table 1, so that the scholarly calendar information of the staff is recognizable to the S-party.
And finally, the converted S-party code is sent to an S-party database, so that staff academic information can be updated, and field level data synchronization from the O party to the S party is realized.
In the above, the synchronization from the O party to the S party is realized aiming at the 'academic' field information in the 'education background' business, the fields are matched in two ERP systems one by one, and the synchronization can be carried out aiming at other interested business fields in the same way. Therefore, the invention can realize the field-level correspondence of the two systems by carrying out data synchronization on the SAP ERP system and the ORACLE ERP system.
In the embodiment of the invention, an interface middle base server is erected between an O side and an S side to connect the two sides, referring to fig. 2, the middle base server is used as an interface system, Oracle Database DBLink (Database linking mode) is respectively established in a middle base server Database and connected to the O side Database, JDBC (Database linking mode) is connected to the S side Database, and the Database on the middle base server adopts an Oracle Database11g Database which is common to both ERP systems. The method is used for realizing interconnection of two parties and data conversion.
In one embodiment of the invention, two sets of data architecture models are created in the intermediate library server for storing the extracted data in the data extraction, conversion and transmission processes of the two parties. Specifically, on one hand, a data architecture model of the O side is created and is the same as the data architecture of the O side database, and a data architecture model of the S side is also created and is the same as the data architecture of the S side database.
For the table 1 embodiment, after all employee "scholarly" data is extracted from the O-party database, the O-party code (a series of 20, 30, 40, 50 sorted by employee name position) is deposited into the "scholarly" field in the O-party data architecture model. After the mapping conversion from the O-party code to the S-party code is completed, the obtained S-party code (a series of ZK, BK, SH and BO sorted according to the position of the employee name) is stored in the data architecture model of the S-party. And sending the S-party code to the S-party database for data updating.
Unlike the embodiment of table 1, for the "personal event" service concerned by the S-party, for example, referring to fig. 3, the service module does not exist on the O-party, that is, the information data of the personal event does not exist, so that the "personal event" service data cannot be obtained during data extraction.
In this regard, in an embodiment of the present invention, data extraction for the "personal event" service is not performed, but data of other services related to the "personal event" service, such as "job assignment" service of the O-party, which contains field information such as employee record, employee turnover, and post change, is extracted.
Specifically, according to the 'assignment of duties' information of the O party, the 'personnel event' business information of the staff can be obtained through analysis and calculation. For example, the "assignment of duties" business of employee a on the O side states that the duties of employee a during 1/2001 to 5/31/2001 are "trial workers," the duties during 6/1/2001 to 5/31/2003 are "official workers," the duties during 6/1/2003 to 5/31/2005 are "assistant engineers," and so on. This implicitly indicates that the "human events" business information of employee a is: "employee record" on 1 month 1 of 2001, "employee visit expire on 1 month 6 of 2001," post-shift-assistant engineer "on 1 month 6 of 2003, and so on. The information derived by the analysis can be used as the 'personnel event' business data of the employee A on the S side, the data is recorded as the recognizable code of the S side and is stored in the data architecture model of the S side. Table 2 schematically lists the relevant service names and codes. And transmitting the codes to an S-party database, and synchronizing data of personnel event services after identification. With respect to the analytical derivation performed, data that is not present in the source system but is present in the target system can be generated by source data mining, as desired, in terms of associations between specific business information, using two large system dictionary type conversion matching and appropriate computational logic scripts and data conversion logic validation rules.
| Personnel event service | O-square code | S square code |
| Employee record | / | LUY |
| The staff's term of sight | / | ZHZ |
| Position change | / | ZHG |
TABLE 2
In addition, in the process of realizing the data transmission synchronization of the O side and the S side by using the interface method of the embodiment of the invention, error data which does not meet the requirements of a target database may occur, so that a data checking link is set.
Referring to fig. 4, in the intermediate repository server, the extracted data content of a certain service is checked, and when the constraint condition that the same service in the target database is not met occurs, the check result is that there is a check error, for example: the target database S side requires that the "academic calendar" is an employee above the specialty and needs to enter the "professional learned" information at the same time, and the source database O side requires that the "professional learned" is a filling item.
Then, due to the lack of the field information of the 'professional learned' field, the verification of the 'academic calendar' data of the O side is not passed, the data is not converted and sent, the verification error information is recorded and sent back to the O side database to inform a data source maintainer to perform targeted database maintenance, the required information is added, in other embodiments, the maintenance such as modification and/or deletion may be required, and the service field can be extracted again to complete synchronization when the next synchronization is performed. Otherwise, if the constraint conditions of the two parties are the same, which indicates that the two parties can be directly synchronized, the verification is passed, and the next code conversion or related data analysis processing flow is carried out. Therefore, the embodiment of the invention can perform the function of data comparison and verification and correct the difference of the data of the two parties.
In addition, in the above embodiment, the code stored in the S-side data architecture model in the middle library server may be collected through the middleware system, referring to fig. 4, for example, an SAP PI (Process Integration) system monitors and reads the S-side data architecture model, receives the converted data, performs data verification by the S-side, verifies the normal data, and sends the successfully converted data to the S-side database. And data with errors or unsuccessful conversion is checked, feedback is sent to the intermediate library server through the SAP PI system, the corresponding service is also recorded as a check error, and the data source maintainer can check and maintain the data. The SAP PI system is used as a middleware system for exchanging data between the SAP ERP system and the heterogeneous system, and a standard interface technology is adopted, so that the flexibility of the system can be improved, and the maintenance investment of the system can be reduced.
Similarly, in the embodiment where the O-side database is used as the source database and the S-side database is used as the target database, the ORACLE middleware system may be used to perform listening reading and other processing on the O-side data architecture model.
In one embodiment of the invention, a 'full-process control application system' is created in the intermediate library server, the full process of the work of the intermediate library server is controlled on the basis of the intermediate library server database, and maintenance personnel check and operate the full-process control application system through a system operation interface. Specifically, an interface application system can be established on a database of the middle library server in a JDBC mode, and a WEB application mode with a J2EE architecture is adopted, so that a maintainer can control the data synchronization full-flow operation of the two sides through a WEB browser.
The full-flow control application system can comprise: the interface system is provided with a maintenance interface, a viewing/maintenance conversion rule interface, a viewing/maintenance verification rule interface, a synchronous task viewing interface, an error data viewing interface and a synchronous time control interface. For the synchronous time control interface, the synchronous time is divided into two types: firstly, timing synchronization is carried out, and synchronization operation is carried out at unit intervals based on minutes, hours, days and months; and secondly, specified time synchronization, namely performing synchronization operation according to specified date and time.
When the O side-S side interface method of the invention is used, when the data synchronization of the two sides is implemented for the first time, the full transmission mode can be adopted to synchronize all the data of all the services of the source system at one time. In the later synchronization, an incremental transmission mode is adopted, and the incremental service information in a specific time period is synchronized, for example, in the interval from the last transmission synchronization time to the current time, the addition, modification and deletion of individual service data are performed.
For example, by using the scheme of the embodiment of the invention, the ORACLE ERP human resource subsystem service data of a certain group is used as a data source to perform data synchronization with the SAP ERP human resource subsystem of the headquarter of the group, wherein the data synchronization can involve extraction, conversion, validation, error correction and data transmission of the system service data, and can also involve dictionary type conversion matching, logic script calculation, data conversion logic validation rules and the like of two systems. After the scheme is on line, full transmission is adopted for the first time to complete data conversion transmission of each post object and related additional information in most organizations of the group; after the full transmission is finished, an increment and timing synchronization mode is adopted, and increment data transmission is carried out according to days, namely increment information is transmitted at fixed time every day, and data synchronization maintenance of the two systems is carried out.
In addition, the present invention also provides an interface device for the SAP ERP system and the ORACLE ERP system, referring to fig. 5, including:
the data extraction module 101 is configured to extract data corresponding to a first service from a source database, and determine a first source data code corresponding to the data;
the data conversion module 102 is configured to convert the first source data code into a first target data code based on a preset conversion rule;
the data transmission module 103 is configured to send the first target data code to the target database, and update data corresponding to the first service in the target database.
The system comprises a source database, a target database and a target database, wherein the source database is one of an SAP ERP system database and an ORACLE ERP system database, and the target database is the other; the conversion rule contains a mapping relation from the first source data code to the first target data code for the data corresponding to the first service.
The invention realizes the data synchronization of the international two ERP systems on the field level, can enable one set of enterprise data information to be shared in the two ERP systems, combines the advantages of the characteristics of the two sets of ERP systems and makes up the defects of the other system.
The technical solutions of the present invention have been described in detail with reference to specific embodiments, which are used to help understand the ideas of the present invention. The derivation and modification made by the person skilled in the art on the basis of the specific embodiment of the present invention also belong to the protection scope of the present invention.
Claims (12)
1. An interface method for an SAP ERP system and an ORACLE ERP system, comprising:
a data extraction step, namely extracting data corresponding to the first service from a source database and determining a first source data code corresponding to the data;
a data conversion step of converting the first source data code into a first target data code based on a preset conversion rule;
a data transmission step, namely sending the first target data code to a target database and updating data corresponding to the first service in the target database; wherein,
the source database is one of an SAP ERP system database and an ORACLE ERP system database, and the target database is the other;
the conversion rule comprises a mapping relation from a first source data code to a first target data code for the data corresponding to the first service;
the data conversion step is carried out in a middle library server, the middle library server is connected with an ORACLE ERP system in an Oracle database DBLink database linking mode, and is also connected with an SAP ERP system in a JDBC database linking mode;
if the first service exists in the target database and the first service does not exist in the source database, the method further comprises the following steps:
before the data extraction step, suspending the data extraction step and the data conversion step, triggering a preset data extraction step, and extracting data corresponding to at least one preset service from a source database, wherein the at least one preset service is related to the first service;
a data analysis processing step, in which data corresponding to the first service is obtained according to the extracted data corresponding to the at least one service, and a first target data code corresponding to the data corresponding to the first service is determined;
storing the first target data code in a target data architecture model corresponding to a target database; wherein,
the data architecture of the target data architecture model is the same as that of the target database, and the target data architecture model is arranged in the intermediate library server.
2. The method for interfacing an SAP ERP system with an ORACLE ERP system of claim 1, wherein if the first service exists in both the source database and the target database, the method further comprises:
after the data extraction step, storing the first source data code in a source data architecture model corresponding to a source database; and,
after the data conversion step and before the data transmission step, storing the first target data code in a target data architecture model corresponding to a target database; wherein,
the data architecture of the source data architecture model is the same as that of the source database, the data architecture of the target data architecture model is the same as that of the target database, and the source data architecture model and the target data architecture model are arranged in the middle database server.
3. The method of interfacing an SAP ERP system with an ORACLE ERP system of claim 1, wherein after the data extracting step and before the data converting step, the method further comprises:
a data verification step, namely verifying the extracted data corresponding to the first service based on a preset verification rule, and when the data does not accord with the verification rule, giving up the data transmission and recording the verification error information; wherein,
the check rule comprises a data information constraint condition of the first service in the target database.
4. The method of claim 1, wherein in the step of data transfer, the first target data code is sent to a target database through a middleware system, the middleware system comprising SAP PI middleware or ORACLE middleware.
5. The method of interfacing an SAP ERP system with an ORACLE ERP system of claim 1, wherein the method further comprises:
viewing and/or maintaining data in the intermediate library server through an operation interface provided by the full-flow control application system; wherein,
the full-process control application system is positioned on a middle library server and comprises: the interface system is provided with a maintenance interface, a viewing/maintenance conversion rule interface, a viewing/maintenance verification rule interface, a synchronous task viewing interface, an error data viewing interface and a synchronous time control interface.
6. The method of claim 5, wherein the isochronous time control interface divides isochronous time into two types: firstly, fixed time synchronization is carried out, and periodical synchronization is carried out at unit time intervals of minutes, hours, days or months; and secondly, time synchronization is appointed, and synchronization is carried out at a pre-appointed time.
7. An interface device for an SAP ERP system and an ORACLE ERP system, comprising:
the data extraction module is used for extracting data corresponding to the first service from a source database and determining a first source data code corresponding to the data;
the data conversion module is used for converting the first source data code into a first target data code based on a preset conversion rule;
the data transmission module is used for sending the first target data code to a target database and updating data corresponding to the first service in the target database; wherein,
the source database is one of an SAP ERP system database and an ORACLE ERP system database, and the target database is the other;
the conversion rule comprises a mapping relation from a first source data code to a first target data code for the data corresponding to the first service;
the data conversion module is arranged in a middle library server, and the middle library server is connected with an ORACLE ERP system in an Oracle database DBLink database linking mode and is also connected with an SAP ERP system in a JDBC database linking mode;
if the first service exists in the target database and the first service does not exist in the source database, the apparatus further includes:
the trigger processing module is used for suspending the data extraction module and the data conversion module before data extraction and triggering a preset data extraction module;
the preset data extraction module is used for extracting data corresponding to at least one preset service from a source database, wherein the at least one preset service is related to the first service;
the data analysis processing module is used for acquiring data corresponding to the first service according to the extracted data corresponding to the at least one service and determining a first target data code corresponding to the data corresponding to the first service;
the third storage processing module is used for storing the first target data code in a target data architecture model corresponding to a target database; wherein,
the data architecture of the target data architecture model is the same as that of the target database, and the target data architecture model is arranged in the intermediate library server.
8. The interface apparatus for an SAP ERP system and an ORACLE ERP system of claim 7, wherein if the first service exists in both the source database and the target database, the apparatus further comprises:
the first storage processing module is used for storing the first source data code in a source data architecture model corresponding to a source database after data extraction; and,
the second storage processing module is used for storing the first target data code in a target data architecture model corresponding to a target database after data conversion and before data transmission; wherein,
the data architecture of the source data architecture model is the same as that of the source database, the data architecture of the target data architecture model is the same as that of the target database, and the source data architecture model and the target data architecture model are arranged in the middle database server.
9. An interface apparatus for an SAP ERP system and an ORACLE ERP system as claimed in claim 7, wherein after data extraction and before data transformation, the apparatus further comprises:
the data verification module is used for verifying the extracted data corresponding to the first service based on a preset verification rule, and when the data does not accord with the verification rule, the data transmission is abandoned and the verification error information is recorded; wherein,
the check rule comprises a data information constraint condition of the first service in the target database.
10. The interface apparatus for an SAP ERP system and an ORACLE ERP system of claim 7, further comprising a middleware system, the data transmission module to send the first target data code to a target database through the middleware system, the middleware system comprising an SAP PI middleware or an ORACLE middleware.
11. The interface apparatus for an SAP ERP system and an ORACLE ERP system of claim 7, wherein the apparatus further comprises:
the full-flow control application system is used for providing an operation interface to view and/or maintain data in the intermediate library server; wherein,
the full-process control application system is positioned on a middle library server and comprises: the interface system is provided with a maintenance interface, a viewing/maintenance conversion rule interface, a viewing/maintenance verification rule interface, a synchronous task viewing interface, an error data viewing interface and a synchronous time control interface.
12. The interface apparatus for an SAP ERP system and an ORACLE ERP system of claim 11, wherein the synchronized time control interface divides the synchronized time into the following two types: firstly, fixed time synchronization is carried out, and periodical synchronization is carried out at unit time intervals of minutes, hours, days or months; and secondly, time synchronization is appointed, and synchronization is carried out at a pre-appointed time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410120656.7A CN103914526B (en) | 2014-03-27 | 2014-03-27 | A kind of interface method and device for SAP ERP systems and ORACLE ERP systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410120656.7A CN103914526B (en) | 2014-03-27 | 2014-03-27 | A kind of interface method and device for SAP ERP systems and ORACLE ERP systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103914526A CN103914526A (en) | 2014-07-09 |
| CN103914526B true CN103914526B (en) | 2017-06-16 |
Family
ID=51040206
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410120656.7A Active CN103914526B (en) | 2014-03-27 | 2014-03-27 | A kind of interface method and device for SAP ERP systems and ORACLE ERP systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103914526B (en) |
Families Citing this family (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104915362A (en) * | 2014-07-19 | 2015-09-16 | 国家电网公司 | Fast intelligent ERP system data migration scheme based on time slices, increment analysis and random disorganizing technology |
| CN104484164A (en) * | 2014-11-20 | 2015-04-01 | 朱敏 | Method and system for processing data in an ERP (Enterprise Resource Planning) environment |
| CN105404527B (en) * | 2015-09-24 | 2019-05-28 | 国网山东省电力公司 | Interface allocation method and system based on SAP platform |
| CN105867895A (en) * | 2015-11-20 | 2016-08-17 | 乐视致新电子科技（天津）有限公司 | Method for realizing code management and need management information synchronization and device thereof |
| CN105677384A (en) * | 2015-12-28 | 2016-06-15 | 上海爱数信息技术股份有限公司 | System supporting information synchronization of organizations and users between different application systems |
| CN105760485A (en) * | 2016-02-17 | 2016-07-13 | 上海携程商务有限公司 | Financial data extraction method and system |
| CN107273222A (en) * | 2017-05-19 | 2017-10-20 | 黎敏 | An Interaction Method and Middleware for ERP Systems of Different Companies |
| CN107562931A (en) * | 2017-09-15 | 2018-01-09 | 新智云数据服务有限公司 | Data pick-up system and data abstracting method |
| CN108471441A (en) * | 2018-03-15 | 2018-08-31 | 广东科达洁能股份有限公司 | A kind of SAP middlewares and the SAP R3 both-way communication methods using the SAP middlewares |
| CN108595391A (en) * | 2018-04-28 | 2018-09-28 | 中国建设银行股份有限公司 | A kind of data information conversion method and device |
| CN108900497B (en) * | 2018-06-25 | 2021-11-02 | 江苏欧软信息科技有限公司 | Method and system for data synchronization between heterogeneous systems |
| CN109165200B (en) * | 2018-08-10 | 2022-04-01 | 北京奇虎科技有限公司 | Data synchronization method and device, computing equipment and computer storage medium |
| CN109472479A (en) * | 2018-10-31 | 2019-03-15 | 中冶赛迪技术研究中心有限公司 | A kind of method of MES product plan insertion simulation model |
| CN109783555B (en) * | 2018-12-13 | 2021-07-30 | 东软集团股份有限公司 | Form template storage method and device, storage medium and electronic equipment |
| CN110334141B (en) * | 2019-05-30 | 2023-11-21 | 平安科技（深圳）有限公司 | Method, device, computer equipment and storage medium for data conversion |
| CN110389988A (en) * | 2019-07-30 | 2019-10-29 | 四川虹魔方网络科技有限公司 | A kind of the user data processing method and system of real-time high-efficiency |
| CN111008250A (en) * | 2019-12-05 | 2020-04-14 | 国家电网公司 | A data synchronization method between ERP system and other systems |
| CN111488335A (en) * | 2020-03-17 | 2020-08-04 | 上海维信荟智金融科技有限公司 | Rule-based data automatic restoration method and system |
| CN111858668B (en) * | 2020-06-30 | 2021-05-18 | 物产中大数字科技有限公司 | Data extraction method and device for SAP HANA |
| CN111858647B (en) * | 2020-08-04 | 2022-07-05 | 浪潮卓数大数据产业发展有限公司 | Method for verifying conversion field type between data sources |
| CN113095783A (en) * | 2021-04-12 | 2021-07-09 | 远光软件股份有限公司 | Method, device, storage medium and electronic equipment for converting financial data adjusting period |
| CN114356483B (en) * | 2022-01-05 | 2023-04-21 | 北京京航计算通讯研究所 | SAP ERP system data processing method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102129478A (en) * | 2011-04-26 | 2011-07-20 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
| CN102542007A (en) * | 2011-12-13 | 2012-07-04 | 中国电子科技集团公司第十五研究所 | Method and system for synchronization of relational databases |
| CN102841927A (en) * | 2012-07-18 | 2012-12-26 | 福建省新泽尔资讯科技有限公司 | Method and device for data interaction among a plurality of databases and distributed data interaction system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040024771A1 (en) * | 2002-08-01 | 2004-02-05 | Oracle International Corporation | Buffered message queue architecture for database management systems with transactional enqueue support |
-
2014
- 2014-03-27 CN CN201410120656.7A patent/CN103914526B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102129478A (en) * | 2011-04-26 | 2011-07-20 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
| CN102542007A (en) * | 2011-12-13 | 2012-07-04 | 中国电子科技集团公司第十五研究所 | Method and system for synchronization of relational databases |
| CN102841927A (en) * | 2012-07-18 | 2012-12-26 | 福建省新泽尔资讯科技有限公司 | Method and device for data interaction among a plurality of databases and distributed data interaction system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103914526A (en) | 2014-07-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103914526B (en) | A kind of interface method and device for SAP ERP systems and ORACLE ERP systems | |
| US8195605B2 (en) | Data cache techniques in support of synchronization of databases in a distributed environment | |
| RU2607992C2 (en) | Tools operation monitoring system and method | |
| US8515903B2 (en) | Collaboration of plural databases by interaction through universal index | |
| US20170316183A1 (en) | Clinical data management system | |
| EP3361429A1 (en) | Component tracking method and system | |
| US8626703B2 (en) | Enterprise resource planning (ERP) system change data capture | |
| US20110161132A1 (en) | Method and system for extracting process sequences | |
| CN104766151A (en) | Quality management and control method for electricity transaction data warehouses and management and control system thereof | |
| US20210343401A1 (en) | Blockchain-Based Technologies for Tracking Product Lifecycle | |
| US20230092365A1 (en) | Graph models of relationships between data stored in blocks on distributed ledgers that are learned through machine learning and platforms for creating, cataloging, and storing the same | |
| US11728028B2 (en) | Clinical services patient management system | |
| CN107886296B (en) | Collaborative auditing method between heterogeneous PDM systems | |
| US10566086B2 (en) | Centralized accumulator systems and methods | |
| US20230015950A1 (en) | Method and system for converting database applications into blockchain applications | |
| KR20140069669A (en) | System and Method for processing of large scale data based rule set | |
| CN102222280B (en) | Information interaction processing system and method | |
| US20130254156A1 (en) | Algorithm and System for Automated Enterprise-wide Data Quality Improvement | |
| CN107808198A (en) | Automation engineering instruction creates | |
| CN101339506A (en) | Device for implementing software products resource and version management | |
| CN118708652A (en) | A data synchronization method and system for detection data platform | |
| CN114202307A (en) | Financial management registration and reporting system and equipment | |
| US10545952B2 (en) | Multitenant architecture for prior period adjustment processing | |
| CN118193508A (en) | Data checking method, device, computer equipment and storage medium | |
| Kline et al. | Database derived from an electronic medical record-based surveillance network of US emergency department patients with acute respiratory illness |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant |