Integrated interface service data automatic synchronization method based on ERP (Enterprise Resource Planning) system

Abstract

The invention discloses an automatic business data synchronization method based on an ERP (Enterprise Resource Planning) system integrated interface, which relates to the technical field of computer systems, and comprises the following steps: monitoring the change of business data at the ERP system integrated interface, collecting the changed business data when the change of the business data is detected, encrypting and verifying the collected business data, and sending the encrypted business data to a server; according to the scheme, the business data change of the integrated interface of the ERP system is monitored in real time, the change data is acquired in time, the elliptic curve encryption algorithm and the dual-check mechanism are adopted, and the dynamic data transmission strategy is combined for adjustment, so that the data transmission efficiency is improved. The problems that in the prior art, data collection is not timely, data encryption safety is insufficient, transmission strategy making is unreasonable, and transmission quality monitoring and adjusting capacity is limited are effectively solved.

Description

Technical Field

[0001] The present invention relates to the technical field of computer systems, and in particular to an automatic synchronization method for business data based on an ERP system integration interface. Background Art

[0002] With the advancement of enterprise informatization, data synchronization technology for the integrated interfaces of ERP systems, as core management systems, is crucial. In recent years, the development of big data and cloud computing has driven advancements in ERP system integration interface technology, improving the accuracy and real-time nature of data synchronization. However, existing technologies still have shortcomings.

[0003] Existing data synchronization methods for ERP system integration interfaces suffer from significant deficiencies in data collection, encryption, and transmission strategy development. Existing technologies are unable to monitor business data changes in real time, resulting in delayed data collection. Traditional encryption algorithms lack security, are unable to meet enterprise needs, lack data classification and priority setting, and suffer from low transmission efficiency and reliability. Furthermore, existing technologies have limited capabilities for monitoring and adjusting transmission quality during the transmission process, making it impossible to dynamically adjust transmission strategies, impacting data synchronization efficiency and accuracy. These issues prevent existing technologies from achieving the technical benefits of the present invention. Summary of the Invention

[0004] In view of the above existing problems, the present invention is proposed.

[0005] Therefore, the present invention provides an automatic synchronization method for business data based on the ERP system integration interface to solve the problems of untimely data collection, insufficient data encryption security, unreasonable transmission strategy formulation, and limited transmission quality monitoring and adjustment capabilities.

[0006] In order to solve the above technical problems, the present invention provides the following technical solutions:

[0007] In a first aspect, the present invention provides a method for automatically synchronizing business data based on an ERP system integration interface, which comprises:

[0008] Detect business data changes at the ERP system integration interface, and collect the changed business data when changes are detected;

[0009] Encrypt and verify the collected business data to generate a verification code;

[0010] Formulate data transmission strategies based on changes in business data;

[0011] Transmit the encrypted data and checksum to the target through the ERP system integration interface, monitor the transmission status during the transmission process, and adjust the data transmission strategy based on the monitoring results;

[0012] Decrypt the received data, use the checksum to verify the decrypted data, and verify whether the data is complete. Once the data is complete, store it in the target database to complete the automatic synchronization of business data.

[0013] As a preferred solution of the method for automatically synchronizing business data based on the ERP system integration interface of the present invention, wherein: the business data changes at the ERP system integration interface are monitored, and when the business data changes are detected, the changed business data are collected, the specific steps are as follows:

[0014] Deploy monitoring tools at the ERP system integration interface to monitor business data transmission channels, capture data packets flowing through the ERP system integration interface, parse the content, record business data information, and create monitoring logs;

[0015] Based on business data information, the system compares the previous and next states of business data in real time and sends the changed business data information to the message queue;

[0016] After receiving the changed business data, the message queue locates and obtains the changed business data through the data access interface provided by the ERP system;

[0017] The changed business data is compared with the monitoring log and stored in the database after the comparison is passed.

[0018] As a preferred solution of the method for automatic synchronization of business data based on the ERP system integration interface of the present invention, wherein: the collected business data is encrypted and verified to generate a verification code, the specific steps are:

[0019] Use elliptic curve encryption algorithm to encrypt business data;

[0020] The encrypted data is verified using a double check mechanism, which includes CRC check and parity check, to obtain the verified business data and encapsulation information;

[0021] Use a custom encapsulation format to encapsulate the verified data and verification information into a data packet;

[0022] Use a hash function to calculate the hash value of the data packet, and use the hash value as a checksum for the data packet content.

[0023] As a preferred solution of the method for automatic synchronization of business data based on the ERP system integration interface of the present invention, wherein: the data transmission strategy is formulated according to the changes in business data, and the specific steps are:

[0024] Classify the collected business data into real-time data and non-real-time data;

[0025] Prioritize real-time data and non-real-time data separately;

[0026] Selecting a transmission path based on priority;

[0027] Develop data transmission strategies based on data classification, priority, and transmission paths.

[0028] As a preferred solution of the method for automatic synchronization of business data based on the ERP system integration interface of the present invention, wherein: the encrypted data and the check code are transmitted to the target through the ERP system integration interface, the transmission status is monitored during the transmission process, and the data transmission strategy is adjusted according to the monitoring results. The specific steps are:

[0029] Select the HTTPS protocol based on the ERP interface technology and target requirements;

[0030] Establish a secure connection between the ERP system integration interface and the target, and send the packaged encrypted business data and verification code data package after completing identity authentication;

[0031] Monitor the transmission delay and packet loss rate of encrypted business data and checksums, analyze and evaluate the transmission quality, and obtain a transmission quality assessment report;

[0032] The data transmission strategy is adjusted based on the transmission quality evaluation report, wherein the adjusting of the data transmission strategy includes adjusting the data packet sending rate and switching to a backup channel.

[0033] As a preferred solution of the method for automatic synchronization of business data based on the ERP system integration interface of the present invention, wherein: the data transmission strategy is adjusted based on the transmission quality assessment report, and the data transmission strategy includes adjusting the data packet sending rate and switching to the backup channel. The specific steps are:

[0034] Predefine a transmission quality threshold based on service data, wherein the transmission quality threshold includes transmission delay and packet loss rate;

[0035] comparing the transmission quality assessment report with a transmission quality threshold, and adjusting a data transmission strategy when the transmission quality assessment report exceeds the transmission quality threshold;

[0036] The sending rate of data packets is adjusted according to the adjusted data transmission strategy. When the packet loss rate and delay exceed the preset transmission quality threshold, the rate is increased or decreased by a predetermined amount. Otherwise, the backup channel is switched to transmit data, and the target is notified to complete the channel switching.

[0037] As a preferred solution of the method for automatic synchronization of business data based on the ERP system integration interface of the present invention, wherein: the received data is decrypted, the decrypted data is verified using a check code, and the data is verified to be complete. After the data is complete, it is stored in the target database to complete the automatic synchronization of business data. The specific steps are:

[0038] Decrypt the encrypted data received through the ERP system integration interface to obtain the plaintext data;

[0039] Calculate the hash value of the plaintext data through the hash algorithm and compare it with the checksum to verify whether the encrypted data has been tampered with during transmission;

[0040] Checking whether the decrypted encrypted data is complete, the checking including checking the length and format of the encrypted data;

[0041] The verified complete encrypted data is stored in the target database to complete the automatic synchronization of business data.

[0042] As a preferred solution of the method for automatic synchronization of business data based on the ERP system integration interface of the present invention, wherein: the hash value of the plaintext data is calculated by the hash algorithm and compared with the check code to verify whether the encrypted data has been tampered with during the transmission process, the specific steps are:

[0043] Use the SHA-256 hash algorithm to calculate the decrypted plaintext data and generate the corresponding hash value;

[0044] Extracting a checksum with the same hash value as the plaintext data from the data packet;

[0045] Compare the calculated hash value with the extracted check code bit by bit.

[0046] In a second aspect, the present invention provides a computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: when the computer program is executed by the processor, any step of the method for automatic synchronization of business data based on the ERP system integration interface as described in the first aspect of the present invention is implemented.

[0047] In a third aspect, the present invention provides a computer-readable storage medium having a computer program stored thereon, wherein: when the computer program is executed by a processor, it implements any step of the method for automatic synchronization of business data based on the ERP system integration interface as described in the first aspect of the present invention.

[0048] The beneficial effects of the present invention are: real-time monitoring of business data changes of the ERP system integration interface, timely collection of change data, ensuring the timeliness and accuracy of data collection, using elliptic curve encryption algorithm and double verification mechanism to improve data security and integrity, classifying business data into real-time data and non-real-time data, setting priorities respectively, selecting transmission paths based on priorities, formulating reasonable data transmission strategies, improving transmission efficiency and reliability, monitoring the transmission status during transmission and dynamically adjusting strategies based on the results, such as adjusting the sending rate and switching channels, optimizing the transmission process, ensuring the accuracy and efficiency of data synchronization, decrypting and verifying the received data to ensure that the data has not been tampered with, verifying that the complete data is stored in the target database, and completing automatic synchronization of business data. The entire process improves the accuracy and security of data synchronization and effectively solves the shortcomings of the existing technology. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0050] Figure 1 This is a flowchart of the method for automatically synchronizing business data based on the ERP system integration interface in Example 1.

[0051] Figure 2 This is a data transmission flow chart of the automatic synchronization method of business data based on the ERP system integration interface in Example 1. DETAILED DESCRIPTION

[0052] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the specific embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0053] In the following description, many specific details are set forth to facilitate a full understanding of the present invention. However, the present invention may also be implemented in other ways different from those described herein. Those skilled in the art may make similar generalizations without violating the connotation of the present invention. Therefore, the present invention is not limited to the specific embodiments disclosed below.

[0054] Secondly, the term "one embodiment" or "embodiment" herein refers to a specific feature, structure, or characteristic that may be included in at least one implementation of the present invention. The phrase "in one embodiment" appearing in various places throughout this specification does not necessarily refer to the same embodiment, nor does it refer to a separate or selective embodiment that is mutually exclusive of other embodiments.

[0055] Example 1, reference Figure 1 and Figure 2 , which is the first embodiment of the present invention, provides a method for automatically synchronizing business data based on an ERP system integration interface, comprising the following steps:

[0056] S1. Monitor business data changes at the ERP system integration interface, and collect the changed business data when changes are detected.

[0057] Furthermore, a monitoring tool is deployed at the ERP system integration interface to monitor the business data transmission channel, capture the data packets flowing through the ERP system integration interface and parse the content, record business data information and establish a monitoring log.

[0058] Specifically, a monitoring tool is deployed at the ERP system integration interface to monitor the business data transmission channel, capture data packets flowing through the ERP system integration interface and parse the content, record business data information and establish a monitoring log. The monitoring tool captures data packets passing through the interface through the network protocol stack, uses a data packet parsing algorithm to extract the business data fields therein, and matches these fields with the predefined business data model to determine the type and content of the data. Subsequently, the successfully matched data information is recorded in the monitoring log for subsequent comparison and processing. The monitoring tool uses efficient data packet capture and parsing technology to ensure that data packets can still be accurately captured and parsed under high concurrency conditions, avoiding data loss or parsing errors. By deploying the monitoring tool at the ERP system integration interface, real-time monitoring of business data changes is achieved, ensuring the timeliness and accuracy of data collection. The monitoring tool can efficiently capture and parse data packets, avoiding data loss or parsing errors, and providing a reliable data foundation for subsequent data processing and synchronization. This process effectively solves the problem of untimely data collection in the existing technology and improves the real-time and accuracy of data synchronization.

[0059] Furthermore, based on the business data information, the previous and subsequent states of the business data are compared in real time, and the changed business data information is sent to the message queue.

[0060] Specifically, the ERP system examines the previous and next states of business data item by item based on pre-set comparison rules, identifying any changed data items. The system then encapsulates these identified changed data items into messages and sends them to a pre-set message queue. The message queue temporarily stores these changed data, ensuring that they can be promptly retrieved and processed by subsequent processing modules. This method allows the ERP system to efficiently manage and transmit changed business data, ensuring timely and accurate data synchronization. By comparing the previous and next states of business data in real time, the ERP system accurately identifies changed data items and promptly sends them to the message queue. This process ensures that only changed data is transmitted and processed, avoiding unnecessary data transmission and processing, and improving the efficiency and performance of the ERP system. Furthermore, the use of the message queue provides reliable support for data transmission and processing, ensuring data integrity and consistency during transmission. Ultimately, this step enables efficient management and transmission of changed business data, improves the timeliness and accuracy of data synchronization, and provides strong support for subsequent data processing and storage.

[0061] Furthermore, after receiving the changed business data, the message queue locates and obtains the changed business data through the data access interface provided by the ERP system.

[0062] Specifically, the message queue uses the changed data as a parameter and sends a request to the ERP system through the data access interface to locate and retrieve the changed business data. Upon receiving the request, the ERP system extracts the changed business data from the corresponding data source based on the request parameters and returns it to the message queue. The message queue then performs preliminary processing and verification on the returned data to ensure data integrity and accuracy. This allows the ERP system to accurately retrieve the changed business data, providing a reliable data source for subsequent data processing and synchronization. By invoking the data access interface provided by the ERP system through the message queue, the ERP system can accurately locate and retrieve the changed business data. This process ensures the accuracy and reliability of data acquisition and avoids data synchronization issues caused by data acquisition errors. Furthermore, the use of the message queue provides a reliable guarantee for data acquisition and transmission, ensuring data integrity and consistency during transmission. Ultimately, this step ensures accurate acquisition of the changed business data, providing a reliable data source for subsequent data processing and storage, and improving the accuracy and reliability of data synchronization.

[0063] Furthermore, the changed business data is compared with the monitoring log and stored in the database after the comparison is passed.

[0064] Specifically, the ERP system checks each changed business data against the records in the monitoring log based on pre-set comparison rules. During this comparison process, the ERP system verifies the integrity and consistency of the data, ensuring that no tampering or loss occurred during the data acquisition and transmission process. Business data that passes the comparison is stored in a pre-set database. The database is responsible for storing these changed data, ensuring data persistence and accessibility. In this way, the ERP system ensures that changed business data is accurately stored, providing a reliable data foundation for subsequent data synchronization and analysis. By comparing changed business data with the monitoring log, the ERP system ensures data integrity and consistency, avoiding data synchronization issues caused by data errors. Once the comparison passes, the data is accurately stored in the database, ensuring data persistence and accessibility. This process improves the reliability and security of data storage, providing a solid data foundation for subsequent data synchronization and analysis. Ultimately, this step ensures the accurate storage of changed business data, improves the accuracy and reliability of data synchronization, and provides strong support for enterprise data management and decision-making.

[0065] S2. Encrypt and verify the collected business data to generate a verification code.

[0066] Furthermore, the business data is encrypted using an elliptic curve encryption algorithm.

[0067] Specifically, appropriate elliptic curve parameters, including the elliptic curve equation, base point, and order, are selected to generate a public and private key pair. The public key is used for encryption, and the private key is used for decryption. Business data is segmented into fixed-length data blocks, ensuring that each block is of a suitable size for encryption. Each block is encrypted and encrypted using the public key to generate an encrypted data block. All encrypted data blocks are then combined to form encrypted business data. By encrypting business data using the elliptic curve encryption algorithm, high data security and confidentiality are achieved. Elliptic curve encryption algorithms feature short key lengths, fast computation speed, and high security, effectively preventing data theft or tampering during transmission. Specifically, elliptic curve encryption algorithms utilize point operations on the elliptic curve for encryption and decryption, ensuring data security and integrity. Ultimately, this step ensures the security of business data during transmission and improves the reliability and efficiency of data synchronization.

[0068] Furthermore, the encrypted data is verified using a double verification mechanism, which includes a CRC check and a parity check, to obtain verified business data and encapsulation information.

[0069] Specifically, after encryption is complete, the encrypted data is double-checked, including CRC and parity checks. The specific operations include selecting an appropriate CRC polynomial, such as CRC-32, performing a CRC check on the encrypted data, calculating the cyclic redundancy check value (CRC value) of the data, appending the calculated CRC value to the end of the encrypted data, and generating a CRC check code. Parity check: Counting the number of 1s in the encrypted data, generating a parity bit based on the statistical result, if the number of 1s is odd, the parity bit is 1, otherwise it is 0, appending the parity bit to the end of the encrypted data, generating a parity check code, combining the CRC check code and the parity check code with the encrypted data to generate verified business data and encapsulation information. By using a double-check mechanism (CRC and parity check), the integrity and reliability of the encrypted data are further ensured. CRC check can detect errors in data transmission, and parity check can detect single-bit errors in data. The combination of the double-check mechanism improves the accuracy and reliability of data verification, ensuring that the data has not been tampered with or damaged during transmission. Ultimately, this step ensures the integrity and reliability of encrypted data and improves the accuracy and efficiency of data synchronization.

[0070] Furthermore, a user-defined encapsulation format is used to encapsulate the verified data and the verification information into a data packet.

[0071] Specifically, after completing the double check, the verified data and verification information are encapsulated to generate a data packet. The specific operations include: defining a custom encapsulation format, which includes a data packet header, data packet body, and data packet trailer. This format contains basic data packet information, such as packet length, data type, source address, and destination address. This information is stored in fixed-length fields to ensure a uniform format for the data packet header. The data packet body contains the verified encrypted data and verification information, which are arranged in a predetermined order to ensure the integrity of the data packet body. The data packet trailer contains the data packet end flag and check code, which are stored in fixed-length fields to ensure a uniform format for the data packet trailer. The data packet header, data packet body, and data packet trailer are combined according to the custom encapsulation format to generate a complete data packet. By encapsulating the verified data and verification information into a data packet using the custom encapsulation format, standardized data transmission is achieved. The custom encapsulation format ensures the integrity and consistency of the data packet, facilitating identification and processing during transmission. The basic information in the data packet header (such as packet length, data type, source address, and destination address) provides essential metadata for data transmission and reception, ensuring that the data is accurately transmitted to the target ERP system. The end flag and checksum in the data packet further ensure the integrity and reliability of the data packet, effectively detecting and correcting errors in data transmission. Ultimately, this step ensures the normalization and standardization of data packet transmission, improving the reliability and efficiency of data transmission.

[0072] Furthermore, a hash function is used to calculate a hash value of the data packet, and the hash value is used as a check code for the data packet content.

[0073] Specifically, after the data packet is encapsulated, a hash function is used to calculate the packet's hash value, which is used as a checksum for the packet's contents. The specific operation involves selecting an appropriate hash function, such as SHA-256, taking the encapsulated data packet as input, calculating the packet's hash value, and appending the calculated hash value to the end of the packet to generate the final data packet. During transmission, the receiver can verify the packet's integrity and consistency by calculating the received packet's hash value and comparing it with the appended hash value. By using the hash function to calculate the packet's hash value and using it as a checksum for the packet's contents, the integrity and consistency of the packet are further ensured. Hash functions are one-way and collision-resistant, ensuring the uniqueness and integrity of the packet. The calculated hash value, used as a checksum for the packet's contents, effectively detects tampering and errors during data transmission. By calculating the received packet's hash value and comparing it with the appended hash value, the receiver can verify the packet's integrity and consistency, ensuring data reliability and security. Ultimately, this step ensures the integrity and consistency of the packet, improving the reliability and security of data transmission.

[0074] S3. Develop data transmission strategies based on changes in business data.

[0075] Furthermore, the collected business data is classified into real-time data and non-real-time data.

[0076] Specifically, after collecting business data, it is first pre-processed to ensure that its format and content meet classification requirements. Then, based on the characteristics and needs of the business data, the data is classified into real-time and non-real-time data. This includes defining classification criteria for real-time and non-real-time data. Real-time data typically refers to data that requires immediate processing and response, such as real-time status updates on production orders. Non-real-time data refers to data that can be processed and responded to later, such as monthly sales reports. The collected business data is analyzed and classified as real-time or non-real-time based on its characteristics and needs. For example, data can be classified based on characteristics such as update frequency and processing timeliness. The classified data is then stored in separate data queues for subsequent processing. Real-time data is stored in the real-time data queue, and non-real-time data is stored in the non-real-time data queue. By classifying collected business data into real-time and non-real-time data, classified data management is implemented, ensuring timely and targeted data processing. Real-time data can be processed and responded to promptly, meeting the real-time needs of the business. Non-real-time data can be processed on a scheduled basis, improving data processing flexibility and efficiency. Ultimately, this step improves the efficiency and accuracy of data processing and ensures the timeliness and reliability of business data.

[0077] Furthermore, priorities are set for real-time data and non-real-time data respectively.

[0078] Specifically, after classifying business data into real-time and non-real-time data, priorities are further assigned to each category. This includes defining priority criteria for real-time and non-real-time data. Real-time data is typically prioritized based on its importance and urgency, such as a real-time status update for a production order, which might be assigned a high priority. Non-real-time data is prioritized based on its timeliness and importance, such as a monthly sales report, which might be assigned a low priority. Data in the real-time data queue is prioritized. Real-time data is prioritized based on pre-set priority criteria to ensure that high-priority data is processed first, while data in the non-real-time data queue is prioritized. Non-real-time data is prioritized based on pre-set priority criteria to ensure that important data is processed as planned. The prioritized data queue is then stored in a corresponding data structure for subsequent transmission and processing. By assigning separate priorities to real-time and non-real-time data, orderly and efficient data processing is achieved. Real-time data is prioritized based on importance and urgency to ensure that critical data is processed first, meeting the real-time requirements of the business. Non-real-time data is prioritized based on timeliness and importance to ensure that important data is processed as planned, improving data processing flexibility and efficiency. Ultimately, this step improves the orderliness and efficiency of data processing and ensures the timeliness and reliability of business data.

[0079] Furthermore, a transmission path is selected based on the priority.

[0080] Specifically, after setting the priorities for real-time and non-real-time data, an appropriate transmission path is selected based on the priorities. This includes defining transmission path selection criteria. An appropriate transmission path is selected based on the data's priority and transmission requirements. For example, high-priority real-time data can choose a high-speed transmission path, while low-priority non-real-time data can choose a standard transmission path. Transmission path selection is performed for data in the real-time data queue. The appropriate transmission path is selected based on the data's priority. For example, high-priority real-time data can choose a high-speed transmission path to ensure fast data transmission. For data in the non-real-time data queue, a transmission path is selected based on the data's priority. For example, low-priority non-real-time data can choose a standard transmission path to ensure scheduled data transmission. The selected transmission path information is stored in a corresponding data structure for subsequent transmission and processing. Priority-based transmission path selection achieves efficient and reliable data transmission. High-priority real-time data chooses a high-speed transmission path to ensure fast data transmission, meeting the real-time requirements of the service; low-priority non-real-time data chooses a standard transmission path to ensure scheduled data transmission, improving data transmission flexibility and efficiency. Ultimately, this step improves the efficiency and reliability of data transmission, ensuring the timeliness and integrity of service data.

[0081] Furthermore, a data transmission strategy is formulated based on data classification, priority and transmission path.

[0082] Specifically, after completing data classification, priority setting, and transmission path selection, a data transmission strategy is formulated based on this information. Specific operations include: defining rules for formulating data transmission strategies. Formulating corresponding data transmission strategies based on data classification, priority, and transmission paths. For example, high-priority real-time data is preferentially transmitted via high-speed transmission paths, while low-priority non-real-time data is transmitted as planned via ordinary transmission paths. A transmission strategy is formulated for data in the real-time data queue. Formulating corresponding transmission strategies based on data classification, priority, and transmission paths. For example, high-priority real-time data is preferentially transmitted via high-speed transmission paths to ensure that the data can quickly reach the target ERP system. A transmission strategy is formulated for data in the non-real-time data queue. Formulating corresponding transmission strategies based on data classification, priority, and transmission paths. For example, low-priority non-real-time data is transmitted as planned via ordinary transmission paths to ensure that the data can reach the target ERP system as planned. The formulated data transmission strategies are stored in the corresponding data structure for subsequent transmission and processing. By formulating data transmission strategies based on data classification, priority, and transmission paths, orderly and efficient data transmission is achieved. High-priority real-time data is transmitted first via high-speed transmission paths, ensuring it reaches the target ERP system quickly and meeting the real-time needs of the business. Low-priority non-real-time data is transmitted as planned via standard transmission paths, ensuring it reaches the target ERP system as planned, improving data transmission flexibility and efficiency. Ultimately, this step improves the orderliness and efficiency of data transmission, ensuring the timeliness and integrity of business data.

[0083] S4. Transmit the encrypted data and checksum to the target through the ERP system integration interface, monitor the transmission status during the transmission process, and adjust the data transmission strategy based on the monitoring results.

[0084] Furthermore, the HTTPS protocol is selected based on the ERP interface technology and target requirements.

[0085] Specifically, before data transmission, first select a suitable transmission protocol based on the technical characteristics of the ERP system integration interface and the requirements of the target ERP system. Specific operations include: analyzing the technical characteristics of the ERP system integration interface, including supported protocol types, data formats, security requirements, etc.; analyzing the requirements of the target ERP system, including data receiving capabilities, security requirements, transmission efficiency, etc.; and selecting the HTTPS protocol as the data transmission protocol based on the above analysis results. The HTTPS protocol has high security and reliability and can meet the security requirements of data transmission. Configure the relevant parameters of the HTTPS protocol, such as port number, certificate path, timeout period, etc., to ensure that the protocol can work properly. By selecting the HTTPS protocol based on the ERP interface technology and target requirements, the security and reliability of data transmission are achieved. The use of the HTTPS protocol ensures the encryption and integrity of data during transmission, preventing data from being stolen or tampered with. At the same time, the high reliability and wide support of the HTTPS protocol ensure the stability and compatibility of data transmission, and improve the overall performance of data transmission.

[0086] Furthermore, a secure connection is established between the ERP system integration interface and the target, and after identity authentication is completed, a data packet containing encapsulated encrypted business data and a verification code is sent.

[0087] Specifically, after selecting the transmission protocol, the ERP system integration interface needs to establish a secure connection with the target ERP system and complete identity authentication. This involves using the client functionality of the HTTPS protocol to initiate a connection request to the target ERP system. This connection request includes the ERP system integration interface's identity information, such as certificates and keys, for authentication. Upon receiving the connection request, the target ERP system verifies the ERP system integration interface's identity information to ensure the legitimacy of the connection. After successful authentication, a secure connection is established. The encryption functionality of the HTTPS protocol is used to encrypt the transmitted data. The encapsulated encrypted business data and checksum data packet are sent to the target ERP system via a secure link. By establishing a secure connection between the ERP system integration interface and the target and completing identity authentication, the security and legitimacy of data transmission are ensured. The authentication process prevents unauthorized access and ensures the confidentiality and integrity of data transmission. Establishing a secure connection utilizes the encryption functionality of the HTTPS protocol, further enhancing the security of data transmission and preventing data theft or tampering during transmission. Ultimately, this step ensures the security and reliability of data transmission and improves the overall performance of data synchronization.

[0088] Furthermore, the transmission delay and packet loss rate of the encrypted business data and the checksum are monitored, the transmission quality is analyzed and evaluated, and a transmission quality evaluation report is obtained.

[0089] Specifically, during data transmission, it is necessary to monitor the transmission status in real time, including transmission delay and packet loss rate. This includes using network monitoring tools or protocol analysis tools to capture data packet transmission information in real time, including send time, receive time, and packet size. This includes calculating the transmission delay for each packet (i.e., the difference between the receive time and the send time), calculating the packet loss rate (i.e., the ratio of the number of packets lost during transmission to the total number of packets), analyzing the transmission delay and packet loss rate data, evaluating transmission quality, and generating a transmission quality assessment report. This report includes information such as the average, maximum, and minimum transmission delay values and the statistical value of the packet loss rate.

[0090] In order to evaluate the transmission quality and dynamically adjust the data transmission strategy, let the transmission quality evaluation function be Q and design the following formula:

[0091]

[0092] Where T is the transmission delay, T0 is the threshold of transmission delay, L is the packet loss rate, L0 is the threshold of packet loss rate, and k is the adjustment parameter;

[0093] Controls the steepness of the transmission quality evaluation function, Q is in the range of (0,2);

[0094] When Q is close to 0, it indicates poor transmission quality, and when Q is close to 2, it indicates good transmission quality;

[0095] The difference between T and T0 is calculated by the logic function Converted to a value in the range of (0,1) to represent the effect of transmission delay, the difference between L and L0 is calculated by the logic function Converted to a value in the range of (0,1), it represents the impact of packet loss rate. The larger the value of k, the steeper the function is, and the more sensitive it is to changes in transmission delay and packet loss rate. In practical applications, the data transmission strategy is dynamically adjusted according to the size of the transmission quality evaluation value Q:

[0096] When Q<1, it indicates that the transmission quality is poor and it is necessary to adjust the packet sending rate or switch to the backup channel;

[0097] When Q ≥ 1, it indicates that the transmission quality is good and the current data transmission strategy can be maintained.

[0098] By monitoring the transmission delay and packet loss rate of encrypted business data and checksums, and analyzing and evaluating transmission quality, a transmission quality assessment report is generated. This report provides key metrics during the transmission process, such as transmission delay and packet loss rate, helping the ERP system promptly identify transmission problems. Monitoring transmission delay ensures the timeliness of data transmission, while monitoring packet loss rate ensures the integrity of data transmission. Ultimately, this step enables real-time monitoring and assessment of data transmission quality, providing a basis for subsequent adjustments to data transmission strategies and improving data transmission reliability and efficiency.

[0099] Furthermore, the data transmission strategy is adjusted based on the transmission quality evaluation report, wherein the adjustment of the data transmission strategy includes adjusting the data packet sending rate and switching to a backup channel.

[0100] Specifically, the transmission delay and packet loss rate data in the transmission quality evaluation report are analyzed to determine whether the transmission quality meets a preset threshold.

[0101] If the transmission delay or packet loss rate exceeds the preset threshold, adjust the data transmission strategy and the packet sending rate. According to the transmission delay and packet loss rate, appropriately increase or decrease the packet sending rate. If adjusting the sending rate fails to improve the transmission quality, switch to the backup channel for data transmission. After switching to the backup channel, re-establish the connection and notify the target ERP system to complete the channel switching. By adjusting the data transmission strategy based on the transmission quality assessment report, dynamic optimization of data transmission is achieved. Adjusting the packet sending rate can effectively respond to changes in transmission delay and packet loss rate, ensuring the stability and reliability of data transmission. Switching to the backup channel can quickly resume data transmission when the main channel fails or performance degrades, ensuring the continuity of data synchronization. Ultimately, this step realizes the dynamic adjustment of the data transmission strategy, improves the reliability and efficiency of data transmission, and ensures the timeliness and integrity of business data.

[0102] Furthermore, a transmission quality threshold is predefined by the service data, and the transmission quality threshold includes a transmission delay and a packet loss rate.

[0103] Specifically, based on the characteristics and requirements of business data, reasonable ranges for transmission delay and packet loss rate are determined. A transmission delay threshold, such as a maximum allowable transmission delay of 100 milliseconds, and a packet loss threshold, such as a maximum allowable packet loss rate of 1%, are set. These thresholds are stored in the ERP system configuration file or database for subsequent transmission quality assessments. Pre-defined transmission quality thresholds provide clear standards for transmission quality assessment. Transmission delay and packet loss rate thresholds ensure data transmission performance requirements and enable timely detection of transmission problems. Ultimately, this step provides a basis for adjusting data transmission policies, improving data transmission reliability and efficiency.

[0104] Furthermore, the transmission quality evaluation report is compared with a transmission quality threshold, and the data transmission policy is adjusted when the transmission quality evaluation report exceeds the transmission quality threshold.

[0105] Specifically, the transmission delay and packet loss rate data in the transmission quality assessment report are read, the preset transmission delay and packet loss rate thresholds are read, the actual values of the transmission delay and packet loss rate are compared with the thresholds, and a determination is made as to whether the thresholds are exceeded. If the actual values of the transmission delay or packet loss rate exceed the thresholds, an adjustment of the data transmission strategy is triggered. The data transmission strategy is adjusted, including adjusting the packet sending rate or switching to a backup channel. By comparing the transmission quality assessment report with the transmission quality thresholds, real-time monitoring and early warning of the transmission quality are achieved. When the transmission delay or packet loss rate exceeds the threshold, the data transmission strategy can be adjusted in a timely manner to ensure the stability and reliability of data transmission. Ultimately, this step improves the reliability and efficiency of data transmission and ensures the timeliness and integrity of business data.

[0106] Furthermore, the data packet sending rate is adjusted according to the adjusted data transmission policy. When the packet loss rate and delay exceed the preset transmission quality threshold, the rate is increased or decreased by a predetermined amount. Otherwise, the data is switched to the backup channel for transmission, and the target system is notified to complete the channel switch. Specifically, the adjusted data transmission policy is read to determine the new data packet sending rate. If the packet loss rate and delay exceed the preset transmission quality threshold, the rate is increased or decreased by a predetermined amount. If adjusting the sending rate does not improve the transmission quality, the data is switched to the backup channel for transmission. After switching to the backup channel, the connection is reestablished, and the target ERP system is notified to complete the channel switch. The transmission status of the backup channel is monitored to ensure the stability and reliability of data transmission. By adjusting the data packet sending rate according to the adjusted data transmission policy, dynamic optimization of data transmission is achieved. The increase or decrease rate can effectively cope with changes in transmission delay and packet loss rate, ensuring the stability and reliability of data transmission. Switching to the backup channel can quickly resume data transmission when the primary channel fails or performance degrades, ensuring the continuity of data synchronization. Ultimately, this step improves the reliability and efficiency of data transmission, ensuring the timeliness and integrity of business data.

[0107] S5. Decrypt the received data, use the check code to verify the decrypted data, and verify whether the data is complete. After the data is complete, store it in the target database to complete the automatic synchronization of business data.

[0108] Furthermore, the encrypted data received through the ERP system integration interface is decrypted to obtain plaintext data.

[0109] Specifically, the encrypted data and checksum are extracted from the received data packet. A data packet typically contains a header identifying the source and type of the data, and a data body containing the actual encrypted data and checksum. The encrypted data is then decrypted using a preset decryption algorithm. The decryption algorithm corresponds to the encryption algorithm, ensuring that the plaintext data can be accurately restored. For example, if the encryption algorithm is elliptic curve cryptography (ECC), the decryption algorithm is also ECC. During the decryption process, the encrypted data is decrypted using a preset key. The key is a parameter used in the encryption and decryption processes to ensure data security. After decryption, the plaintext data is obtained. Plaintext data is the unencrypted raw data that can be directly used for subsequent processing and storage. For example, suppose a received data packet contains encrypted order data. Using the ECC decryption algorithm and the preset key, the plaintext order data is decrypted, including the order number, customer information, product information, etc. By decrypting the received encrypted data, the data is restored and its availability is ensured. The decryption process uses the preset decryption algorithm and key to ensure accuracy and security, preventing data tampering or corruption during the decryption process. Ultimately, this step ensures the integrity and availability of plaintext data, providing a basis for subsequent data verification and storage.

[0110] Furthermore, the hash value of the plaintext data is calculated using a hash algorithm and compared with the checksum to verify whether the encrypted data has been tampered with during transmission.

[0111] Specifically, a suitable hash algorithm, such as SHA-256, is selected to perform a hash calculation on the plaintext data. A hash algorithm converts data of any length into a fixed-length hash value. The plaintext data is input into the hash algorithm to calculate the hash value. For example, assuming the plaintext data is a string of order information, a 256-bit hash value is calculated using the SHA-256 algorithm. A checksum is then extracted from the received data packet. The checksum is calculated and appended at the data sender to verify data integrity. The calculated hash value is then compared bit by bit with the extracted checksum. During this comparison, the hash value and checksum are checked bit by bit for consistency. The hash value of the plaintext data is calculated using the hash algorithm and compared with the checksum, verifying data integrity. Hash algorithms are unidirectional and collision-resistant, ensuring data uniqueness and integrity. Comparing the hash value with the checksum effectively detects data tampering during transmission, ensuring data reliability and security. Ultimately, this step ensures data integrity and safeguards subsequent data storage.

[0112] Furthermore, the decrypted encrypted data is checked for integrity, and the checking includes checking the length and format of the encrypted data.

[0113] Specifically, the length of the decrypted plaintext data is checked to ensure it matches the expected length. For example, assuming the expected order data length is 1024 bytes, the actual decrypted data length is checked to ensure it is 1024 bytes. The format of the plaintext data is also checked to ensure it conforms to predefined data format specifications. For example, assuming the order data is formatted in JSON, the data is checked to ensure it conforms to JSON syntax specifications, performing detailed checks and verification of the data length and format. For example, a JSON parser is used to parse the data to check whether fields such as the order number, customer information, and product information can be correctly parsed. If the data length and format checks pass, the data is complete and can be stored. If they fail, appropriate processing is required, such as retransmission or discarding the data. For example, assuming the decrypted data length is 1024 bytes and formatted in JSON, a JSON parser is used to parse the data. If all fields are successfully parsed, the data is complete. By checking the length and format of the decrypted data, further verification of data integrity is achieved. Data length and format checks ensure data integrity and availability, preventing storage errors caused by corrupted or incomplete data. Ultimately, this step ensures the integrity and availability of the data, providing a guarantee for subsequent data storage.

[0114] Furthermore, the verified complete encrypted data is stored in the target database to complete the automatic synchronization of business data.

[0115] Specifically, the verified plaintext data is transferred to the target database system. For example, assuming the target database is a relational database such as MySQL, the corresponding data tables are created or updated in the target database to ensure the correct data storage structure and format. For example, an order table is created with fields such as order number, customer information, and product information. The plaintext data is then inserted or updated into the target database table. For example, SQL statements are used to insert the order data into the order table. After data storage is complete, data synchronization log information is recorded, including the synchronization time, data volume, and synchronization results. For example, the synchronization time is recorded as 2024-10-10 10:00:00, the data volume is 100 order data items, and the synchronization result is successful. If the data storage is successful, automatic synchronization of the business data is completed. If the storage fails, appropriate error handling and retry mechanisms are implemented. For example, if the storage fails, the error message is recorded and a retry attempt is made. By storing the verified data in the target database, automatic synchronization of the business data is achieved. The data storage process ensures data accuracy and consistency, preventing business problems caused by data errors. Ultimately, this step ensures the timeliness and integrity of business data, providing strong support for the enterprise's information development and data management.

[0116] Furthermore, the SHA-256 hash algorithm is used to calculate the decrypted plaintext data to generate the corresponding hash value.

[0117] Specifically, the decrypted plaintext data is read to ensure data integrity and availability. The SHA-256 hash algorithm is initialized to prepare for hashing the plaintext data. The plaintext data is then divided into blocks, each of which is hashed using the SHA-256 algorithm. The hash results for each block are accumulated to generate a final hash value. The decrypted plaintext data is then hashed using the SHA-256 algorithm to generate the corresponding hash value. This process ensures data uniqueness and integrity, providing a reliable foundation for subsequent verification. The SHA-256 algorithm is highly secure and collision-resistant, effectively detecting data tampering during transmission and ensuring data reliability and security.

[0118] Furthermore, a checksum having the same hash value as the plaintext data is extracted from the data packet.

[0119] Specifically, the received data packet is read, the checksum is located, and the checksum is extracted to ensure that it corresponds to the hash value of the plaintext data. For example, assuming the data packet contains a checksum field, the value of this field is extracted, such as abcdef1234567890, and the extracted checksum is ensured to have the same format and length as the calculated hash value. By extracting a checksum with the same hash value as the plaintext data from the data packet, the accuracy and reliability of the checksum are ensured. This process provides the necessary data for subsequent comparisons, ensuring the accuracy and effectiveness of data verification. Comparing the extracted checksum with the calculated hash value can effectively verify the integrity and non-tampering of the data, thereby improving the reliability and security of data transmission.

[0120] Furthermore, the calculated hash value is compared bit by bit with the extracted check code.

[0121] Specifically, the calculated hash value and the extracted checksum are aligned bit by bit, and the hash value and checksum are compared bit by bit to check whether each bit is identical. If all bits are identical, the data has not been tampered with; if any bit is different, the data may have been tampered with. By comparing the calculated hash value with the extracted checksum bit by bit, accurate verification of data integrity is achieved. This process ensures that the data has not been tampered with during transmission, improving data reliability and security. The bit-by-bit comparison method can effectively detect any subtle changes in the data, ensuring data integrity and consistency, and providing reliable protection for subsequent data storage and use.

[0122] This embodiment also provides a computer device, which is suitable for the case of an automatic synchronization method of business data based on an ERP system integration interface, including: a memory and a processor; the memory is used to store computer-executable instructions, and the processor is used to execute computer-executable instructions to implement the automatic synchronization method of business data based on an ERP system integration interface proposed in the above embodiment.

[0123] The computer device may be a terminal, comprising a processor, a memory, a communication interface, a display screen and an input device connected via a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device comprises a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner may be achieved through WIFI, an operator network, NFC (near field communication) or other technologies. The display screen of the computer device may be a liquid crystal display or an electronic ink display screen, and the input device of the computer device may be a touch layer covering the display screen, or a button, trackball or touchpad provided on the housing of the computer device, or an external keyboard, touchpad or mouse.

[0124] This embodiment also provides a storage medium having a computer program stored thereon, which, when executed by a processor, implements the method for automatically synchronizing business data based on an ERP system integration interface as proposed in the above embodiment; the storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, disk or optical disk.

[0125] In summary, the present invention achieves this by: real-time monitoring of business data changes in the ERP system integration interface, timely collection of change data, ensuring the timeliness and accuracy of data collection, adopting elliptic curve encryption algorithm and double verification mechanism to improve data security and integrity, classifying business data into real-time data and non-real-time data, setting priorities for each, selecting transmission paths based on the priorities, formulating reasonable data transmission strategies, improving transmission efficiency and reliability, monitoring the transmission status during transmission and dynamically adjusting strategies based on the results, such as adjusting the sending rate and switching channels, optimizing the transmission process, ensuring the accuracy and efficiency of data synchronization, decrypting and verifying the received data to ensure that the data has not been tampered with, verifying that the complete data is stored in the target database, and completing automatic synchronization of business data. The entire process improves the accuracy and security of data synchronization, effectively solving the shortcomings of the existing technology.

[0126] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit the present invention. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solutions of the present invention may be modified or replaced by equivalents without departing from the spirit and scope of the technical solutions of the present invention, which should all be included in the scope of the claims of the present invention.

Claims

1. A method for automatically synchronizing business data based on an ERP system integration interface, characterized by: include, Monitor business data changes at the ERP system integration interface and collect the changed business data when changes are detected; Encrypt and verify the collected business data to generate a verification code; Formulate data transmission strategies based on changes in business data; Transmit the encrypted data and checksum to the target through the ERP system integration interface, monitor the transmission status during the transmission process, and adjust the data transmission strategy based on the monitoring results; The received data is decrypted and verified using a checksum to verify the decrypted data and verify the data is complete. Once the data is complete, it is stored in the target database to complete automatic synchronization of business data.

2. The method for automatically synchronizing business data based on an ERP system integration interface according to claim 1, characterized in that: The monitoring of business data changes at the ERP system integration interface and the collection of the changed business data when changes in the business data are detected are specifically carried out as follows: Deploy monitoring tools at the ERP system integration interface to monitor business data transmission channels, capture data packets flowing through the ERP system integration interface, parse the content, record business data information, and create monitoring logs; Based on business data information, the system compares the previous and next states of business data in real time and sends the changed business data information to the message queue; After receiving the changed business data, the message queue locates and obtains the changed business data through the data access interface provided by the ERP system; The changed business data is compared with the monitoring log and stored in the database after the comparison is passed.

3. The method for automatically synchronizing business data based on an ERP system integration interface according to claim 2, characterized in that: The collected business data is encrypted and verified to generate a verification code. The specific steps are: Use elliptic curve encryption algorithm to encrypt business data; The encrypted data is verified using a double check mechanism, which includes CRC check and parity check, to obtain the verified business data and encapsulation information; Use a custom encapsulation format to encapsulate the verified data and verification information into a data packet; Use a hash function to calculate the hash value of the data packet, and use the hash value as a checksum for the data packet content.

4. The method for automatically synchronizing business data based on an ERP system integration interface according to claim 3, characterized in that: The data transmission strategy is formulated based on the changes in business data. The specific steps are: Classify the collected business data into real-time data and non-real-time data; Prioritize real-time data and non-real-time data separately; Selecting a transmission path based on priority; Develop data transmission strategies based on data classification, priority, and transmission paths.

5. The method for automatically synchronizing business data based on an ERP system integration interface according to claim 4, characterized in that: The encrypted data and check code are transmitted to the target through the ERP system integration interface, the transmission status is monitored during the transmission process, and the data transmission strategy is adjusted according to the monitoring results. The specific steps are: Select the HTTPS protocol based on the ERP interface technology and target requirements; Establish a secure connection between the ERP system integration interface and the target, and send the packaged encrypted business data and verification code data package after completing identity authentication; Monitor the transmission delay and packet loss rate of encrypted business data and checksums, analyze and evaluate the transmission quality, and obtain a transmission quality assessment report; The data transmission strategy is adjusted based on the transmission quality evaluation report, wherein the adjusting of the data transmission strategy includes adjusting the data packet sending rate and switching to a backup channel.

6. The method for automatic synchronization of business data based on an ERP system integration interface according to claim 5, characterized in that: The data transmission strategy is adjusted based on the transmission quality assessment report, and the data transmission strategy includes adjusting the data packet sending rate and switching to the backup channel. The specific steps are: Predefine a transmission quality threshold based on service data, wherein the transmission quality threshold includes transmission delay and packet loss rate; comparing the transmission quality assessment report with a transmission quality threshold, and adjusting a data transmission strategy when the transmission quality assessment report exceeds the transmission quality threshold; The sending rate of data packets is adjusted according to the adjusted data transmission strategy. When the packet loss rate and delay exceed the preset transmission quality threshold, the rate is increased or decreased by a predetermined amount. Otherwise, the backup channel is switched to transmit data, and the target is notified to complete the channel switching.

7. The method for automatic synchronization of business data based on an ERP system integration interface according to claim 6, characterized in that: The received data is decrypted and verified using a check code to verify the decrypted data and verify whether the data is complete. After the data is complete, it is stored in the target database to complete the automatic synchronization of business data. The specific steps are: Decrypt the encrypted data received through the ERP system integration interface to obtain the plaintext data; Calculate the hash value of the plaintext data through the hash algorithm and compare it with the checksum to verify whether the encrypted data has been tampered with during transmission; Checking whether the decrypted encrypted data is complete, the checking including checking the length and format of the encrypted data; The verified complete encrypted data is stored in the target database to complete the automatic synchronization of business data.

8. The method for automatic synchronization of business data based on an ERP system integration interface according to claim 7, characterized in that: The hash value of the plaintext data is calculated by the hash algorithm and compared with the check code to verify whether the encrypted data has been tampered with during the transmission process. The specific steps are: Use the SHA-256 hash algorithm to calculate the decrypted plaintext data and generate the corresponding hash value; Extracting a checksum with the same hash value as the plaintext data from the data packet; The calculated hash value is compared bit by bit with the extracted check code.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method for automatic synchronization of business data based on the ERP system integration interface according to any one of claims 1 to 8 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method for automatic synchronization of business data based on an ERP system integration interface according to any one of claims 1 to 8 are implemented.

Images