CN107977277B - Method and device for integrating third-party system in ERP system and computer equipment - Google Patents
Method and device for integrating third-party system in ERP system and computer equipment Download PDFInfo
- Publication number
- CN107977277B CN107977277B CN201711391277.1A CN201711391277A CN107977277B CN 107977277 B CN107977277 B CN 107977277B CN 201711391277 A CN201711391277 A CN 201711391277A CN 107977277 B CN107977277 B CN 107977277B
- Authority
- CN
- China
- Prior art keywords
- data
- party system
- request
- interface
- party
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/543—User-generated data transfer, e.g. clipboards, dynamic data exchange [DDE], object linking and embedding [OLE]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method and a device for integrating a third-party system in an ERP system, computer equipment and a storage medium. The method comprises the following steps: the ERP system acquires a data request, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance by an accessed third-party system; acquiring corresponding data from a database according to the data request; and returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display. By the mode, the third-party system accessed to the ERP system can simply and quickly acquire the data of the ERP system, the ERP system and the third-party system do not need to know the structure of the other party, and only a corresponding interface is called, so that the process of synchronizing a large amount of data is reduced, and the convenience of acquiring the data is improved.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method and a device for integrating a third-party system in an ERP system, computer equipment and a storage medium.
Background
The ERP system is a short term for Enterprise Resource Planning (Enterprise Resource Planning), and is a management platform which is established on the basis of information technology, integrates the information technology and advanced management ideas, and provides decision means for Enterprise employees and decision layers by using a systematized management idea. The system is a new generation of integrated management information system developed from MRP (material demand planning), expands the functions of MRP and has the core idea of supply chain management.
In the actual operation process, different third-party systems need to be integrated in the ERP system, and when the third-party systems are integrated, the ERP system generally provides data, and the third-party systems integrate the ERP data. In the conventional technology, an ELT (Extract-Transform-Load) tool is generally adopted to synchronize data between the ERP system and a third-party system. However, this scheme has a problem of a large amount of data redundancy.
Disclosure of Invention
In view of the foregoing, it is necessary to provide a method, an apparatus, a computer device and a storage medium for integrating a third-party system in an ERP system.
A method of integrating a third party system in an ERP system, the method comprising:
the ERP system acquires a data request, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance by an accessed third-party system;
acquiring corresponding data from a database according to the data request;
and returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display.
In one embodiment, the obtaining corresponding data from the database according to the data request includes: and receiving an operation request for the ERP system, which is generated by the third-party system calling a standard data interface, and performing corresponding operation on data in a database according to the operation request.
In one embodiment, the obtaining corresponding data from the database according to the data request includes: and acquiring corresponding data from a database according to the request parameters carried in the data request.
In one embodiment, the method further comprises: and adding a third-party view template in a list of the ERP system, wherein the third-party view template is used for the third-party system to design pages.
In one embodiment, before the ERP system obtains the data request, the method further includes: acquiring the service requirement of a third-party system; and configuring a standard data interface and a metadata interface according to the service requirement.
In one embodiment, the obtaining corresponding data from the database according to the data request includes:
and receiving a page style data request generated by the third-party system calling a metadata interface, and acquiring corresponding page style data from a database according to the page style data request, wherein the page style data defines at least one of layout information and display fields of the third-party system page.
An apparatus for integrating a third party system in an ERP system, the apparatus comprising:
and the data request acquisition module is used for the ERP system to acquire a data request, and the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance by an accessed third-party system.
And the data response module is used for acquiring corresponding data from a database according to the data request and returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display.
In one embodiment, the data request obtaining module is further configured to receive an operation request for the ERP system, which is generated by a third-party system calling a standard data interface, and perform corresponding operation on data in the database according to the operation request.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps when executing the program of:
the ERP system acquires a data request, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance by an accessed third-party system;
acquiring corresponding data from a database according to the data request;
and returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
the ERP system acquires a data request, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance by an accessed third-party system;
acquiring corresponding data from a database according to the data request;
and returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display.
The method, the device, the computer equipment and the storage medium for integrating the third-party system in the ERP system acquire the data request through the ERP system, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance by the accessed third-party system; acquiring corresponding data from a database according to the data request; and returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display. By the mode, the third-party system accessed to the ERP system can simply and quickly acquire the data of the ERP system, the ERP system and the third-party system do not need to know the structure of the other party, and only a corresponding interface is called, so that the process of synchronizing a large amount of data is reduced, and the convenience of acquiring the data is improved.
Drawings
FIG. 1 is a diagram of an application environment for a method of integrating third-party systems in an ERP system, in one embodiment;
FIG. 2 is a diagram illustrating an internal structure of a computer device according to an embodiment;
FIG. 3 is a schematic flow chart illustrating a method for integrating a third-party system in an ERP system, according to an embodiment;
FIG. 4 is a schematic flow chart illustrating a method for integrating a third-party system in an ERP system in accordance with another embodiment;
FIG. 5 is a block diagram illustrating the structure of an ERP system and a third-party system in one embodiment;
FIG. 6 is a block diagram of an apparatus for integrating a third-party system in an ERP system, in accordance with an embodiment;
fig. 7 is a block diagram illustrating an apparatus for integrating a third-party system in the ERP system in another embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
FIG. 1 illustrates an application environment diagram of a method for integrating third-party systems in an ERP system, in one embodiment. Referring to fig. 1, the system includes an ERP system 110 and a third party system 120, and the ERP system 110 is connected to the server 120 through a network. The ERP system 110 and the third-party system may be servers that implement a single function, or may be servers that implement multiple functions, specifically, may be independent physical servers, or may be a physical server cluster. The ERP system 110 may also run on a terminal, and when running on the terminal, the configuration interface may be displayed through a specific application, such as configuring a standard data interface and a metadata interface through the configuration interface.
FIG. 2 is a diagram showing an internal configuration of a computer device according to an embodiment. The computer device may specifically run an ERP system 110 as in fig. 1. As shown in fig. 2, the computer apparatus includes a processor, a storage medium, an internal memory, a network interface, a display screen, and an input device, which are connected through a system bus. Wherein, the processor is used for providing calculation and control capability and supporting the operation of the whole computer equipment. A storage medium of a computer device stores an operating system and a computer program that, when executed by a processor, causes the processor to implement a method of integrating a third party system in an ERP system. The internal memory of the computer device may also store a computer program that, when executed by the processor, causes the processor to perform a method of integrating a third party system in an ERP system. The network interface of the computer device is used to communicate with the third party system 120, such as by obtaining a data request generated by the third party system 120 by invoking the standard data interface and the metadata interface via the network interface. The display screen of the computer device may be a liquid crystal display screen or an electronic ink display screen, the input device of the computer device may be a touch layer covered on the display screen, or may be a key, a trackball or a touch pad arranged on a housing of the computer device, or may be an external keyboard, a touch pad or a mouse, and the input device may obtain the data acquisition request initiated by the third-party system 120 by loading the server address of the third-party system 120. The display screen can be used for displaying a configuration interface of a standard data interface and a metadata interface or displaying a page by a third-party system and the like.
It will be appreciated by those skilled in the art that the configuration shown in fig. 2 is a block diagram of only a portion of the configuration associated with the inventive arrangements and does not constitute a limitation of the terminal to which the inventive arrangements are applied, and that a particular terminal may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
As shown in fig. 3, in one embodiment, a method for integrating a third party system in an ERP system is provided, which is exemplified by being applied to the ERP system shown in fig. 1 and 2. The method comprises the following steps:
And step 304, acquiring corresponding data from the database according to the data request.
An API (Application Programming Interface) is a predefined function that is intended to provide applications and developers the ability to access a set of routines based on certain software or hardware, without accessing source code or understanding the details of internal working mechanisms, generally referred to as interfaces. In the actual use process, REST API, SOAP protocol, and the like are generally used. restful, reproducible State Transfer, represents a layer State transition. REST is an architectural design guideline that all Web applications should adhere to, while restful API refers to an API that conforms to REST architectural design. The REST API is used for facilitating integration of a third-party system and improving interoperability. A standard data interface and a metadata interface are pre-configured in the ERP system and are used for a third-party system accessing the ERP system to call. After the third-party system is accessed into the ERP system, a corresponding data request can be initiated to the ERP system by calling the standard data interface and the metadata interface, and after the ERP system obtains the data request initiated by the third-party system, the corresponding data can be returned according to the data request.
And step 306, returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display.
After the data request initiated by the third-party system is obtained, the ERP system performs specific response according to parameters specifically carried in the data request, that is, corresponding data is returned to the third-party system, and after the third-party system receives the data returned by the ERP system, the displayed data is updated or filled on a page, or the ERP system can perform page rendering according to the received data.
By the mode, the third-party system accessed to the ERP system can simply and quickly acquire the data of the ERP system, the ERP system and the third-party system do not need to know the structure of the other party, and only a corresponding interface is called, so that the process of synchronizing a large amount of data is reduced, and the convenience of acquiring the data is improved.
In one embodiment, obtaining corresponding data from a database according to a data request includes: and receiving an operation request for the ERP system, which is generated by calling a standard data interface by a third-party system, and performing corresponding operation on data in the database according to the operation request.
The standard data interface may be an interface based on a REST (Representational State Transfer) protocol, and may be called by a third party system, where the third party may send an operation request to the ERP system by calling the standard data interface, and then the third party system may perform a corresponding operation on data in the ERP system database. The operation comprises operations of adding, modifying, deleting, inquiring and the like, wherein the adding means that a third-party system can add new data to the data in the ERP system database; the modification means that a third-party system can correct, revise and the like the data in the ERP system database; deleting the delete, namely the delete in common, means that the third-party system can remove invalid data or repeated data and the like in the ERP system database through a delete command; the query is the operation of querying, checking and the like. By calling the interface, the accessed third-party system can realize the increasing, deleting, modifying and checking of the data in the database in the ERP system without complex data synchronization, the operation is simple, and the efficiency of data operation is improved.
In one embodiment, obtaining corresponding data from a database according to a data request includes: and acquiring corresponding data from the database according to the request parameters carried in the data request.
Each request carries a request parameter, and the difference of the request parameters determines the difference of the acquired data. For example, if the request parameters carried in the request for obtaining the comment list are the user name, the comment content, and the number of praise, the obtained data corresponds to the user name, the specific content of the comment, and the number of praise corresponding to each comment. If the request for commenting the user list is obtained, the carried request parameters may be a user name, a user avatar, user gender and the number of commenting users, and the obtained data is the user name on the commenting list, the avatar URL (avatar address) of the user, the gender of the user and the number of commenting users in the general commenting list. Therefore, after the ERP system obtains the data request sent by the third-party system, the ERP system obtains corresponding data from the database according to the request parameters carried in the data request, and then returns the data to the third-party system for data display on the page.
In general, REST protocols are used, which have the advantage that REST stresses that HTTP should be Resource-centric and specifies the style of Resource URI (Uniform Resource Identifier) and the use of HTTP request actions (PUT, POST, etc.), with corresponding semantics. Applications that comply with the REST specification will therefore obtain the following benefits: URL (Uniform Resource Locator) has strong readability and self-descriptiveness; loose coupling of resource descriptions to views; the OpenAPI can be provided, so that the integration of a third-party system is facilitated, and the interoperability is improved; if a stateless service interface is provided, the horizontal scalability of the application can be improved, and the like. Therefore, the REST protocol is used for sending the data request, and corresponding data are returned according to the request parameters in the specific data request, so that the data transmission is more simplified and more accurate, the data redundancy is avoided, and the data transmission efficiency is improved.
In one embodiment, the method further comprises: and adding a third-party view template in the list of the ERP system, wherein the third-party view template is used for the third-party system to design pages.
The third-party view template refers to a third-party view design control provided by the ERP list, and the control has the function of designing the third-party view list. The control is the encapsulation of data and methods, the control can have its own attributes and methods, wherein the attributes are simple visitors of the control data, the methods are some simple and visible functions of the control, the greatest meaning of creating the control lies in the repeated work of encapsulation, and the functions of the existing control can be expanded. After the third-party view template is added to the list of the ERP system, the third-party system can directly use the third-party view template when performing page design, so that the page design of the third-party system is uniform, and the management of the third-party system is facilitated.
In one embodiment, before the ERP system obtains the data request, the method further includes: acquiring the service requirement of a third-party system; and configuring a standard data interface and a metadata interface according to the service requirement.
For different third-party systems, respective requirements are different, because when a standard data interface and a metadata interface which are configured on the ERP system in advance are called to generate data requests, data which need to be acquired from an ERP system database are also different, in order to realize the 'customized' of the accessed third-party system, the ERP system can be configured according to the requirements of the third-party system when the standard data interface and the metadata interface are configured in advance, namely the standard data interface and the metadata interface are customized according to the third-party system, and different parameters are configured for the interfaces. When configuration is carried out, specific configuration operation can be carried out on the interface through the configuration interface.
For example, if a third-party system named a needs to obtain name data, a request parameter of "name" may be configured in the parameter of the standard data interface, and a third-party system named B needs gender data, then the request parameter of the standard data interface customized for the third-party system named B includes "sender". Therefore, request parameters in data requests generated by different standard data interfaces called by the third-party system and metadata interfaces may be different, and when the ERP system acquires the data request of the third-party system, corresponding data needs to be acquired from the database according to the request parameters specifically carried in the data request, and then the data is returned to the third-party system. The interface is customized according to the service requirement, the specific requirement of each third-party system can be processed in a targeted manner, and the simplicity and the accuracy of data transmission are further improved.
In one embodiment, obtaining corresponding data from a database according to a data request includes: and receiving a page style data request generated by a third-party system calling a metadata interface, and acquiring corresponding page style data from a database according to the page style data request, wherein the page style data defines at least one of layout information and display fields of a third-party system page.
The third-party system generates a page style data request when calling the metadata interface, and the ERP system acquires corresponding page style data from the database according to the page style data request after receiving the page style data request. The page style data includes layout information, display fields, etc. of the third-party system page, and may also include font styles, such as the color of the "name" displayed on the page, font size, line spacing between fonts, etc. The page layout can be divided into a static layout and a dynamic layout, wherein the static layout refers to a layout mode in which page elements are not changed, and the elements on the page are fixed and cannot be changed along with a request. The dynamic layout is just the opposite, and the elements on the page change according to the data obtained after the request is initiated, in a simple way, the data is requested, and then the returned data is filled in the page. Here, the page layout of the third-party system is a dynamic layout, and therefore, a page style data request needs to be initiated by calling a metadata interface, and then page rendering is performed according to page style data returned by the ERP system, where the page rendering is a process of displaying page elements and corresponding data on a page. Through the calling of the interface, the specific display of the page is carried out according to the returned data, the real-time performance and the accuracy of the page data display are ensured, and the control and the management of the ERP system on the display data on the page of the third-party system are facilitated.
As shown in fig. 4, in an embodiment, a method for integrating a third-party system in an ERP system is further provided, and the method is exemplified by being applied to the ERP system shown in fig. 1 and fig. 2. The method comprises the following steps:
At step 404, the ERP system adds a third party view template to the list.
A standard data interface and a metadata interface are pre-configured in the ERP system and are used for a third-party system accessing the ERP system to call. The third-party system calls the standard data interface to perform operations such as adding, modifying, deleting and inquiring on the ERP system, the metadata interface can acquire the style and layout data of the page, and the page can be laid out and rendered by combining the data acquired by calling the standard data interface. A third-party view template is also added in advance in the list of the ERP system, and the third-party view template can be directly used by the third-party system when the third-party system carries out page design.
Before the third-party system is accessed, the ERP system verifies the authority of the third-party system, and after the third-party system passes the verification, the third-party system can be successfully accessed to the ERP system. The third-party system can obtain corresponding data by calling the standard data interface and the metadata interface, and the ERP system can return the corresponding data to the third-party system according to request parameters specifically carried in the data request after obtaining the data request initiated by the third-party system by calling the standard data interface and the metadata interface. And after the ERP system calls a page style data request generated by the metadata interface according to the third-party system, the corresponding page style data is returned, and the third-party system can finish page rendering by combining the data returned by the ERP system according to the third-party system calling the standard data interface, namely displaying specific data and page layout on the page.
As shown in FIG. 5, the things that the ERP system needs to do can be summarized simply as: and configuring a standard data interface, a metadata interface and a third-party view template, wherein the third-party system can directly use the third-party view template, and then the page rendering can be completed only by calling the configuration standard data interface and the metadata interface. By the mode, the third-party system accessed to the ERP system can simply and quickly acquire the data of the ERP system, the ERP system and the third-party system do not need to know the structure of the other party, and only a corresponding interface is called, so that the process of synchronizing a large amount of data is reduced, and the convenience of acquiring the data is improved.
In one embodiment, as shown in fig. 6, there is provided an apparatus for integrating a third-party system in an ERP system, including:
the data request obtaining module 602 is configured to obtain a data request by the ERP system, where the data request is generated by an access third-party system calling a standard data interface and a metadata interface that are configured on the ERP system in advance.
And the data response module 604 is configured to obtain corresponding data from the database according to the data request, and return the corresponding data to the third-party system, where the data is used for the third-party system to complete data and page display.
In an embodiment, the data request obtaining module 602 is further configured to receive an operation request for the ERP system, which is generated by a third-party system calling a standard data interface, and perform a corresponding operation on data in the database according to the operation request.
In an embodiment, the data request obtaining module 602 is further configured to receive a page style data request generated by the third-party system invoking the metadata interface, and obtain corresponding page style data from the database according to the page style data request, where the page style data defines at least one of layout information and a display field of a page of the third-party system.
In an embodiment, the data response module 604 is further configured to obtain corresponding data from a database according to a request parameter carried in the data request.
As shown in fig. 7, in an embodiment, the apparatus further includes a third-party view adding module 606, configured to add a third-party view template to the list of the ERP system, where the third-party view template is used by the third-party system for page design.
As shown in fig. 7, in an embodiment, the apparatus further includes a configuration module 608, configured to obtain a service requirement of a third-party system; and configuring a standard data interface and a metadata interface according to the service requirement.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: the ERP system acquires a data request, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance by an accessed third-party system; acquiring corresponding data from a database according to the data request; and returning the corresponding data to the third-party system, wherein the data is used for the third-party system to finish data and page display.
In one embodiment, the computer program when executed by the processor to perform the step of retrieving corresponding data from the database in response to the data request comprises: and receiving an operation request for the ERP system, which is generated by calling a standard data interface by a third-party system, and performing corresponding operation on data in the database according to the operation request.
In one embodiment, the computer program when executed by the processor to perform the step of retrieving corresponding data from the database in response to the data request comprises: and acquiring corresponding data from the database according to the request parameters carried in the data request.
In one embodiment, the computer program, when executed by the processor, further comprises the steps of: and adding a third-party view template in the list of the ERP system, wherein the third-party view template is used for the third-party system to design pages.
In one embodiment, before the step of the ERP system obtaining the data request is executed by the processor, the computer program further includes: acquiring the service requirement of a third-party system; and configuring a standard data interface and a metadata interface according to the service requirement.
In one embodiment, the computer program when executed by the processor to perform the step of retrieving corresponding data from the database in response to the data request comprises: and receiving a page style data request generated by a third-party system calling a metadata interface, and acquiring corresponding page style data from a database according to the page style data request, wherein the page style data defines at least one of layout information and display fields of a third-party system page.
It will be understood by those skilled in the art that all or part of the processes in the methods of the embodiments described above may be implemented by a computer program, which is stored in a non-volatile computer-readable storage medium, and executed by at least one processor in a computer system, so as to implement the processes of the embodiments including the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method of integrating a third party system in an ERP system, the method comprising:
the ERP system acquires a data request, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance and correspond to a third-party system by an accessed third-party system;
acquiring corresponding data from a database according to the data request, wherein the data request comprises the following steps: receiving a page style data request generated by the third-party system calling a metadata interface, acquiring corresponding page style data from a database according to the page style data request, wherein the page style data defines at least one of layout information, a display field and a font style of a page of the third-party system, acquiring a data request generated by the third-party system through the standard data interface, and acquiring data corresponding to the standard data interface according to the data request;
and returning the page style data and the data corresponding to the standard data interface to the third-party system, wherein the page style data and the data corresponding to the standard data interface are used for rendering the page by the third-party system, and finishing data and page display.
2. The method of claim 1, wherein obtaining the corresponding data from the database according to the data request comprises:
and receiving an operation request for the ERP system, which is generated by the third-party system calling a standard data interface, and performing corresponding operation on data in a database according to the operation request.
3. The method of claim 1, wherein obtaining the corresponding data from the database according to the data request comprises:
and acquiring corresponding data from a database according to the request parameters carried in the data request.
4. The method of claim 1, further comprising:
and adding a third-party view template in a list of the ERP system, wherein the third-party view template is used for the third-party system to design pages.
5. The method of claim 1, prior to the ERP system obtaining the data request, further comprising:
acquiring the service requirement of a third-party system;
and configuring a standard data interface and a metadata interface according to the service requirement.
6. The method of claim 1, wherein the page layout is divided into a static layout and a dynamic layout.
7. An apparatus for integrating a third party system in an ERP system, the apparatus comprising:
the data request acquisition module is used for the ERP system to acquire a data request, wherein the data request is generated by calling a standard data interface and a metadata interface which are configured on the ERP system in advance and correspond to a third-party system by an accessed third-party system;
the data response module is used for acquiring corresponding data from a database according to the data request, and comprises: receiving a page style data request generated by the third-party system calling a metadata interface, acquiring corresponding page style data from a database according to the page style data request, wherein the page style data defines at least one of layout information, a display field and a font style of a page of the third-party system, acquiring a data request generated by the third-party system through the standard data interface, and acquiring data corresponding to the standard data interface according to the data request; and returning the page style data and the data corresponding to the standard data interface to the third-party system, wherein the page style data and the data corresponding to the standard data interface are used for rendering the page by the third-party system, and finishing data and page display.
8. The apparatus according to claim 7, wherein the data request obtaining module is further configured to receive an operation request for the ERP system, the operation request being generated by a third-party system calling a standard data interface, and perform corresponding operation on data in the database according to the operation request.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program performs the steps of the method of integrating a third party system in an ERP system according to any one of claims 1 to 6.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of integrating a third party system in an ERP system according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711391277.1A CN107977277B (en) | 2017-12-21 | 2017-12-21 | Method and device for integrating third-party system in ERP system and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711391277.1A CN107977277B (en) | 2017-12-21 | 2017-12-21 | Method and device for integrating third-party system in ERP system and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107977277A CN107977277A (en) | 2018-05-01 |
| CN107977277B true CN107977277B (en) | 2021-02-02 |
Family
ID=62007102
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711391277.1A Active CN107977277B (en) | 2017-12-21 | 2017-12-21 | Method and device for integrating third-party system in ERP system and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107977277B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108833355B (en) * | 2018-05-21 | 2020-12-29 | 深圳云之家网络有限公司 | Data processing method, data processing device, computer equipment and computer readable storage medium |
| CN108763586B (en) * | 2018-06-12 | 2022-07-05 | 广东科达洁能股份有限公司 | General data dictionary interface device based on SAP field search help |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751256B (en) * | 2009-12-31 | 2013-09-11 | 金蝶软件（中国）有限公司 | Method and system for exchanging data with third-party system |
| CN103309659A (en) * | 2013-05-24 | 2013-09-18 | 天津市天安怡和信息技术有限公司 | User interface dynamic generation method and device based on rich client platform |
| CN106209936A (en) * | 2015-05-04 | 2016-12-07 | 北大方正集团有限公司 | Third party system data capture method and device |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7188333B1 (en) * | 2001-12-28 | 2007-03-06 | Sprint Communications Company L.P. | Product incompatibility system |
| US7912810B2 (en) * | 2005-06-28 | 2011-03-22 | Sap Ag | Methods, systems and computer program products for integrating carrier services into an enterprise |
-
2017
- 2017-12-21 CN CN201711391277.1A patent/CN107977277B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751256B (en) * | 2009-12-31 | 2013-09-11 | 金蝶软件（中国）有限公司 | Method and system for exchanging data with third-party system |
| CN103309659A (en) * | 2013-05-24 | 2013-09-18 | 天津市天安怡和信息技术有限公司 | User interface dynamic generation method and device based on rich client platform |
| CN106209936A (en) * | 2015-05-04 | 2016-12-07 | 北大方正集团有限公司 | Third party system data capture method and device |
Non-Patent Citations (3)
| Title |
|---|
| ERP中组件技术的研究;赵常思，;《中国优秀博硕士学位论文全文数据库（硕士）信息科技辑（季刊）》;20041215(第04期);I138-489 * |
| SAP模板化推广实施的策略研究和方法设计;蒋伟文，;《中国优秀硕士学位论文全文数据库信息科技辑（月刊）》;20140615(第06期);I138-514 * |
| 赵常思，.ERP中组件技术的研究.《中国优秀博硕士学位论文全文数据库（硕士）信息科技辑（季刊）》.2004,(第04期),I138-489. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107977277A (en) | 2018-05-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111708600B (en) | Page display method, device, equipment and computer readable storage medium | |
| US20220247833A1 (en) | Installable web applications | |
| EP3408744B1 (en) | Providing access to a hybrid application offline | |
| EP3251288B1 (en) | Email integration with shared folder based integrated workspaces | |
| KR102185864B1 (en) | Server-side rendering method and system of native content for presentation | |
| US8312170B2 (en) | Method and apparatus for managing a collection of portlets in a portal server | |
| KR20130126610A (en) | Identifiers for style sheets | |
| CN104519120A (en) | Business object attachments and expiring URL | |
| CN103207873A (en) | Method and system for displaying exclusive user page | |
| US20220164743A1 (en) | Managing projects in a content management system | |
| US20190050420A1 (en) | Edit and share unsupported files through instantly generated preview | |
| CN112685091A (en) | Service request processing method, device, equipment and medium based on big data | |
| CN107977277B (en) | Method and device for integrating third-party system in ERP system and computer equipment | |
| CN113742601A (en) | Content sharing method and device, computer equipment and storage medium | |
| CN107430609B (en) | Generation of new tab pages for browsers for enterprise environments | |
| US7809837B2 (en) | User interface for configuring web services for remote portlets | |
| CN114489916A (en) | Method and device for loading visual large-screen page component | |
| CN102004729A (en) | Method and system for showing website webpage and website server | |
| US20140317169A1 (en) | Method, apparatus, and computer program product for server side data mashups specification | |
| CN111506644B (en) | Application data processing method and device and electronic equipment | |
| CN110888901B (en) | System management method, device, computer equipment and storage medium | |
| RU2634221C2 (en) | Method and device for drawing presentation of electronic document on screen | |
| WO2018217406A1 (en) | Providing instant preview of cloud based file | |
| US11966770B2 (en) | Collaboration across isolated virtual environments | |
| US11936531B2 (en) | Transforming content in a document using chained applications in a client-server architecture |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |