CN105701188A - Process integration server and method for implementing system integration by using same - Google Patents
Process integration server and method for implementing system integration by using same Download PDFInfo
- Publication number
- CN105701188A CN105701188A CN201610012481.7A CN201610012481A CN105701188A CN 105701188 A CN105701188 A CN 105701188A CN 201610012481 A CN201610012481 A CN 201610012481A CN 105701188 A CN105701188 A CN 105701188A
- Authority
- CN
- China
- Prior art keywords
- business datum
- database server
- daily record
- flow process
- 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.)
- Granted
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)
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for implementing system integration by using a process integration server. The method comprises: receiving a txt file sent by a file adapter; inquiring needed service data from a database server via a database query statement in the txt file; converting the inquired service data into service data conforming to a remote function calling adapter access format; writing the service data of the remote function calling adapter access format into an SAP (Systems Applications and Products in Data Processing) system; receiving logs returned after the SAP system executes the service data; sending the log conforming to a Java database connection adapter access format to the database server, and updating the corresponding service data in the database server by using the log. The invention further provides a process integration server. By using the method, data can be quickly written from the database server to the SAP system, and the execution result returned by the SAP system can be quickly received.
Description
Technical field
The present invention relates to a kind of server, particularly relate to a kind of flow process integrated service device and utilize its method realizing system combination。
Background technology
Along with the continuous propelling of IT application process, enterprises occurs in that increasing application system, for instance JXC System, purchasing system, accounting system, bonded system, logistics system and marketing system。Each application system has different data forms and adopts different data storage methods, for instance utilize data base (such as SQLserver or VisualFox) to store data。When SAP (SystemsApplicationsandProductsinDataProcessing) system is introduced original application system, difference due to data form and data storage method, and when database server has multiple list, it is necessary to from multiple lists, obtain corresponding data and write SAP and become highly difficult。
Summary of the invention
In view of the foregoing, it is necessary to provide a kind of flow process integrated service device, it is possible to quickly the business datum in database server be written in SAP system, and receive the execution result that SAP system returns。
There is a need to provide a kind of method utilizing flow process integrated service device to realize system combination, it is possible to quickly the business datum in database server be written in SAP system, and receive the execution result that SAP system returns。
A kind of flow process integrated service device, this flow process integrated service device is connected to database server and SAP system, this database server stores multiple list, this flow process integrated service device includes file adapter, remote function calls adapter and Java data base's connection adaptor, this flow process integrated service device also includes: acquisition module, for receiving the txt file that suffix is txt that file adapter sends, the content of this txt file is query sentence of database；Enquiry module, for sending txt file in database server, and in this database server, the business datum of needs is inquired about by the query sentence of database in this txt file, each business datum has the mark of correspondence, and describes the field at this business datum place in the list at this business datum place and this list in mark；Described acquisition module, is additionally operable to from database server and receives the business datum that inquiry obtains, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil；Writing module, for by the described business datum write SAP system meeting remote function calls adapter access stencil；Receiver module, for receiving the daily record returned after SAP system performs described business datum, and is converted to the daily record meeting Java data base's connection adaptor access stencil by this daily record；And described sending module, for the daily record meeting Java data base's connection adaptor access stencil is sent to database server, its corresponding field found in database server in corresponding list by the mark that business datum each in described daily record is corresponding, utilizes the execution result of each business datum in daily record to update the data in the field found。
A kind of method utilizing flow process integrated service device to realize system combination, this flow process integrated service device is connected to database server and SAP system, and include file adapter, remote function calls adapter and Java data base's connection adaptor, the method comprises the steps: to receive the txt file that suffix is txt that file adapter sends, and the content of this txt file is query sentence of database；Send txt file to database server, and in this database server, the business datum of needs is inquired about by the query sentence of database in this txt file, each business datum has the mark of correspondence, and describes the field at this business datum place in the list at this business datum place and this list in mark；From database server, receive the business datum that inquiry obtains, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil；By in the described business datum write SAP system meeting remote function calls adapter access stencil；Receive the daily record returned after SAP system performs described business datum, and this daily record is converted to the daily record meeting Java data base's connection adaptor access stencil；And the daily record meeting Java data base's connection adaptor access stencil is sent to database server, by the corresponding field that the mark that business datum each in described daily record is corresponding finds in database server in corresponding list, the execution result of each business datum in daily record is utilized to update the data in the field found。
Compared to prior art, described flow process integrated service device and utilize its method realizing system combination, require according to user to search the business datum meeting querying condition in data base in each list, SAP system utilizes the business datum inquired described in the function reception that flow process integrated service device provides, and return the daily record performing this business datum in database server, update the data in corresponding list in database server。
Accompanying drawing explanation
Fig. 1 is that the present invention utilizes flow process integrated service device to realize the running environment schematic diagram of method preferred embodiment of system combination。
Fig. 2 is that the present invention utilizes flow process integrated service device to realize the operation process chart of method preferred embodiment of system combination。
Main element symbol description
Detailed description of the invention
As it is shown in figure 1, be that the present invention utilizes flow process integrated service device to realize the running environment schematic diagram of method preferred embodiment of system combination。This flow process is integrated (processintegration, PI) server 1 (hereinafter referred to as PI server 1) and is connected to file system 2, database server 3 and SAP system 4。Described PI server 1 is connected by data base and database server 3 communicates, it can be Open Database Connection (OpenDatabaseConnectivity that this data base connects, ODBC), Java data base connects (JavaDataBaseConnectivity, JDBC) etc.。In the present embodiment, this data base is connected as JDBC。It is pointed out that in the present embodiment, this SAP system 4 receives the flow process of the data in database server 3 by PI server 1 clocked flip, and requires to synchronize to return data。
This database server 3 stores multiple list, each list stores multiple business datum。This database server 3 can be located in the interior JXC System of enterprise, purchasing system, accounting system, bonded system, logistics system and marketing system。
This PI server 1, as the middleware between database server 3 and described SAP system 4, transmits for the data between database server 3 and SAP system 4。Described PI server 1 includes file adapter (fileadapter) 10, JDBC adapter (JDBCadapter) 11 and remote function calls adapter (remotefunctioncalladapter, RFCadapter) 12。This fileadapter10 for reading txt file from file system 2, and this txt file content is query sentence of database。This document system 2 is file transfer protocol (FTP) (FileTransferProtocol, FTP) server or local file server etc.。In the present embodiment, this query sentence of database is SQL (StructuredQueryLanguage, SQL)。Described JDBCadapter11, for being sent to database server 3 by described query statement, utilizes the business datum that the inquiry of this query sentence of database is required。Described RFCadapter12 is for writing described business datum in SAP system 4, and receives the daily record performing this business datum that SAP system 4 returns。
This SAP system 4 also includes RFC interface 40, and this RFC interface 40 is as the communication interface between PI server 1 and SAP system 4, for receiving described business datum from RFCadapter12。
JDBCadapter11 in described PI server 1 includes: acquisition module 100, enquiry module 101 and sending module 102。RFCadapter12 includes: writing module 110, receiver module 111 and delivery module 112。Described module is the software program section with specific function, this software is stored in computer-readable recording medium or other storage device, can be performed by computer or other calculation element comprising processor, thus completing the work flow utilizing PI server 1 to realize system combination in the present invention。
Acquisition module 100 is for receiving the fileadapter10 txt file sent, and the content of this txt file is query sentence of database, and form is meet the JDBCadapter11 form accessed。
Enquiry module 101 is used for sending this txt file to database server 3, and is inquired about the business datum of needs in this database server 3 by the query sentence of database in this txt file。
Described acquisition module 100 is additionally operable to from database server 3 to receive the business datum that inquiry obtains, and the business datum this inquired is converted to the business datum meeting RFCadapter12 access stencil。Each business datum has the mark of correspondence, describes the field at this business datum place in the list at the place of this business datum and this list in the mark of each business datum。
Sending module 102 is for sending this business datum meeting RFCadapter12 access stencil extremely described RFCadapter12。
Writing module 110 is write in SAP system 4 by RFC interface 40 for the business datum sent by described sending module 102。
Receiver module 111 is for receiving the daily record returned after SAP system 4 performs described business datum, and the form of this daily record is consistent with the RFCadapter12 form accessed。In the present embodiment, this daily record includes the execution result performing each business datum, and this execution result includes running succeeded or performing failed information and perform failed reason。This receiver module 111 is additionally operable to this daily record received is converted to the daily record meeting JDBCadapter11 access stencil。
Delivery module 112 is for meeting the Log Shipping of JDBCadapter11 access stencil to JDBCadapter11 by this。
Described sending module 102 is additionally operable to the daily record that delivery module 112 transmits is sent to database server 3, utilizes the execution result of each business datum in this daily record business datum to update in database server 2 in corresponding list。Specifically, the corresponding field that this sending module 102 is found in database server 3 in corresponding list by the mark that business datum each in this daily record is corresponding, utilize the execution result of each business datum in daily record to update the data in the field found。
As in figure 2 it is shown, be that the present invention utilizes flow process integrated service device to realize the operation process chart of method preferred embodiment of system combination。
The interval that step S30, fileadapter10 set according to user reads txt file from file system 2, and the content of this txt file is query sentence of database, and is represented to meet the JDBCadapter11 form accessed by this txt file。In the present embodiment, the interval that this user sets can be 1 day。In other embodiments, this interval is not limited to 1 day, and it can by User Defined。
Step S31, acquisition module 100 receives the fileadapter10 txt file sent。
Step S32, enquiry module 101 sends this txt file to database server 3, and is inquired about the business datum of needs in this database server 3 by the query sentence of database in this txt file。
Step S33, described acquisition module 100 receives the business datum that inquiry obtains from database server 3, and the business datum this inquired is converted to the business datum meeting RFCadapter12 access stencil。Each business datum has the mark of correspondence, describes the field at this business datum place in the list at this business datum place and this list in the mark of each business datum。
Step S34, sending module 102 sends this business datum meeting RFCadapter12 access stencil extremely described RFCadapter12。
Step S35, the business datum that described sending module 102 is sent by writing module 110 is write in SAP system 4 by RFC interface 40。
Step S36, receiver module 111 receives the daily record returned after SAP system 4 performs described business datum, and the form of this daily record is consistent with the RFCadapter12 form accessed。In the present embodiment, this daily record includes the execution result of each business datum, and this execution result includes running succeeded or performing failed information and perform failed reason。
Step S37, this daily record received is converted to the daily record meeting JDBCadapter11 access stencil by this receiver module 111。
Step S38, the daily record that delivery module 112 transmits is sent to database server 3 by described sending module 102, utilizes the execution result of each business datum in this daily record business datum to update in database server 2 in corresponding list。Specifically, the corresponding field that this sending module 102 is found in database server 3 in corresponding list by the mark that business datum each in this daily record is corresponding, utilize the execution result of each business datum in daily record to update the data in the field found。
It should be noted last that, above example is only in order to illustrate technical scheme and unrestricted, although the present invention being described in detail with reference to preferred embodiment, it will be understood by those within the art that, technical scheme can be modified or equivalent replacement, without deviating from the spirit and scope of technical solution of the present invention。
Claims (5)
1. a flow process integrated service device, this flow process integrated service device is connected to database server and SAP system, this database server stores multiple list, this flow process integrated service device includes file adapter, remote function calls adapter and Java data base's connection adaptor, it is characterized in that, this flow process integrated service device also includes:
Acquisition module, for receiving the txt file that suffix is txt that file adapter sends, the content of this txt file is query sentence of database；
Enquiry module, for sending txt file in database server, and in this database server, the business datum of needs is inquired about by the query sentence of database in this txt file, each business datum has the mark of correspondence, and describes the field at this business datum place in the list at this business datum place and this list in mark。
Described acquisition module, is additionally operable to from database server and receives the business datum that inquiry obtains, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil；
Writing module, for by the described business datum write SAP system meeting remote function calls adapter access stencil；
Receiver module, for receiving the daily record returned after SAP system performs described business datum, and is converted to the daily record meeting Java data base's connection adaptor access stencil by this daily record；And
Described sending module, for the daily record meeting Java data base's connection adaptor access stencil is sent to database server, its corresponding field found in database server in corresponding list by the mark that business datum each in described daily record is corresponding, utilizes the execution result of each business datum in daily record to update the data in the field found。
2. flow process integrated service device as claimed in claim 1, it is characterised in that described SAP system performs the daily record of described business datum return and includes performing running succeeded or performing failed information and perform failed reason of each business datum。
3. flow process integrated service device as claimed in claim 1, it is characterised in that described SAP system includes remote function calls interface, for receiving business datum from flow process integrated service device and sending described daily record to this flow process integrated service device。
4. one kind utilizes the method that flow process integrated service device realizes system combination, this flow process integrated service device is connected to database server and SAP system, and including file adapter, remote function calls adapter and Java data base's connection adaptor, it is characterised in that the method comprises the steps:
Receiving the txt file that suffix is txt that file adapter sends, the content of this txt file is query sentence of database；
Send txt file to database server, and in this database server, the business datum of needs is inquired about by the query sentence of database in this txt file, each business datum has the mark of correspondence, and describes the field at this business datum place in the list at this business datum place and this list in mark；
From database server, receive the business datum that inquiry obtains, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil；
By in the described business datum write SAP system meeting remote function calls adapter access stencil；
Receive the daily record returned after SAP system performs described business datum, and this daily record is converted to the daily record meeting Java data base's connection adaptor access stencil；And
The daily record meeting Java data base's connection adaptor access stencil is sent to database server, by the corresponding field that the mark that business datum each in described daily record is corresponding finds in database server in corresponding list, the execution result of each business datum in daily record is utilized to update the data in the field found。
5. utilize the method that flow process integrated service device realizes system combination as claimed in claim 4, it is characterized in that, described SAP system performs the daily record of described business datum return and includes performing running succeeded or performing failed information and perform failed reason of each business datum。
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 |
|---|---|---|---|
| CN201610012481.7A CN105701188B (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 |
|---|---|
| CN105701188A true CN105701188A (en) | 2016-06-22 |
| CN105701188B 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 |
|---|---|
| CN105701188B (en) | 2019-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103177116B (en) | A kind of distributed information log based on two-stage index is processed and querying method | |
| US6721871B2 (en) | Method and apparatus for synchronizing data stores with respect to changes in folders | |
| US8756206B2 (en) | Updating an inverted index in a real time fashion | |
| US20060230066A1 (en) | Using schemas to generate application specific business objects for use in an integration broker | |
| CN100547545C (en) | The method and system that is used for the application fractionation of network edge calculating | |
| CN103793749A (en) | Safety production comprehensive supervisory platform data transmission method | |
| EP1164519A3 (en) | A computer apparatus for monitoring and updating accountancy records | |
| CN101557427A (en) | Method for providing diffluent information and realizing the diffluence of clients, system and server thereof | |
| CN104092770A (en) | Inner-enterprise address book management method and system based on cloud computing | |
| CN105095313A (en) | Data access method and equipment | |
| CN102045399A (en) | Cloud computing mode file system and file reading method | |
| CN102646072B (en) | Data management method | |
| CN102385617A (en) | Dynamic domain query and query translation | |
| CN107644017A (en) | The querying method and device of journal file | |
| US20130124611A1 (en) | Unified repository & tool infrastructure | |
| CN105701187A (en) | Process integration server and method for implementing system integration by using same | |
| CN102377738A (en) | Process integration server and method for realizing system integration by utilizing process integration server | |
| CN102103606A (en) | Technology for realizing advanced search of commodities on mobile phone client | |
| CN103118045A (en) | Method and system of off-line downloading | |
| US20060161449A1 (en) | Automated real estate data replication | |
| CN105701188A (en) | Process integration server and method for implementing system integration by using same | |
| CN102685220A (en) | Method and system for data interaction based on WEB page | |
| CN202443466U (en) | Multi-user SQLITE database management system | |
| US20050159975A1 (en) | Multiple-party business cooperation system and method | |
| CN102325095A (en) | Method for managing personalized signature of member in instant messaging |
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 | ||
| 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. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20190426 |