CN105701188B - 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
- CN105701188B CN105701188B CN201610012481.7A CN201610012481A CN105701188B CN 105701188 B CN105701188 B CN 105701188B CN 201610012481 A CN201610012481 A CN 201610012481A CN 105701188 B CN105701188 B CN 105701188B
- Authority
- CN
- China
- Prior art keywords
- business datum
- log
- database
- adapter
- service device
- 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.)
- Expired - Fee Related
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)
- Debugging And Monitoring (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, the process integrated service device further include: module is obtained, for receiving file adapter transmission
Suffix is the txt file of txt, and the content of the txt file is query sentence of database；Enquiry module, for sending txt file extremely
In database server, and needs are inquired in the database server by the query sentence of database in the txt file
Business datum；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；It writes
Enter module, the business datum for that described will meet remote function calls adapter access stencil is written in SAP system；Receive mould
Block executes the log returned after the business datum for receiving SAP system, and the log is converted to and meets Java database
Connect the log of adapter access stencil；And the sending module, for Java database connection adapter access lattice will to be met
The log of formula is sent to database server, finds database clothes by the corresponding mark of business datum each in the log
The correspondence field in list is corresponded in business device, updates the field found using the implementing result of business datum each in log
In data.
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 should
Method includes the following steps: that receiving the suffix that file adapter is sent is the txt file of txt, and the content of the txt file is data
Library inquiry sentence；Txt file is sent into database server, and by the query sentence of database in the txt file at this
The business datum of needs is inquired in database server；The business datum that inquiry obtains is received from database server, and will
The business datum inquired is converted to the business datum for meeting remote function calls adapter access stencil, each business datum
There is a corresponding mark, and describes the column in list and the list where the business datum where the business datum in identifying
Position；It will be in the business datum write-in SAP system that remote function calls adapter access stencil be met；SAP system is received to hold
The log returned after the row business datum, and the log is converted to and meets Java database connection adapter access stencil
Log；And the log for meeting Java database connection adapter access stencil is sent to database server, pass through the day
The corresponding mark of each business datum finds the correspondence field correspond in list in database server in will, using in log often
The implementing result of a business datum updates the data in the field found.
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, for the log for meeting Java database connection adapter access stencil to be sent to database service
Device finds the correspondence column corresponded in list in database server by the corresponding mark of business datum each in the log
Position, updates the data in the field found using the implementing result of business datum each in log.
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, by the log
Corresponding identify of each business datum finds the correspondence field corresponded in list in database server, utilizes industry each in log
The implementing result for data of being engaged in updates the data in the field found.
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 |
|---|---|---|---|
| CN201610012481.7A CN105701188B (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 |
|---|---|---|---|
| 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 |
| CN201610012481.7A CN105701188B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
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 |
|---|---|
| CN105701188A CN105701188A (en) | 2016-06-22 |
| CN105701188B true CN105701188B (en) | 2019-04-26 |
Family
ID=56227028
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610012481.7A Expired - Fee Related CN105701188B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105701188B (en) |
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 |
-
2010
- 2010-08-13 CN CN201610012481.7A patent/CN105701188B/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 |
|---|---|
| CN105701188A (en) | 2016-06-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106814982B (en) | Label printing processing device, system and method | |
| US7810106B2 (en) | Uniform access to entities in registered data store services | |
| US20150378721A1 (en) | Methods for managing applications using semantic modeling and tagging and devices thereof | |
| CN102810066A (en) | Terminal adapting method and terminal and server based on terminal characteristic configuration program | |
| EP1537494A2 (en) | Central master data management | |
| CN101101550B (en) | Mapping a new user interface onto an existing integrated interface | |
| EP1815349A2 (en) | Methods and systems for semantic identification in data systems | |
| WO2010144329A1 (en) | Systems and methods for metadata driven dynamic web services | |
| US8756561B2 (en) | Software model normalization and mediation | |
| CN102710593A (en) | Method, device and system for publishing message in graph mashup | |
| CN102355499B (en) | Cloud computing system | |
| US20170011128A1 (en) | Dynamic domain query and query translation | |
| CN102541535A (en) | Method and system for publishing industry business architecture model | |
| CN109871354A (en) | A kind of method and device of file process | |
| US8978041B2 (en) | Service virtualization container | |
| US20130124611A1 (en) | Unified repository & tool infrastructure | |
| US7865403B2 (en) | Method, system, and program for translating and interfacing between data pools and product information management (PIM) systems | |
| AU2018267278A1 (en) | A system for improved data storage and retrieval | |
| CN105701187B (en) | Process integrated service device and the method for realizing system combination using it | |
| CN102377738A (en) | Process integration server and method for realizing system integration by utilizing process integration server | |
| CN109145092A (en) | A kind of database update, intelligent answer management method, device and its equipment | |
| CN105701188B (en) | Process integrated service device and the method for realizing system combination using it | |
| CN101751256B (en) | Method and system for exchanging data with third-party system | |
| US20050159975A1 (en) | Multiple-party business cooperation system and method | |
| 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: 20190328 Address after: 401120 data of Xiantao street, Yubei District, Chongqing 19 Applicant after: Chongqing Software Technology Co.,Ltd. Address before: 518000 Room 201, building A, 1 front Bay Road, Shenzhen Qianhai cooperation zone, Shenzhen, Guangdong Applicant before: JIUZUNCHENG NETWORK TECHNOLOGY (SHENZHEN) Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20190426 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |