JP2005322159A - Data linkage system and method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To ensure maintainability, response easiness at the occurrence of an error, and flexibility of a system. <P>SOLUTION: This data linkage system 101 between business systems includes three data processing definition/execution parts such as a data reception part 102 for receiving data from a transmission source system 106, a data converting/processing part 103 for converting/processing data received from the transmission source system 106 to generate data transmitted to a reception destination system 107, and a data transmission part 104 for transmitting the data to the reception destination system 107. In addition, the system includes a processing schedule part 105 for controlling the processing sequence in the data reception part 102, the data converting/processing part 102 and the data transmission part 104. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a data linkage system, method, and computer program for performing data linkage between two or more systems.

  Conventionally, different systems have been constructed corresponding to each business content and processing data, and are used for business. In recent years, instead of operating these systems independently, it has been attempted to exchange data and share information between the systems.

  However, it is not always possible to exchange information such as data between these systems as they are. This is because the programs and program languages used for each system are often different. Even if a similar program is used, the format of each data is optimized in each system, and as a result, there is a reality that it is difficult to seamlessly link as common data.

  Therefore, a method for exchanging data between different systems has been proposed. For example, in Patent Literature 1, a step of selecting a corresponding pattern from among linkage patterns based on data definition information of the linkage source and linkage destination systems, and a plurality of processes and the plurality of processes are executed according to the selected pattern A linkage method and a linkage program having a step of generating control information in which the order to be performed is generated and a step of outputting data generated by executing the control information according to the corresponding control information to the linkage destination system. It is disclosed.

  Patent Document 2 discloses a data linkage system that creates conversion data based on a conversion table stored in a linkage database when data is converted from a transfer source system to a transfer destination system.

  Patent Document 3 discloses an inter-system cooperation security system having a secure server that performs user authentication and inter-system cooperation.

  Patent Document 4 compares the internal structure of the encapsulated data from the connection source and the encapsulated data to the connection destination, and creates connection definition data in which data items to be exchanged are defined. A data file connection device and an information processing system are disclosed.

  For example, in Patent Document 1, by registering a data processing pattern in advance, the linkage pattern most appropriate for the data definition information is automatically determined from the linkage data definition information, and is generated as process control information. It has been proposed to automatically determine and execute the processing order and priority level in the control information. According to the data linkage proposed here, the process creation and control information generation / execution can be performed almost automatically (automatically) simply by giving the data definition information. It is said that it can respond flexibly.

JP 2002-298072 A JP 2002-99451 A JP 2002-140301 A JP 9-223051 A

  However, in the data linkage disclosed in Patent Document 1, the maintainability of the automatically generated data processing program is not generally high, and the process tends to become a black box, causing some problem on the system. In some cases, for example, when an error occurs during execution of a process, it may be extremely difficult to specify a re-execution location for re-executing the process.

  In addition, the automatic creation of processes and the generation / execution of control information can provide a great deal of operational benefits if the processes are constant, but the contents of the processes change. In many cases, it is necessary to fundamentally make necessary program changes accordingly, and the flexibility of the system tends to be insufficient.

  The present invention has been made in view of the above points, and an object thereof is to ensure maintainability, ease of handling when an error occurs, and flexibility of the system.

The data linkage system of the present invention is a data linkage system that performs data linkage between two or more systems, and converts a data reception part that receives data from a transmission source system and data received from the transmission source system. And / or a data conversion / processing part for generating transmission data to the receiving system, a data transmitting part for transmitting data to the receiving system, the data receiving part, the data converting / processing part, and And a processing schedule part for controlling the processing order in the data transmission part.
The data linkage method of the present invention is a data linkage method for performing data linkage between two or more systems via a data linkage system, and receives data from a transmission source system by a data receiving portion of the data linkage system. A procedure for converting and / or processing data received from the transmission source system by a data conversion / processing part of the data linkage system, and generating transmission data to the reception destination system; The data transmission part controls the order of processing in the data reception part, the data conversion / processing part, and the data transmission part by the procedure of transmitting data to the receiving system and the processing schedule part of the data linkage system It has the feature in having a procedure to do.
The computer program of the present invention is a computer program that causes a computer to execute processing for data linkage between two or more systems, the computer receiving data from a transmission source system, A data conversion / processing part that converts and / or processes data received from the transmission source system and generates transmission data to the reception destination system, a data transmission part that transmits data to the reception destination system, and the data reception part The data conversion / processing portion and the data transmission portion function as a processing schedule portion for controlling the processing order.

  According to the present invention, a data receiving portion that receives data from a transmission source system, a data conversion / processing portion that converts and / or processes data received from the transmission source system, and generates transmission data to the reception destination system. Data linkage between business systems by having a data transmission part that transmits data to the receiving system, a data reception part, a data conversion / processing part, and a processing schedule part that controls the processing order in the data transmission part It is possible to ensure process maintainability, ease of handling when an error occurs, and system flexibility.

  Preferred embodiments of the present invention will be described below with reference to the accompanying drawings. FIG. 1 is an overall schematic diagram of an inter-business-system data linkage system. The inter-business-system data linkage system 101 is a data receiving part 102 that receives data from the transmission source system 106 and data that converts and processes the data received from the transmission source system 106 and generates transmission data to the reception destination system 107. It has three data processing definition / execution parts such as a conversion / processing part 103 and a data transmission part 104 for transmitting data to the receiving system 107. Furthermore, the data receiving part 102, the data converting / processing part 103, and the processing schedule part 105 for controlling the processing order in the data transmitting part 104 are provided.

  The data receiving unit 102 receives source data 111 such as databases (DBs) and files from a plurality of source systems 106 via the data receiving transmission middleware 108 when data is linked between the systems. Store as an internal data file 113.

  The data conversion / processing unit 103 converts / processes the received internal data file 113 stored by the data receiving unit 102, and generates character code conversion, file layout conversion, file format to generate a transmission internal data file 114. Data conversion / processing software 110 having functions of conversion, data format conversion, and processing logic is provided.

  The data transmission part 104 transmits the internal data file 114 for transmission generated in the data conversion / processing part 103 to the reception destination data 112 such as DBs and files of a plurality of reception destination systems 107 via the data transmission transmission middleware 109. To do.

  The processing schedule part 105 defines the context and processing order of the data reception part 102, the data conversion / processing part 103, and the data transmission part 104, executes the process itself, confirms the process execution status and results, and receives the data. The part 102, the data conversion / processing part 103, and the data transmission part 104 are controlled.

  Next, with reference to FIG. 2, processing parts / templates will be described. As shown in FIG. 2, data conversion such as a data reception program, a data storage location change program, a data reception single part program 208 such as a reception data backup program, a data conversion / processing program, an unnecessary intermediate data deletion program, etc. Single component programs with limited functions and roles to some extent, such as machining single component program 209, transmission data backup program, data storage location change program, data transmission program, etc. Prepare as.

  A processing template storage area 201 is prepared on the processing schedule portion 105 described with reference to FIG. 1, and a data reception processing template 205 having processing functions to be executed by the data receiving portion 102 described with reference to FIG. Prepare a data conversion / processing template 206 having a processing function to be executed in the data conversion / processing part 103 described with reference to FIG. 1, and execute it in the data transmission part 103 described with reference to FIG. A data transmission processing template 207 having a power processing function is prepared.

  Then, a data reception processing component template 208 is constructed by combining the data reception single component program 208 in a form suitable for the content and order of processing necessary for the data reception portion 102 described in FIG. The data is stored and managed in the processing template storage area 201 on the processing schedule portion 105 described in FIG. Similarly, a process definition template is constructed by combining the data conversion / processing single part program 209 in a form suitable for the contents and order of processing required in the data conversion / processing part 103 described in FIG. 1 is held and managed as the processing template 206 for processing in the processing template storage area 201 on the processing schedule portion 105 described in FIG. 1, and the data transmission single component program 210 is necessary for the data transmission portion 104 described in FIG. A process definition template is constructed by combining them in a form that suits the contents and order of the processes, and is stored and managed as the data transmission process template 207 in the process template storage area 201 on the process schedule portion 105 described in FIG.

  Further, the same as the data reception partial processing template group 202 and the data conversion / processing processing template 206, in which a plurality of other data reception processing templates having functions and purposes similar to those of the data reception processing template 205 are assembled. Other data conversion / processing partial processing template group 203 for assembling a plurality of other data conversion / processing processing templates having the functions and purposes, and other functions and purposes similar to those of data transmission processing template 207 A data transmission partial processing template group 204 in which a plurality of data transmission processing templates are assembled is held and managed in the processing template storage area 201 on the processing schedule portion 105 described with reference to FIG. Then, by copying the template as needed, it is reflected / utilized as actual process definition information, and each single component program and each data process definition / execution part is diverted and reused.

  FIG. 3 is a diagram for explaining an example of a combination of parts arranged in a template. In a processing template, a data reception partial processing template group 301, a data conversion / processing partial processing template group 302, a data transmission portion Regardless of the processing template group of the processing template group 303, the in-house software that is composed only of the externally-made commercial software type processing template 304 and the in-house software single-component program 308 that are composed only of the externally-made commercial software single component program 307 There exists an externally manufactured commercial software & in-house software mixed type processing template 305 configured to include a mold processing template 306, an externally manufactured software single component program 307, and an in-house software single component program 308. Possible it is.

  Next, the processing operation (schedule software processing) in the processing schedule portion 105 will be described with reference to FIG. As shown in FIG. 4, in the processing template storage area 401 of the processing schedule portion (the same as the processing template storage area 201 of the processing schedule portion of FIG. 2), the data reception partial processing template group 402 (data reception partial processing template of FIG. 2). Group 202), data conversion / processing partial processing template group 403 (same as data conversion / processing partial processing template group 203 in FIG. 2), data transmission partial processing template group 404 (data transmission partial processing template in FIG. 2) Data reception processing template A 405, data reception processing template B 406, data conversion / processing processing template A 407, in which, for example, the component single unit program 410 is embedded from each template group. Data transmission processing template A 408, copies the data transmitting processing template B409 on actual processing definition information 411 is the actual business process definition information.

  The 5 templates 405 to 409 copied onto the actual process definition information 411 are the data reception actual processing pattern A413, the data reception actual processing pattern B414, the data conversion / processing actual processing pattern A415, and the data transmission actual processing pattern, respectively. A416, registered as a data transmission actual processing pattern B417, defines the processing order of each actual processing pattern as in the relation 412 of the processing order between each actual processing pattern, and defines the front-rear relationship, and is arranged in each processing pattern. It also has a function for creating a process definition such as calling a single component program, giving parameters necessary for business process definition in the execution module, and setting file arrival monitoring, setting process start time, and the like. At the same time, an actual process execution function based on business process definition information and a process execution status / result confirmation function are also provided.

  The data reception processing template 205 described with reference to FIG. 2 will be described in more detail with reference to the data reception partial template explanatory diagram of FIG. 5. As shown in the processing configuration example 502 of the data reception processing template of FIG. A transmission data reception program 503 based on a data transmission protocol necessary for data reception from various transmission source systems such as HTTP, FTP, an in-house data transmission tool, and commercial package software for data transmission is arranged at the head. Provide data arrival waiting function and time limit setting function for data arrival time. Next, a data movement program 504 for transferring data from the subsequent data reception area to the data conversion / processing area is arranged. Here, it is also possible to transfer data to the resident file area. Then, a received data backup program 505 for backing up the data moved to the data conversion / processing area is arranged. The data reception processing template 205 described with reference to FIG. 2 is a program group arranged exclusively in the order as in the processing configuration example 502 of the data reception processing template, as shown in the data reception processing template example 506. , HTTP, FTP, in-house production, and external sales package software are divided into a plurality of types according to the difference in transmission protocol, and are held and managed in the data reception partial processing template group 501.

The data conversion / processing processing template 206 described with reference to FIG. 2 will be described in more detail with reference to the data conversion / processing partial template explanatory diagram of FIG. First, a data conversion / processing program 603 is arranged at the head in order to reshape the conversion / processing data generated by the data receiving portion 102 described with reference to FIG. This data conversion / processing program 603 has the following functions.
1. Character code conversion function For example, it is a function that mutually converts data with character codes such as SJIS, EUC, EBCDIC, and KEIS.
2. Data format conversion function For example, it is a function that mutually converts data of individual items with different attributes such as numeric items, date items, and character string items.
3. File format conversion function This function converts file formats of different formats, such as variable-length text files, fixed-length text files, and binary data files.
4). Layout conversion function This function handles the same or different data layout for transmitted data and received data, and shapes the layout.
5). Processing logic generation function This is a function that can set various processing logics for data extraction conditions, conversion conditions, etc., mainly according to the requirements of the receiving system, and has the following patterns.
(1) Conversion format from the viewpoint of the number of transmitted and received files such as 1: 1, N: 1, 1: N, N: M (2) Number of records in individual files such as n = m, n> m, n <m (3) Conversion format from the viewpoint of data creation conditions as follows
<a> Select
(Condition selection: match condition / exclusion condition)
<B> Edit
(Constant value setting, editing for individual items)
<C> Sort
(Sort by control key items: ascending / descending order)
<D> Summary
(Data aggregation and calculation using condition keys)
<E> Merge
(Same layout / format integration: n → 1, m → n)
<F> branch
(Same layout / format branch: 1 → n, n → m)
<G> Matching (join)
(Data output based on key item match determination: 1 to n, n to m)
These functions are combined in a single or complex manner and defined as business processing in the program, so that transmission data to the receiving system can be created flexibly. Next, an unnecessary intermediate data deletion program 604 that deletes unnecessary intermediate files generated and used in the defined business process is arranged. The data conversion / processing template 206 described with reference to FIG. 2 is a group of programs arranged in the order as in the processing configuration example 602 of the data conversion / processing template. As in the example 605, it is divided into a plurality of parts depending on the difference between in-house software parts, external sales package software parts, etc., and stored and managed in the data conversion / processed partial processing template group 601.

  The data transmission processing template 207 described with reference to FIG. 2 will be described in more detail with reference to the data transmission partial template explanatory diagram of FIG. 7. First, as shown in the processing configuration example 702 of the data transmission processing template of FIG. A transmission data backup program 703 for backing up the transmission data generated in the data conversion / processing part 103 described with reference to FIG. Next, a data movement program 704 for transferring data from the data conversion / processing area to the subsequent data transmission area is arranged. Next, a transmission data transmission program 705 based on a data transmission protocol necessary for data transmission to various recipient systems such as HTTP, FTP, an in-house data transmission tool, and commercially available package software for data transmission is arranged. The data transmission processing template 207 described with reference to FIG. 2 is a program group arranged exclusively in the order of the processing configuration example 702 of the data transmission processing template, as shown in the data transmission processing template example 706. , HTTP, FTP, in-house production, and external sales package software are divided into a plurality of transmission protocols, and are held and managed in the data reception partial processing template group 701.

  Regarding the handling of data, as shown in FIG. 8, in the inter-business-system data cooperation HUB system 801, data received from a plurality of transmission source systems 802 using data reception transmission middleware 803 is used as data reception transmission middleware. It is stored in the storage location for 803 as an entity file 809.

  Example of data handling pattern (1) In the pass-through type 806, first, the entity file 809 stored in the storage location for the data reception transmission middleware 803 is moved to the data conversion / processing area as the entity file 809. The data conversion / processing input is used, and the processing result output is also stored as the entity file 809 and then moved to the storage location for the data transmission transmission middleware 805.

  Example of Data Handling Pattern (2) In the file resident / reusable type 807, first, the entity file 809 stored in the storage location for the data receiving transmission middleware 803 is converted into the data conversion / processing area as the entity file 809. The data to be stored and can be reused in other processes, and used as data conversion / processing input while remaining as a resident file 810. The processing result output is also stored as the entity file 809, and then transmitted for data transmission. Move to the storage location for middleware 805.

  Example of Data Handling Pattern (3) In the backup type 808, first, the actual file 809 stored in the storage location for the data receiving transmission middleware 803 is backed up while performing generation management so that it can be used for reprocessing and the like. 811 is moved to the data conversion / processing area as the entity file 809 and used as the data conversion / processing input, and the processing result output is also stored as the entity file 809 and then reprocessed in the subsequent processing. In order to be usable, it is moved to the storage location for the transmission middleware 805 for data transmission while keeping the backup file 811 while performing generation management.

  The substance file 809 moved to the storage location for the data transmission transmission middleware 805 is transmitted to the plurality of receiving systems 804 by the data transmission transmission middleware 805. When each process is normally performed, the entity file 809 other than the resident file 810 and the backup file 811 is deleted. However, when a process abnormality occurs, the entity file 809 is not deleted, and the data is confirmed and re-executed. It has a function that can be processed.

  In this way, by sending and receiving data internally as an actual data file in all of the data reception part, data conversion / processing part, and data transmission part, by executing the process while leaving it, A mechanism that can check the processing result data, and the processing execution status can be checked from the processing schedule software when processing ends abnormally, and if necessary, the necessary files can be used from the middle of the internal processing, and the processing can be re-executed System, a mechanism to delete unnecessary data as needed, and a mechanism to store data by generation management as necessary, so that the process execution status, ease of checking results, Ease of operation at the time of execution can be ensured.

  FIG. 9 is a diagram for explaining processing execution status history file output. In the template group storage area 901, the reception template 902, the conversion / processing template 903, and the transmission template 904 are each embedded with a component single program 905 in which a log file output program is embedded in advance. This is set according to the actual business process, and the actual process definition information 906 is created by defining the relation 907 of the process order between the actual process patterns, and is executed by the inter-business system data linkage HUB system 913 As a result, data is transmitted from the transmission source system 912 to the reception destination system 914 via the inter-business-system data linkage HUB system 913, but the single component incorporated in the processing pattern by executing the series of processing Program call / execution module 9 1 is executed, the internal processing status is recorded in the processing execution status history file 915, and by referring to the processing execution status history file 915 at the time of abnormal termination of processing, the cause, It has a function to assist specification of the re-execution method.

  FIG. 10 is a diagram for explaining security measures. In the template group storage area 1001, a reception template 1002, a conversion / processing template 1003, and a transmission template 1004 are embedded with a component single program 1005 in which a data encryption program is embedded in advance. A template is set in accordance with the actual business process, and the actual process definition information 1006 is created by defining the relation 1007 between the actual process patterns, and is executed by the inter-business system data linkage HUB system 1013. As a result, the data is transmitted from the transmission source system 1012 to the reception destination system 1014 via the inter-business-system data linkage HUB system 1013, but the single component incorporated in the processing pattern by executing the series of processing. Program call By data encryption program installed in the execution module 1011 is executed, the transmission data is encrypted in the range of encryption coverage 1015 has a function of maintaining the security level.

  FIG. 11 is a diagram for explaining unified management of definition information. An administrator who manages the inter-business-system data linkage HUB system 1102 uses the central management software 1108 having a function of centrally managing the setting contents from the administrator PC 1109, so that the transmission source system 1101. To receiving middleware 1104 for receiving data from data, data conversion / processing software 1105 typified by ETL software, transmission middleware 1106 for sending data to the receiving system 1103, and schedule software 1107 for controlling the overall processing schedule By referring to and updating all information such as parameters, data types, data transmission / reception paths, processing logic, processing schedule / timing, etc., which are set and defined for the business system, the inter-business-system data linkage HUB system 1 02 has a function to manage.

  As described above, by creating the process definition by the program creator, the maintenance inside the process is high, the ease of specifying the re-execution location when a process error occurs, and the individual process parts and templates High reusability and reusability due to computerization (for example, even if the specification of the processing template part changes, the processing unit is divided finely, so it is possible to minimize the modification of the system part program. ) Will improve. As a result, the conventional problems can be solved, and further advantages in terms of system operation and management can be enjoyed.

(Example)
Hereinafter, as an example of data linkage from multiple files to multiple files, an example in which parts order information from a plurality of factories is collected and sorted by business partner will be described with reference to FIG.

1501: Data receiving portion The data receiving portion 1501 has a function of receiving data from outside the system and storing information.

1502: Data conversion portion The data conversion portion 1502 receives data from the data reception portion 1501 and sends the data to the data transmission portion 1503. The data format (number of records, file layout, file format, character code, etc.) ) Conversion and processing logic (sorting / matching / summary / branch / merging / editing) (the above-mentioned data conversion / processing program 603).

1503: Data transmission part The data transmission part 1503 has a function of storing and distributing information to be transmitted to the outside of the system.

1504: Processing schedule part It has a function of controlling a series of flows such as taking data from the data input part and sending it to the data transmission part via the conversion part.

1505: Company-wide material master information Company-wide material master information 1505 stores company-wide information of master information necessary for ordering parts for each business partner. Stores details of management information required for each business partner / part such as business partner / part / purchase price / delivery location.

1506: Factory A order information The factory A order information 1506 stores order information for each part sent from the factory A. Stores the details of management information necessary for the factory to order parts from the supplier, such as parts, quantity, supplier, order date, delivery date, delivery date, and purchase price (initially 0). ing .

1507: Factory B order information The factory B order information 1507 stores order information for each part delivered from the factory B. Stores the details of management information necessary for the factory to order parts from the supplier, such as parts, quantity, supplier, order date, delivery date, delivery date, and purchase price (initially 0). ing .

1508: Order information for business partner a Order information 1508 for business partner a stores ordering information sorted for business partner a.

1509: Order error information for business partner a The order error information 1509 for business partner a cannot obtain unit price information because there is no information in the business partner master among the order information sorted for business partner a. Stored order information.

1510: Order error master information for supplier a Order information master information for supplier a 1515 contains information on the supplier master, but the supplier master for which the order information sorted for supplier a did not exist Information is stored.

1511: Order information for the customer b The order information for the customer b is stored in the order information 1511 for the customer b.

1512: Order b error information for customer b The order error information 1512 for customer b cannot obtain unit price information because there is no information in the customer master among the order information sorted for the customer b. Stored order information.

1513: Order error master information for supplier b Order information master information for supplier b 1515 contains information in the supplier master, but does not include order information sorted for supplier b Information is stored.

  The data reception part 1501 receives the factory A order information 1506 as the external system and the factory B order information 1507 as the external system (using the transmission data reception program 503 described above). Further, the company-wide material master information 1505 is received by the data receiving portion 1501 (using the transmission data receiving program 503 described above).

  The processing schedule portion 1504 performs monitoring (control) so as to wait for all files to arrive at the data receiving portion 1501. A time limit can be specified here, and if the necessary information is not available even at a predetermined time, zero dummy files with the same layout and format are created and regarded as alternative files (data The subsequent process proceeds as an empty file with no). For example, when the arrival of the factory A order information 1506 is not in time, 0 pseudo files having the same layout and the same format as the factory A order information 1506 are created as a substitute for the factory A order information 1506, and the subsequent processing is performed. To proceed.

  In the data conversion part 1502, the factory A order information 1506 and the factory B order information 1507 are first merged (using the data conversion / processing program 603 described above), and sorted in ascending order using the business partners and parts as keys (described above). Data conversion / processing program 603). This is referred to as company-wide order information.

  The company-wide order information and company-wide material master information 1505 are matched using the supplier / part as a key (using the data conversion / processing program 603 described above). If they match, the purchase unit price information stored in the company-wide material master information 1505 is taken out and stored in a record having the corresponding supplier / part of the company-wide order information as a key. On the other hand, the part purchase amount of the corresponding record is calculated by taking out the order quantity of the part from the corresponding record of the company-wide order information and multiplying this by the purchase unit price obtained from the company-wide material master information 1505. This part purchase price is stored in a record having the corresponding supplier / part of the company-wide order information as a key. This is sorted by business partner (using the above-described data conversion / processing program 603), information for business partner a is ordering information 1508 for business partner a, and information for business partner b is ordering information for business partner b. The accumulation is repeated as 1508.

  The company-wide order information and the company-wide material master information 1505 are matched using the supplier / part as a key (using the data conversion / processing program 603 described above). If they do not match, two types of error processing are performed.

  The first error process is the order information for which unit price information could not be obtained in the company-wide order information because no information exists in the company-wide material master information 1505 (contract information is not registered as a business partner). In that case, a branch (using the above-described data conversion / processing program 603) is made as supplier order error information in a state in which nothing is performed on the record having the relevant supplier / part of the company-wide order information as a key. If this is part data of the supplier a, it is stored as order error information 1509 for the supplier a, and if it is part data of the supplier b, it is stored as order error information 1512 for the supplier b.

  The second error processing is the company-wide order information registered in the company-wide material master information 1505 but not entered in the company-wide order information (the order is suspended for some reason). Branches as supplier order error master information in a state where nothing is performed on the record having the relevant supplier / part of the company-wide material master information 1505 as a key (using the above-described data conversion / processing program 603). If this is part data of the supplier a, it is stored as order error master information 1510 for the supplier a, and if it is part data of the supplier b, it is stored as order error master information 1513 for the supplier a. The above processing is repeated for all data.

  Order information 1508 for supplier a, order error information 1509 for supplier a, order error master information 1510 for supplier a, order information 1511 for supplier b, order error for supplier b accumulated through the above series of processing. The information 1512 and the order error master information 1513 for the supplier b are converted in the file format by the data conversion part 1502 in units for each supplier. For example, the information group for the supplier a is converted into the CSV format, and the information group for the supplier b is converted into the fixed length format and stored in the data transmission part 1503.

  Specifically, for the supplier a ordering information 1508, the supplier a ordering error information 1509, and the supplier a ordering error master information 1510, the data conversion part 1502 converts the file format into CSV format and sends the data. 1503, the order information 1511 for the customer b, the order error information 1512 for the customer b, and the order error master information 1513 for the customer b are converted into a fixed length format in the data conversion part 1502 and data is transmitted. Stored in portion 1503.

  In the data transmission portion 1503, transmission (transmission) is performed outside the system by a transmission protocol method for each business partner. Specifically, the order information 1508 for the supplier a, the order error information 1509 for the supplier a, and the order error master information 1510 for the supplier a are transmitted from the data transmission portion 1503 by FTP (the transmission data transmission program 705 described above). ), The order information 1511 for the customer b, the order error information 1512 for the customer b, and the order error master information 1513 for the customer b are transmitted from the data transmission portion 1503 by OracleNET8 (the transmission data transmission program 705 described above) use).

  An object of the present invention is to supply a storage medium storing software program codes for realizing the functions of the above-described embodiments to a system (or apparatus), and the system (or apparatus) computer (or CPU or MPU). Needless to say, this is also achieved by reading and executing the program code stored in the storage medium.

  In this case, the program code itself read from the storage medium realizes the functions of the above-described embodiments, and the program code itself and the storage medium storing the program code constitute the present invention.

  As a storage medium for supplying the program code, for example, a flexible disk, a hard disk, an optical disk, a magneto-optical disk, a CD-ROM, a CD-R, a magnetic tape, a nonvolatile memory card, a ROM, or the like can be used.

  Further, by executing the program code read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (basic system or operating system) running on the computer based on the instruction of the program code. Needless to say, a case where the functions of the above-described embodiment are realized by performing part or all of the actual processing and the processing is included.

  Further, after the program code read from the storage medium is written to a memory provided in a function expansion board inserted into the computer or a function expansion unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that the CPU or the like provided in the board or function expansion unit performs part or all of the actual processing, and the functions of the above-described embodiments are realized by the processing.

1 is an overall schematic diagram of a data linkage system between business systems. It is a figure for demonstrating the outline of processing component-izing and template-izing. It is a figure for demonstrating an example of the combination of the components arrange | positioned in a template. It is processing explanatory drawing on schedule software. It is a figure for demonstrating a data reception partial template. It is a figure for demonstrating a data conversion and process part template. It is a figure for demonstrating a data transmission partial template. It is a figure for demonstrating handling of data. It is a figure for demonstrating process execution status log file output. It is a figure for demonstrating a security measure. It is a figure for demonstrating the unified management of definition information. It is a figure which shows the Example of the data cooperation from multiple files to multiple files.

Explanation of symbols

101: Data linkage system between business systems 102: Data reception part 103: Data conversion / processing part 104: Data transmission part 105: Processing schedule part

Claims (8)

A data linkage system that performs data linkage between two or more systems,
A data receiving part for receiving data from the source system;
A data conversion / processing part that converts and / or processes data received from the transmission source system and generates transmission data to the reception destination system;
A data transmission part for transmitting data to the recipient system;
A data linkage system comprising: a data receiving part, a data conversion / processing part, and a process schedule part for controlling a processing order in the data transmission part.   2. The data linkage system according to claim 1, wherein data is internally stored as an actual data file in all of the data receiving part, the data converting / processing part, and the data transmitting part.   3. The data linkage system according to claim 2, further comprising means for confirming the processing result data when the processing is normally completed by executing the processing while leaving the substance data file.   3. The data linkage according to claim 2, further comprising means for confirming a processing execution status at the time of abnormal termination of a process, using a necessary entity data file in the middle of internal processing, and re-executing the processing. system.   The data linkage system according to claim 2, further comprising means for deleting the entity data file.   3. The data linkage system according to claim 2, further comprising means for storing the actual data file under generation management. A data linkage method for performing data linkage between two or more systems via a data linkage system,
A procedure for receiving data from a transmission source system by a data receiving part of the data linkage system;
A procedure for converting and / or processing data received from the transmission source system by the data conversion / processing part of the data linkage system, and generating transmission data to the reception destination system,
A procedure of transmitting data to the destination system by a data transmission portion of the data linkage system;
A data linkage method comprising: a procedure for controlling processing order in the data reception portion, the data conversion / processing portion, and the data transmission portion according to a processing schedule portion of the data linkage system. A computer program for causing a computer to execute a process for data linkage between two or more systems,
A data receiving part for receiving data from a transmission source system; a data conversion / processing part for converting and / or processing data received from the transmission source system to generate transmission data to the reception destination system; A computer program that functions as a data transmission part that transmits data to a reception destination system, a data reception part, the data conversion / processing part, and a process schedule part that controls the order of processing in the data transmission part .

Images