CN102376016B - Flow process integrated service device and utilize it to realize the method for system combination - Google Patents
Flow process integrated service device and utilize it to realize the method for system combination Download PDFInfo
- Publication number
- CN102376016B CN102376016B CN201010253319.7A CN201010253319A CN102376016B CN 102376016 B CN102376016 B CN 102376016B CN 201010253319 A CN201010253319 A CN 201010253319A CN 102376016 B CN102376016 B CN 102376016B
- Authority
- CN
- China
- Prior art keywords
- business datum
- database server
- database
- adapter
- daily record
- 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)
Abstract
Utilize flow process integrated service device to realize a method for system combination, comprising: receive the txt file that file adapter sends; In database server, the business datum of needs is inquired about by the query sentence of database in this txt file; The business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil; Meet in the business datum write SAP system of remote function calls adapter access stencil by described; Receive the daily record returned after SAP system performs described business datum; And will the Log Sender of Java DataBase combining adapter access stencil be met to database server, utilize the corresponding service data in this daily record renewal database server.Present invention also offers a kind of flow process integrated service device, utilize the present invention, SAP system can be write data to from database server fast, and receive the execution result that SAP system returns.
Description
Technical field
The present invention relates to a kind of flow process integrated service device, particularly relate to a kind of flow process integrated service device and utilize it to realize the method for system combination.
Background technology
Along with the continuous propelling of IT application process, there is increasing application system in enterprises, such as JXC System, purchasing system, accounting system, bonded system, logistics system and marketing system.Each application system has different data layouts and adopts different data storage methods, such as, utilize database (as SQLserver or VisualFox) to store data.When SAP (SystemsApplicationsandProductsinDataProcessing) system is introduced original application system, due to the difference of data layout and data storage method, and when there being multiple list in database server, needing to obtain corresponding data from multiple list and writing SAP and become very difficult.
Summary of the invention
In view of above content, be necessary to provide a kind of flow process integrated service device, can fast 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, can fast 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, multiple list is stored in this database server, this flow process integrated service device comprises file adapter, remote function calls adapter and Java DataBase combining adapter, this flow process integrated service device also comprises: acquisition module, for receiving the txt file 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 inquires about the business datum of needs in this database server by the query sentence of database in this txt file; Described acquisition module, also for receiving the business datum of inquiring about and obtaining from database server, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil; Writing module, for meeting in the business datum write SAP system of remote function calls adapter access stencil by described; Receiver module, for receiving the daily record returned after SAP system performs described business datum, and is converted to the daily record meeting Java DataBase combining adapter access stencil by this daily record; And described sending module, also for will the Log Sender of Java DataBase combining adapter access stencil be met to database server, utilize the corresponding service data in this daily record renewal database server.
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 comprise file adapter, remote function calls adapter and Java DataBase combining adapter, the method comprises the steps: the txt file receiving file adapter transmission, and the content of this txt file is query sentence of database; Send txt file in database server, and in this database server, inquired about the business datum of needs by the query sentence of database in this txt file; From database server, receive the business datum of inquiring about and obtaining, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil; Meet in the business datum write SAP system of remote function calls adapter access stencil by described; Receive the daily record returned after SAP system performs described business datum, and this daily record is converted to the daily record meeting Java DataBase combining adapter access stencil; And will the Log Sender of Java DataBase combining adapter access stencil be met to database server, utilize the corresponding service data in this daily record renewal database server.
Compared to prior art, described flow process integrated service device and utilize it to realize the method for system combination, require to search the business datum meeting querying condition in database in each list according to user, the business datum inquired described in the function that SAP system utilizes flow process integrated service device to provide receives, and return and perform the daily record of this business datum in database server, upgrade 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 the 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 the method preferred embodiment of system combination.
Main element symbol description
| Flow process integrated service device | 1 |
| File system | 2 |
| Database server | 3 |
| SAP system | 4 |
| File adapter | 10 |
| Java DataBase combining adapter | 11 |
| Remote function calls adapter | 12 |
| Remote function calls interface | 40 |
| Acquisition module | 100 |
| Enquiry module | 101 |
| Sending module | 102 |
| Writing module | 110 |
| Receiver module | 111 |
| Delivery module | 112 |
Embodiment
As shown in Figure 1, be that the present invention utilizes flow process integrated service device to realize the running environment schematic diagram of the method preferred embodiment of system combination.This flow process to be 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 communicated with database server 3 by DataBase combining, this DataBase combining can be Open Database Connection (OpenDatabaseConnectivity, ODBC), Java DataBase combining (JavaDataBaseConnectivity, JDBC) etc.In the present embodiment, this DataBase combining is 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 synchronous return data.
Store multiple list in this database server 3, in each list, store 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 comprises file adapter (fileadapter) 10, JDBC adapter (JDBCadapter) 11 and remote function calls adapter (remotefunctioncalladapter, RFCadapter) 12.This fileadapter10 is used for reading txt file from file system 2, and this txt file content is query sentence of database.This file 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 Structured Query Language (SQL) (StructuredQueryLanguage, SQL).Described JDBCadapter11 is used for described query statement to be sent in database server 3, utilizes the business datum required for the inquiry of this query sentence of database.Described RFCadapter12 is used in described business datum write SAP system 4, and receives the daily record of this business datum of execution that SAP system 4 returns.
This SAP system 4 also comprises RFC interface 40, this RFC interface 40 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 comprises: acquisition module 100, enquiry module 101 and sending module 102.RFCadapter12 comprises: 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 memory device, can be performed by the calculation element that computing machine or other comprise processor, thus complete in the present invention the work flow utilizing PI server 1 to realize system combination.
The txt file that acquisition module 100 sends for receiving fileadapter10, the content of this txt file is query sentence of database, and form is the form meeting JDBCadapter11 access.
Enquiry module 101 for sending this txt file in database server 3, and inquires 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 also for receiving the business datum of inquiring about and obtaining from database server 3, and the business datum this inquired is converted to the business datum meeting RFCadapter12 access stencil.Each business datum has corresponding mark, 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.
The business datum extremely described RFCadapter12 that sending module 102 meets RFCadapter12 access stencil for sending this.
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 the form meeting RFCadapter12 access.In the present embodiment, this daily record comprises the execution result performing each business datum, and this execution result comprises and runs succeeded or perform failed information and perform failed reason.This receiver module 111 daily record also for this being 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 also for Log Sender that delivery module 112 is transmitted to database server 3, utilize the execution result of each business datum in this daily record to upgrade the business datum in database server 2 in corresponding list.Specifically, this sending module 102 finds the corresponding field in database server 3 in corresponding list by the mark that business datum each in this daily record is corresponding, utilizes the execution result of each business datum in daily record to upgrade the data in the field found.
As shown in Figure 2, be that the present invention utilizes flow process integrated service device to realize the operation process chart of the method preferred embodiment of system combination.
The time 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 with the form meeting JDBCadapter11 access by this txt file.In the present embodiment, the time interval of this user setting can be 1 day.In other embodiments, this time interval is not limited to 1 day, and it can by User Defined.
Step S31, acquisition module 100 receives the txt file that fileadapter10 sends.
Step S32, enquiry module 101 sends this txt file in database server 3, and in this database server 3, inquired about the business datum of needs by the query sentence of database in this txt file.
Step S33, described acquisition module 100 receives the business datum of inquiring about and obtaining from database server 3, and the business datum this inquired is converted to the business datum meeting RFCadapter12 access stencil.Each business datum has corresponding mark, 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 to described RFCadapter12.
Step S35, the business datum that described sending module 102 sends is write in SAP system 4 by RFC interface 40 by writing module 110.
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 the form meeting RFCadapter12 access.In the present embodiment, this daily record comprises the execution result of each business datum, and this execution result comprises and runs succeeded or perform failed information and perform failed reason.
Step S37, the daily record that this receives by this receiver module 111 is converted to the daily record meeting JDBCadapter11 access stencil.
Step S38, the Log Sender that delivery module 112 transmits by described sending module 102, to database server 3, utilizes the execution result of each business datum in this daily record to upgrade the business datum in database server 2 in corresponding list.Specifically, this sending module 102 finds the corresponding field in database server 3 in corresponding list by the mark that business datum each in this daily record is corresponding, utilizes the execution result of each business datum in daily record to upgrade the data in the field found.
It should be noted last that, above embodiment is only in order to illustrate technical scheme of the present invention and unrestricted, although with reference to preferred embodiment to invention has been detailed description, those of ordinary skill in the art is to be understood that, can modify to technical scheme of the present invention or equivalent replacement, and not depart from the spirit and scope of technical solution of the present invention.
Claims (4)
1. a flow process integrated service device, this flow process integrated service device is connected to database server and SAP system, multiple list is stored in this database server, this flow process integrated service device comprises file adapter, remote function calls adapter and Java DataBase combining adapter, it is characterized in that, this flow process integrated service device also comprises:
Acquisition module, the suffix sent for receiving file adapter is the txt file of txt, and the content of this txt file is query sentence of database;
Enquiry module, for sending txt file in database server, and inquires about the business datum of needs in this database server by the query sentence of database in this txt file;
Described acquisition module, also for receiving the business datum of inquiring about and obtaining from database server, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil;
Writing module, for meeting in the business datum write SAP system of remote function calls adapter access stencil by described;
Receiver module, for receiving the daily record returned after SAP system performs described business datum, and is converted to the daily record meeting Java DataBase combining adapter access stencil by this daily record; And
Described sending module, also for meeting the Log Sender of Java DataBase combining adapter access stencil to database server, utilizes the corresponding service data in this daily record renewal database server.
2. flow process integrated service device as claimed in claim 1, is characterized in that, described SAP system performs daily record that described business datum returns and comprises and perform running succeeded or performing failed information and perform failed reason of each business datum.
3. the 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 comprise file adapter, remote function calls adapter and Java DataBase combining adapter, it is characterized in that, the method comprises the steps:
The suffix receiving file adapter transmission is the txt file of txt, and the content of this txt file is query sentence of database;
Send txt file in database server, and in this database server, inquired about the business datum of needs by the query sentence of database in this txt file;
From database server, receive the business datum of inquiring about and obtaining, and the business datum this inquired is converted to the business datum meeting remote function calls adapter access stencil;
Meet in the business datum write SAP system of remote function calls adapter access stencil by described;
Receive the daily record returned after SAP system performs described business datum, and this daily record is converted to the daily record meeting Java DataBase combining adapter access stencil; And
To the Log Sender of Java DataBase combining adapter access stencil be met to database server, utilize the corresponding service data in this daily record renewal database server.
4. utilize flow process integrated service device to realize the method for system combination as claimed in claim 3, it is characterized in that, described SAP system performs daily record that described business datum returns and comprises and perform running succeeded or performing failed information and perform failed reason of each business datum.
Priority Applications (3)
| 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 |
| 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 |
Applications Claiming Priority (1)
| 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 |
Related Child Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610012472.8A Division CN105701187B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
| CN201610012481.7A Division CN105701188B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102376016A CN102376016A (en) | 2012-03-14 |
| CN102376016B true CN102376016B (en) | 2016-04-13 |
Family
ID=45794584
Family Applications (2)
| 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 |
| CN201610012472.8A Active CN105701187B (en) | 2010-08-13 | 2010-08-13 | Process integrated service device and the method for realizing system combination using it |
Family Applications After (1)
| 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 |
Country Status (1)
| Country | Link |
|---|---|
| CN (2) | CN102376016B (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 (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002039353A1 (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 |
| CN101562606A (en) * | 2008-04-17 | 2009-10-21 | 鸿富锦精密工业（深圳）有限公司 | Open type data calling system and method |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| FI103459B (en) * | 1997-06-02 | 1999-06-30 | Nokia Telecommunications Oy | A method for transmitting data traffic in a communication 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 |
| US7917524B2 (en) * | 2006-06-27 | 2011-03-29 | Sap Ag | 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 |
| CN101212719B (en) * | 2006-12-31 | 2011-12-28 | 华为技术有限公司 | Method and system for implementing converged message service in radio communication network |
| CN100580662C (en) * | 2007-12-29 | 2010-01-13 | 中国建设银行股份有限公司 | Heterogeneous report form integration and centralized management device and system |
| CN101686581B (en) * | 2008-09-22 | 2012-06-27 | 中国移动通信集团北京有限公司 | Mobile communication business service system and business processing method thereof |
-
2010
- 2010-08-13 CN CN201010253319.7A patent/CN102376016B/en not_active Expired - Fee Related
- 2010-08-13 CN CN201610012472.8A patent/CN105701187B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002039353A1 (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 |
| CN101562606A (en) * | 2008-04-17 | 2009-10-21 | 鸿富锦精密工业（深圳）有限公司 | Open type data calling system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105701187B (en) | 2019-04-26 |
| CN102376016A (en) | 2012-03-14 |
| CN105701187A (en) | 2016-06-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104090889B (en) | Data processing method and system | |
| CN103177116B (en) | A kind of distributed information log based on two-stage index is processed and querying method | |
| CN103246595B (en) | Application management method, device, server and terminating unit | |
| CN102333092B (en) | Network user identification method and application server | |
| CN104092770B (en) | Enterprises book management method and system based on cloud computing | |
| CN103209223A (en) | Distributed application conversation information sharing method and system and application server | |
| US20120173679A1 (en) | Adaptation method, adapter and adapter system for network service communication | |
| CN102130959A (en) | System and method for scheduling cloud storage resource | |
| CN100385973C (en) | Business information processing system and method | |
| CN108667866A (en) | A kind of request processing method and device based on API intelligent adaptations | |
| CN102609488A (en) | Client, data query method of client, server and data query system | |
| CN103793749A (en) | Safety production comprehensive supervisory platform data transmission method | |
| CN102376016B (en) | Flow process integrated service device and utilize it to realize the method for system combination | |
| CN102546261A (en) | Network element upgrading method, network element, server and system | |
| CN102385617A (en) | Dynamic domain query and query translation | |
| CN105446819A (en) | Service connection system and design method therefor | |
| CN101729584A (en) | Service adaptor for software service integration system and operation method thereof | |
| CN102377738A (en) | Process integration server and method for realizing system integration by utilizing process integration server | |
| CN102592190B (en) | A kind of signing system of electronic contract | |
| CN102103606A (en) | Technology for realizing advanced search of commodities on mobile phone client | |
| CN102375825A (en) | Process integration server and method for realizing system integration by utilizing same | |
| CN111026796B (en) | Multi-source heterogeneous data acquisition method, device, system, medium and equipment | |
| CN102937862B (en) | System and method for managing mobile terminal by browser | |
| CN102332026A (en) | Inquiring statistical method for service database | |
| CN105205060A (en) | Method and device for generating word document database dictionary |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20151201 Address after: 201424 Shanghai city Fengxian District Tuo Village barracks Lin Zhen No. 598 building ninth room 111 Applicant after: Shanghai Lirui Network Technology Co.,Ltd. Address before: 518109 Guangdong province Shenzhen city Longhua District Dragon Road No. 83 wing group building 11 floor Applicant before: SCIENBIZIP CONSULTING (SHEN ZHEN) Co.,Ltd. Effective date of registration: 20151201 Address after: 518109 Guangdong province Shenzhen city Longhua District Dragon Road No. 83 wing group building 11 floor Applicant after: SCIENBIZIP CONSULTING (SHEN ZHEN) Co.,Ltd. Address before: 518109, Guangdong, Baoan District, Shenzhen, Longhua Road, road, east side of Foxconn science and Technology Park, D1 district workshop, stamping workshop, third layers, distinguish the body Applicant before: GDS Software (Shenzhen) Co.,Ltd. Applicant before: HON HAI PRECISION INDUSTRY Co.,Ltd. |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| CB03 | Change of inventor or designer information |
Inventor after: Su Li Inventor before: Wang Taihong Inventor before: Lin Cheng Inventor before: Huang Yuxi Inventor before: Liu Baiting Inventor before: Gan Shuhui Inventor before: Jian Jiting Inventor before: Liang Wenguang Inventor before: Yao Jin Inventor before: Luo Wei Inventor before: He Baoru |
|
| COR | Change of bibliographic data | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20160315 Address after: 210048 Jiangsu Province, Nanjing city Liuhe District Dachang geguan Road No. 552 Applicant after: NANJING JIANGBEI PEOPLE'S Hospital Address before: 201424 Shanghai city Fengxian District Tuo Village barracks Lin Zhen No. 598 building ninth room 111 Applicant before: Shanghai Lirui Network Technology Co.,Ltd. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20160413 Termination date: 20170813 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |