CN103914526A - Interface method and interface device for SAP ERP (enterprise resource planning) system and ORACLE ERP system - Google Patents

Interface method and interface device for SAP ERP (enterprise resource planning) system and ORACLE ERP system Download PDF

Info

Publication number
CN103914526A
CN103914526A CN 201410120656 CN201410120656A CN103914526A CN 103914526 A CN103914526 A CN 103914526A CN 201410120656 CN201410120656 CN 201410120656 CN 201410120656 A CN201410120656 A CN 201410120656A CN 103914526 A CN103914526 A CN 103914526A
Authority
CN
Grant status
Application
Patent type
Prior art keywords
data
erp
database
system
target
Prior art date
Application number
CN 201410120656
Other languages
Chinese (zh)
Other versions
CN103914526B (en )
Inventor
谢洲
王自河
何志强
王森
杨苇
李耀斌
官向栋
闫瑞
Original Assignee
神华集团有限责任公司
神华宁夏煤业集团有限责任公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30557Details of integrating or interfacing systems involving at least one database management system
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30575Replication, distribution or synchronisation of data between databases or within a distributed database; Distributed database system architectures therefor

Abstract

The invention discloses an interface method for an SAP ERP (enterprise resource planning) system and an ORACLE ERP system. The interface method includes a data extraction step: extracting data corresponding to first services from a source database and determining first source data codes corresponding to the data; a data conversion step: converting the first source data codes into first target data codes on the basis of preset conversion rules; a data transmission step: transmitting the first target data codes to a target database and updating certain data in the target databases. The certain data in the target database correspond to the first services. The source database is one of a database of the SAP ERP system and a database of the ORACLE ERP system, and the target database is the other one of the database of the SAP ERP system and the database of the ORACLE ERP system. The conversion rules comprise mapping relations of the data corresponding to the first services among the first source data codes and the first target data codes. The interface method has the advantage that data of the two major ERP systems can be synchronized by the aid of the interface method.

Description

—种用于SAP ERP系统与ORACLE ERP系统的接口方法和装 - a kind of interface method SAP ERP system and ORACLE ERP systems and apparatus

技术领域 FIELD

[0001] 本发明涉及数据处理技术领域,具体涉及一种用于SAP ERP系统与ORACLE ERP系统的接口方法和装置 [0001] The present invention relates to the technical field of data processing, in particular, to a method and apparatus for an interface system and the SAP ERP system for ORACLE ERP

背景技术 Background technique

[0002] ERP (Enterprise Resource Planning)即企业资源计划系统,是一种以系统化管理思想为企业提供决策运行手段的管理平台,其将客户需求和企业内部的制造活动以及供应商的制造资源整合在一起,形成企业的完整的供应链。 [0002] ERP (Enterprise Resource Planning) Enterprise Resource Planning System is a systematic management thinking means to provide decision to run for the enterprise management platform, which will be manufacturing resources and manufacturing activities within the enterprise customer demand and supplier integration together to form a complete supply chain companies. ERP主要针对人力资源管理、物流 ERP mainly for human resources management, logistics

管理、财务管理和信息管理等集成一体化。 Management, financial management and information management for Integration.

[0003] SAP ERP是SAP公司出品的ERP解决方案,SAP ERP系统包括人4资源管理模块、物料管理模块、财务管理模块、生产计划模块、销售与分销模块等。 [0003] SAP ERP is SAP's ERP solutions produced, SAP ERP systems including human resource management module 4, material management modules, financial management module, production planning module, sales and distribution module. SAP ERP是目前在世界范围内被广泛采用的ERP软件之一。 SAP ERP is one in the world that are widely used ERP software.

[0004] ORACLE ERP是甲骨文公司出品的ERP解决方案,ORACLE ERP系统主要包括财务模块、配销模块和制造模块等。 [0004] ORACLE ERP Oracle's ERP solution produced, the ORACLE ERP system includes financial modules, distribution module, and module manufacturing.

[0005] 比较而言,SAP ERP系统和ORACLE ERP系统均致力于向全球各行业企业提供企业级管理解决方案,由于两者所依据的设计理念不同,因而采用的数据架构模型、数据效验规则等多方面性能各有不同,业务复杂程度差别较大。 [0005] In contrast, SAP ERP system and ORACLE ERP systems are dedicated to providing enterprise-class management solutions to various industries and enterprises worldwide, due to the difference between the two is based on the design, data architecture model thus employed, the efficacy data rules the performance of many different, complex businesses quite different.

[0006] 当前,由于存在不同企业使用的ERP系统不同,甚至同一企业不同下属公司使用的ERP系统也不同的情况,以业务需求为导向,希望实现SAP ERP系统和ORACLE ERP系统之间的数据交互,实现数据同步。 [0006] Currently, due to the presence of different ERP systems used by different companies, even the same enterprise ERP systems used by different companies under different circumstances, with business demand, hope to achieve data exchange between the SAP ERP system and ORACLE ERP system to achieve data synchronization. 但是由于SAP ERP系统和ORACLE ERP系统的性能差异,当前尚不存在SAP ERP系统和ORACLE ERP系统之间的数据交互处理方案。 However, due to performance differences SAP ERP system and ORACLE ERP system, the current does not yet exist between the data exchange processing scheme SAP ERP system and ORACLE ERP systems.

发明内容 SUMMARY

[0007] 有鉴于此,本发明提供了一种用于SAP ERP系统与ORACLE ERP系统的接口方法和装置,实现了两系统之间的数据同步。 [0007] Accordingly, the present invention provides a method and apparatus for an interface system and the SAP ERP ORACLE ERP system used to achieve a synchronization of data between two systems.

[0008] 一方面,本发明提供一种用于SAP ERP系统和ORACLE ERP系统的接口方法,包括:数据抽取步骤,从源数据库抽取第一业务对应的数据,确定该数据对应的第一源数据代码;数据转换步骤,基于预设的转换规则,将第一源数据代码转换为第一目标数据代码;数据传输步骤,将第一目标数据代码发送至目标数据库,对目标数据库中的第一业务对应的数据进行更新;其中,源数据库为SAP ERP系统数据库和0RACLEERP系统数据库中的一者,目标数据库为另一者;转换规则包含对于第一业务对应的数据,从第一源数据代码到第一目标数据代码的映射关系。 [0008] In one aspect, the present invention provides a method of SAP ERP system and an interface ORACLE ERP system, comprising: a data extraction step of extracting data corresponding to the first service from the source database, determines that the data corresponding to a first data source codes; data conversion step, based on a predetermined conversion rule, first converting the source code for the first target data codes data; a data transmission step of transmitting a first target data to the target database codes, the first service on the target database corresponding to the updated data; wherein, the source database and the database for the SAP ERP system 0RACLEERP system database of one, the other target database; comprising data conversion rule corresponding to the first service from the first code to the second data source data mapping between a target code.

[0009] 优选地,数据转换步骤在中间库服务器中进行,中间库服务器通过OracleDatabase DBLink数据库链接方式与ORACLE ERP系统连接,还通过JDBC数据库链接方式与SAP ERP系统连接。 [0009] Preferably, the data conversion step in intermediate library server, the intermediate link library server database manner ORACLE ERP system via OracleDatabase DBLink, also connected to the SAP ERP system by way of a JDBC database link. [0010] 优选地,如果第一业务同时存在于源数据库和目标数据库中,方法还包括:在数据抽取步骤之后,将第一源数据代码存放在源数据库对应的源数据架构模型中;并且,在数据转换步骤之后、数据传输步骤之前,将第一目标数据代码存放在目标数据库对应的目标数据架构模型中;其中,源数据架构模型的数据架构与源数据库的数据架构相同,目标数据架构模型的数据架构与目标数据库的数据架构相同,源数据架构模型和目标数据架构模型设置于中间库服务器中。 [0010] Preferably, if the first service exist in the source and target databases, the method further comprising: after the data extraction step, the first source code is stored in the source database data corresponding to the source data schema model; and, after the data conversion step, prior to data transmission step, the first target data corresponding to the code stored in the destination target database data model architecture; wherein the same data source database schema data structure and a source data schema model, the target data schema model the same data structure and architecture of the target database data, source data and destination data architecture model architecture model is provided in the intermediate database server.

[0011] 优选地,如果目标数据库中存在第一业务,源数据库中不存在第一业务,方法还包括:在数据抽取步骤之前,挂起数据抽取步骤和数据转换步骤,触发预设数据抽取步骤,从源数据库抽取预设的至少一项业务对应的数据,预设的至少一项业务与第一业务有关;数据分析处理步骤,根据抽取到的至少一项业务对应的数据,获得第一业务对应的数据,并确定第一业务对应的数据所对应的第一目标数据代码;将第一目标数据代码存放在目标数据库对应的目标数据架构模型中;其中,目标数据架构模型的数据架构与目标数据库的数据架构相同,目标数据架构模型设置于中间库服务器中。 [0011] Preferably, if the first service is present in the target database, the source database does not exist in the first service, the method further comprising: prior to the step of extracting data, pending data extraction step and the data conversion step, trigger preset data extraction step extracted from the source database preset data corresponding to the at least one service, the at least one predetermined service and a first service related; data analysis processing step, according to the extracted data corresponding to the at least one service, the first service is obtained the corresponding data and determines the first target data corresponding to the code of the first service data corresponds; the first target data corresponding to the code stored in the destination target database data model architecture; wherein the data structure and the target object data model schema the same data schema of the database, the target set in the middle of the data architecture model library server.

[0012] 优选地,在数据抽取步骤之后、数据转换步骤之前,方法还包括:数据校验步骤,基于预设的校验规则,对抽取到的第一业务对应的数据进行验证,当该数据不符合校验规则时,放弃本次数据传输,记录本次校验错误信息;其中,校验规则包含目标数据库中第一业务的数据信息约束条件。 [0012] Preferably, after the data extraction step, prior to data conversion step, the method further comprising: a data verifying step, based on a preset validation rules, the extraction of the data corresponding to the first service to verify if the data is when not meet the validation rules, give up this data transmission, this parity error record; wherein the validation rules comprising data information in a first target database service constraints.

[0013] 优选地,在数据传输步骤中,通过中间件系统将第一目标数据代码发送至目标数据库,中间件系统包括SAP PI中间件或ORACLE中间件。 [0013] Preferably, in the data transmission step, the first target code to send data to the target database middleware system, middleware system including SAP PI middleware middleware or ORACLE.

[0014] 优选地,方法还包括:通过全流程控制应用系统提供的操作界面对中间库服务器中的数据进行查看和/或维护;其中,全流程控制应用系统位于中间库服务器,包括:接口系统配置维护界面、查看/维护转换规则界面、查看/维护验证效验规则界面、同步任务查看界面、错误数据查看界面和同步时间控制界面。 [0014] Preferably, the method further comprising: providing by total process control application interface data intermediate database servers for viewing and / or maintenance; wherein the whole process control applications in the middle of the database server, comprising: an interface system configuration and maintenance interface to view / maintain conversion rules interface to view / maintain efficacy validation rules interface, task synchronization interface view, erroneous data viewing interface and synchronize time control interface.

[0015] 优选地,同步时间控制界面将同步时间分为以下两种:一是固定时间同步,按分、时、天或月为单位时间间隔进行周期性地同步;二是指定时间同步,在预先指定的时刻进行同步。 [0015] Preferably, the time synchronization control interface synchronization time is divided into the following two: First, a fixed time synchronization, by minutes, hours, days or months periodically synchronizing time intervals; second synchronization time specified in advance specified time synchronization.

[0016] 另一方面,本发明还提供一种用于SAP ERP系统和ORACLE ERP系统的接口装置,包括:数据抽取模块,用于从源数据库抽取第一业务对应的数据,确定该数据对应的第一源数据代码;数据转换模块,用于基于预设的转换规则,将第一源数据代码转换为第一目标数据代码;数据传输模块,用于将第一目标数据代码发送至目标数据库,对目标数据库中的第一业务对应的数据进行更新;其中,源数据库为SAP ERP系统数据库和ORACLE ERP系统数据库中的一者,目标数据库为另一者;转换规则包含对于第一业务对应的数据,从第一源数据代码到第一目标数据代码的映射关系。 [0016] another aspect, the present invention provides an interface apparatus SAP ERP system and ORACLE ERP system, comprising: a data extraction module for extracting the first service corresponding to the data from the source database, determines that the data corresponding to a first data source codes; data conversion module, based on a predetermined conversion rule, first converting the source code for the first target data codes data; a data transmission means for transmitting a first target data codes to the target database, service data corresponding to the first target database to be updated; wherein the source database and the database for the SAP ERP system ORACLE ERP system database of one, the other target database; comprising data conversion rule corresponding to the first service , a first mapping from source data code into the first target code data.

[0017] 本发明的有益效果:本发明通过对SAP ERP系统和ORACLE ERP系统基础信息字段进行代码转换,实现了两大ERP系统在字段级别上的数据同步。 [0017] Advantageous Effects of Invention: The present invention, by synchronizing the ORACLE SAP ERP system and the ERP system based information field code conversion, the data in the ERP system on the two column level.

附图说明 BRIEF DESCRIPTION

[0018] 图1是本发明实施例的用于SAP ERP系统和ORACLE ERP系统的接口方法流程图。 [0018] FIG. 1 is the interface system and a method for SAP ERP ORACLE ERP system embodiment of the present invention a flowchart.

[0019] 图2是本发明实施例的中间库服务器架构示意图。 [0019] FIG. 2 is a schematic view of an intermediate library server architecture of the present embodiment of the invention. [0020] 图3是本发明实施例的SAP ERP系统中人事事件业务模块示意图。 [0020] FIG. 3 is a schematic diagram of personnel event service module SAP ERP system of the embodiment of the present invention.

[0021 ] 图4是本发明实施例的接口方法流程框图。 [0021] FIG. 4 is a flow diagram of an embodiment method of the interface of the present invention.

[0022] 图5是本发明实施例的接口装置结构示意图。 [0022] FIG. 5 is a schematic structure of an embodiment of the interface apparatus of the present invention.

具体实施方式 detailed description

[0023] 以下结合附图并举实施例,对本发明的技术方案进行详细描述。 [0023] conjunction with the accompanying drawings and the following embodiments, the technical solutions of the present invention will be described in detail.

[0024] 在ERP系统的各个业务应用架构中,每个业务应用的业务实体对应相关数据,一般由最基层的信息元素字段组成,例如:“员工基本信息”是业务实体,性别、年龄、民族是信息元素字段。 [0024] In each business application architecture ERP system, each business entity business applications corresponding to the relevant data, generally consists of the most basic elements of information fields, such as: "basic employee information" is a business entity, gender, age, ethnicity It is an information element field. 本发明的目的是针对SAP ERP系统和ORACLE ERP系统的基层信息元素字段进行同步。 Object of the present invention is directed to the base layer information element field SAP ERP system and ORACLE ERP system synchronization.

[0025] 图1为本发明实施例的用于SAP ERP系统和ORACLE ERP系统的接口方法流程图,包括: Interface system and a method for SAP ERP ORACLE ERP system [0025] FIG. 1 is a flowchart of an embodiment of the present invention, comprising:

[0026] SlOl数据抽取处理步骤,从源数据库抽取第一业务对应的数据,确定该数据对应的第一源数据代码。 [0026] SlOl data extraction step of extracting data corresponding to the first service from the source database, determines that the data corresponding to a first data source code.

[0027] S102数据转换处理步骤,基于预设的转换规则将第一源数据代码转换为第一目标数据代码。 [0027] S102 data conversion processing step, based on a predetermined conversion rule to convert a first code for the first target data source data codes.

[0028] S103数据传输处理步骤,将第一目标数据代码发送至目标数据库,对目标数据库中的第一业务对应的数据进行更新。 [0028] S103 data transmission processing step of the first target data code is sent to the target database, service data corresponding to the first target database is updated.

[0029] 其中,当希望将SAP ERP系统的数据同步至ORACLE ERP系统时,将SAP ERP系统的数据库作为源数据库,将ORACLE ERP系统的数据库作为目标数据库,反之亦然,可根据企业实际需求选择设定。 [0029] wherein, when it is desired to synchronize the data to the SAP ERP system ORACLE ERP system, SAP ERP system database as the source database, the ORACLE ERP system database as the target database, vice versa, may be selected according to the actual demand set up.

[0030] 以下针对将ORACLE ERP系统的数据同步至SAP ERP系统的情况描述具体实施方式,即以ORACLE ERP系统(以下简称“O方”)作为源系统,以SAP ERP系统(以下简称“S方”)作为接收端。 [0030] The following conditions for the data ORACLE ERP system is synchronized to the SAP ERP system of describing particular embodiments, i.e. ORACLE ERP system (hereinafter referred to as "O") on a source system to SAP ERP system (hereinafter referred to as "S side ") as a receiver.

[0031] 在实际应用场景中,首先,从O方数据库中抽取感兴趣的业务数据,比如抽取了员工的“教育背景”业务中的“学历”字段,在O方学历为本科对应的代码为“30”,硕士对应的代码为“40”,等等。 [0031] In practice scenarios, first of all, to extract business data from interested parties O database, such as extracting the employees' educational background "in the business" education "field in the O side undergraduate degree corresponding code "30", the corresponding master code "40", and the like.

[0032] 为了进行数据的转换,建立一个转换规则,针对每个实体业务的字段数据,规定其从O方代码到S方代码的映射关系。 [0032] In order to perform data conversion, a conversion rule established, the field data for each business entity, which is predetermined direction codes mapping from O to S side code. 对于“学历”业务,可建立如表1的映射转换关系: For the "education" services, such as mapping can be established conversion table 1:

[0033] [0033]

Figure CN103914526AD00071

[0034]表1[0035] 然后,按照表I的映射关系,将抽取的O方学历数据的所有代码转换成S方学历对应的代码,使得员工的学历信息对于S方来说是可识别的。 [0034] Table 1 [0035] Then, according to the mapping relationship of Table I, all the code extracted square academic O data into the S side code corresponding degree, so that the employee qualifications for the S-side information is identifiable .

[0036] 最后,将转换后的S方代码发送到S方数据库中,可对员工学历信息进行更新,实现了O方到S方的字段级数据同步。 [0036] Finally, the converted code is sent to party S S side database can be updated employee education information to achieve the O side to the field side of the S-level data synchronization.

[0037] 以上,针对“教育背景”业务中的“学历”字段信息实现了从O方到S方的同步,该字段在两大ERP系统中一一匹配,同理还可针对其它感兴趣的业务字段进行同步。 [0037] or more, for "education" information field "Education" business achieved from O side to side synchronous S, the field one matched in two ERP systems, but also empathy for other interested business field for synchronization. 可见,利用本发明对SAP ERP系统和ORACLE ERP系统进行数据同步,能够实现两大系统的字段级对应。 Be seen, the present invention is to use the SAP ERP system and ORACLE ERP system for data synchronization can be achieved corresponding to the two field-level system.

[0038] 在本发明的具体实施例中,通过在O方和S方之间架设接口中间库服务器将双方连接起来,参见图2,中间库服务器作为接口系统,在中间库服务器数据库中分别创建Oracle Database DBLink (数据库链接方式)连接至O方数据库,以及JDBC (数据库链接方式)连接至S方数据库,在中间库服务器上数据库采用双方ERP系统都能通用的OracleDatabasellg数据库。 [0038] In a particular embodiment of the invention, the database server through an intermediate staging interface between the O and S side connecting both side together, see FIG. 2, as an intermediate interface to the database server system, are created in the middle of the library server database Oracle database DBLink (database link mode) is connected to the O side database, and JDBC (database link mode) to the S side of the database, the database uses both the ERP system can be common in the middle of OracleDatabasellg database library server. 用以实现双方互联,进行数据转换。 In order to achieve mutually interconnected, data conversion.

[0039] 在本发明的一个实施例中,在中间库服务器中创建两套数据架构模型,用于双方在数据抽取、转换和传输过程中存放抽取数据。 [0039], creating two intermediate data library server architecture model In one embodiment of the present invention, both for data extraction, transformation, and extracts data stored in the transmission process. 具体地,一方面,创建O方的数据架构模型,与O方数据库的数据架构相同,还创建S方的数据架构模型,与S方数据库的数据架构相同。 Specifically, on the one hand, to create a data model architecture O side, and data architecture O side of the same database, but also create a data architecture model S side, with the data structure S side of the same database.

[0040] 针对表I实施例,从O方数据库抽取所有员工的“学历”数据后,向O方的数据架构模型中的“学历”字段存放O方代码(按员工姓名位置排序的一系列20、30、40、50)。 [0040] Examples for the embodiments in Table I, extracted "degree" from the data for all employees side database O, O-party tags to the data storage architecture model O side of the "education" field (sorted by employee name a series of positions 20 , 30,40,50). 在完成O方代码到S方代码的映射转换后,将得到的S方代码(按员工姓名位置排序的一系列ZK、BK、SH、B0)存放于S方的数据架构模型中。 After completion of the mapping of O party code into the code converter side S, S party obtained codes (sorted by employee name a series of position ZK, BK, SH, B0) stored in the data model architecture of S side. 将S方代码发送给S方数据库可进行数据更新。 Transmitting the code to a side S S party database may be updated data.

[0041] 不同于表I实施例,对于例如S方关心的“人事事件”业务,参见图3,在O方并不存在该业务模块,也就不存在人事事件的信息数据,因此在数据抽取时无法获得“人事事件”业务数据。 [0041] The embodiment differs from the embodiment in Table I, for example, S party concerned about the "personnel event" traffic, see FIG. 3, the service module not present at the O side, there would be no personnel event information data, the data thus extracted unable to get "personnel event" business data.

[0042] 对此,在本发明的具体实施例中,不执行针对“人事事件”业务的数据抽取,而是抽取与“人事事件”业务相关的其它业务的数据,比如O方的“任职分配”业务,其含有员工录用、员工转正和岗位变动等字段信息。 [0042] In this regard, in a particular embodiment of the present invention, the data extraction is not performed for the "personnel event" operations, but to extract the data associated with "event personnel" service other services, such as "office party assigned O "business, which comprises employees hired, positive staff and job changes and other field information.

[0043] 具体地,根据O方的“任职分配”信息,通过分析和计算,能够反推得到员工的“人事事件”业务信息。 [0043] In particular, the "distribution office" information according to O side, through the analysis and calculation, thrust reversers can get employees' personnel event "business information. 例如,O方员工甲的“任职分配”业务里记载了员工甲在2001年I月I日至2001年5月31日期间的任职岗位为“试用工”,在2001年6月I日至2003年5月31日期间的任职岗位为“正式工”,在2003年6月I日至2005年5月31日期间的任职岗位为“助理工程师”,等等。 For example, O side employees armor "Service assigned a" business in the records of employees armor in 2001, I dated office jobs between I May 2001 May 31 date for the "trial work", in June 2001 I to 2003 post office between May 31 as "official workers", the post office between June 2003 to May of 2005 I was 31, "assistant engineer", and so on. 这隐含地表明,员工甲的“人事事件”业务信息有:2001年I月I日“员工录用”,2001年6月I日“员工见习期满”,2003年6月I日“调岗-助理工程师”,等等。 This implicitly indicates that employee A's "personnel event" Business Offers: 2001 I dated I May "employee hiring," June 2001 I day "probationary employee expires," June 2003 I Day "transfer Kong - assistant Engineer, "and so on. 这些分析推导出的信息可作为员工甲在S方的“人事事件”业务数据,将这些数据记为S方可识别的代码,存放在S方的数据架构模型中。 These analyzes information derived can be used as the employee A "personnel event" traffic data S side, this data is referred to codes recognizable only S, stored in the data model schema S party's. 表2示意性地列举了相关业务名称及代码。 Table 2 schematically cited relevant business name and code. 将代码传输给S方数据库,识别后进行人事事件业务的数据同步。 Data transmitted to the S side code database, service personnel after identifying the synchronization event. 关于所进行的分析推导,可按照具体业务信息之间的关联,利用两大系统字典类型转换匹配和适当的计算逻辑脚本以及数据转换逻辑效验规则,按需定义,从而通过源数据挖掘生成源系统中不存在、但在目标系统中存在的数据。 Derivation analysis performed, in accordance with the association between the specific business information system using two types of conversion dictionary and matching the appropriate calculation logic script and data conversion logic rules efficacy, defined as needed, to tap data from source system generating source It does not exist, but there is data in the target system.

[0044] [0044]

Figure CN103914526AD00091

[0045]表 2 [0045] TABLE 2

[0046] 另外,在利用本发明实施例的接口方法实现O方和S方数据传输同步的过程中,可能会出现不符合目标数据库要求的错误数据,因此设置数据校验环节。 [0046] Further, the interface method of the present invention, the implementation process of embodiments of O and S side of the synchronized data transmission side, an error may occur not meet the requirements of the target database data, thus parity data link is provided.

[0047] 参照图4,在中间库服务器中,对抽取到的某项业务的数据内容进行校验,当出现不符合目标数据库中相同业务的约束条件时,校验结果为校验有误,例如:目标数据库S方要求“学历”为专科以上的员工,需要同时录入“所学专业”信息,而源数据库O方的“所学专业”为选填项目。 [0047] Referring to FIG 4, in the middle of the library server, the data to extract the contents of a business check is performed, when the target does not meet the constraints appear in the database of the same service, parity check result is incorrect, For example: the target database S side "graduate" to more specialist staff, we need to enter information "learned profession", while the source database O side "learned professional" are optional items.

[0048] 那么,由于“所学专业”字段信息的缺失,对O方的“学历”数据的校验不通过,不进行数据的转换和发送,将校验错误信息记录下来,发回O方数据库以通知数据源维护人员进行针对性的数据库维护,增加需要的信息,在其它实施例中可能还需要进行修改和/或删除等维护,在下次同步时可再次抽取该业务字段完成同步。 [0048] Then, due to the lack of field information "learned professional" check on the "degree" O party data does not pass through, without conversion and transmission data, the parity error is recorded, back side O database data source to notify maintenance personnel targeted database maintenance, increase the required information, and the like may also need to be modified and / or deleted in other embodiments, the maintenance can be extracted again at the next synchronization completion of synchronization of the service field. 反之,如果双方的约束条件相同,表明可以直接同步,则校验通过,进入下一步代码转换或相关数据的分析处理等流程。 Conversely, if the two sides of the same constraint, showed directly synchronized by the check, the next step transcoding process or analyze data related to other processes. 可见,本发明的实施例可进行数据比对审核的功能,修正双方数据的差异性。 Seen, embodiments of the present invention may be compared to data auditing function, both corrected difference data.

[0049] 另外,在上述实施例中,可通过中间件系统收集中间库服务器中S方数据架构模型中存放的代码,参见图4,例如以SAP PI (Process Integration,流程集成)系统对S方数据架构模型进行监听读取,接收转换后的数据,由S方进行数据校验,校验正常的数据且转换成功的数据,发送到S方数据库。 [0049] Further, in the above embodiments, the middleware may be collected by the system code S intermediate party data repository server architecture model stored, see FIG. 4, for example, SAP PI (Process Integration, Process Integration) system side S reading the data architecture model monitor, receiving the converted data, check data by the S side, and converts normal data verification data is successfully transmitted to the S side database. 校验有误或转换不成功的数据,通过SAP PI系统向中间库服务器发出反馈,将对应业务也记录为校验错误,数据源维护人员可对其进行查看和维护。 Parity error or data conversion is unsuccessful, the feedback sent to the intermediate server via SAP PI library system, the corresponding service will be recorded as a parity error, the data source can be viewed maintenance personnel and maintenance. SAP PI系统作为SAP ERP系统与异构系统交换数据的中间件系统,采用标准接口技术,可提高系统灵活性,减少系统维护投入。 SAP PI system as SAP ERP system with heterogeneous systems to exchange data middleware system, using standard interface technology can improve the flexibility of the system, reduce system maintenance effort.

[0050] 类似地,在以O方数据库作为源数据库,以S方数据库作为目标数据库的实施例中,可利用ORACLE中间件系统对O方数据架构模型进行监听读取等处理。 [0050] Similarly, in the embodiment party database as an O source database to the target database as the database S side, a pair of O-party data may be listening architecture models using ORACLE processing such as reading middleware system.

[0051] 在本发明的一个实施例中,在中间库服务器中创建“全流程控制应用系统”,以中间库服务器数据库为基础,控制中间库服务器的工作全流程,维护人员通过系统操作界面进行查看和操作。 [0051] In one embodiment of the present invention, creating the intermediate repository server, "the whole process control applications", intermediate library server database based control operation among library server whole process, maintenance personnel through the system interface view and manipulate. 具体地,可通过JDBC方式在中间库服务器数据库上建立接口应用系统,采用J2EE架构的WEB应用方式,让维护人员通过WEB浏览器来操控双方数据同步全流程操作。 Specifically, the interface can build applications on the middle of the library server database via JDBC way, using J2EE WEB application architecture, which allows maintenance personnel to manipulate both the full data synchronization process operated by WEB browser.

[0052] 全流程控制应用系统可包括:接口系统配置维护界面、查看/维护转换规则界面、查看/维护验证效验规则界面、同步任务查看界面、错误数据查看界面和同步时间控制界面。 [0052] The full process control applications may include: an interface system configuration and maintenance interface Check / maintenance interface conversion rule check / validation maintain efficacy interface rules, synchronization task viewing interface, the error data and the synchronization time viewing interface control interface. 对于同步时间控制界面,其将同步时间分为两种:一是定时同步,按分、时、天、月为基础单位间隔进行同步操作;二是指定时间同步,按指定日期时间进行同步操作。 Control interface for time synchronization, time synchronization which is divided into two: First, timing synchronization, by minutes, hours, days, months intervals based synchronization unit; second specified time synchronization, synchronous operation at the specified date and time. [0053] 使用本发明的O方-S方接口方法,在首次实施双方数据同步时,可采用全量传输的方式,一次性地将源系统的全部业务的所有数据进行同步。 [0053] The present invention is used -S party side O interface method, data synchronization in both the first embodiment, the total amount of employed transmission mode, once the source of all data traffic system are synchronized. 在后期同步时采用增量传输的方式,针对特定时间段的增量业务信息进行同步,例如在上次传输同步时间到当前时间的区间内,个别业务数据的新增、修改和删除等。 In late synchronous mode when using incremental transfer, synchronize incremental business information for a specific period of time, for example, in the last synchronized transmission time interval to the current time, individual business data add, modify, delete, and so on.

[0054] 举例来讲,利用本发明实施例的方案,以某集团的ORACLE ERP人力资源子系统业务数据作为数据源,与该集团总部的SAP ERP人力资源子系统进行数据同步,其中可涉及到对系统业务数据的抽取、转换、效验、纠错和数据传输,还可能涉及到两大系统字典类型转换匹配、计算逻辑脚本以及数据转换逻辑效验规则等。 [0054] For example in terms of using the embodiment of the present invention embodiment, to a group of the ORACLE ERP human resources subsystem traffic data as the data source, the data subsystem with SAP ERP human resources of the synchronous group headquarters, which may involve system service data extraction, transformation, efficacy, error correction and data transmission, the system also may involve two types of conversion dictionary match computation logic script and data conversion logic rules efficacy. 方案上线后,首次采用全量传输,完成集团大部分组织机构中各岗位对象及相关附加信息的数据转换传输;全量传输完成后,采用增量、定时同步模式,按天进行增量数据传输,即每天固定时刻传输增量信息,进行两大系统的数据同步维护。 After the program line, the first time the total amount of transmission, completion of most organizations groups each job objects and data conversion transmission-related additional information; the total amount of the transfer is complete, incremental, timing synchronization mode, incremental data transfer by day, i.e., fixed time every day to transfer incremental information, data synchronization of two systems maintenance.

[0055] 除此之外,本发明还提供一种用于SAP ERP系统和ORACLE ERP系统的接口装置,参见图5,包括: [0055] In addition, the present invention provides an interface apparatus SAP ERP system and ORACLE ERP system is provided, see Figure 5, comprising:

[0056] 数据抽取模块101,用于从源数据库抽取第一业务对应的数据,确定该数据对应的第一源数据代码; [0056] The data extraction module 101 for extracting the first service corresponding to the data from the source database to determine the source of data corresponding to a first data symbol;

[0057] 数据转换模块102,用于基于预设的转换规则,将第一源数据代码转换为第一目标数据代码; [0057] The data conversion module 102, based on a predetermined conversion rule, first converting the source code for the first target data data codes;

[0058] 数据传输模块103,用于将第一目标数据代码发送至目标数据库,对目标数据库中的第一业务对应的数据进行更新。 [0058] The data transmission module 103, configured to send a first target data to the target database codes, the first target database corresponding to the service data is updated.

[0059] 其中,源数据库为SAP ERP系统数据库和ORACLE ERP系统数据库中的一者,目标数据库为另一者;转换规则包含对于第一业务对应的数据,从第一源数据代码到第一目标数据代码的映射关系。 [0059] wherein the source database and the database for the SAP ERP system ORACLE ERP system database of one, the other target database; comprising data conversion rule corresponding to the first service, data from a first source code to the first target mapping relational data code.

[0060] 利用本发明实现国际两大ERP系统在字段级别上的数据同步,可使一套企业数据信息在两大ERP系统中共用,将两套ERP系统自身的特点优势结合,弥补对方系统存在的不足。 [0060] The present invention enables the use of data in the two major international ERP system on field-level synchronization enables an enterprise data information shared by the two major ERP systems, will own characteristics combine the advantages of two ERP systems, to make up for the other systems exist deficiencies.

[0061]以上,结合具体实施例对本发明的技术方案进行了详细介绍,所描述的具体实施例用于帮助理解本发明的思想。 [0061] above with reference to specific technical solution of the present invention has been described in detail embodiments, specific embodiments are described to aid in understanding the inventive idea. 本领域技术人员在本发明具体实施例的基础上做出的推导和变型也属于本发明保护范围之内。 Made basic to those skilled in the embodiment of the present invention, the derivation and modifications also fall within the scope of the present invention.

Claims (16)

  1. 1.一种用于SAP ERP系统和ORACLE ERP系统的接口方法,其特征在于,包括: 数据抽取步骤,从源数据库抽取第一业务对应的数据,确定该数据对应的第一源数据代码; 数据转换步骤,基于预设的转换规则,将所述第一源数据代码转换为第一目标数据代码; 数据传输步骤,将第一目标数据代码发送至目标数据库,对目标数据库中的第一业务对应的数据进行更新;其中, 所述源数据库为SAP ERP系统数据库和ORACLE ERP系统数据库中的一者,所述目标数据库为另一者; 所述转换规则包含对于所述第一业务对应的数据,从第一源数据代码到第一目标数据代码的映射关系。 An interface method SAP ERP system and ORACLE ERP system, characterized by comprising: a data extraction step of extracting data corresponding to the first service from the source database, determines that the data corresponding to a first data source codes; data conversion step, based on a predetermined conversion rule, first converting the source code for the first target data codes data; a data transmission step of transmitting a first target data to the target database codes, the first target database corresponding to the services updated data; wherein said source database is a database system and SAP ERP ORACLE ERP system database of one, the other of the target database; the conversion rule for the first service comprises data corresponding a first data mapping from source code into the first target code data.
  2. 2.如权利要求1所述的用于SAP ERP系统与ORACLE ERP系统的接口方法,其特征在于,其中,所述数据转换步骤在中间库服务器中进行,中间库服务器通过Oracle DatabaseDBLink数据库链接方式与ORACLE ERP系统连接,还通过JDBC数据库链接方式与SAP ERP系统连接。 2. A method as claimed in claim Interface SAP ERP system and ORACLE ERP system for the 1, characterized in that wherein said data conversion step in intermediate database server, database server through the intermediate database links manner Oracle DatabaseDBLink ORACLE ERP system is connected, also connected with the SAP ERP system via JDBC database link mode.
  3. 3.如权利要求2所述的用于SAP ERP系统与ORACLE ERP系统的接口方法,其特征在于,如果所述第一业务同时存在于源数据库和目标数据库中,所述方法还包括: 在所述数据抽取步骤之后,将所述第一源数据代码存放在源数据库对应的源数据架构模型中;并且, 在所述数据转换步骤之后、所述数据传输步骤之前,将所述第一目标数据代码存放在目标数据库对应的目标数据架构模型中;其中, 所述源数据架构模型的数据架构与源数据库的数据架构相同,所述目标数据架构模型的数据架构与目标数据库的数据架构相同,所述源数据架构模型和所述目标数据架构模型设置于所述中间库服务器中。 A method as claimed in claim SAP ERP system interfaces with a system for the ORACLE ERP 2, wherein, if the first service exist in both the source and target databases, the method further comprising: in the after said data extraction step, the first source code is stored in the source database data corresponding to the source data schema model; and, after the data conversion step, prior to the data transmission step, the first target data the code stored in the target database schema corresponding target data model; wherein the same data source schema data structure and the source database data model architecture, the same data structure and data schema of the target database schema object data model, the said source data architecture model and the target data provided in said intermediate model architecture library server.
  4. 4.如权利要求2所述的用于SAP ERP系统与ORACLE ERP系统的接口方法,其特征在于,如果目标数据库中存在所述第一业务,源数据库中不存在所述第一业务,所述方法还包括: 在所述数据抽取步骤之前,挂起所述数据抽取步骤和所述数据转换步骤,触发预设数据抽取步骤,从源数据库抽取预设的至少一项业务对应的数据,所述预设的至少一项业务与所述第一业务有关; 数据分析处理步骤,根据抽取到的所述至少一项业务对应的数据,获得所述第一业务对应的数据,并确定所述第一业务对应的数据所对应的第一目标数据代码; 将所述第一目标数据代码存放在目标数据库对应的目标数据架构模型中;其中, 所述目标数据架构模型的数据架构与目标数据库的数据架构相同,所述目标数据架构模型设置于所述中间库服务器中。 A method as claimed in claim SAP ERP system interfaces with a system for the ORACLE ERP 2, wherein, if the first service is present in the target database, the source database and the first service does not exist, the the method further comprising: prior to the data extraction step, suspending the data extraction step and said data conversion step, the preset trigger data extraction step of extracting predetermined data corresponding to the at least one service from the source database, the at least one predetermined service related to the first service; data analysis processing step, according to said extracted data corresponding to the at least one service, to obtain data corresponding to the first service, and determining a first service data corresponding to the first target data corresponding to the code; the first target data corresponding to the code stored in the destination target database data model architecture; data schema data structure and wherein the target database, the target data schema model the same as the target data provided in said intermediate model architecture library server.
  5. 5.如权利要求1所述的用于SAP ERP系统与ORACLE ERP系统的接口方法,其特征在于,在所述数据抽取步骤之后、所述数据转换步骤之前,所述方法还包括: 数据校验步骤,基于预设的校验规则,对抽取到的第一业务对应的数据进行验证,当该数据不符合校验规则时,放弃本次数据传输,记录本次校验错误信息;其中,所述校验规则包含目标数据库中所述第一业务的数据信息约束条件。 A method as claimed in claim Interface SAP ERP system and ORACLE ERP system for the 1, wherein, after the data extraction step, prior to said data conversion step, the method further comprises: checking data step, based on a preset validation rules, the extraction of the data corresponding to the first service to verify, when the data does not meet the validation rules, give up this data transmission, this parity error record; wherein the said constraint information data validation rules contained in the target database of the first service.
  6. 6.如权利要求1所述的用于SAP ERP系统与ORACLE ERP系统的接口方法,其特征在于,在所述数据传输步骤中,通过中间件系统将所述第一目标数据代码发送至目标数据库,所述中间件系统包括SAP PI中间件或ORACLE中间件。 A method as claimed in claim Interface SAP ERP system and ORACLE ERP system for the 1, wherein, in the data transmission step, the first target middleware data codes sent to the destination database , said intermediate system comprising SAP PI middleware middleware or ORACLE.
  7. 7.如权利要求2所述的用于SAP ERP系统与ORACLE ERP系统的接口方法,其特征在于,所述方法还包括: 通过全流程控制应用系统提供的操作界面对中间库服务器中的数据进行查看和/或维护;其中, 所述全流程控制应用系统位于中间库服务器,包括:接口系统配置维护界面、查看/维护转换规则界面、查看/维护验证效验规则界面、同步任务查看界面、错误数据查看界面和冋步时间控制界面。 A method as claimed in claim SAP ERP system interfaces with a system for the ORACLE ERP 2, characterized in that, said method further comprising: providing the whole process by the system control application database interface to the data intermediate server is view and / or maintenance; wherein the whole process control applications in the middle of the database server, comprising: an interface system configuration and maintenance interface Check / maintenance conversion rule interface to view / maintain validation efficacy rule interface, synchronization task to view the interface, the error data View interface and Jiong step time control interface.
  8. 8.如权利要求7所述的用于SAP ERP系统与ORACLE ERP系统的接口方法,其特征在于,所述同步时间控制界面将同步时间分为以下两种:一是固定时间同步,按分、时、天或月为单位时间间隔进行周期性地同步;二是指定时间同步,在预先指定的时刻进行同步。 First, a fixed time synchronization, by minutes, hours: interfacing method as claimed in claim ORACLE ERP system and the SAP ERP system for the 7, wherein said control interface synchronization time synchronization time is divided into the following two , days or months periodically synchronizing time intervals; second specified time synchronization, synchronization timing specified in advance.
  9. 9.一种用于SAP ERP系统和ORACLE ERP系统的接口装置,其特征在于,包括: 数据抽取模块,用于从源数据库抽取第一业务对应的数据,确定该数据对应的第一源数据代码; 数据转换模块,用于基于预设的转换规则,将所述第一源数据代码转换为第一目标数据代码; 数据传输模块,用于将第一目标数据代码发送至目标数据库,对目标数据库中的第一业务对应的数据进行更新;其中, 所述源数据库为SAP ERP系统数据库和ORACLE ERP系统数据库中的一者,所述目标数据库为另一者; 所述转换规则包含对于所述第一业务对应的数据,从第一源数据代码到第一目标数据代码的映射关系。 An interface apparatus SAP ERP system and ORACLE ERP system, characterized by comprising: a data extraction module for extracting the first service corresponding to the data from the source database, determines that the data corresponding to a first data source codes ; data conversion module, based on a predetermined conversion rule, first converting the source code for the first target data codes data; a data transmission means for transmitting a first target data codes to the target database, a target database the first service corresponding to the updated data; wherein said source database is a database system and SAP ERP ORACLE ERP system database of one, the other of the target database; comprises the conversion rule for said second corresponding to a data service, a first mapping from source data code into the first target code data.
  10. 10.如权利要求9所述的用于SAP ERP系统与ORACLE ERP系统的接口装置,其特征在于,其中,所述数据转换模块设置于中间库服务器中,中间库服务器通过Oracle DatabaseDBLink数据库链接方式与ORACLE ERP系统连接,还通过JDBC数据库链接方式与SAP ERP系统连接。 10. The interface apparatus as claimed in claim ORACLE ERP system and the SAP ERP system for claim 9, wherein, wherein said conversion module is disposed in the intermediate data library server, a database server through the intermediate database links manner Oracle DatabaseDBLink ORACLE ERP system is connected, also connected with the SAP ERP system via JDBC database link mode.
  11. 11.如权利要求10所述的用于SAP ERP系统与ORACLE ERP系统的接口装置,其特征在于,如果所述第一业务同时存在于源数据库和目标数据库中,所述装置还包括: 第一存放处理模块,用于在数据抽取之后,将所述第一源数据代码存放在源数据库对应的源数据架构模型中;并且, 第二存放处理模块,用于在数据转换之后、数据传输之前,将所述第一目标数据代码存放在目标数据库对应的目标数据架构模型中;其中, 所述源数据架构模型的数据架构与源数据库的数据架构相同,所述目标数据架构模型的数据架构与目标数据库的数据架构相同,所述源数据架构模型和所述目标数据架构模型设置于所述中间库服务器中。 11. The interface apparatus as claimed in claim SAP ERP system for the ORACLE ERP system 10, wherein, if the first service exist in both the source and target databases, the apparatus further comprises: a first storing a processing module, configured to, after extracting the data, the first source code is stored in the source database data corresponding to source data schema model; and the second processing module is stored, after the data conversion, prior to data transmission, the first target data corresponding to the code stored in the destination target database data model architecture; wherein the same data source schema data structure and the source database data model architecture, data architecture of the target model and the target data schema the same database schema data, the source data and the target data schema model is provided in said intermediate model architecture library server.
  12. 12.如权利要求10所述的用于SAP ERP系统与ORACLE ERP系统的接口装置,其特征在于,如果目标数据库中存在所述第一业务,源数据库中不存在所述第一业务,所述装置还包括: 触发处理模块,用于在数据抽取之前挂起所述数据抽取模块和所述数据转换模块,触发预设数据抽取模块; 所述预设数据抽取模块用于从源数据库抽取预设的至少一项业务对应的数据,所述预设的至少一项业务与所述第一业务有关; 数据分析处理模块,用于根据抽取到的所述至少一项业务对应的数据,获得所述第一业务对应的数据,并确定所述第一业务对应的数据所对应的第一目标数据代码; 第三存放处理模块,用于将所述第一目标数据代码存放在目标数据库对应的目标数据架构模型中;其中, 所述目标数据架构模型的数据架构与目标数据库的数据架构相同,所述目标数据架构模 12. The interface apparatus as claimed in claim SAP ERP system for the ORACLE ERP system 10, wherein, if the first service is present in the target database, the source database and the first service does not exist, the apparatus further comprising: a trigger processing module to suspend the data extraction module and the data conversion module before the data extraction, data extraction module preset trigger; said preset data extraction module for extracting from the source a preset database at least one service data corresponding to the predetermined at least one of the first service-related service; data analysis module, at least for a corresponding service according to the extracted data to obtain the data corresponding to the first service, and determines the first target data corresponding to the code of the first service data corresponds; storing a third processing module for said first target data codes stored in the database corresponding to the target data of the target architectural model; wherein the same data structure and data architecture target database architecture model of the target data, the target data schema mold 型设置于所述中间库服务器中。 Type disposed in said intermediate database server.
  13. 13.如权利要求9所述的用于SAP ERP系统与ORACLE ERP系统的接口装置,其特征在于,在数据抽取之后、数据转换之前,所述装置还包括: 数据校验模块,用于基于预设的校验规则,对抽取到的第一业务对应的数据进行验证,当该数据不符合校验规则时,放弃本次数据传输,记录本次校验错误信息;其中, 所述校验规则包含目标数据库中所述第一业务的数据信息约束条件。 13. The interface device of claim ORACLE ERP system and the SAP ERP system for claim 9, wherein, after the data extraction, data before conversion, said apparatus further comprising: a data check module, based on pre- set of validation rules, the extraction of the data corresponding to the first service to verify, when the data does not meet the validation rules, give up this data transmission, this parity error record; wherein the validation rules a target database comprising data information in the first service constraints.
  14. 14.如权利要求9所述的用于SAP ERP系统与ORACLE ERP系统的接口装置,其特征在于,还包括中间件系统,所述数据传输模块通过中间件系统将所述第一目标数据代码发送至目标数据库,所述中间件系统包括SAP PI中间件或ORACLE中间件。 14. The interface device of claim ORACLE ERP system and the SAP ERP system for claim 9, characterized in that the system further includes a middleware, the data transmission module to the system through a first intermediate transmission target data codes to the target database, the middleware system comprises a SAP PI middleware middleware or ORACLE.
  15. 15.如权利要求10所述的用于SAP ERP系统与ORACLE ERP系统的接口装置,其特征在于,所述装置还包括: 全流程控制应用系统,用于提供操作界面以对中间库服务器中的数据进行查看和/或维护;其中, 所述全流程控制应用系统位于中间库服务器,包括:接口系统配置维护界面、查看/维护转换规则界面、查看/维护验证效验规则界面、同步任务查看界面、错误数据查看界面和冋步时间控制界面。 15. The interface device of claim SAP ERP system and the system for the ORACLE ERP 10, characterized in that said apparatus further comprises: a full process control applications, for providing a user interface to the intermediate library server check the data and / or maintenance; wherein the whole process control applications in the middle of the database server, comprising: an interface system configuration and maintenance interface Check / maintenance conversion rule interface to view / maintain validation efficacy rule interface, synchronization task viewing interface, data View interface and error Jiong step time control interface.
  16. 16.如权利要求15所述的用于SAP ERP系统与ORACLE ERP系统的接口装置,其特征在于,所述同步时间控制界面将同步时间分为以下两种:一是固定时间同步,按分、时、天或月为单位时间间隔进行周期性地同步;二是指定时间同步,在预先指定的时刻进行同步。 16. The interface device of claim SAP ERP system for ORACLE ERP system of claim 15, wherein said control interface synchronization time synchronization time is divided into the following two: First, a fixed time synchronization, by minutes, hours , days or months periodically synchronizing time intervals; second specified time synchronization, synchronization timing specified in advance.
