CN105701187B - Process integrated service device and the method for realizing system combination using it - Google Patents
Process integrated service device and the method for realizing system combination using it Download PDFInfo
- Publication number
- CN105701187B CN105701187B CN201610012472.8A CN201610012472A CN105701187B CN 105701187 B CN105701187 B CN 105701187B CN 201610012472 A CN201610012472 A CN 201610012472A CN 105701187 B CN105701187 B CN 105701187B
- Authority
- CN
- China
- Prior art keywords
- business datum
- log
- adapter
- database
- database server
- 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
A method of system combination is realized using process integrated service device, comprising: receives the txt file that file adapter is sent；The business datum of needs is inquired in database server by the query sentence of database in the txt file；The business datum that this is inquired is converted to the business datum for meeting remote function calls adapter access stencil；It will be in the business datum write-in SAP system that remote function calls adapter access stencil be met；It receives SAP system and executes the log returned after the business datum；And the log for meeting Java database connection adapter access stencil is sent to database server, the corresponding service data in database server are updated using the log.The present invention also provides a kind of process integrated service devices quickly can write data to SAP system from database server using the present invention, and receive the implementing result of SAP system return.
Description
Technical field
System combination is realized the present invention relates to a kind of server more particularly to a kind of process integrated service device and using it
Method.
Background technique
With the continuous propulsion of IT application process, there are more and more application systems, such as goods entry, stock and sales in enterprises
System, purchasing system, accounting system, bonded system, logistics system and marketing system.Each application system has different data
Format and the different data storage method of use, such as database (such as SQL server or Visual Fox) is utilized to store number
According to.It is original introducing SAP (Systems Applications and Products in Data Processing) system
When application system, there are multiple lists due to data format and the difference of data storage method, and in the database server
When, needing to obtain corresponding data from multiple lists and SAP is written becomes highly difficult.
Summary of the invention
In view of the foregoing, it is necessary to a kind of process integrated service device is provided, it can quickly will be in database server
Business datum is written in SAP system, and receives the implementing result of SAP system return.
It there is a need to provide a kind of method for realizing system combination using process integrated service device, it can be quickly by database
Business datum in server is written in SAP system, and receives the implementing result of SAP system return.
A kind of process integrated service device, the process integrated service device are connected to database server and SAP system, the data
Multiple lists are stored in the server of library, the process integrated service device include file adapter, remote function calls adapter and
Java database connects adapter, which is characterized in that the process integrated service device further include:
Module is obtained, for receiving the suffix of file adapter transmission as the txt file of txt, the content of the txt file is
Query sentence of database；
Enquiry module is looked into for sending txt file into database server, and by the database in the txt file
Ask the business datum that sentence inquires needs in the database server.
The acquisition module, is also used to receive the obtained business datum of inquiry from database server, and by the inquiry
To business datum be converted to and meet the business datum of remote function calls adapter access stencil, each business datum has pair
The mark answered, and the field in the list and the list where the business datum where the business datum is described in identifying；
Writing module, for SAP system to be written in the business datum for meeting remote function calls adapter access stencil
In system；
Receiving module executes the log returned after the business datum for receiving SAP system, and the log is converted to
Meet the log of Java database connection adapter access stencil；And
The sending module is also used to the log for meeting Java database connection adapter access stencil being sent to data
Library server updates the corresponding service data in database server using the log.
A method of system combination is realized using process integrated service device, which is connected to database
Server and SAP system, and adapter is connected including file adapter, remote function calls adapter and Java database,
It is characterized in that, this method comprises the following steps:
The txt file that the suffix that file adapter is sent is txt is received, the content of the txt file is data base querying language
Sentence；
Txt file is sent into database server, and by the query sentence of database in the txt file in the data
The business datum of needs is inquired in the server of library；
The business datum that inquiry obtains is received from database server, and the business datum that this is inquired is converted to symbol
The business datum of remote function calls adapter access stencil is closed, each business datum has corresponding mark, and remembers in mark
The field in the list and the list where the business datum where the business datum is carried；
It will be in the business datum write-in SAP system that remote function calls adapter access stencil be met；
It receives SAP system and executes the log returned after the business datum, and the log is converted to and meets Java data
The log of library connection adapter access stencil；And
The log for meeting Java database connection adapter access stencil is sent to database server, utilizes the log
Update the corresponding service data in database server.
Compared to the prior art, the process integrated service device and the method for realizing system combination using it, according to user
It is required that searching the business datum for meeting querying condition in database in each list, SAP system is mentioned using process integrated service device
The business datum inquired described in the function reception of confession, and the log for executing the business datum is returned into database server,
Update the data in database server in corresponding list.
Detailed description of the invention
Fig. 1 is that the running environment of method preferred embodiment of the present invention using the realization system combination of process integrated service device is shown
It is intended to.
Fig. 2 is the work flow for the method preferred embodiment that the present invention realizes system combination using process integrated service device
Figure.
Main element symbol description
Specific embodiment
As shown in Figure 1, being the fortune for the method preferred embodiment that the present invention realizes system combination using process integrated service device
Row environment schematic.The process integrates (process integration, PI) server 1 (hereinafter referred to as are as follows: PI server 1)
It is connected to file system 2, database server 3 and SAP system 4.The PI server 1 is connected by database and data
Library server 3 is communicated, and database connection can be Open Database Connection (Open Database
Connectivity, ODBC), Java database connects (Java Data Base Connectivity, JDBC) etc..In this reality
It applies in example, which is connected as JDBC.It should be pointed out that in the present embodiment, which receives database service
The process of data in device 3 is and to require synchronous returned data by 1 clocked flip of PI server.
Multiple lists are stored in the database server 3, and multiple business datums are stored in each list.The database
Server 3 can be set to interior JXC System, purchasing system, accounting system, bonded system, logistics system and the marketing system of enterprise
In.
The PI server 1 is used for database service as the middleware between database server 3 and the SAP system 4
Data transmission between device 3 and SAP system 4.The PI server 1 includes file adapter (file adapter) 10, JDBC
Adapter (JDBC adapter) 11 and remote function calls adapter (remote function call adapter, RFC
adapter)12.For the file adapter 10 for reading txt file from file system 2, which is data
Library inquiry sentence.This document system 2 is File Transfer Protocol (File Transfer Protocol, FTP) server or local
File server etc..In the present embodiment, which is structured query language (Structured Query
Language, SQL).The JDBC adapter 11 is utilized for the query statement to be sent in database server 3
Business datum required for the query sentence of database is inquired.The RFC adapter 12 is for the business datum to be written
In SAP system 4, and receive the log for executing the business datum that SAP system 4 is returned.
The SAP system 4 further includes RFC interface 40, and the RFC interface 40 is as logical between PI server 1 and SAP system 4
Interface is believed, for receiving the business datum from RFC adapter 12.
JDBC adapter 11 in the PI server 1 includes: to obtain module 100, enquiry module 101 and transmission mould
Block 102.RFC adapter 12 includes: writing module 110, receiving module 111 and delivery module 112.The module is that have
The software program section of specific function, the software are stored in computer readable storage medium or other storage equipment, can be by computer
Or other computing devices comprising processor execute, middle utilization PI server 1 realizes the work of system combination thereby completing the present invention
Industry process.
The txt file that module 100 is used to receive the transmission of file adapter 10 is obtained, the content of the txt file is data
Library inquiry sentence, and format is the format for meeting the access of JDBC adapter 11.
Enquiry module 101 passes through the data in the txt file for sending the txt file into database server 3
Library inquiry sentence inquires the business datum of needs in the database server 3.
The module 100 that obtains is also used to receive the business datum that inquiry obtains from database server 3, and this is looked into
The business datum ask is converted to the business datum for meeting 12 access stencil of RFC adapter.Each business datum has correspondence
Mark, the business datum institute in the list and the list at the place for describing the business datum in the mark of each business datum
Field.
Sending module 102 is for sending the business datum for meeting 12 access stencil of RFC adapter to the RFC
adapter 12。
SAP system is written by RFC interface 40 in the business datum that writing module 110 is used to send the sending module 102
In system 4.
Receiving module 111 executes the log returned after the business datum, the format of the log for receiving SAP system 4
It is the format for meeting the access of RFC adapter 12.In the present embodiment, which includes the execution knot for executing each business datum
Fruit, the implementing result include the reason of running succeeded or execute the information of failure and execute failure.The receiving module 111 is also
Log for receiving this is converted to the log for meeting 11 access stencil of JDBC adapter.
Delivery module 112 is used to this meeting the Log Shipping of 11 access stencil of JDBC adapter to JDBC
adapter 11。
The sending module 102 is also used to the log that delivery module 112 transmits being sent to database server 3, utilizes
The implementing result of each business datum updates the business datum in database server 2 in corresponding list in the log.Specifically
For, which is found corresponding in database server 3 by the corresponding mark of business datum each in the log
Correspondence field in list updates the data in the field found using the implementing result of business datum each in log.
As shown in Fig. 2, being the work for the method preferred embodiment that the present invention realizes system combination using process integrated service device
Industry flow chart.
Step S30, file adapter 10 reads txt text according to time interval set by user from file system 2
The content of part, the txt file is query sentence of database, and by the txt file to meet the lattice that JDBC adapter 11 is accessed
Formula indicates.In the present embodiment, which can be 1 day.In other embodiments, the time interval is not
It is limited to 1 day, can be customized by users.
Step S31 obtains module 100 and receives the txt file that file adapter 10 is sent.
Step S32, enquiry module 101 send the txt file into database server 3, and by the txt file
Query sentence of database inquires the business datum of needs in the database server 3.
Step S33, the module 100 that obtains receive the business datum that inquiry obtains from database server 3, and should
The business datum inquired is converted to the business datum for meeting 12 access stencil of RFC adapter.Each business datum has pair
The mark answered describes the business datum institute in the list and the list where the business datum in the mark of each business datum
Field.
Step S34, sending module 102 send this and meet business datum of 12 access stencil of RFC adapter to described
RFC adapter 12。
The business datum that the sending module 102 is sent is written by RFC interface 40 for step S35, writing module 110
In SAP system 4.
Step S36, receiving module 111 receive SAP system 4 and execute the log returned after the business datum, the log
Format is the format for meeting the access of RFC adapter 12.In the present embodiment, which includes the execution knot of each business datum
Fruit, the implementing result include the reason of running succeeded or execute the information of failure and execute failure.
Step S37, the log which receives this, which is converted to, meets the access lattice of JDBC adapter 11
The log of formula.
The log that delivery module 112 transmits is sent to database server 3 by step S38, the sending module 102, benefit
The business datum in database server 2 in corresponding list is updated with the implementing result of each business datum in the log.Tool
For body, the sending module 102 is right in database server 3 to find by the corresponding mark of business datum each in the log
The correspondence field in list is answered, updates the number in the field found using the implementing result of business datum each in log
According to.
It should be noted last that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although ginseng
It is described the invention in detail according to preferred embodiment, those skilled in the art should understand that, it can be to the present invention
Technical solution modify or equivalent replacement, without departing from the spirit and scope of the technical solution of the present invention.
Claims (5)
1. a kind of process integrated service device, which is connected to database server and SAP system, the database
Multiple lists are stored in server, the process integrated service device include file adapter, remote function calls adapter and
Java database connects adapter, which is characterized in that the process integrated service device further include:
Module is obtained, the txt file that the suffix for receiving file adapter transmission is txt, the content of the txt file is data
Library inquiry sentence；
Enquiry module for sending txt file into database server, and passes through the data base querying language in the txt file
Sentence inquires the business datum of needs in the database server；
The acquisition module is also used to receive the business datum that inquiry obtains from database server, and this is inquired
Business datum is converted to the business datum for meeting remote function calls adapter access stencil, and each business datum has corresponding
Mark, and the field in the list and the list where the business datum where the business datum is described in identifying；
Writing module, the business datum for that described will meet remote function calls adapter access stencil are written in SAP system；
Receiving module executes the log returned after the business datum for receiving SAP system, and the log is converted to and is met
The log of Java database connection adapter access stencil；And
The sending module is also used to the log for meeting Java database connection adapter access stencil being sent to database clothes
Business device, utilizes the log to update the corresponding service data in database server.
2. process integrated service device as described in claim 1, which is characterized in that the SAP system executes the business datum
It include the reason of executing the information for running succeeded or executing failure of each business datum and execute failure in the log of return.
3. process integrated service device as described in claim 1, which is characterized in that the SAP system includes remote function calls
Interface gives the process integrated service device for receiving business datum from process integrated service device and sending the log.
4. a kind of method for realizing system combination using process integrated service device, which is connected to database clothes
Business device and SAP system, and adapter is connected including file adapter, remote function calls adapter and Java database, it is special
Sign is that this method comprises the following steps:
The txt file that the suffix that file adapter is sent is txt is received, the content of the txt file is query sentence of database；
Txt file is sent into database server, and is taken by the query sentence of database in the txt file in the database
The business datum of needs is inquired in business device；
The business datum that inquiry obtains is received from database server, and the business datum that this is inquired is converted to and meets far
The business datum of journey function call adapter access stencil, each business datum has corresponding mark, and describes in mark
Field in list and the list where the business datum where the business datum；
It will be in the business datum write-in SAP system that remote function calls adapter access stencil be met；
It receives SAP system and executes the log returned after the business datum, and the log is converted to and meets Java database company
Connect the log of adapter access stencil；And
The log for meeting Java database connection adapter access stencil is sent to database server, is updated using the log
Corresponding service data in database server.
5. the method for realizing system combination using process integrated service device as claimed in claim 4, which is characterized in that described
SAP system executes what running succeeded or executing including each business datum of execution in the log that the business datum returns failed
The reason of information and execution failure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610012472.8A CN105701187B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610012472.8A CN105701187B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
| CN201010253319.7A CN102376016B (en) | 2010-08-13 | 2010-08-13 | Flow process integrated service device and utilize it to realize the method for system combination |
Related Parent Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010253319.7A Division CN102376016B (en) | 2010-08-13 | 2010-08-13 | Flow process integrated service device and utilize it to realize the method for system combination |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105701187A CN105701187A (en) | 2016-06-22 |
| CN105701187B true CN105701187B (en) | 2019-04-26 |
Family
ID=45794584
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610012472.8A Active CN105701187B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
| CN201010253319.7A Expired - Fee Related CN102376016B (en) | 2010-08-13 | 2010-08-13 | Flow process integrated service device and utilize it to realize the method for system combination |
Family Applications After (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010253319.7A Expired - Fee Related CN102376016B (en) | 2010-08-13 | 2010-08-13 | Flow process integrated service device and utilize it to realize the method for system combination |
Country Status (1)
| Country | Link |
|---|---|
| CN (2) | CN105701187B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10956139B2 (en) * | 2018-11-26 | 2021-03-23 | Sap Se | Integration process to integration adapter connector |
| CN111339177A (en) * | 2020-03-11 | 2020-06-26 | 南京金信通信息服务有限公司 | SAP platform-based data export method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1998056143A2 (en) * | 1997-06-02 | 1998-12-10 | Nokia Networks Oy | Procedure for the switching of data traffic in a data communication system |
| CN101097579A (en) * | 2006-06-27 | 2008-01-02 | Sap股份公司 | Systems and methods for providing a mockup data generator |
| EP1916599A1 (en) * | 2006-10-26 | 2008-04-30 | Intellectual Business Machines Corporation | Method, system and computer program for configuring server farms at minimum cost |
| CN101212719A (en) * | 2006-12-31 | 2008-07-02 | 华为技术有限公司 | Method and system for implementing converged message service in radio communication network |
| CN101216817A (en) * | 2007-12-29 | 2008-07-09 | 中国建设银行股份有限公司 | Heterogeneous report form integration and centralized management device and system |
| CN101686581A (en) * | 2008-09-22 | 2010-03-31 | 中国移动通信集团北京有限公司 | Mobile communication business service system and business processing method thereof |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2428240A1 (en) * | 2000-11-09 | 2002-05-16 | Accenture Llp | System and method for interfacing a data processing system to a business-to-business integration system |
| CA2438362C (en) * | 2003-08-26 | 2011-05-31 | John William Comeau | A method and system for synchronizing a client user interface with server backend |
| CN101562606A (en) * | 2008-04-17 | 2009-10-21 | 鸿富锦精密工业（深圳）有限公司 | Open type data calling system and method |
-
2010
- 2010-08-13 CN CN201610012472.8A patent/CN105701187B/en active Active
- 2010-08-13 CN CN201010253319.7A patent/CN102376016B/en not_active Expired - Fee Related
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1998056143A2 (en) * | 1997-06-02 | 1998-12-10 | Nokia Networks Oy | Procedure for the switching of data traffic in a data communication system |
| CN101097579A (en) * | 2006-06-27 | 2008-01-02 | Sap股份公司 | Systems and methods for providing a mockup data generator |
| EP1916599A1 (en) * | 2006-10-26 | 2008-04-30 | Intellectual Business Machines Corporation | Method, system and computer program for configuring server farms at minimum cost |
| CN101212719A (en) * | 2006-12-31 | 2008-07-02 | 华为技术有限公司 | Method and system for implementing converged message service in radio communication network |
| CN101216817A (en) * | 2007-12-29 | 2008-07-09 | 中国建设银行股份有限公司 | Heterogeneous report form integration and centralized management device and system |
| CN101686581A (en) * | 2008-09-22 | 2010-03-31 | 中国移动通信集团北京有限公司 | Mobile communication business service system and business processing method thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102376016B (en) | 2016-04-13 |
| CN105701187A (en) | 2016-06-22 |
| CN102376016A (en) | 2012-03-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20150378721A1 (en) | Methods for managing applications using semantic modeling and tagging and devices thereof | |
| CN100547545C (en) | The method and system that is used for the application fractionation of network edge calculating | |
| CN106814982A (en) | Label print processing device, system and method | |
| US20160162470A1 (en) | Semantic Application Logging and Analytics | |
| US20100257260A1 (en) | System and method for dynamically modifying synchronized business information server interfaces | |
| US20120173679A1 (en) | Adaptation method, adapter and adapter system for network service communication | |
| EA012934B1 (en) | A system and a method for managing remote applications | |
| CN102810066A (en) | Terminal adapting method and terminal and server based on terminal characteristic configuration program | |
| CN101101550B (en) | Mapping a new user interface onto an existing integrated interface | |
| EP1537494A2 (en) | Central master data management | |
| US8756561B2 (en) | Software model normalization and mediation | |
| US20170011128A1 (en) | Dynamic domain query and query translation | |
| US20200125541A1 (en) | System for data storage and retrieval | |
| US8010419B2 (en) | Transparent object identities across and outside of ERP systems | |
| US7865403B2 (en) | Method, system, and program for translating and interfacing between data pools and product information management (PIM) systems | |
| US20130124611A1 (en) | Unified repository & tool infrastructure | |
| CA3062604A1 (en) | A system for improved data storage and retrieval | |
| CN201689418U (en) | Management data sheet updating device and managing system | |
| US8978041B2 (en) | Service virtualization container | |
| CN105701187B (en) | Process integrated service device and the method for realizing system combination using it | |
| CN102103606A (en) | Technology for realizing advanced search of commodities on mobile phone client | |
| CN102377738A (en) | Process integration server and method for realizing system integration by utilizing process integration server | |
| CN105447000A (en) | Transactional message transmission method and device | |
| CN105701188B (en) | Process integrated service device and the method for realizing system combination using it | |
| CN102375825A (en) | Process integration server and method for realizing system integration by utilizing same |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20190329 Address after: Room 8687, 8th floor, No. 3 Courtyard, 30 Shixing Street, Shijingshan District, Beijing 100041 Applicant after: Beijing Global Media Technology Co., Ltd. Address before: 518000 Room 201, building A, 1 front Bay Road, Shenzhen Qianhai cooperation zone, Shenzhen, Guangdong Applicant before: Nine city network technology (Shenzhen) Co., Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |