201209737 六、發明說明： 【發明所屬之技術領域】 [0001] 本發明涉及一種流程整合伺服器，尤其涉及一種流程整 合伺服器及利用其實現系統整合的方法。 【先前技術】 [0002] 隨著資訊化進程的不斷推進，企業内部出現了越來越多 的應用系統，例如進銷存系統、採購系統、會計系統、 保稅系統、物流系統及銷售系統。各個應用系統具有不 同的資料格式並且採用不同的資料儲存方式，例如利用 資料庫（如SQL server或Visual Fox)儲存資料。在 將SAP (Systems Applications and Products in Data Processing)系統引入原有應用系統的時候，由 於資料格式及資料儲存方式的差異，SAP系統與原有應用 系統之間的資料交互變得困難。 【發明内容】 [0003] 鑒於以上内容，有必要提供一種流程整合伺服器及利用 流程整合伺服器實現系統整合的方法，可以快速將資料 庫伺服器中的業務資料寫入到SAP系統中，並接收SAP系 統返回的執行結果。 [0004] 一種流程整合伺服器，該流程整合伺服器連接於資料庫 伺服器和SAP系統，該資料庫伺服器中儲存有表單，該流 程整合伺服器包括遠端函數調用適配器和Java資料庫連 接適配器，該流程整合伺服器還包括：讀取模組，用於 按照用戶設定的時間間隔從資料庫伺服器中的表單中讀 取業務資料；轉換模組，用於將讀取的業務資料轉換為 099128453 表單編號A0101 第4頁/共15頁 0992049997- 201209737 符合遠端函數調用適配器訪問格式的業務資料；寫入模 組，用於將所述符合遠端函數調用適配器訪問格式的業 務資料寫入SAP系統中；接收模組，用於接收SAP系統執 行所述業務資料返回的日誌，並將該日誌轉換為符合 Java資料庫連接適配器訪問格式的曰誌；及發送模組， 用於將所述符合Java資料庫連接適配器訪問格式的日誌 發送給資料庫伺服器，更新資料庫伺服器中表單内的資 料。 [0005] —種利用流程整合伺服器實現系統整合的方法，該流程 整合伺服器連接於資料庫伺服器和SAP系統，並包括遠端 函數調用適配器和Java資料庫連接適配器，該方法包括 如下步驟：按照用戶設定的時間間隔從資料庫伺服器中 的表單中讀取業務資料；將讀取的業務資料轉換為符合 遠端函數調用適配器訪問格式的業務資料；將所述符合 遠端函數調用適配器訪問格式的業務資料寫入SAP系統中 ;接收SAP系統執行所述業務資料返回的日誌，並將該日 誌轉換為符合Java資料庫連接適配器訪問格式的曰誌； 及將所述符合Java資料庫連接適配器訪問格式的日誌發 送給資料庫伺服器，更新資料庫伺服器中表單内的資料 〇 [0006] 相較於習知技術，所述流程整合伺服器及利用其實現系 統整合的方法，其中SAP系統利用該流程整合伺服器提供 的功能接收資料庫伺服器中的資料，並返回執行該資料 的曰誌到資料庫伺服器中，更新資料庫伺服器中的資料 099128453 表單編號A0101 第5頁/共15頁 0992049997-0 201209737 【實施方式】 剛㈣1所示，係本發明利用流程整合飼服器實現系統整合 的方法較佳實施例之運行環境示意圖。該流程整合（ process integration，ρι)伺服器丨（以下簡稱為： PI伺服器1 )透過資料庫連接從資料庫伺服器2中讀取資 料，該資料庫連接可以為開放資料庫互連（〇pen Data_ base Connectivity，ODBC)，java 資料庫連接（Java Data Base Connectivity，JDBC)等。在本實施例中 ，該資料庫連接為JDBC。該PI伺服器1作為資料庫伺服器 2和所述S A P系統3之間的中間件，用於資料庫伺服器2和 SAP系統3之間的資料傳輸。 [_8]所述資料庫伺服器2中儲存了一個表單，該表單中儲存了 業務K料，該資料庫飼服器2可設於企業的.内進銷存系統 、採購系統、會計系統、保稅系統、物流系統及銷售系 統中。 [0009] 所述 PI 伺服器 1 包括 JDBCi|S$S (JDBC adapter) 10 和 遠端函數調用適配器Crenrote.:function call ad-apter ’ RFC adapter) 11。該JDBC adapter 10包括 接收通道12和發送通道13。該接收通道12用於從資料庫 伺服器2中讀取業務資料。該JDBC adapterlO將該讀取 的業務資料轉換為符合RFC adapter 11訪問格式的業務 資料，再將該轉換後的業務資料傳送給RFC adapter 11 。所述發送通道13用於發送資料給資料庫伺服器2。 [0010] 該SAP系統3還包括RFC介面30，該RFC介面30作為PI伺 服器1和SAP系統3之間的通信介面，用於從RFC ad- 099128453 表單編號A0101 第6頁/共15頁 0992049997-0 201209737 apter 11接收所述業務資料。 ’1]所述PI伺服器丨中的JDBC adapter 1〇包括：讀取模組 1〇〇、轉換模組101及發送模組1〇2。RFC adapter 11包 括：寫入模組110、接收模組111及傳送模組112。所述 模組是具有特定功能的軟體程式段，該軟體儲存於電腦 可讀儲存介質或其他儲存設備’可被電腦或其他包含處 理器的計算裝置執行，從而完成本發明中利用ρι伺服器1 實現系統整合的作業流程。 Ο [0012]需要指出的是，在本實施例中，該SAP系統3接收資料庫 祠服器2中的資料的流程是由p〗伺服器1定時觸發的，並 且要求同步返回資料。 [0013]讀取模組1 〇 〇用於按照用戶妓定的時間間隔透過接收通道 12從資料庫伺服器2中讀取業務資料。本實施例中，該用 戶設定的時間間隔可以為1天。在其他實施例中，該時間 間隔不限於1天’其可由用戶:k定義。該讀取模組1〇〇還 用於將該讀取的業務資料以綍备J1)BC adapter 10訪問 M 的格式來表示。％ ^ ' [0014]轉換模組101用於將所述符合JDBC adapter 10訪問格 式的業務資料轉換為符合RFC adapter 11訪問格式的業 務資料。本實施例t，該轉換模組1〇1首先映射該符合 JDBC adapter 1〇訪問格式的業務資料，再將該映射得 到的業務資料轉換為符合RFC adapter 11訪問格式的業 務資料。 [0015]發送模組102用於發送該符合RFC adapter 11訪問格式 0992049997-0 099128453 表單編號A0101 第7頁/共15頁 201209737 的業務資料至所述RFC adapter 11。 [0016] 寫入模組110用於將所述發送模組102發送的業務資料透 過RFC介面30寫入SAP系統3中。 [0017] 接收模組111用於接收SAP系統3執行所述業務資料後返回 的日諸，該日諸、的格式是符合RFC adapter 11訪問的格 式。本實施例中，該日誌包括所述業務資料的執行結果 ，該執行結果包括執行成功或者執行失敗的資訊以及執 行失敗的原因。該接收模組111還用於將該接收的日誌轉 換為符合JDBC adapter 10訪.間格式的日諸。 [0018] 傳送模組112用於將該符合JDBC adapter 10訪問格式 的日諸傳送給JDBC adapter. 10。 [0019] 所述發送模組102還用於將傳送模組112傳送的日誌利用 發送通道13發送給資料庫伺服器2，利用該日誌更新資料 庫伺服器2中所述表單内的資料。本實施例中，將所述曰 誌中的業務資料被執行的結果更新到表單中相應的欄位 里。 [0020] 如圖2所示，係本發明利用流程整合伺服器實現系統整合 的方法較佳實施例之作業流程圖。 [0021] 步驟S30，讀取模組100按照用戶設定的時間間隔透過接 收通道12從資料庫伺服器2中讀取業務資料，並將該讀取 的業務資料以符合JDBC adapter 10訪問的格式來表示 。本實施例中，該用戶設定的時間間隔可以為1天。在其 他實施例中，該時間間隔不限於1天，其可由用戶自定義 099128453 表單編號A0101 第8頁/共15頁 0992049997-0 201209737 [0022] 步驟S31，轉換模組101將所述符合JDBC adapter 1〇訪 問格式的業務資料轉換為符合RFC adapter 11訪問招^ 的業務資料。本實施例中，該轉換模組101首先映射該符 合JDBC adapter 10訪問格式的業務資料，再將該映射 得到的業務資料轉換為符合RFC adapter 11訪問格式的 業務資料。 [0023]步驟S32，發送模組102發送該符合RFC adapter 11訪 問格式的業務資料至所述RFC adapter 11。 〇 [0024]步驟S33，寫入模組110將所述發送模組102發送的業務 資料透過RFC介面30寫入SAP系統3中。 [0025]步驟S34，SAP系統3執行接收的業務資料，並透過RFX介 面30返回日諸、給rfc adapter 11，該曰魏的格式是符 合RFC adapter 11訪問的格式。本實施例中，該日誌包 括所述業務資料的執行結果。該執行結果包括執行成功 或者執行失敗的資訊以及執行失敗的原因。 〇 剛步驟S35，接收模組U1將該接收的日姥轉換為符合j])BC adapter 1〇訪問格式的日誌。 _步驟S36，傳送模組112將該符合JDBC adapter 1〇訪問 格式的日誌傳送給JDBC adapter 10。 [0028] 步驟S37 ’所述發送模組1〇2將傳送模組ιΐ2傳送的日誌 透過所述發送通道13發送給倾庫他S2，湘該日該 更新貝料庫伺服器2中所述表單内的資料。具體而言，資 料庫司服器2將所述日誌中的業務資料被軟行的結果更新 到表單中相應的攔位里。 099128453 表單編號A0101 第9頁/共15頁 0992049997-0 201209737 [0029] 最後所應說明的是，以上實施例僅用以說明本發明的技 術方案而非限制，儘管參照以上較佳實施例對本發明進 行了詳細說明，本領域的普通技術人員應當理解，可以 對本發明的技術方案進行修改或等同替換，而不脫離本 發明技術方案的精神和範圍。 【圖式簡單說明】 [0030] 圖1係本發明利用流程整合伺服器實現系統整合的方法較 佳實施例之運行環境示意圖。 [0031] 圖2係本發明利用流程整合伺服器實現系統整合的方法較 佳實施例之作業流程圖。 【主要元件符號說明】 [0032] 流程整合伺服器：1 [0033] 資料庫伺服器：2 [0034] SAP系統：3 [0035] Java資料庫連接適配器：10 [0036] 遠端函數調用適配器：11 [0037] 接收通道：12 [0038] 發送通道：13 [0039] 遠端函數調用介面：30 [0040] 讀取模組：100 [0041] 轉換模組：101 [0042] 發送模組：102 表單編號A0101 第10頁/共15頁 099128453 0992049997-0 201209737 [0043] 寫入模組：110 [0044] 接收模組：111 [0045] 傳送模組：112201209737 VI. Description of the Invention: [Technical Field] The present invention relates to a process integration server, and more particularly to a process integration server and a method for implementing system integration using the same. [Prior Art] [0002] With the continuous advancement of the informationization process, more and more application systems have emerged within the enterprise, such as invoicing systems, procurement systems, accounting systems, bonded systems, logistics systems, and sales systems. Each application system has a different data format and uses different data storage methods, such as using a database (such as SQL server or Visual Fox) to store data. When the SAP (Systems Applications and Products in Data Processing) system was introduced into the original application system, the data interaction between the SAP system and the original application system became difficult due to differences in data formats and data storage methods. SUMMARY OF THE INVENTION [0003] In view of the above, it is necessary to provide a process integration server and a system integration method using a process integration server, which can quickly write business data in the database server to the SAP system, and Receive the execution result returned by the SAP system. [0004] A process integration server, the process integration server is connected to a database server and an SAP system, wherein the database server stores a form, and the process integration server includes a remote function call adapter and a Java database connection. The adapter, the process integration server further comprises: a reading module, configured to read the business data from the form in the database server according to a time interval set by the user; and the conversion module is configured to convert the read business data 099128453 Form No. A0101 Page 4 / Total 15 Page 0992049997- 201209737 Business data conforming to the remote function call adapter access format; write module for writing the business data conforming to the remote function call adapter access format In the SAP system, the receiving module is configured to receive a log that is returned by the SAP system to execute the service data, and convert the log into a file that conforms to a Java database connection adapter access format; and a sending module, configured to: Logs conforming to the Java database connection adapter access format are sent to the database server, and the database server table is updated. Owned material within. [0005] A method for implementing system integration by using a process integration server, the process integration server is connected to a database server and an SAP system, and includes a remote function call adapter and a Java database connection adapter, the method comprising the following steps : reading the business data from the form in the database server according to the time interval set by the user; converting the read business data into the business data conforming to the remote function calling adapter access format; and the matching remote function calling adapter The service data of the access format is written into the SAP system; receiving the log returned by the SAP system to execute the service data, and converting the log into a file conforming to the Java database connection adapter access format; and connecting the conforming Java database The log of the adapter access format is sent to the database server to update the data in the form in the database server. [0006] Compared with the prior art, the process integrates the server and the method for implementing the system integration, wherein SAP The system uses the process to integrate the functions provided by the server to receive the database server. And return to the database server to execute the data, update the data in the database server 099128453 Form No. A0101 Page 5 / Total 15 Page 0992049997-0 201209737 [Embodiment] Just shown in (4) 1 The schematic diagram of the operating environment of the preferred embodiment of the method for implementing system integration using the process integration feeder. The process integration (ρι) server 丨 (hereinafter referred to as: PI server 1) reads data from the database server 2 through a database connection, and the database connection can be an open database interconnection (〇 Pen Data_base Connectivity, ODBC), Java Data Base Connectivity (JDBC), etc. In this embodiment, the database is connected as JDBC. The PI server 1 serves as a middleware between the database server 2 and the SIP system 3 for data transfer between the database server 2 and the SAP system 3. [_8] The database server 2 stores a form in which the service K material is stored, and the database feed device 2 can be set in the enterprise's internal invoicing system, procurement system, accounting system, Bonded systems, logistics systems and sales systems. [0009] The PI server 1 includes a JDBCi|S$S (JDBC adapter) 10 and a remote function call adapter Crenorte.: function call ad-apter ’ RFC adapter 11 . The JDBC adapter 10 includes a receive channel 12 and a transmit channel 13. The receiving channel 12 is used to read the business data from the database server 2. The JDBC adapter 10 converts the read business data into business data conforming to the RFC adapter 11 access format, and transmits the converted business data to the RFC adapter 11 . The sending channel 13 is configured to send data to the database server 2. [0010] The SAP system 3 further includes an RFC interface 30 as a communication interface between the PI server 1 and the SAP system 3 for use from RFC ad- 099128453 Form No. A0101 Page 6 of 15 0992049997 -0 201209737 apter 11 receives the business data. The JDBC adapter 1 in the PI server includes the following: a read module 1A, a conversion module 101, and a transmission module 1〇2. The RFC adapter 11 includes a write module 110, a receive module 111, and a transfer module 112. The module is a software program segment having a specific function, and the software stored in a computer readable storage medium or other storage device can be executed by a computer or other computing device including a processor, thereby completing the present invention using the 伺服1 server 1 A workflow that enables system integration. [0012] It should be noted that, in this embodiment, the flow of the SAP system 3 receiving the data in the database server 2 is triggered periodically by the server 1 and requires synchronous return of data. [0013] The reading module 1 is configured to read the business data from the database server 2 through the receiving channel 12 at a time interval determined by the user. In this embodiment, the time interval set by the user may be 1 day. In other embodiments, the time interval is not limited to one day 'which may be defined by the user: k. The read module 1 is further configured to represent the read service data in the format of the backup J1) BC adapter 10 access M. % ^ ' [0014] The conversion module 101 is configured to convert the service data conforming to the JDBC adapter 10 access format into business data conforming to the RFC adapter 11 access format. In the embodiment t, the conversion module 101 first maps the service data conforming to the JDBC adapter 1 access format, and then converts the mapped service data into business data conforming to the RFC adapter 11 access format. [0015] The sending module 102 is configured to send the RFC adapter 11 access format 0992049997-0 099128453 Form No. A0101 Page 7 of 15 201209737 business data to the RFC adapter 11. [0016] The write module 110 is configured to write the service data sent by the sending module 102 into the SAP system 3 through the RFC interface 30. [0017] The receiving module 111 is configured to receive the date returned by the SAP system 3 after executing the service data, and the format of the day is in accordance with the format accessed by the RFC adapter 11. In this embodiment, the log includes an execution result of the service data, and the execution result includes information about successful execution or execution failure and a reason for the execution failure. The receiving module 111 is further configured to convert the received log into a date conforming to the JDBC adapter 10 access format. [0018] The transmitting module 112 is configured to transmit the date conforming to the JDBC adapter 10 access format to the JDBC adapter. [0019] The sending module 102 is further configured to send the log transmitted by the transmitting module 112 to the database server 2 by using the sending channel 13, and use the log to update the data in the form in the database server 2. In this embodiment, the results of the execution of the business data in the log are updated to the corresponding fields in the form. [0020] As shown in FIG. 2, it is a flowchart of a preferred embodiment of the method for implementing system integration using a process integration server. [0021] Step S30, the reading module 100 reads the service data from the database server 2 through the receiving channel 12 according to the time interval set by the user, and the read service data is in a format compatible with the JDBC adapter 10 access. Said. In this embodiment, the time interval set by the user may be 1 day. In other embodiments, the time interval is not limited to one day, and can be customized by the user. 099128453 Form No. A0101 Page 8 / Total 15 Page 0992049997-0 201209737 [0022] Step S31, the conversion module 101 will match the JDBC adapter 1. The business data of the access format is converted into the business data of the RFC adapter 11 access. In this embodiment, the conversion module 101 first maps the service data conforming to the access format of the JDBC adapter 10, and then converts the mapped business data into service data conforming to the RFC adapter 11 access format. [0023] In step S32, the sending module 102 sends the service data conforming to the RFC adapter 11 access format to the RFC adapter 11. [0024] In step S33, the write module 110 writes the service data sent by the sending module 102 to the SAP system 3 through the RFC interface 30. [0025] In step S34, the SAP system 3 executes the received service data and returns it to the rfc adapter through the RFX interface 30. The format of the UI is in accordance with the format accessed by the RFC adapter 11. In this embodiment, the log includes an execution result of the service data. The execution result includes information on successful execution or execution failure and the reason for the execution failure.刚 Just step S35, the receiving module U1 converts the received date into a log conforming to the j])BC adapter 1〇 access format. In step S36, the delivery module 112 transmits the log conforming to the JDBC adapter 1 access format to the JDBC adapter 10. [0028] Step S37' The sending module 1〇2 sends the log transmitted by the transmitting module ΐ2 to the dumping S2 through the sending channel 13, and the form in the shell server 2 is updated on the same day. Information within. Specifically, the repository server 2 updates the results of the soft data in the log to the corresponding blocks in the form. 099128453 Form No. A0101 Page 9 of 15 0992049997-0 201209737 [0029] It should be noted that the above embodiments are merely illustrative of the technical solutions of the present invention and are not limiting, although the present invention is described with reference to the above preferred embodiments. The detailed description of the technical solutions of the present invention may be made without departing from the spirit and scope of the technical solutions of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS [0030] FIG. 1 is a schematic diagram of an operating environment of a preferred embodiment of a method for implementing system integration using a process integration server. 2 is a flow chart of a preferred embodiment of the method for implementing system integration using the process integration server of the present invention. [Main component symbol description] [0032] Process integration server: 1 [0033] Database server: 2 [0034] SAP system: 3 [0035] Java database connection adapter: 10 [0036] Remote function call adapter: [0037] Receive channel: 12 [0038] Send channel: 13 [0039] Remote function call interface: 30 [0040] Read module: 100 [0041] Conversion module: 101 [0042] Send module: 102 Form No. A0101 Page 10 / Total 15 Pages 099128453 0992049997-0 201209737 [0043] Write Module: 110 [0044] Receive Module: 111 [0045] Transfer Module: 112
099128453 表單編號A0101 第11頁/共15頁 0992049997-0099128453 Form No. A0101 Page 11 of 15 0992049997-0