CN 201410120656 2014-03-27 2014-03-27 A method and apparatus for an interface system and the SAP ERP system for oracle erp CN103914526B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201410120656 CN103914526B (en) 2014-03-27 2014-03-27 A method and apparatus for an interface system and the SAP ERP system for oracle erp

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201410120656 CN103914526B (en) 2014-03-27 2014-03-27 A method and apparatus for an interface system and the SAP ERP system for oracle erp

Publications (2)

Publication Number Publication Date
CN103914526A true true CN103914526A (en) 2014-07-09
CN103914526B CN103914526B (en) 2017-06-16

Family

ID=51040206

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201410120656 CN103914526B (en) 2014-03-27 2014-03-27 A method and apparatus for an interface system and the SAP ERP system for oracle erp

Country Status (1)

Country Link
CN (1) CN103914526B (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104484164A (en) * 2014-11-20 2015-04-01 朱敏 Method and system for processing data in an ERP (Enterprise Resource Planning) environment
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
CN105404527A (en) * 2015-09-24 2016-03-16 国网山东省电力公司 Interface configuration method and system based on SAP (System Applications and Products in Data Processing) platform
CN105677384A (en) * 2015-12-28 2016-06-15 上海爱数信息技术股份有限公司 System supporting information synchronization of organizations and users between different application systems

Citations (4)

* Cited by examiner, † Cited by third party
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
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

Patent Citations (4)

* Cited by examiner, † Cited by third party
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
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

Cited By (4)

* Cited by examiner, † Cited by third party
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
CN105404527A (en) * 2015-09-24 2016-03-16 国网山东省电力公司 Interface configuration method and system based on SAP (System Applications and Products in Data Processing) platform
CN105677384A (en) * 2015-12-28 2016-06-15 上海爱数信息技术股份有限公司 System supporting information synchronization of organizations and users between different application systems

Also Published As

Publication number Publication date Type
CN103914526B (en) 2017-06-16 grant

Similar Documents

Publication Publication Date Title
Rozinat et al. Workflow simulation for operational decision support
Jagadish et al. Big data and its technical challenges
US7299216B1 (en) Method and apparatus for supervising extraction/transformation/loading processes within a database system
US7814142B2 (en) User interface service for a services oriented architecture in a data integration platform
US20060161460A1 (en) System and method for a graphical user interface for healthcare data
US20140040182A1 (en) Systems and methods for collection and consolidation of heterogeneous remote business data using dynamic data handling
US20050210026A1 (en) Software architecture and system for performing validated clinical studies of pharmaceutical related products
US20050223109A1 (en) Data integration through a services oriented architecture
US20060010195A1 (en) Service oriented architecture for a message broker in a data integration platform
US20030144969A1 (en) Method and system for the management of professional services project information
US20050222931A1 (en) Real time data integration services for financial information data integration
US20050228808A1 (en) Real time data integration services for health care information data integration
US20050262189A1 (en) Server-side application programming interface for a real time data integration service
US20060069717A1 (en) Security service for a services oriented architecture in a data integration platform
US20050235274A1 (en) Real time data integration for inventory management
US20050262192A1 (en) Service oriented architecture for a transformation function in a data integration platform
US20050262193A1 (en) Logging service for a services oriented architecture in a data integration platform
US20070112579A1 (en) Market management system
Cooper Knowledge management and tourism
US20080133300A1 (en) System and apparatus for enterprise resilience
US20030131018A1 (en) Common business data management
Langer Analysis and design of information systems
US20040249854A1 (en) Common common object
US20120072464A1 (en) Systems and methods for master data management using record and field based rules
US20120089562A1 (en) Methods and Apparatus for Integrated Management of Structured Data From Various Sources and Having Various Formats

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination