Data interaction platform based on ERP system

Abstract

The invention provides a data interaction platform based on an ERP (Enterprise Resource Planning) system, which belongs to the technical field of data interaction and comprises a service interface interaction service, a data migration service, a data issuing service, a data uploading service, a distributed data interaction service, an EXCEL import and export service and the like. Data interface interaction, migration, issuing, uploading, file import and export and the like between the ERP system and the external system can be carried out, service authorization is carried out through authority management, and standardized, real-time and secure data intercommunication and service collaboration between the ERP system and the multiple systems are achieved. According to the invention, the compatibility between the ERP system and the external service system and the timeliness and security of data interaction are improved, the overall cooperation efficiency of the service is improved, the development period is shortened, and the accuracy and security of data transmission are ensured.

Description

Technical Field

[0001] This invention relates to the field of data interaction technology, and in particular to a data interaction platform based on an ERP system. Background Technology

[0002] With the deepening of enterprise digital transformation, Enterprise Resource Planning (ERP) systems have become key information carriers and management hubs that integrate core business processes such as finance, procurement, production, and sales. Through a unified data model and process engine, it effectively improves the efficiency of internal resource allocation and the level of management standardization.

[0003] However, in complex business environments, enterprise operations typically involve multiple heterogeneous professional systems, such as customer relationship management systems (CRM), supply chain management systems (SRM), manufacturing execution systems (MES), warehouse management systems (WMS), and e-commerce platforms. The functional boundaries of a single ERP system are insufficient to cover all business scenarios. Therefore, enterprises urgently need to achieve efficient and reliable data interaction between their core ERP system and these internal and external business systems to achieve key business collaborations such as order status synchronization, inventory level sharing, and production planning and execution linkage, thereby breaking down information silos and building end-to-end business processes. However, existing ERP systems still suffer from poor compatibility, insufficient timeliness, weak process linkage, and a lack of security controls when interacting with external systems.

[0004] Therefore, developing a new data interaction platform based on ERP systems has become an urgent technological need to promote the in-depth development of enterprise digital transformation. Summary of the Invention

[0005] This invention provides a data interaction platform based on an ERP system to address the shortcomings of existing technologies, such as poor compatibility, insufficient timeliness, weak process linkage, and lack of security control when data interaction between ERP systems and external systems. It enables standardized, real-time, and secure data interoperability and business collaboration between ERP and multiple systems, thereby improving the overall operational efficiency of enterprises.

[0006] In a first aspect, the present invention provides a data interaction platform based on an ERP system, comprising: Basic business functions are used for environment configuration, rule maintenance, and enterprise organizational structure definition; Access control is used to divide permissions based on user roles and to authorize business operations and menus. The service interface interaction business is used to make service calls based on the backend interface platform to process data integration business from multiple heterogeneous systems and write the service call results into the database tables of the heterogeneous systems. Data migration services are used to migrate business data from other business systems to the target ERP system based on the database source environment, data migration service plan, and target data environment. The data delivery service is used to output basic data issued by the group company system to the database tables or file storage environment of the subsidiary system according to the data delivery service plan and the enterprise organizational structure. The data upload service is used to output the basic data uploaded by the subsidiary system to the database table or file storage environment of the group company system, according to the data upload service plan and the enterprise organizational structure. Distributed data interaction service is used to perform data import / export interaction with the heterogeneous system via files when it is not possible to directly obtain database permissions of the heterogeneous system; The EXCEL import / export function is used to write data from an EXCEL file to the front-end panel or database table of a target business system, or to export data from the front-end panel or database table of a target business system to an EXCEL file.

[0007] According to the data interaction platform based on an ERP system provided by the present invention, the business process of the service interface interaction includes: Determine the data sources for data integration services across multiple heterogeneous systems, including browser data and heterogeneous database data; Based on the different user operation methods, the service operation methods of the data integration business are divided into online call mode and batch processing call mode; wherein, in the online call mode, the user identity information is determined according to the data source, and the user identity information is passed to the backend interface platform as an input parameter; in the batch processing call mode, the business rule data defined by the user according to the interface interaction scheme is passed to the backend interface platform as an input parameter. After receiving the input parameters, the backend interface platform performs service permission verification based on the permission management. If the verification is successful, it performs internal or external service calls according to the service deployment type. The service deployment type includes centralized and distributed. When the service deployment type is centralized, the internal service call is executed; when the service deployment type is distributed, the external service call is executed. After the internal service call or the external service call is completed, the service call result is written to the database table of the heterogeneous system.

[0008] According to the data interaction platform based on an ERP system provided by the present invention, in the online calling mode, after the back-end interface platform receives the user identity information, it parses the user device IP, obtains the server authorization information, verifies the calling server, and saves the server authorization information; If a user calls a microservice, the backend model service is invoked online through the backend interface; otherwise, the user-defined service is executed through a third-party server. The backend model service provides a proprietary model and a general model. If a user calls the general model, the proprietary model is called first for data conversion and adaptation, and then the general model is called. After the online call scheme of the backend interface interaction is completed, the backend interface platform marks and pushes the execution status and related messages to the user device according to the execution result.

[0009] According to a data interaction platform based on an ERP system provided by the present invention, the business process of the data migration service includes: Based on the target data environment for migration, duplicate data in business data from other business systems is deleted, and the target ERP system is selected based on the enterprise's organizational structure. Select a data migration service plan and enter the data migration service rules according to the data migration service plan; wherein, the data migration service plan includes row to column, column to row, and data splitting; For the business data input from the database source environment, the business data is migrated according to the data migration business rules, and the business data is output to the database table of the target ERP system.

[0010] According to a data interaction platform based on an ERP system provided by the present invention, the business process of the data distribution service includes: Group company users select a data distribution service plan, choose the subsidiary system to which the data is distributed based on the enterprise's organizational structure, and then distribute the basic data. Determine whether the subsidiary system and the group company system are isomorphic systems. If so, distribute the basic data online through table data, and select to distribute the full data or incremental data, and output the table data to the database table of the subsidiary system. If not, the basic data will be distributed offline via file data and provided by the subsidiary system, outputting the file data to the database table or file storage environment of the subsidiary system.

[0011] According to a data interaction platform based on an ERP system provided by the present invention, the business process of the data upload service includes: Subsidiary users select a data upload service plan, choose the group company system to upload to based on the enterprise's organizational structure, and then upload the file data. The system invokes the services provided by the group company's system to write the file data into the database table or file storage environment of the group company's system.

[0012] According to the present invention, a data interaction platform based on an ERP system is provided, wherein the distributed data interaction service includes: heterogeneous system file import service and heterogeneous system file export service; The business process for importing files from heterogeneous systems includes: Import business data according to the file import scheme and the source data file of the heterogeneous system, and write the business data into a temporary table; The imported business data is verified according to the business data verification scheme. After the verification is passed, the imported business data is stored in the database table of the target business system through full update or incremental update. The business process for exporting files from heterogeneous systems includes: Export business data according to the file export scheme and source data, distribute files according to the data mapping relationship of the target heterogeneous system, perform permission verification, and output the exported business data to the database table or file storage environment of the target heterogeneous system. Both the file import scheme and the file export scheme include row-to-column and column-to-row conversion.

[0013] According to the data interaction platform based on an ERP system provided by the present invention, the EXCEL import and export business includes: EXCEL import business and EXCEL export business; The business process for importing Excel files includes: Based on the Excel import scheme, determine the Excel template file, import the user-inputted Excel file data through the Excel template file, and obtain the Excel business data; Determine the target data type, and based on the target data type, write the EXCEL business data into the front-end panel or database table of the target business system; wherein, the EXCEL import scheme includes row to column and column to row conversion; The business process for exporting Excel files includes: Based on the EXCEL export scheme, the export rules are determined, and the source data type is judged. According to the export rules and the source data type, the front-end panel data or database table data of the target business system is exported into an EXCEL file. Both the target data type and the source data type include front-end panel data and database table data.

[0014] According to the present invention, a data interaction platform based on an ERP system is provided, the data interaction platform further includes: a background public method and a background proprietary method; The aforementioned backend public solution is used to provide read / write solutions for files of different formats, as well as row-to-column and column-to-row solutions; wherein, the different file formats include Excel files, JSON files, XML files, and SQL files; The proprietary backend solution provides solutions for data migration, centralized data distribution, data distribution, data upload, file import, file export, Excel import, Excel export, generating Excel template files, and online call solutions for backend interface interaction.

[0015] According to the present invention, a data interaction platform based on an ERP system is provided, the data interaction platform further includes: For the service interface interaction business, the data migration business, the data distribution business, the data upload business, the distributed data interaction business, and the EXCEL import and export business, corresponding business models are established, and the addition, maintenance, and viewing of each business model are supported.

[0016] The beneficial effects of the technical solutions provided by some embodiments of the present invention include at least the following: 1) This invention provides a data interaction platform based on an ERP system. Through service interface interaction, data migration, data distribution, data upload, distributed data interaction, and Excel import / export, it realizes data interface interaction, migration, distribution, upload, and file import / export functions between the ERP system and external systems. Furthermore, through access control for business authorization, it achieves standardized, real-time, and secure data interoperability and business collaboration between the ERP system and multiple systems. This improves the compatibility between the ERP system and external systems, the timeliness and security of data interaction, and helps improve overall enterprise collaboration efficiency, reduce development cycles, and ensure the accuracy and security of data transmission.

[0017] 2) This invention enables efficient interface data interaction between different heterogeneous systems by processing data integration business through service interface interaction. It can shield the differences between underlying systems, avoid custom interface development, improve compatibility and reduce interface conflicts, thereby improving the data synchronization success rate; and improve the security of data transmission through service permission verification.

[0018] 3) This invention migrates business data from other business systems to the target ERP system through data migration, enabling rapid business data exchange between the ERP system and other business systems. It also associates data migration rules to standardize and automate the migration process, improves business process linkage, and significantly enhances business collaboration efficiency and quality.

[0019] 4) This invention achieves efficient data synchronization between the group company system and the subsidiary system through data distribution services, data upload services, and corresponding business solutions, thereby improving the timeliness of data interaction between different systems.

[0020] 5) This invention enables the rapid import and export of various commonly used files between heterogeneous systems through distributed data interaction services and EXCEL import and export services, thereby improving the convenience of data interaction between different business systems.

[0021] 6) This invention improves development efficiency and reduces redundancy through a common backend solution, and provides data interaction schemes and business rule support for various business processes through a proprietary backend solution, which is conducive to realizing customized optimization of different business logics.

[0022] 7) This invention achieves a high degree of business encapsulation and abstraction through business models corresponding to various business types, which can improve the business flexibility and scalability of the data interaction platform. Attached Figure Description

[0023] To more clearly illustrate the technical solutions in this invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0024] Figure 1 This invention provides an overall business architecture for a data interaction platform based on an ERP system. Figure 2 This is a schematic diagram of the service interface interaction process provided by the present invention; Figure 3 This is a schematic diagram of the online calling process between the heterogeneous system and the backend interface platform provided by the present invention; Figure 4 This is a flowchart of the functional processing of the service interface interaction provided by the present invention; Figure 5 This is a schematic diagram of the data migration service provided by the present invention; Figure 6 This is a schematic diagram of the data delivery service provided by the present invention; Figure 7This is a schematic diagram of the data upload service provided by the present invention; Figure 8 This is a schematic diagram of the heterogeneous system file import process provided by the present invention; Figure 9 This is a flowchart illustrating the heterogeneous system file export service provided by the present invention; Figure 10 This is a schematic diagram of the EXCEL import process provided by the present invention; Figure 11 This is a flowchart illustrating the EXCEL export process provided by the present invention; Figure 12 This is a schematic diagram of the application architecture of a data interaction platform based on an ERP system provided by the present invention. Detailed Implementation

[0025] To make the objectives, technical solutions, and advantages of this invention clearer, the technical solutions of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this invention. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0026] As enterprises deepen their digital transformation, ERP systems have become a key platform for integrating core business processes such as finance, procurement, production, and sales. However, a single ERP system cannot cover all business scenarios, and enterprises often need to interact with other business systems to achieve business collaboration such as order synchronization, inventory sharing, and production planning linkage. Existing data interaction methods between ERP systems and external systems still have many technical shortcomings, mainly manifested in: The interfaces are highly customized but have poor compatibility: the data source formats and field definitions of the ERP system and external systems are very different. The existing interactions mostly rely on developing point-to-point customized interfaces. When external systems are upgraded or new business systems are added, the interfaces need to be redeveloped, resulting in long development cycles, high maintenance costs, and easy data synchronization failures due to interface conflicts.

[0027] Insufficient timeliness and consistency of data interaction: The interaction between the ERP system and external systems mostly adopts timed batch synchronization, which cannot meet the real-time business needs. At the same time, there is a lack of a unified data verification mechanism. When there are abnormalities in the interactive data, it cannot be automatically intercepted or corrected, resulting in the disconnect between the ERP system data and the actual business.

[0028] Weak business process linkage: The business processes of the ERP system rely on external system data for triggering, but the existing interactions only realize data transmission and do not associate business rules.

[0029] Access control and log traceability are indeed problematic: ERP system data contains core sensitive information of the enterprise, but the existing interaction methods lack role-based access control and cannot record the entire data interaction log, which poses a risk of data leakage and makes it difficult to meet audit compliance requirements.

[0030] Therefore, in response to the problems of poor compatibility, insufficient timeliness, weak process linkage and lack of security control in the interaction between existing ERP systems and external systems, this invention proposes a data interaction platform based on ERP systems, which realizes standardized, real-time and secure data interoperability and business collaboration between ERP systems and multiple external systems, thereby improving the overall operational efficiency of enterprises.

[0031] Please see Figure 1 , Figure 1 An overall business architecture for a data interaction platform based on an ERP system, provided as an embodiment of the present invention, includes: Access control is used to divide permissions based on user roles and to authorize business operations and menus. Service interface interaction business is used to make service calls based on the backend interface platform to handle data integration business from multiple heterogeneous systems and write the service call results into the database tables of the heterogeneous systems; Data migration services are used to migrate business data from other business systems to the target ERP system based on the database source environment, data migration service plan, and target data environment. The data delivery service is used to output basic data from the group company system to the database tables or file storage environment of the subsidiary system, according to the data delivery service plan and the enterprise organizational structure. The data upload service is used to output basic data uploaded by subsidiary systems to the group company's database tables or file storage environment, based on the data upload service plan and the company's organizational structure. Distributed data interaction service is used to perform data import / export interaction with heterogeneous systems via files when it is not possible to directly obtain database permissions of heterogeneous systems, based on file import / export schemes. The EXCEL import / export function is used to write data from an EXCEL file to the front-end panel or database table of a target business system, or to export data from the front-end panel or database table of a target business system to an EXCEL file.

[0032] This invention enables data interface interaction, migration, distribution, uploading, and file import / export between the ERP system and external business systems through service interface interaction, data migration, data distribution, data uploading, distributed data interaction, and Excel import / export. Furthermore, it achieves standardized, real-time, and secure data interoperability and business collaboration between the ERP system and multiple systems through access control for business authorization. This improves the compatibility, timeliness, and security of data interaction between the ERP system and external business systems, thereby enhancing overall enterprise collaboration efficiency, reducing development cycles, and ensuring the accuracy and security of data transmission.

[0033] according to Figure 1 The overall business architecture shown in this invention includes the following data interaction platform: basic business, permission management function, service interface interaction business, data migration business, data distribution business, data upload business, distributed data interaction business, EXCEL import and export business, etc. The business process of each business is determined below based on the overall business architecture.

[0034] The basic business functions of this invention are used for configuring the database environment, configuring the file storage environment, and handling related business inputs such as enterprise organizational structure and maintaining relevant rules.

[0035] The permission management function of this invention can divide permissions for various user roles. For example, the permission levels and scope of users in a group company and users in a subsidiary company may be different. When the group company performs data distribution business, or when the subsidiary company performs data upload business, different business authorizations and menu authorizations may be required based on different user roles.

[0036] This invention uses access control to divide permissions based on roles, reducing the risk of leakage of core sensitive enterprise data, improving the security of data interaction, and largely meeting audit compliance requirements.

[0037] The service interface interaction business of the present invention utilizes a backend interface platform to make service calls and handle data integration business of multiple heterogeneous information systems of an enterprise.

[0038] like Figure 2 As shown, in some possible embodiments, the business process of the service interface interaction service includes: 2-1) Determine the data sources for data integration services across multiple heterogeneous systems. Data sources include browser data and heterogeneous database data. 2-2) Based on the different user operation methods, the service operation methods of data integration business are divided into online call mode and batch processing call mode. In the online call mode, the user identity information is determined according to the data source and passed to the backend interface platform in this data interaction platform as input parameters. In the batch processing call mode, the business rule data defined by the user according to the interface interaction scheme is passed to the backend interface platform as input parameters. 2-3) After receiving the input parameters, the backend interface platform performs service permission verification based on permission management. After successful verification, it performs internal or external service calls according to the service deployment type. The service deployment types include centralized and distributed. When the service deployment type is centralized, internal service calls are executed; when the service deployment type is distributed, external service calls are executed. In addition, the backend interface platform also supports serial and parallel service calls. In serial mode, if a previous service call fails, the interface call process will stop.

[0039] 2-4) After an internal or external service call is completed, the service call result is written to the database table of the heterogeneous system.

[0040] Based on the relationships between ERP systems, other business systems, heterogeneous systems, and data interaction platforms with different business descriptions, this invention determines the interaction logic between systems, platform functional modules, and the methods and services to be invoked.

[0041] like Figure 3 As shown, in some possible embodiments, the online call process between the heterogeneous system and the backend interface platform includes: 3-1) Users can call the backend interface platform online through heterogeneous systems and transmit data in the form of data tables, files, etc. 3-2) In online call mode, after the backend interface platform receives the user's identity information, it parses the user's device IP, uses the IP as the key to query the server authorization information from Redis and verify the calling server, and saves the server authorization information to Redis and the database. 3-3) If a user calls a microservice, the backend model service is invoked online through the backend interface; otherwise, the user-defined service is executed through a third-party server. The backend model service provides a proprietary model and a general model. If a user calls the general model, since the parameter structure of the third-party system is different from that of the general model, the proprietary model must be called first for data conversion and adaptation before the general model is called. 3-4) After the online call solution is executed through the backend interface interaction, the backend interface platform marks and pushes the execution status and related messages to the user device based on the execution result.

[0042] This invention enables efficient interface data interaction between different heterogeneous systems by processing data integration business through service interfaces. It can shield the differences between underlying systems, avoid custom interface development, improve compatibility, reduce interface conflicts, and thus improve the success rate of data synchronization. Furthermore, it can enhance the security of data transmission through service permission verification.

[0043] This invention determines the specific processing flow for each function based on the platform's functional modules. Figure 4 A flowchart illustrating the functional processing of interactions with the service interface.

[0044] like Figure 4 As shown, in some possible embodiments, the functional processing flow of service interface interaction includes: 4-1) Obtain user device IP and interface parameters through online backend interface interaction; 4-1) Obtain the list of servers configured for the current interface; 4-1) Call the server verification method to obtain server authorization information from Redis, verify whether calling the server is allowed, and prompt the server verification failure if the verification fails. 4-1) If the verification passes, the service will be called repeatedly; 4-1) If the subsystem is not empty, call the backend model service; otherwise, call the user-defined method. 4-1) Obtain the service execution result; if successful, execute other services. 4-1) If the execution fails and the working mode is serial mode, then terminate the current interface access; otherwise, execute other services.

[0045] Furthermore, this invention establishes separate data dictionaries for different functional modules. Taking the backend interface definition table for service interface interaction as an example, the data dictionary is shown in Table 1.

[0046] Table 1 Backend Interface Definition Table DIM_INF_MOD

[0047] This backend interface definition table is used to define interfaces. The interface content includes information such as interface code, interface name, working mode, whether it is effective, and the interface maintainer. The interface code is a unique identification field and cannot be duplicated.

[0048] The data migration service of this invention is used to migrate data from other systems to a target ERP system. The inputs for data migration include the source database environment, the data migration scheme, and the target environment. The source database environment includes single-table, multi-table, single-header-single-detail, and multi-header-multi-detail configurations. The data migration scheme includes row-to-column conversion, column-to-row conversion, and data splitting.

[0049] like Figure 5 As shown, in some possible embodiments, the business process of data migration includes: 5-1) Based on the target data environment for migration, users determine whether business data originating from other business systems needs to be deduplicated. After deduplicating the data, they select the target ERP system based on the enterprise's organizational structure. 5-2) Select a data migration service plan, and enter the data migration service rules such as the data range and interaction conditions according to the data migration service plan; 5-3) For the business data input from the database source environment, perform data migration according to the data migration business rules, and output the business data to the database table of the target ERP system (i.e. the target environment) to obtain the target environment data form.

[0050] This invention enables the migration of business data from other business systems to a target ERP system through data migration services, achieving rapid business data interoperability between the ERP system and other business systems. Furthermore, it incorporates data migration rules to standardize and automate the migration process, thereby improving business process linkage and significantly enhancing business collaboration efficiency and quality.

[0051] The data distribution service of this invention is mainly used by a group company to distribute basic data to its subsidiaries, and the data distribution is operated by the group's business personnel.

[0052] like Figure 6 As shown, in some possible embodiments, the business process of the data delivery service includes: 6-1) Group company users select a data distribution business plan, and select the subsidiary system to which the data is distributed based on the company's organizational structure, and then distribute the basic data. 6-2) Determine whether the subsidiary system and the group company system are isomorphic systems. If so, distribute the basic data online via table data, and select full data distribution or incremental data distribution, and output the table data to the database table of the subsidiary system. If not, distribute the basic data offline via file data, and the subsidiary system provides the service, outputting the file data to the database table or file storage environment of the subsidiary system.

[0053] The data upload service of this invention is used by subsidiaries to upload data to the group, and the data upload is operated by the subsidiary's business personnel.

[0054] like Figure 7 As shown, in some possible embodiments, the business process of the data upload service includes: 7-1) Subsidiary users select a data upload service plan, choose the group company system to upload to based on the company's organizational structure, and then upload the file data; 7-2) Call the services provided by the group company system to write file data into the database table or file storage environment of the group company system.

[0055] The distributed data interaction service of the present invention includes heterogeneous system file import service and heterogeneous system file export service.

[0056] The heterogeneous system file import service of the present invention is used to import data through files when it is not possible to directly obtain the database permissions of the source heterogeneous system. The file types include EXCEL, XML, SQL, JSON and other formats.

[0057] like Figure 8 As shown, in some possible embodiments, the business process for importing files from heterogeneous systems includes: 8-1) Import business data according to the file import scheme and the source data file of the heterogeneous system, and write the business data to a temporary table; 8-2) Verify the imported business data according to the business data verification plan. After verification, store the imported business data in the database table of the target business system through full update or incremental update.

[0058] Specifically, business personnel import business data from the source data files of the heterogeneous source system based on the file import scheme and the field mapping relationship of the source data. They can choose to import manually, via scheduled jobs, or in real-time. The imported business data is written to a temporary table, and then validated using a business data verification scheme. This scheme includes uniqueness verification, related business status verification, verification that the data is in use and cannot be deleted, and verification that it cannot be deleted or modified. For data that passes verification, it is then confirmed whether it is a full update or an incremental update before storing the imported business data in the database table of the target business system or data interaction platform. The file import scheme includes row-to-column and column-to-row conversion. The heterogeneous system file export service of the present invention is used to perform data export interaction through files when it is not possible to directly obtain the database permissions of the target heterogeneous system. The file types include EXCEL, XML, SQL, JSON and other formats.

[0059] like Figure 9 As shown, in some possible embodiments, the business process for exporting files from a heterogeneous system includes: Export business data according to the file export scheme and source data, distribute files according to the data mapping relationship of the target heterogeneous system, perform permission verification, and output the exported business data to the database table or file storage environment of the target heterogeneous system.

[0060] Specifically, based on the file export scheme and data range export rules, business data is exported from the data source system according to the export rules. The file is then distributed according to the field mapping relationship of the target data in the target heterogeneous system. The system checks for authorization by verifying permissions. If the target heterogeneous system is not authorized, the business data is generated into a target file and stored in the target heterogeneous system's file storage environment. If the target heterogeneous system is authorized, the target heterogeneous system's service is invoked to output the business data to the target heterogeneous system's database table. The file export scheme includes row-to-column and column-to-row conversion.

[0061] This invention enables the rapid import and export of various types of data between heterogeneous systems through distributed data interaction services, thereby improving the convenience of data interaction between different business systems.

[0062] The EXCEL import and export service of the present invention includes an EXCEL import service and an EXCEL export service. The EXCEL import service is used to import EXCEL data into a target business system, and the EXCEL export service is used to export data from the target business system into an Excel file.

[0063] like Figure 10 As shown, in some possible embodiments, the business process for importing data from Excel includes: 10-1) Determine the Excel template file according to the Excel import scheme, and import the user-inputted Excel file data through the Excel template file to obtain the Excel business data; 10-2) Determine the target data type and, based on the target data type, write the EXCEL business data into the front-end panel or database table of the target business system.

[0064] Specifically, based on the Excel import scheme, the style of the data to be imported is converted from row to column or column to row. The target business system, its contents, and the Excel template used are also determined. The Excel template used for importing data can be a template exported from the target business system or a template created directly in Excel. After importing the data through the Excel template file, depending on the target type, it is determined whether the imported Excel business data will be directly displayed on the front-end panel of the target business system or imported into a temporary table. If the data is imported into a temporary table, the imported data needs to be checked through the back-end model, such as whether numeric values ​​have been written as character values. If the check passes, the imported Excel business data is written into the database table of the target business system. The Excel import scheme includes row-to-column and column-to-row conversions. like Figure 11 As shown, in some possible embodiments, the business process for exporting an Excel file includes: Based on the EXCEL export scheme, determine the export rules and identify the source data type. Then, based on the export rules and the source data type, export the front-end panel data or database table data of the target business system into an EXCEL file. The target data type and the source data type both include front-end panel data and database table data.

[0065] Specifically, the data sources for export are divided into front-end panel data and back-end database data. Front-end panel data can be directly output as an Excel file. Exporting back-end database data requires an Excel export scheme to determine the export rules, such as defining which target business system to export from, what content to export, and what conditions to export, as well as whether to export the conditions entered on the front-end page or directly export the database table data, and finally export it as an Excel file.

[0066] This invention enables rapid data exchange between different business systems via Excel import / export, thereby improving the efficiency of data interaction between different business systems.

[0067] In addition to the key business functions mentioned above, the data interaction platform of this invention may also include attachment services, used for online migration of attachments, batch migration of attachments, etc.

[0068] Please see Figure 12 , Figure 12 A schematic diagram of an application architecture for a data interaction platform based on an ERP system, provided as an embodiment of the present invention, is shown. The data interaction platform includes: For service interface interaction, data migration, data distribution, data upload, distributed data interaction, and Excel import / export, corresponding business models are encapsulated, and the addition, maintenance, and viewing of each business model are supported.

[0069] This includes service interface interaction business, such as defining, maintaining and viewing interface interactions, as well as maintaining calling servers and authorization servers.

[0070] Data migration services include adding, maintaining, and viewing data migration models, as well as performing data migration based on these models.

[0071] Data delivery services include adding, maintaining, and viewing centralized delivery models, adding, maintaining, and viewing distributed delivery models, as well as executing centralized data delivery based on centralized delivery models and executing distributed data delivery based on distributed delivery models.

[0072] Data upload services include adding, maintaining, and viewing distributed upload models, as well as executing distributed data uploads based on distributed upload models.

[0073] Distributed data interaction services include adding, maintaining, and viewing files in the import model, as well as adding, maintaining, and viewing files in the export model.

[0074] EXCEL import and export services include EXCEL database export model, EXCEL panel export model, EXCEL database import model, and EXCEL panel import model.

[0075] In addition, the data interaction platform also includes basic business functions, such as row-to-column rule maintenance, column-to-row rule maintenance, database configuration, server configuration, and enterprise organizational structure definition.

[0076] This invention achieves a high degree of business encapsulation and abstraction by using business models corresponding to various business types, which can improve the business flexibility and scalability of the data interaction platform.

[0077] In some possible embodiments, the data interaction platform may also include: background public methods and background proprietary methods.

[0078] The backend public solution provides read / write options for different file formats, as well as row-to-column and column-to-row conversion options. These different file formats include Excel files, JSON files, XML files, and SQL files. The backend-specific solutions provide solutions for data migration, centralized data distribution, data distribution, data upload, file import, file export, Excel import, Excel export, generation of Excel template files, and online API interaction.

[0079] Specifically, the data migration business solution is applied to Figure 5 In the corresponding data migration business process, the centralized data distribution solution is applied. Figure 6 In the corresponding data distribution business process, the data upload business solution is applied to Figure 7 In the corresponding data upload business process, the file import solution is applied to Figure 8 In the corresponding heterogeneous system file import business process, the file export solution is applied to Figure 9 In the corresponding heterogeneous system file export business process, the EXCEL import solution is applied. Figure 10 In the corresponding Excel import business process, the Excel export solution is applied to Figure 11 In the corresponding Excel export business process, the solution of generating an Excel template file is applied. Figure 10 In the corresponding Excel import business process, the online backend interface interaction solution is applied. Figure 2 In the corresponding service interface interaction business process.

[0080] This invention improves development efficiency and reduces redundancy through a common backend solution, and provides data interaction schemes and business rule support for various business processes through a proprietary backend solution, which is conducive to the customization and optimization of different business logics.

[0081] Based on the data interaction platform based on the ERP system provided in the above embodiments, the present invention also proposes a data interaction method. This data interaction method can use the data interaction platform based on the ERP system to perform data interaction steps such as service interface interaction, data migration, data distribution, data upload, distributed data interaction, and EXCEL import and export.

[0082] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments or some parts of the embodiments.

[0083] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data interaction platform based on an ERP system, characterized in that, include: Access control is used to divide permissions based on user roles and to authorize business operations and menus. The service interface interaction business is used to make service calls based on the backend interface platform to process data integration business from multiple heterogeneous systems and write the service call results into the database tables of the heterogeneous systems. Data migration services are used to migrate business data from other business systems to the target ERP system based on the database source environment, data migration service plan, and target data environment. The data delivery service is used to output basic data issued by the group company system to the database tables or file storage environment of the subsidiary system according to the data delivery service plan and the enterprise organizational structure. The data upload service is used to output the basic data uploaded by the subsidiary system to the database table or file storage environment of the group company system, according to the data upload service plan and the enterprise organizational structure. Distributed data interaction service is used to perform data import / export interaction with the heterogeneous system via files when it is not possible to directly obtain database permissions of the heterogeneous system; The EXCEL import / export function is used to write data from an EXCEL file to the front-end panel or database table of a target business system, or to export data from the front-end panel or database table of a target business system to an EXCEL file.

2. The data interaction platform based on the ERP system according to claim 1, characterized in that, The business process of the service interface interaction includes: Determine the data sources for data integration services across multiple heterogeneous systems, including browser data and heterogeneous database data; Based on the different user operation methods, the service operation methods of the data integration business are divided into online call mode and batch processing call mode; wherein, in the online call mode, the user identity information is determined according to the data source, and the user identity information is passed to the backend interface platform as an input parameter; in the batch processing call mode, the business rule data defined by the user according to the interface interaction scheme is passed to the backend interface platform as an input parameter. After receiving the input parameters, the backend interface platform performs service permission verification based on the permission management. If the verification is successful, it performs internal or external service calls according to the service deployment type. The service deployment type includes centralized and distributed. When the service deployment type is centralized, the internal service call is executed; when the service deployment type is distributed, the external service call is executed. After the internal service call or the external service call is completed, the service call result is written to the database table of the heterogeneous system.

3. The data interaction platform based on the ERP system according to claim 2, characterized in that, In the online invocation mode, after receiving the user's identity information, the backend interface platform parses the user's device IP, obtains the server authorization information, verifies the invocation server, and saves the server authorization information. If a user calls a microservice, the backend model service is invoked online through the backend interface; otherwise, the user-defined service is executed through a third-party server. The backend model service provides a proprietary model and a general model. If a user calls the general model, the proprietary model is called first for data conversion and adaptation, and then the general model is called. After the online call scheme of the backend interface interaction is completed, the backend interface platform marks and pushes the execution status and related messages to the user device according to the execution result.

4. The data interaction platform based on the ERP system according to claim 1, characterized in that, The business process for the data migration service includes: Based on the target data environment for migration, duplicate data in business data from other business systems is deleted, and the target ERP system is selected based on the enterprise's organizational structure. Select a data migration service plan and enter the data migration service rules according to the data migration service plan; wherein, the data migration service plan includes row to column, column to row, and data splitting; For the business data input from the database source environment, the business data is migrated according to the data migration business rules, and the business data is output to the database table of the target ERP system.

5. The data interaction platform based on the ERP system according to claim 1, characterized in that, The business process for the data delivery service includes: Group company users select a data distribution service plan, choose the subsidiary system to which the data is distributed based on the enterprise's organizational structure, and then distribute the basic data. Determine whether the subsidiary system and the group company system are isomorphic systems. If so, distribute the basic data online through table data, and select to distribute the full data or incremental data, and output the table data to the database table of the subsidiary system. If not, the basic data will be distributed offline via file data and provided by the subsidiary system, outputting the file data to the database table or file storage environment of the subsidiary system.

6. The data interaction platform based on the ERP system according to claim 1, characterized in that, The business process of the data upload service includes: Subsidiary users select a data upload service plan, choose the group company system to upload to based on the enterprise's organizational structure, and then upload the file data. The system invokes the services provided by the group company system to write the file data into the database table or file storage environment of the group company system.

7. The data interaction platform based on the ERP system according to claim 1, characterized in that, The distributed data interaction service includes: heterogeneous system file import service and heterogeneous system file export service; The business process for importing files from heterogeneous systems includes: Import business data according to the file import scheme and the source data file of the heterogeneous system, and write the business data into a temporary table; The imported business data is verified according to the business data verification scheme. After the verification is passed, the imported business data is stored in the database table of the target business system through full update or incremental update. The business process for exporting files from heterogeneous systems includes: Export business data according to the file export scheme and source data, distribute files according to the data mapping relationship of the target heterogeneous system, perform permission verification, and output the exported business data to the database table or file storage environment of the target heterogeneous system. Both the file import scheme and the file export scheme include row-to-column and column-to-row conversion.

8. The data interaction platform based on the ERP system according to claim 1, characterized in that, The EXCEL import / export service includes: EXCEL import service and EXCEL export service; The business process for importing Excel files includes: Based on the Excel import scheme, determine the Excel template file, import the user-inputted Excel file data through the Excel template file, and obtain the Excel business data; Determine the target data type, and based on the target data type, write the EXCEL business data into the front-end panel or database table of the target business system; wherein, the EXCEL import scheme includes row to column and column to row conversion; The business process for exporting Excel files includes: Based on the EXCEL export scheme, the export rules are determined, and the source data type is judged. According to the export rules and the source data type, the front-end panel data or database table data of the target business system is exported into an EXCEL file. Both the target data type and the source data type include front-end panel data and database table data.

9. The data interaction platform based on the ERP system according to claim 1, characterized in that, The data interaction platform also includes: public backend methods and private backend methods; The aforementioned backend public solution is used to provide read / write solutions for files of different formats, as well as row-to-column and column-to-row solutions; wherein, the different file formats include Excel files, JSON files, XML files, and SQL files; The proprietary backend solution provides solutions for data migration, centralized data distribution, data distribution, data upload, file import, file export, Excel import, Excel export, generating Excel template files, and online call solutions for backend interface interaction.

10. The data interaction platform based on the ERP system according to claim 1, characterized in that, The data interaction platform also includes: For the service interface interaction business, the data migration business, the data distribution business, the data upload business, the distributed data interaction business, and the EXCEL import and export business, corresponding business models are established, and the addition, maintenance, and viewing of each business model are supported.

Images