CN111382314A - Method for realizing flexible configuration of heterogeneous system service integration - Google Patents
Method for realizing flexible configuration of heterogeneous system service integration Download PDFInfo
- Publication number
- CN111382314A CN111382314A CN202010199927.8A CN202010199927A CN111382314A CN 111382314 A CN111382314 A CN 111382314A CN 202010199927 A CN202010199927 A CN 202010199927A CN 111382314 A CN111382314 A CN 111382314A
- Authority
- CN
- China
- Prior art keywords
- data
- heterogeneous system
- interface
- xml
- business document
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
- G06F16/838—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for realizing flexible configuration of heterogeneous system service integration, which relates to the technical field of data integration, and adopts a technical scheme comprising two parts of data analysis and data display; in the data analysis part, interface data of the heterogeneous system is read in a dynamic calling mode based on XML or JSON as a data analysis format, the heterogeneous system automatically adapts an analysis template according to returned data, the data is finally analyzed into the XML format fixed in the heterogeneous system, and data interaction of the heterogeneous system is realized by relying on WebService and ODBC; and in the data display part, mapping configuration is carried out on the analyzed data and the data to be displayed of the business document based on the analyzed data, and automatic assignment and display of the business document data are carried out. The invention can be better suitable for integration among business systems, and can realize the purposes that a user can configure the data source and display the data source on a business document interface without the participation of research and development personnel.
Description
Technical Field
The invention relates to the technical field of data integration, in particular to a method for realizing flexible configuration of heterogeneous system service integration.
Background
The contract management system is developed and operated based on the Langchao GS platform, and the core application layer of the contract management system comprises a contract center and a contract settlement part. The contract input function of the contract center is used as a core function of the contract and needs to be integrated with an upstream business system such as a purchasing order, an asset application module and the like. The integrated module has differences according to different manufacturers and different business processes used by each client, the attention points of the same module client are different, and the integrated content is also different.
Therefore, in order to reduce the burden of research and development personnel and increase the expandability of the system, a method for realizing flexible configuration of service integration of the heterogeneous system is provided, and the operations of data reading, data analysis and data mapping assignment among the heterogeneous systems are realized.
Disclosure of Invention
Aiming at the requirements and the defects of the prior art development, the invention aims to reduce the burden of research personnel, provides a method for realizing flexible configuration of heterogeneous system service integration, and realizes the operations of data reading, data analysis and data mapping assignment among heterogeneous systems.
The invention discloses a method for realizing flexible configuration of heterogeneous system service integration, which adopts the following technical scheme for solving the technical problems:
a method for realizing flexible configuration of heterogeneous system service integration comprises two parts of data analysis and data display;
in the data analysis part, the XML or JSON is used as a data analysis format, and the data interaction of a heterogeneous system is realized by relying on WebService and ODBC;
and in the data display part, mapping configuration is carried out on the analyzed data and the data to be displayed of the business document based on the analyzed data, and automatic assignment and display of the business document data are carried out.
In the data analysis part, the concrete operations of data analysis are as follows:
reading interface data of the heterogeneous system in a dynamic calling mode, automatically adapting an analysis template by the heterogeneous system according to returned data, and finally analyzing the data into a fixed XML format inside the heterogeneous system.
Furthermore, the interfaces of the related heterogeneous system comprise a WebService interface and a database interface;
when data of a WebService interface is analyzed, downloading a corresponding ASMX file into an agent class, then executing a method in the agent class through reflection calling, and acquiring a return value;
when analyzing the data of the database interface, the user is required to configure the link address of the source database and the SQL sentence which needs to be fetched, the heterogeneous system directly executes the designated SQL in the source database according to the ODBC technology, and the returned data is organized into an XML format.
Furthermore, the interface data of the heterogeneous system is read in a dynamic calling manner, and at this time, the format of the returned data needs to be judged:
A) if the list name information is in the XML format, judging that the list name information is stored in a single node or the list name and the list value share one node, and uniformly formatting the data into a style of the list name single node according to different storage positions of the list name information;
B) and if the JSON format is the JSON format, the JSON strings are analyzed similarly, information of each JSON substring is obtained, the column names and the column values are read, the column names and the column values are formatted into an XML form, and the list is singly node.
In the data display part, based on the analyzed data, the heterogeneous system displays the analyzed data in a form of a master-slave table in the configuration function.
Preferably, the display interface of the configuration function supports data display of a plurality of heterogeneous systems.
In the data display part, a user can specify a heterogeneous system for acquiring data, and configure whether the column of information is displayed and which field of the business document the column needs to be assigned to for setting aiming at each column, and mapping configuration of the analyzed data and the data to be displayed by the business document is completed.
In the data display part, after the business document is loaded or fixed operation is clicked, the interface data of the heterogeneous system is read in a dynamic calling mode and displayed in a fixed master-slave table, and the display of the data in the business document is completed.
Preferably, the user can select the heterogeneous system interface data to be acquired by himself and display the heterogeneous system interface data in the master-slave table.
In the data display part, the automatic assignment of the business document data is carried out, and the steps comprise:
firstly, acquiring the corresponding relation between data selected by a user and the content of a business document based on the mapping configuration;
then, the interface of the business document is analyzed into an XML format, each control is an independent XML node, and then XML node information is replaced according to the corresponding relation;
and finally, reversely analyzing the replaced XML and displaying the XML on an interface.
Compared with the prior art, the method for realizing the flexible configuration of the heterogeneous system service integration has the following beneficial effects:
1) the data analysis is based on the current mainstream XML and JSON as the format of the data analysis, the data interaction of a heterogeneous system is realized by relying on the technologies such as WebService, ODBC and the like, and the data display shows the data of the heterogeneous system in the service document based on XML configuration on the basis of the data analysis, so that the purposes of configuring a data source and displaying the data in a service document interface by a user without the participation of research and development personnel can be realized;
2) the invention can enable a user to flexibly configure the interface path of the heterogeneous system, and configure the data corresponding relation with the business document according to the analyzed information, thereby achieving the effect of automatically acquiring data from the heterogeneous system without manual input again when the business document is made;
3) compared with the mainstream heterogeneous system integration method, the method can be better suitable for integration among service systems, and the aim of setting the source and the destination of service data can be realized by a system user through configuration under the condition of not needing research and development personnel to participate.
Detailed Description
In order to make the technical scheme, the technical problems to be solved and the technical effects of the present invention more clearly apparent, the following technical scheme of the present invention is clearly and completely described with reference to the specific embodiments.
The first embodiment is as follows:
the embodiment provides a method for realizing flexible configuration of heterogeneous system service integration, which comprises two parts, namely data analysis and data display.
In the data analysis part, the data interaction of the heterogeneous system is realized by relying on WebService and ODBC based on XML or JSON as a data analysis format. The specific operation of data analysis is as follows:
reading interface data of the heterogeneous system in a dynamic calling mode, automatically adapting an analysis template by the heterogeneous system according to returned data, and finally analyzing the data into a fixed XML format inside the heterogeneous system.
Reading interface data of the heterogeneous system in a dynamic calling mode, wherein at the moment, the format of returned data needs to be judged:
A) if the list name information is in the XML format, judging that the list name information is stored in a single node or the list name and the list value share one node, and uniformly formatting the data into a style of the list name single node according to different storage positions of the list name information;
B) and if the JSON format is the JSON format, the JSON strings are analyzed similarly, information of each JSON substring is obtained, the column names and the column values are read, the column names and the column values are formatted into an XML form, and the list is singly node.
In the process of data analysis, the interfaces of the related heterogeneous system comprise a WebService interface and a database interface. Wherein: when data of a WebService interface is analyzed, downloading a corresponding ASMX file into an agent class, then executing a method in the agent class through reflection calling, and acquiring a return value; when analyzing the data of the database interface, the user is required to configure the link address of the source database and the SQL sentence which needs to be fetched, the heterogeneous system directly executes the designated SQL in the source database according to the ODBC technology, and the returned data is organized into an XML format.
And in the data display part, mapping configuration is carried out on the analyzed data and the data to be displayed of the business document based on the analyzed data, and automatic assignment and display of the business document data are carried out. In the process, the heterogeneous system displays the analyzed data in a form of a master-slave table in the configuration function. The display interface of the configuration function supports data display of a plurality of heterogeneous systems.
In the data display part, a user can specify a heterogeneous system for acquiring data, and configure whether the column of information is displayed and which field of the business document the column needs to be assigned to for setting aiming at each column, so that mapping configuration of the analyzed data and the data to be displayed by the business document is completed.
In the data display part, after the business document is loaded or fixed operation is clicked, the interface data of the heterogeneous system is read in a dynamic calling mode and displayed in a fixed master-slave table, and the display of the data in the business document is completed. In the process, the user can select the heterogeneous system interface data to be acquired by himself and display the heterogeneous system interface data in the master-slave table.
In the data display part, the automatic assignment of the business document data is carried out, and the steps comprise:
firstly, acquiring the corresponding relation between data selected by a user and the content of a business document based on the mapping configuration;
then, the interface of the business document is analyzed into an XML format, each control is an independent XML node, and then XML node information is replaced according to the corresponding relation;
and finally, reversely analyzing the replaced XML and displaying the XML on an interface.
The method for realizing the flexible configuration of the heterogeneous system service integration based on the embodiment is applied to contract reference of a contract management system. The specific application process and effect are as follows:
the upstream business of the contract card comprises a purchase order, a sales order, a maintenance application, an outsourcing application and the like, and in order to reduce repeated entry of data and maintain the consistency of upstream and downstream business data, the data is acquired from the business system to the contract card through a reference function when the contract is entered. In this embodiment, the contract card is used to refer to the purchase order as an example to perform specific display of the method application.
The interface provided by the purchase order system is a WebService interface, a WSDL file address of the interface and a specific method name of the acquired data are input in the reference configuration function, then an analysis button is clicked, the system accesses the WSDL address and downloads the content into a binary form, the system generates an accessible proxy class according to the binary form, and then an object is instantiated for the proxy class and the configured method name is called. The system obtains the return information of the method, judges the format of the information, in this case, the XML format and the mode of storing the list single node, reads the node information to obtain the list name, and then displays the list name in the form of a master-slave table in the reference configuration function.
And each column can be expanded and configured in a master-slave table with reference configuration function, and whether the column is displayed on a reference interface, and whether the field of the corresponding business document is modifiable after value assignment is performed can be set. And the user configures according to the business requirements in the master-slave table, such as displaying the hidden purchase order ID, corresponding the sum of the purchase order to the contract sum, and corresponding the material of the purchase order to the contract sum and setting the material of the purchase order to be not modifiable.
After the configuration is completed, when a user newly adds a contract card, the user clicks the reference button, the data of the opposite side system is displayed according to the reference configuration function, and the user checks the order number DD001 in one piece of data and clicks the confirmation button. The system obtains the corresponding relationship between the column of the purchase order and the column of the contract card, for example, the order amount corresponds to the contract amount. The system finds the nodes of the XML of the contract card form according to the contract amount, assigns values to the configuration section of the contract amount, and assigns the information of the contract target according to the same principle. The change event of the XML is registered, the display information of the card interface can be correspondingly updated after the XML value of the form is changed, and whether the control of the contract card interface is read only can be controlled through the read-only attribute of the XML, so that the assignment effect is achieved.
By the method, the effect that a user flexibly configures the source of the data and the corresponding data are displayed on a downstream service system interface when performing service integration can be realized.
Claims (10)
1. A method for realizing flexible configuration of heterogeneous system service integration is characterized in that the method comprises two parts of data analysis and data display;
in the data analysis part, the XML or JSON is used as a data analysis format, and the data interaction of a heterogeneous system is realized by relying on WebService and ODBC;
and in the data display part, mapping configuration is carried out on the analyzed data and the data to be displayed of the business document based on the analyzed data, and automatic assignment and display of the business document data are carried out.
2. The method for implementing flexible configuration of heterogeneous system service integration according to claim 1, wherein in the data parsing part, the specific operations of data parsing are as follows:
reading interface data of the heterogeneous system in a dynamic calling mode, automatically adapting an analysis template by the heterogeneous system according to returned data, and finally analyzing the data into a fixed XML format inside the heterogeneous system.
3. The method of claim 2, wherein the interfaces of the heterogeneous system include a WebService interface and a database interface;
when data of a WebService interface is analyzed, downloading a corresponding ASMX file into an agent class, then executing a method in the agent class through reflection calling, and acquiring a return value;
when analyzing the data of the database interface, the user is required to configure the link address of the source database and the SQL sentence which needs to be fetched, the heterogeneous system directly executes the designated SQL in the source database according to the ODBC technology, and the returned data is organized into an XML format.
4. The method of claim 3, wherein the interface data of the heterogeneous system is read in a dynamic call manner, and at this time, the format of the returned data needs to be determined:
A) if the list name information is in the XML format, judging that the list name information is stored in a single node or the list name and the list value share one node, and uniformly formatting the data into a style of the list name single node according to different storage positions of the list name information;
B) and if the JSON format is the JSON format, the JSON strings are analyzed similarly, information of each JSON substring is obtained, the column names and the column values are read, the column names and the column values are formatted into an XML form, and the list is singly node.
5. The method of claim 4, wherein in the data presentation part, based on the parsed data, the heterogeneous system presents the parsed data in a form of a master-slave table in the configuration function.
6. The method of claim 5, wherein the presentation interface of the configuration function supports data presentation of multiple heterogeneous systems.
7. The method for realizing the flexible configuration of the business integration of the heterogeneous system according to claim 5, wherein in the data display part, a user can specify the heterogeneous system for obtaining the data, and configure whether the information of the column is displayed and which field of the business document the column needs to be assigned with, for each column, to set, and complete the mapping configuration of the analyzed data and the data to be displayed by the business document.
8. The method for realizing the flexible configuration of the business integration of the heterogeneous system according to claim 7, wherein in the data display part, after the business document is loaded or fixed operation is clicked, the interface data of the heterogeneous system is read in a dynamic calling mode and displayed in a fixed master-slave form, so that the display of the data in the business document is completed.
9. The method of claim 8, wherein a user can select the heterogeneous system interface data to be acquired and display the data in a master-slave table.
10. The method for implementing flexible configuration of heterogeneous system service integration according to claim 8, wherein the automatic assignment of the service document data is performed in the data display part, and the steps include:
firstly, acquiring the corresponding relation between data selected by a user and the content of a business document based on the mapping configuration;
then, the interface of the business document is analyzed into an XML format, each control is an independent XML node, and then XML node information is replaced according to the corresponding relation;
and finally, reversely analyzing the replaced XML and displaying the XML on an interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010199927.8A CN111382314A (en) | 2020-03-20 | 2020-03-20 | Method for realizing flexible configuration of heterogeneous system service integration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010199927.8A CN111382314A (en) | 2020-03-20 | 2020-03-20 | Method for realizing flexible configuration of heterogeneous system service integration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111382314A true CN111382314A (en) | 2020-07-07 |
Family
ID=71222720
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010199927.8A Pending CN111382314A (en) | 2020-03-20 | 2020-03-20 | Method for realizing flexible configuration of heterogeneous system service integration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111382314A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256325A (en) * | 2020-10-14 | 2021-01-22 | 北京康惠达科技有限公司 | Interface data adaptation method, equipment, server and storage medium |
| CN112769975A (en) * | 2020-12-31 | 2021-05-07 | 武汉联影医疗科技有限公司 | Data integration method and device, server and storage medium |
| CN114035869A (en) * | 2021-10-26 | 2022-02-11 | 浪潮通信信息系统有限公司 | XML-based configurable interface calling method and system in service order |
| CN114281500A (en) * | 2021-12-22 | 2022-04-05 | 清源云信(武汉)科技有限公司 | A data interface integration configuration method that is convenient for docking with external systems |
| CN116450717A (en) * | 2023-03-14 | 2023-07-18 | 深圳市英捷软件有限公司 | Data integration method and information management system for cross-service modules |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030074419A1 (en) * | 2001-10-15 | 2003-04-17 | Vanderdrift Richard William | System and method for non-programmers to dynamically manage multiple sets of XML document data |
| CN102135954A (en) * | 2010-12-31 | 2011-07-27 | 浪潮集团山东通用软件有限公司 | Method for describing bill conversion relationships in service management software based on extensive markup language (XML) |
| CN102867067A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Device and method for data integration processing for heterogenous system |
| CN103092872A (en) * | 2011-11-01 | 2013-05-08 | 镇江华扬信息科技有限公司 | XML (Extensive Makeup Language) technology based isomerous database access method |
| CN104239073A (en) * | 2014-10-15 | 2014-12-24 | 中国科学院软件研究所 | Data maintenance system rapid prototyping development system and method |
| CN104572096A (en) * | 2014-12-29 | 2015-04-29 | 中国科学院计算机网络信息中心 | A WEB-based multi-model data visualization development method and platform |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN107451103A (en) * | 2016-03-31 | 2017-12-08 | 阿里巴巴集团控股有限公司 | Template for displaying and amending method and equipment |
-
2020
- 2020-03-20 CN CN202010199927.8A patent/CN111382314A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030074419A1 (en) * | 2001-10-15 | 2003-04-17 | Vanderdrift Richard William | System and method for non-programmers to dynamically manage multiple sets of XML document data |
| CN102135954A (en) * | 2010-12-31 | 2011-07-27 | 浪潮集团山东通用软件有限公司 | Method for describing bill conversion relationships in service management software based on extensive markup language (XML) |
| CN103092872A (en) * | 2011-11-01 | 2013-05-08 | 镇江华扬信息科技有限公司 | XML (Extensive Makeup Language) technology based isomerous database access method |
| CN102867067A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Device and method for data integration processing for heterogenous system |
| CN104239073A (en) * | 2014-10-15 | 2014-12-24 | 中国科学院软件研究所 | Data maintenance system rapid prototyping development system and method |
| CN104572096A (en) * | 2014-12-29 | 2015-04-29 | 中国科学院计算机网络信息中心 | A WEB-based multi-model data visualization development method and platform |
| CN107451103A (en) * | 2016-03-31 | 2017-12-08 | 阿里巴巴集团控股有限公司 | Template for displaying and amending method and equipment |
| CN106874388A (en) * | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
Non-Patent Citations (1)
| Title |
|---|
| 陈次白，丁晟春，颜端武等, 国防工业出版社 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256325A (en) * | 2020-10-14 | 2021-01-22 | 北京康惠达科技有限公司 | Interface data adaptation method, equipment, server and storage medium |
| CN112769975A (en) * | 2020-12-31 | 2021-05-07 | 武汉联影医疗科技有限公司 | Data integration method and device, server and storage medium |
| CN112769975B (en) * | 2020-12-31 | 2022-06-24 | 武汉联影医疗科技有限公司 | A data integration method, device, server and storage medium |
| CN114035869A (en) * | 2021-10-26 | 2022-02-11 | 浪潮通信信息系统有限公司 | XML-based configurable interface calling method and system in service order |
| CN114281500A (en) * | 2021-12-22 | 2022-04-05 | 清源云信(武汉)科技有限公司 | A data interface integration configuration method that is convenient for docking with external systems |
| CN116450717A (en) * | 2023-03-14 | 2023-07-18 | 深圳市英捷软件有限公司 | Data integration method and information management system for cross-service modules |
| CN116450717B (en) * | 2023-03-14 | 2023-10-20 | 深圳市英捷软件有限公司 | Data integration method and information management system for cross-service modules |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111382314A (en) | Method for realizing flexible configuration of heterogeneous system service integration | |
| Ganesh et al. | Openerp/odoo-an open source concept to erp solution | |
| CN106598612B (en) | Operation method and system for data table in database | |
| AU2010337218B2 (en) | Specifying user interface elements | |
| US8930337B2 (en) | Mapping dataset elements | |
| US8301420B2 (en) | Method and apparatus for creating a representation of a product or process | |
| US8630969B2 (en) | Systems and methods for implementing business rules designed with cloud computing | |
| US20070011650A1 (en) | Computer method and apparatus for developing web pages and applications | |
| JP7206419B2 (en) | Artificial intelligence recommendation model feature processing method, device, electronic device, and computer program | |
| US20040249867A1 (en) | Mining model versioning | |
| KR101201019B1 (en) | Declarative sequenced report parameterization | |
| CN106990970A (en) | Based on MVC dynamic pages generation method and system | |
| KR20090089601A (en) | Automated document creation system and document creation automation method that combines document form and input data to create document automatically using document creation application | |
| CN110489401B (en) | Method and device for deploying database objects | |
| CN111784108B (en) | Modeling method and device of main data management platform | |
| CN104216701A (en) | System and method for creating a graphical user interface within a manufacturing execution system | |
| CN109840298A (en) | The multi information source acquisition method and system of large scale network data | |
| US7168062B1 (en) | Object-oriented software system allowing live modification of an application | |
| CN110019177A (en) | The method and apparatus of rule storage | |
| US9244706B2 (en) | Command line shell command generation based on schema | |
| US20210124752A1 (en) | System for Data Collection, Aggregation, Storage, Verification and Analytics with User Interface | |
| CN116974527B (en) | Pluggable page expansion method and system based on low-code front-end component | |
| CN112131022A (en) | Open API management method, apparatus, system and computer-readable storage medium | |
| CN116301856A (en) | Design method, device, equipment and medium of visual form designer | |
| US20080022258A1 (en) | Custom database system and method of building and operating the same |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200707 |