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
- business
- erp systems
- 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; CALCULATING OR 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; CALCULATING OR 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 present invention relates to technical field of data processing, and in particular to one kind is for SAP ERP systems and ORACLE ERP systems
The interface method and device of system
Background technology
ERP（Enterprise Resource Planning）That is enterprise resource planning is one kind with systematization pipe
Reason thought is the management platform that enterprise provides decision-making operation means, and it is by the manufacturing activities and confession of customer demand and enterprises
Answer the manufacturing recourses of business to combine, form the complete supply chain of enterprise.ERP is mainly for human resource management, logistics
Management, financial management and information management etc. are integrated.
SAP ERP are the ERP solutions that SAP companies produce, and SAP ERP systems include the resource management module of people 4, material
Management module, financial management module, production schedule module, sale and distribution module etc..SAP ERP be at present worldwide
One of ERP software being widely adopted.
ORACLE ERP are the ERP solutions that Oracle produces, and ORACLE ERP systems mainly include financial mould
Block, distribution module and manufacture module etc..
Comparatively, SAP ERP systems and ORACLE ERP systems are devoted to providing enterprise to global every profession and trade enterprise
Level rwan management solution RWAN, by the design concept of both institute's foundations is different, thus data framework model, the data check rule for using
Then etc. universality can have nothing in common with each other, and business complexity difference is larger.
Currently, it is different due to there is the ERP system that different enterprises use, or even same enterprise difference subsidiary/member companies uses
The also different situation of ERP system, is guiding with business demand, it is desirable to achieve between SAP ERP systems and ORACLE ERP systems
Data interaction, realize data syn-chronization.But due to SAP ERP systems and the performance difference of ORACLE ERP systems, currently still
In the absence of the data interaction processing scheme between SAP ERP systems and ORACLE ERP systems.
The content of the invention
In view of this, the invention provides a kind of interface method for SAP ERP systems and ORACLE ERP systems and
Device, realizes the data syn-chronization between two systems.
On the one hand, the present invention provides 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 are passed
Defeated step, first object data code is sent to target database, to target database in the corresponding data of the first business
It is updated；Wherein, source database is one of SAP ERP systems database and ORACLEERP system databases, number of targets
It is another one according to storehouse；Transformation rule includes data corresponding for the first business, from the first source data code to first object number
According to the mapping relations of code.
Preferably, data conversion step is carried out in middle database server, and middle database server passes through Oracle
Database DBLink database links modes are connected with ORACLE ERP systems, also by JDBC database links mode with
SAP ERP systems are connected.
Preferably, if the first business is present in source database and target database simultaneously, method also includes：In data
After extraction step, the first source data code is stored in the corresponding source data framework model of source database；Also, in data
After switch process, before data transmission step, first object data code is stored in the corresponding number of targets of target database
According in framework model；Wherein, the data framework of source data framework model and the data framework of source database are identical, target data frame
The data framework of structure model is identical with the data framework of target database, and source data framework model and target data framework model set
It is placed in middle database server.
Preferably, if there is the first business in target database, do not exist the first business in source database, method is also wrapped
Include：Before data pick-up step, suspension data extraction step and data conversion step trigger preset data extraction step, from
Source database extracts the corresponding data of default at least one business, and default at least one business is relevant with the first business；Number
According to analyzing and processing step, according to the corresponding data of at least one business being drawn into, the corresponding data of the first business are obtained, and really
First object data code corresponding to the corresponding data of fixed first business；First object data code is stored in target data
In the corresponding target data framework model in storehouse；Wherein, the data of the data framework of target data framework model and target database
Framework is identical, and target data framework model is arranged in middle database server.
Preferably, after data pick-up step, before data conversion step, method also includes：Data check step, base
In default verification rule, the corresponding data of the first business to being drawn into are verified, when the data do not meet verification rule
When, this data transfer is abandoned, record this check errors information；Wherein, verify rule and include the first industry in target database
The data message constraints of business.
Preferably, in data transmission step, first object data code is sent to number of targets by middleware system
According to storehouse, middleware system includes SAP PI middlewares or ORACLE middlewares.
Preferably, method also includes：The operation interface that application system is provided is controlled to middle database server by whole process
In data checked and/or safeguarded；Wherein, whole process control application system is located at middle database server, including：Interface system
It is under unified central planning to put maintenance interface, check/safeguard transformation rule interface, check/safeguard that boundary is checked at checking effect rule interface, synchronous task
Interface and lock in time control interface are checked in face, wrong data.
Preferably, lock in time control interface will be divided into lock in time following two：One is set time synchronization, by point,
When, day or the moon for unit time interval carry out it is periodically synchronous；Two refers to synchronization of fixing time, and is carried out at the preassigned moment
It is synchronous.
On the other hand, the present invention also provides a kind of for SAP ERP systems and the interface arrangement of ORACLE ERP systems, bag
Include：Data extraction module, for extracting the corresponding data of the first business from source database, determines the corresponding first source number of the data
According to code；Data conversion module, for being first object data by the first source data code conversion based on default transformation rule
Code；Data transmission module, for first object data code to be sent to target database, to target database in first
The corresponding data of business are updated；Wherein, source database is SAP ERP systems database and ORACLE ERP system databases
One of, target database is another one；Transformation rule includes data corresponding for the first business, from the first source data generation
Mapping relations of the code to first object data code.
Beneficial effects of the present invention：The present invention is by SAP ERP systems and ORACLE ERP system Back ground Information fields
Code conversion is carried out, data syn-chronization of the two big ERP systems in field rank is realized.
Brief description of the drawings
Fig. 1 is the embodiment of the present invention for SAP ERP systems and the interface method flow chart of ORACLE ERP systems.
Fig. 2 is the middle database server architecture schematic diagram of the embodiment of the present invention.
Fig. 3 be the embodiment of the present invention SAP ERP systems in occurrences in human life event business module schematic diagram.
Fig. 4 is the interface method FB(flow block) of the embodiment of the present invention.
Fig. 5 is the interface arrangement structural representation of the embodiment of the present invention.
Specific embodiment
Developed simultaneously embodiment below in conjunction with accompanying drawing, technical scheme is described in detail.
In each service application framework of ERP system, the Business Entity correspondence related data of each service application, typically
It is made up of the information element field of most basic unit, for example：" employee's essential information " is Business Entity, and sex, age, nationality are information
Element field.The purpose of the present invention is directed to SAP ERP systems and the base layer information element field of ORACLE ERP systems to be carried out
It is synchronous.
Fig. 1 is the embodiment of the present invention for SAP ERP systems and the interface method flow chart of ORACLE ERP systems, bag
Include：
S101 data pick-up process steps, the corresponding data of the first business are extracted from source database, determine data correspondence
The first source data code.
S102 data conversion treatment steps, based on default transformation rule by the first source data code conversion be first object
Data code.
S103 data transmission and processing steps, first object data code are sent to target database, to target database
In the corresponding data of the first business be updated.
Wherein, when wishing the data syn-chronization of SAP ERP systems to ORACLE ERP systems, by SAP ERP systems
, used as source database, using the database of ORACLE ERP systems as target database, vice versa for database, can be according to enterprise
Actual demand selection setting.
Specific embodiment party is described below for by the data syn-chronization of ORACLE ERP systems to the situation of SAP ERP systems
Formula, i.e., with ORACLE ERP systems（Hereinafter referred to as " O side "）As origin system, with SAP ERP systems（Hereinafter referred to as " S side "）Make
It is receiving terminal.
In practical application scene, first, business datum interested is extracted from O party databases, such as extracted member
" educational background " field in " education background " business of work, in O side, educational background is that the corresponding code of undergraduate course is " 30 ", master's corresponding generation
Code is " 40 ", etc..
In order to carry out the conversion of data, a transformation rule is set up, for the field data of each entities business, it is stipulated that its
From O side's code to the mapping relations of S side's code.For " educational background " business, the Mapping and Converting relation such as table 1 can be set up：
| Academic business | O side's code | S side's code |
| Training | 20 | ZK |
| Undergraduate course | 30 | BK |
| Master | 40 | SH |
| Doctor | 50 | BO |
Table 1
Then, according to the mapping relations of table 1, all codes of O side's educational background data of extraction are converted into S side's educational background correspondence
Code so that the academic information of employee is recognizable for S side.
Finally, the S side's code after conversion is sent in S party databases, employee's educational background information can be updated, realized
Field level data syn-chronization of the O side to S side.
More than, realize the synchronization from O side to S side, the word for " educational background " field information in " education background " business
Section is matched one by one in two big ERP systems, similarly can also be synchronized for other service fields interested.It can be seen that, utilize
The present invention carries out data syn-chronization to SAP ERP systems and ORACLE ERP systems, can realize the field level correspondence of two big systems.
In a particular embodiment of the present invention, both sides are connected by setting up interface middle database server between O side and S side
Pick up and, referring to Fig. 2, middle database server is respectively created Oracle as interface system in middle database server database
Database DBLink（Database link mode）It is connected to O party databases, and JDBC（Database link mode）It is connected to
S party databases, the Oracle Database11g numbers that database can be general using both sides' ERP system on middle database server
According to storehouse.It is used to realize that both sides interconnect, carries out data conversion.
In one embodiment of the invention, two sets of data framework models are created in middle database server, for both sides
Extracted data is deposited in data pick-up, conversion and transmitting procedure.Specifically, on the one hand, create the data framework model of O side,
Data framework with O party databases is identical, also creates the data framework model of S side, and the data framework with S party databases is identical.
For the embodiment of table 1, after " educational background " data for extracting all employees from O party databases, to the data framework mould of O side
" educational background " field storage O side's code in type（By a series of the 20 of employee name's name placement, 30,40,50）.Complete O side
Code to after the Mapping and Converting of S side's code, the S side's code that will be obtained（By a series of ZK of employee name's name placement, BK, SH,
BO）In depositing in the data framework model of S side.S side's code is sent into S party databases can carry out data renewal.
Different from the embodiment of table 1, for " occurrences in human life event " business that such as S side is concerned about, referring to Fig. 3, in O side and do not exist
The business module, also just in the absence of the information data of occurrences in human life event, therefore cannot obtain " occurrences in human life event " industry in data pick-up
Business data.
In this regard, in a particular embodiment of the present invention, not performing the data pick-up for " occurrences in human life event " business, but take out
Take the data of other business related to " occurrences in human life event " business, such as " tenure distribution " business of O side, it contains employee's record
Become a full member with, employee and the field information such as change with post.
Specifically, " tenure distribution " information according to O side, by analyzing and calculating, can be back-calculated to obtain " the occurrences in human life of employee
Event " business information.For example, described in " tenure distribution " business of O side's employee's first employee's first on January 1st, 2001 extremely
Tenure post during 31 days Mays in 2001 is " worker on probation ", the tenure during June 1 to 31 days Mays in 2003 in 2001
Post is " regular employee ", and the tenure post during June 1 to 31 days Mays in 2005 in 2003 is " assistant engineer ", etc.
Deng.This impliedly shows that " occurrences in human life event " business information of employee's first has：January 1 " employee employs " in 2001, in June, 2001
" employee learns on the job expired " on the 1st, on June 1st, 2003 " transfer-position-assistant engineer ", etc..The information that these analytical derivations go out can be made
It is employee's first in " occurrences in human life event " business datum of S side, these data is designated as the code that S side can recognize, is stored in the number of S side
According in framework model.Table 2 schematically lists related service title and code.S party databases are given by code transfer, after identification
Carry out the data syn-chronization of occurrences in human life event business.On the analytical derivation for being carried out, can according to the association between specific business information,
It is regular with appropriate calculating logic script and data switching logic effect using two big system dictionary type conversion matchings, on demand
Definition, so as to not exist but the data present in goal systems in excavating generation origin system by source data.
| Occurrences in human life event business | O side's code | S side's code |
| Employee employs | / | LUY |
| Employee learns on the job expired | / | ZHZ |
| Post changes | / | ZHG |
Table 2
In addition, during O side and S side's data transmission synchronization is realized using the interface method of the embodiment of the present invention, can
The wrong data for not meeting target database requirement can occurs, therefore data check link is set.
Reference picture 4, in middle database server, the data content of a certain business to being drawn into is verified, and works as appearance
When not meeting the constraints of identical services in target database, check results are wrong for verification, for example：Target database S side
It is required that " educational background " " learns specialty ", it is necessary to typing simultaneously by employee more than training information, and source database O side " learns special
Industry " fills out project for choosing.
So, by the missing of " learning specialty " field information, the verification to " educational background " data of O side does not pass through, and does not enter
The conversion and transmission of row data, high-ranking officers' error checking false information are recorded, and beam back O party databases to notify that data source attendant enters
Capable targetedly database maintenance, increases the information for needing, and may also need to modify and/or delete in other embodiments
Deng safeguarding, the service fields can be again extracted when subsynchronous under and completes synchronous., whereas if the constraints of both sides is identical,
Showing can be directly synchronous, then verification passes through, into the flow such as analyzing and processing of next step code conversion or related data.Can
See, embodiments of the invention can carry out the function of comparing examination ＆ verification, correct the otherness of both data.
In addition, in the above-described embodiments, S number formularies are according to framework model in can collecting middle database server by middleware system
The code of middle storage, referring to Fig. 4, such as with SAP PI（Process Integration, Process integration）System is to S number formulary evidences
Framework model carries out monitoring reading, receives the data after conversion, and data check is carried out by S side, verifies normal data and conversion
Successful data, are sent to S party databases.Verification is wrong or changes unsuccessful data, by SAP PI systems to middle database
Server sends feedback, and correspondence business is also recorded as into check errors, and data source attendant can be checked and be safeguarded to it.
SAP PI systems, using standard interface technology, can be carried as SAP ERP systems and the middleware system of heterogeneous system exchange data
System flexibility high, reduces system maintenance input.
Similarly, using O party databases as source database, using S party databases as the embodiment of target database in,
O number formularies are carried out according to framework model using ORACLE middleware systems monitor the treatment such as reading.
In one embodiment of the invention, " whole process control application system " is created in middle database server, in
Between based on the server database of storehouse, control the work whole process of middle database server, attendant passes through system operatio interface
Checked and operated.Specifically, interface application system can be set up on middle database server database by JDBC modes, is adopted
With the WEB application mode of J2EE frameworks, allow attendant to pass through web browser to manipulate both data synchronization whole process operation.
Whole process control application system may include：Interface system configuring maintenance interface, check/safeguard transformation rule interface,
Check/safeguard that checking effect rule interface, synchronous task check that interface and lock in time control circle are checked in interface, wrong data
Face.For lock in time control interface, it will be divided into two kinds lock in time：One is Timing Synchronization, by point, when, day, based on the moon
Unit gap synchronizes operation；Two refers to synchronization of fixing time, and operation is synchronized by time scheduled date.
Using-S sides in O side of the invention interface method, when both data synchronization is implemented first, can be using full dose transmission
Mode, disposably synchronizes all data of whole business of origin system.When the later stage is synchronous using incremental transmission
Mode, the increment business information for special time period is synchronized, for example, arrived current time in transmission lock in time last time
In interval, the newly-increased of Individual traffic data, modification and deletion etc..
For example, using the scheme of the embodiment of the present invention, with the ORACLE ERP human resources subsystem industry of certain group
Used as data source, the SAP ERP human resources subsystems with the general headquarters of group carry out data syn-chronization to business data, wherein can involve
Extraction, conversion, effect, error correction and data transfer to system business data, it is also possible to be related to two big system dictionary types and turn
Change matching, calculating logic script and data switching logic effect rule etc..After scheme is reached the standard grade, transmitted using full dose first, it is complete
The data conversion transmission of each post object and relevant supplementary information into most tissues mechanism of group；After full dose is transmitted,
Using increment, Timing Synchronization pattern, incremental data transmission is daily carried out, i.e., daily fixed time transmission increment information carries out two
The data syn-chronization of big system is safeguarded.
In addition, the present invention also provides a kind of for SAP ERP systems and the interface arrangement of ORACLE ERP systems, ginseng
See Fig. 5, including：
Data extraction module 101, for extracting the corresponding data of the first business from source database, determines that the data are corresponding
First source data code；
Data conversion module 102, for being first object by the first source data code conversion based on default transformation rule
Data code；
Data transmission module 103, for first object data code to be sent to target database, in target database
The corresponding data of the first business be updated.
Wherein, source database is one of SAP ERP systems database and ORACLE ERP system databases, number of targets
It is another one according to storehouse；Transformation rule includes data corresponding for the first business, from the first source data code to first object number
According to the mapping relations of code.
Data syn-chronization of the international two big ERP systems in field rank is realized using the present invention, a set of business data can be made
Information is shared in two big ERP systems, and advantage is combined the characteristics of by two sets ERP systems itself, is made up to method, system presence not
Foot.
More than, technical scheme is described in detail in conjunction with specific embodiments, described specific implementation
Example is used to help understand thought of the invention.The derivation that those skilled in the art make on the basis of the specific embodiment of the invention
Fallen within the scope of the present invention with modification.
Claims (12)
1. a kind of for SAP ERP systems and the interface method of ORACLE ERP systems, it is characterised in that including：
Data pick-up step, the corresponding data of the first business are extracted from source database, determine corresponding first source data of the data
Code；
Data conversion step, is first object data generation by the first source data code conversion based on default transformation rule
Code；
Data transmission step, first object data code is sent to target database, to target database in the first business
Corresponding data are updated；Wherein,
The source database is one of SAP ERP systems database and ORACLE ERP system databases, the number of targets
It is another one according to storehouse；
The transformation rule includes data corresponding for first business, from the first source data code to first object data
The mapping relations of code；
The data conversion step is carried out in middle database server, and middle database server passes through Oracle Database
DBLink database links mode is connected with ORACLE ERP systems, also by JDBC database links mode and SAP ERP systems
System connection；
If there is first business in target database, do not exist first business in source database, methods described is also
Including：
Before the data pick-up step, the data pick-up step and the data conversion step are hung up, trigger present count
According to extraction step, the corresponding data of default at least one business, described default at least one business are extracted from source database
It is relevant with first business；
Data Analysis Services step, the corresponding data of at least one business according to being drawn into obtain first business
Corresponding data, and determine the first object data code corresponding to the corresponding data of first business；
The first object data code is stored in the corresponding target data framework model of target database；Wherein,
The data framework of the target data framework model is identical with the data framework of target database, the target data framework
Model is arranged in the middle database server.
2. the interface method of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 1, it is characterised in that
If first business is present in source database and target database simultaneously, methods described also includes：
After the data pick-up step, the first source data code is stored in the corresponding source data framework of source database
In model；Also,
After the data conversion step, before the data transmission step, the first object data code is stored in
In the corresponding target data framework model of target database；Wherein,
The data framework of the source data framework model is identical with the data framework of source database, the target data framework model
Data framework it is identical with the data framework of target database, the source data framework model and the target data framework model
It is arranged in the middle database server.
3. the interface method of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 1, it is characterised in that
After the data pick-up step, before the data conversion step, methods described also includes：
Data check step, based on default verification rule, the corresponding data of the first business to being drawn into are verified, when this
When data do not meet verification rule, this data transfer is abandoned, record this check errors information；Wherein,
The data message constraints of the verification rule comprising the first business described in target database.
4. the interface method of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 1, it is characterised in that
In the data transmission step, the first object data code is sent to target database, institute by middleware system
Stating middleware system includes SAP PI middlewares or ORACLE middlewares.
5. the interface method of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 1, it is characterised in that
Methods described also includes：
The operation interface that application system is provided is controlled to check and/or tie up the data in middle database server by whole process
Shield；Wherein,
The whole process control application system is located at middle database server, including：Interface system configuring maintenance interface, check/tie up
Shield transformation rule interface, check/safeguard checking effect rule interface, synchronous task check interface, wrong data check interface and
Lock in time control interface.
6. the interface method of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 5, it is characterised in that
The lock in time control interface will be divided into lock in time following two：One is set time synchronization, by point, when, day or the moon be
Unit interval carries out periodically synchronous；Two refers to synchronization of fixing time, and is synchronized at the preassigned moment.
7. a kind of for SAP ERP systems and the interface arrangement of ORACLE ERP systems, it is characterised in that including：
Data extraction module, for extracting the corresponding data of the first business from source database, determines corresponding first source of the data
Data code；
Data conversion module, for being first object number by the first source data code conversion based on default transformation rule
According to code；
Data transmission module, for first object data code to be sent to target database, to target database in first
The corresponding data of business are updated；Wherein,
The source database is one of SAP ERP systems database and ORACLE ERP system databases, the number of targets
It is another one according to storehouse；
The transformation rule includes data corresponding for first business, from the first source data code to first object data
The mapping relations of code；
The data conversion module is arranged in middle database server, and middle database server passes through Oracle Database
DBLink database links mode is connected with ORACLE ERP systems, also by JDBC database links mode and SAP ERP systems
System connection；
If there is first business in target database, do not exist first business in source database, described device is also
Including：
Triggering processing module, for hanging up the data extraction module and the data conversion module before data pick-up, touches
Hair preset data abstraction module；
The preset data abstraction module, it is described for extracting the corresponding data of default at least one business from source database
Default at least one business is relevant with first business；
Data Analysis Services module, for the corresponding data of at least one business according to being drawn into, obtains described first
The corresponding data of business, and determine the first object data code corresponding to the corresponding data of first business；
3rd storage processing module, for the first object data code to be stored in into the corresponding target data of target database
In framework model；Wherein,
The data framework of the target data framework model is identical with the data framework of target database, the target data framework
Model is arranged in the middle database server.
8. the interface arrangement of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 7, it is characterised in that
If first business is present in source database and target database simultaneously, described device also includes：
First storage processing module, for after data pick-up, the first source data code being stored in into source database pair
In the source data framework model answered；Also,
Second storage processing module, for after data conversion, before data transfer, the first object data code being deposited
It is placed in the corresponding target data framework model of target database；Wherein,
The data framework of the source data framework model is identical with the data framework of source database, the target data framework model
Data framework it is identical with the data framework of target database, the source data framework model and the target data framework model
It is arranged in the middle database server.
9. the interface arrangement of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 7, it is characterised in that
After data pick-up, before data conversion, described device also includes：
Data check module, for based on default verification rule, the corresponding data of the first business to being drawn into be verified,
When the data do not meet verification rule, this data transfer is abandoned, record this check errors information；Wherein,
The data message constraints of the verification rule comprising the first business described in target database.
10. the interface arrangement of SAP ERP systems and ORACLE ERP systems is used for as claimed in claim 7, it is characterised in that
Also include middleware system, the data transmission module is sent to mesh the first object data code by middleware system
Mark database, the middleware system includes SAP PI middlewares or ORACLE middlewares.
11. interface arrangements for being used for SAP ERP systems and ORACLE ERP systems as claimed in claim 7, it is characterised in that
Described device also includes：
Whole process controls application system, for providing operation interface being checked to the data in middle database server and/or
Safeguard；Wherein,
The whole process control application system is located at middle database server, including：Interface system configuring maintenance interface, check/tie up
Shield transformation rule interface, check/safeguard checking effect rule interface, synchronous task check interface, wrong data check interface and
Lock in time control interface.
12. interface arrangements for being used for SAP ERP systems and ORACLE ERP systems as claimed in claim 11, its feature exists
In the lock in time control interface will be divided into lock in time following two：One is set time synchronization, by point, when, day or the moon
For unit time interval is carried out periodically synchronously；Two refers to synchronization of fixing time, and is synchronized at the preassigned moment.
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 | 黎敏 | A kind of different company's ERP system exchange method and middleware |
| 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 | 江苏欧软信息科技有限公司 | Data synchronization method and system 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 | 国家电网公司 | 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 | |
| CN111031036B (en) | Block chain-based vaccine information monitoring method and device and computer equipment | |
| CN107729366A (en) | A kind of pervasive multi-source heterogeneous large-scale data synchronization system | |
| CN105556552A (en) | Fraud detection and analysis | |
| CN101622622A (en) | Individual health record system and device | |
| CN102663008B (en) | Government integrated business platform business library and construction method of base library | |
| CN107657049A (en) | A kind of data processing method based on data warehouse | |
| CN109448827A (en) | A kind of medical expense intelligence direct auditing system | |
| CN104699760A (en) | Data synchronization method used for heterogeneous system and based on safety isolation | |
| CN101968858A (en) | Software configuration management auxiliary system | |
| CN114841714A (en) | Product traceability system based on block chain | |
| CN108550003A (en) | The data processing method and device traced to the source based on agricultural product | |
| CN107729448A (en) | A kind of data handling system based on data warehouse | |
| CN116861189A (en) | Method for constructing equipment fault diagnosis maintenance knowledge base based on large language model | |
| CN104679870A (en) | Method for data acquisition of information system | |
| CN112965981B (en) | Data checking method, device, computer equipment and storage medium | |
| CN106530474A (en) | Achievement method of queuing system management platform | |
| CN109785172A (en) | Long-term care insurance implementation method, storage medium and equipment based on block chain | |
| CN113256470A (en) | Weapon equipment management system and method based on block chain | |
| CN109408602A (en) | A kind of big data integrated conduct method and system | |
| CN106709016A (en) | Service bus-based data exchange method | |
| CN114202307A (en) | Financial registration reporting system and device | |
| WO2023049348A1 (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 | |
| CN101136088A (en) | Information management system of mouth cavity technical worker institute | |
| CN112559511A (en) | Deposit system historical data cleaning method and system |
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 |