Data synchronization method and system based on RPA robot

Abstract

The application discloses a data synchronization method and system based on an RPA robot, and the method comprises the following steps: determining at least two data systems that need to be synchronized; deploying a synchronization script between the data systems based on RPA technology and a data synchronization rule of the data systems; when there is input data in a target data filling port, obtaining the input data; and executing the synchronization script to synchronize the input data to all the data systems. It can be seen that the application can improve the accuracy and efficiency of data synchronization, reduce the error of data synchronization, and does not need to change the bottom layer of the data system, thereby reducing the research and development cost.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to a data synchronization method and system based on an RPA robot. BACKGROUND

[0002] Under the background of the continuous popularization of informatization, the data of various institutions or units are all using data acquisition uploading technology to realize information acquisition, which also promotes a large number of institutions to adopt various technical means to solve the synchronization problem of data between systems, so as to realize the consistency, integrity and authenticity of the data after informatization. When the existing data of institutions or units realizes the data synchronization problem between multiple systems, the data synchronization is often realized by data grabbing and data transmission technology after data entry, without considering the combination of RPA (Robotic Process Automation, robot process automation) technology and the pre-set synchronization operation process to realize the data synchronization between multiple systems. Therefore, the efficiency of data synchronization is low, and the effect is poor. It can be seen that the existing technology has defects and needs to be solved. SUMMARY

[0003] The technical problem to be solved by the present application is to provide a data synchronization method and system based on an RPA robot, which can improve the accuracy and efficiency of data synchronization, reduce errors in data synchronization, and does not need to change the underlying data system, thereby reducing the research and development cost.

[0004] In order to solve the above technical problems, the first aspect of the present application discloses a data synchronization method based on an RPA robot, which comprises:

[0005] Determine at least two data systems that need to be synchronized;

[0006] Deploy a synchronization script between the data systems based on RPA technology and data synchronization rules of the data systems;

[0007] When there is entry data in the target data reporting port, obtain the entry data;

[0008] Execute the synchronization script to synchronize the entry data to all the data systems.

[0009] As an optional implementation, in the first aspect of the present application, the deployment of the synchronization script between the data systems based on the RPA technology and the data synchronization rules of the data systems comprises:

[0010] Determine the source data object and the target data object in each of the data systems;

[0011] binding the source data object and the target data object according to a data synchronization rule of each of the data systems, to generate an RPA synchronization script;

[0012] deploying the RPA synchronization script on each of the data systems and a target data reporting port of the source data object.

[0013] As an optional implementation, in the first aspect of the present application, the source data object or the target data object is a database data object, an API synchronization data template, or a table data object.

[0014] As an optional implementation, in the first aspect of the present application, the binding the source data object and the target data object according to a data synchronization rule of each of the data systems, to generate an RPA synchronization script, comprises:

[0015] generating an automatic data reporting operation corresponding to each of the data systems according to a data reporting process corresponding to each of the data systems;

[0016] binding the source data object and the target data object, and generating an RPA synchronization script based on the automatic data reporting operation.

[0017] As an optional implementation, in the first aspect of the present application, the generating an automatic data reporting operation corresponding to each of the data systems according to a data reporting process corresponding to each of the data systems, comprises:

[0018] obtaining a guidance file of the data reporting process corresponding to each of the data systems;

[0019] determining a data reporting operation text corresponding to each of the data systems based on a preset keyword matching rule according to the guidance file;

[0020] inputting the data reporting operation text into a trained code generation algorithm model to obtain an automatic reporting code corresponding to each of the data systems as the automatic data reporting operation corresponding to the data system.

[0021] As an optional implementation, in the first aspect of the present application, the synchronization mode of the RPA synchronization script is an API synchronization mode or a database synchronization mode.

[0022] As an optional implementation, in the first aspect of the present application, the determining at least two data systems that need to be synchronized, comprises:

[0023] obtaining data transmission records of a plurality of candidate data systems;

[0024] calculate a synchronization rate parameter between data transmission records of any two of the candidate data systems;

[0025] calculate an average of all the synchronization rate parameters corresponding to each of the candidate data systems, to obtain a synchronization necessity parameter of each of the candidate data systems;

[0026] determine all the candidate data systems with the synchronization necessity parameter greater than a parameter threshold value as data systems that need to be synchronized.

[0027] As an optional implementation, in the first aspect of the present application, the synchronization rate parameter is obtained by calculating a proportion of data records with a time difference between the same data content and upload time in any two of the data transmission records being less than a time threshold value.

[0028] The second aspect of the embodiment of the present application discloses a data synchronization system based on an RPA robot, and the system comprises:

[0029] a determination module configured to determine at least two data systems that need to be synchronized;

[0030] a deployment module configured to deploy a synchronization script between the data systems based on RPA technology and a data synchronization rule of the data systems;

[0031] an acquisition module configured to acquire input data when the input data exists in a target data input port;

[0032] a synchronization module configured to execute the synchronization script and synchronize the input data to all the data systems.

[0033] As an optional implementation, in the second aspect of the present application, the specific manner in which the deployment module deploys the synchronization script between the data systems based on RPA technology and the data synchronization rule of the data systems comprises:

[0034] determining a source data object and a target data object in each of the data systems;

[0035] binding the source data object and the target data object based on a data synchronization rule of each of the data systems, to generate an RPA synchronization script;

[0036] deploying the RPA synchronization script in each of the data systems and a target data input port in which the source data object is input.

[0037] As an optional implementation, in the second aspect of the present application, the source data object or the target data object is a database data object, an API synchronization data template or a table data object.

[0038] As an optional implementation, in the second aspect of the present application, the deployment module binds the source data object and the target data object based on the data synchronization rule of each data system, and the specific manner of generating the RPA synchronization script includes:

[0039] Based on the data filling process corresponding to each data system, an automatic data filling operation corresponding to each data system is generated.

[0040] The source data object and the target data object are bound, and the RPA synchronization script is generated based on the automatic data filling operation.

[0041] As an optional implementation, in the second aspect of the present application, the specific manner of generating the automatic data filling operation corresponding to each data system by the deployment module based on the data filling process corresponding to each data system includes:

[0042] Obtain the guidance file of the data filling process corresponding to each data system;

[0043] According to the guidance file, determine the data filling operation text corresponding to each data system based on a preset keyword matching rule;

[0044] Input the data filling operation text into a trained code generation algorithm model to obtain an automatic filling code corresponding to each data system as the automatic data filling operation corresponding to the data system.

[0045] As an optional implementation, in the second aspect of the present application, the synchronization mode of the RPA synchronization script is an API synchronization mode or a database synchronization mode.

[0046] As an optional implementation, in the second aspect of the present application, the specific manner of determining at least two data systems that need to be synchronized by the determination module includes:

[0047] Obtain the data transmission records of a plurality of candidate data systems;

[0048] Calculate the synchronization rate parameters between the data transmission records of any two candidate data systems;

[0049] Calculate the average value of all synchronization rate parameters corresponding to each candidate data system to obtain a synchronization necessity parameter of each candidate data system;

[0050] All candidate data systems with a synchronization necessity parameter greater than a parameter threshold value are determined as data systems that need to be synchronized.

[0051] As an optional implementation, in the second aspect of the present application, the synchronization rate parameter is obtained by calculating the proportion of the number of data records in which the time difference between the uploading times of the same data content in any two data records is below a time threshold.

[0052] The third aspect of the present application discloses another data synchronization system based on RPA robots, which comprises:

[0053] a memory storing executable program codes;

[0054] a processor coupled with the memory;

[0055] The processor invokes the executable program codes stored in the memory to execute part or all of the steps of the data synchronization method based on RPA robots disclosed in the first aspect of the present application.

[0056] The fourth aspect of the present application discloses a computer storage medium storing computer instructions, which, when invoked, are used to execute part or all of the steps of the data synchronization method based on RPA robots disclosed in the first aspect of the present application.

[0057] Compared with the prior art, the embodiments of the present application have the following beneficial effects:

[0058] The present application can deploy synchronization scripts between data systems that need to be synchronized through RPA technology, so that the entered data can be automatically and quickly synchronized to the databases of all data systems through the synchronization scripts when data is entered, thereby improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and reducing the cost of research and development without changing the underlying data system. BRIEF DESCRIPTION OF DRAWINGS

[0059] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed in the embodiment description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.

[0060] Figure 1 is a flow diagram of a data synchronization method based on RPA robots disclosed by the embodiments of the present application.

[0061] Figure 2 is a structural diagram of a data synchronization system based on RPA robots disclosed by the embodiments of the present application.

[0062] Figure 3is a structural schematic diagram of another data synchronization system based on an RPA robot disclosed by the embodiment of the present application. DETAILED DESCRIPTION

[0063] In order for those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be described clearly and completely below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, not all. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor fall within the scope of protection of the present application.

[0064] The terms "first", "second", and the like in the specification and claims of the present application and the above-mentioned drawings are used to distinguish different objects, not to describe a specific order. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, device, product, or equipment that includes a series of steps or units is not limited to the listed steps or units, but can optionally include steps or units not listed, or can optionally include other steps or units inherent to the process, method, product, or equipment.

[0065] Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the present application. The phrase appears at various places in the specification does not necessarily all refer to the same embodiment, nor is it necessarily mutually exclusive of other embodiments. It is explicitly and implicitly understood that the embodiments described herein can be combined with other embodiments.

[0066] The present application discloses a data synchronization method and system based on an RPA robot, which can deploy synchronization scripts between data systems that need to be synchronized through RPA technology, so that the entered data can be automatically and quickly synchronized to the databases of all data systems through the synchronization scripts when data is entered, thereby improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the underlying data system, reducing research and development costs. The following are described in detail.

[0067] Embodiment one

[0068] Please refer to Figure 1 , Figure 1 is a flowchart of a data synchronization method based on an RPA robot disclosed by the embodiment of the present application. Among them, Figure 1The described RPA robot-based data synchronization method can be applied in a data processing system / data processing device / data processing server (wherein the server includes a local processing server or a cloud processing server). As shown in Figure 1 The RPA robot-based data synchronization method can include the following operations:

[0069] 101. Determine at least two data systems that need to be synchronized.

[0070] 102. Deploy a synchronization script between the data systems based on RPA technology and data synchronization rules of the data systems.

[0071] 103. When there is input data in the target data reporting port, obtain the input data.

[0072] 104. Execute the synchronization script to synchronize the input data to all data systems.

[0073] As can be seen, the above embodiment can deploy a synchronization script between the data systems that need to be synchronized through RPA technology, so that the input data can be automatically and quickly synchronized to the databases of all data systems through the synchronization script when data is input, thereby improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the underlying data system, reducing development costs.

[0074] As an optional embodiment, in the above step, deploying a synchronization script between the data systems based on RPA technology and data synchronization rules of the data systems includes:

[0075] Determine the source data object and the target data object in each data system;

[0076] Bind the source data object and the target data object based on the data synchronization rules of each data system to generate an RPA synchronization script;

[0077] Deploy the RPA synchronization script in each data system and the target data reporting port filled with the source data object.

[0078] As can be seen, through the above optional embodiment, the source data object and the target data object can be bound to generate an RPA synchronization script based on the preset data synchronization rules and deployed to implement data synchronization subsequently, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the underlying data system, reducing development costs.

[0079] As an optional embodiment, in the above step, the source data object or the target data object is a database data object, an API synchronization data template, or a table data object.

[0080] It can be seen that through the above optional embodiments, the type of the data object is determined, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, without changing the underlying data system, and reducing research and development costs.

[0081] As an optional embodiment, in the above step, the source data object and the target data object are bound based on the data synchronization rule of each data system to generate the RPA synchronization script, including:

[0082] Based on the data reporting process corresponding to each data system, an automatic data reporting operation corresponding to each data system is generated.

[0083] The source data object and the target data object are bound, and the RPA synchronization script is generated based on the automatic data reporting operation.

[0084] It can be seen that through the above optional embodiments, the corresponding automatic data reporting operation can be generated based on the data reporting process corresponding to each data system, to generate an accurate and reasonable RPA synchronization script, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, without changing the underlying data system, and reducing research and development costs.

[0085] As an optional embodiment, in the above step, the source data object and the target data object are bound based on the data synchronization rule of each data system to generate the RPA synchronization script, including:

[0086] Obtain the guidance file of the data reporting process corresponding to each data system;

[0087] According to the guidance file, determine the data reporting operation text corresponding to each data system based on a preset keyword matching rule;

[0088] Input the data reporting operation text into the trained code generation algorithm model to obtain the automatic reporting code corresponding to each data system as the automatic data reporting operation corresponding to the data system.

[0089] It can be seen that through the above optional embodiments, the data reporting operation text corresponding to the data system can be determined by the keyword matching rule, and the automatic reporting code corresponding to the data system can be generated based on the code generation algorithm model, which is used for the generation of the synchronization script, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, without changing the underlying data system, and reducing research and development costs.

[0090] As an optional embodiment, in the above step, the synchronization mode of the RPA synchronization script is an API synchronization mode or a database synchronization mode.

[0091] It can be seen that through the above optional embodiments, the type of synchronization mode of the RPA synchronization script is determined, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, without changing the underlying data system, and reducing development costs.

[0092] As an optional embodiment, in the above step, determining the at least two data systems that need to be synchronized includes:

[0093] Obtaining data transmission records of a plurality of candidate data systems;

[0094] Calculating a synchronization rate parameter between the data transmission records of any two candidate data systems;

[0095] Calculating the average value of all synchronization rate parameters corresponding to each candidate data system to obtain a synchronization necessity parameter of each candidate data system;

[0096] All candidate data systems with a synchronization necessity parameter greater than a parameter threshold value are determined as data systems that need to be synchronized.

[0097] It can be seen that through the above optional embodiments, the data transmission records of the candidate data systems can be calculated to obtain the synchronization necessity parameter of the candidate data systems, so as to accurately screen the data systems that need to be synchronized, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, without changing the underlying data system, and reducing development costs.

[0098] As an optional embodiment, in the above step, the synchronization rate parameter is obtained by calculating the number of data records with the same data content and a time difference between upload times less than a time threshold value between any two data transmission records.

[0099] It can be seen that through the above optional embodiments, the calculation rule of the synchronization rate parameter is determined, which is used for subsequent calculation of the synchronization necessity parameter, so as to accurately screen the data systems that need to be synchronized, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, without changing the underlying data system, and reducing development costs.

[0100] In one specific embodiment, an RPA automatic reporting system is implemented, in which automation technologies such as process management, form management, process and form binding in RPA technology are adopted, and in combination with the API provided between different data systems that need to be synchronized, data object access interface permissions, and data reporting (collection) user interface (UI), a large number of repetitive tasks with fixed operation processes between enterprises and productivity applications are simulated and executed by human operations, and the effect can be equivalent to that of the RPA system simulating human to automatically copy and paste the data reported by one system to another system to realize accurate and efficient synchronization of data between systems.

[0101] Specifically, in this scheme, by deploying scripts for simulating manual processes in a system, RPA robots can automatically perform activities and transactions in various unrelated software systems.

[0102] Specifically, in this embodiment, the RPA robot is a software robot that includes customizable processes, forms, bindable process forms, and callable APIs, and executes various executable applications. Its configuration process includes:

[0103] First, start RPA and configure, generate, and deploy RPA synchronization scripts, which include the following specific steps: import target data objects that can be synchronized (including API synchronization data templates, database data objects (tables), and data objects mapped by the data reporting page of the synchronization system), and match the data objects that can provide synchronization data in the source system, configure synchronization processes and synchronization operations according to the operation process of the target system data reporting (i.e., RPA executable synchronization can call synchronization API, database operation, and execute another system's data reporting page), bind the data that can be reported by each synchronization process node, and generate and deploy RPA.

[0104] Second, start the data reporting page of the synchronization source system, report data, save data, and complete data synchronization.

[0105] Specifically, in this embodiment, when RPA executes scripts to achieve data synchronization, there are the following cases:

[0106] (1) When the synchronization mode is API mode, RPA needs to call the synchronization API and report data according to the synchronization data element requirements.

[0107] (2) When the synchronization mode is the database object (table) mode, RPA needs to connect to the target database and update the data of the target object with the synchronization data.

[0108] (3) When the synchronization mode is another system's data reporting page, RPA needs to start the data reporting page of the synchronization target system and report the data to the target system's reporting page after copying and pasting the synchronization data and submitting it.

[0109] For more detailed technical details of the deployment of the synchronization script, please refer to the technical steps in the above embodiments, which will not be repeated here.

[0110] It can be seen that the specific embodiment applies the data synchronization technical idea in the present application, and the RPA data synchronization has the following advantages, including:

[0111] (1) Less coding work: It is not necessary to configure the system by the underlying system developer.

[0112] (2) Fast cost saving: Since the RPA technology reduces the workload of the team, employees can be reassigned to other high-priority work that needs manpower, thereby improving productivity.

[0113] (3) Improve customer satisfaction: Since robots and chatbots can work around the clock, they can reduce customer waiting time and improve customer satisfaction.

[0114] (4) Improve employee morale: RPA technology can free the team from a lot of repetitive work and focus on more thoughtful strategic decisions. This change in work has a positive impact on employee happiness.

[0115] (5) Higher accuracy and compliance: Since RPA robots can be programmed to follow specific workflows and rules, human errors can be reduced, especially for work that requires high accuracy and compliance, so that users can easily monitor progress problems and solve problems faster.

[0116] (6) Existing systems remain unchanged: Robotic process automation software does not cause any damage to the underlying system, because the robot works on the presentation layer of the existing application.

[0117] Embodiment Two

[0118] Please refer to Figure 2 , Figure 2 is a structural schematic diagram of a data synchronization system based on an RPA robot disclosed by an embodiment of the present application. Among them, Figure 2 The data synchronization system based on the RPA robot described can be applied in a data processing system / data processing device / data processing server (wherein the server includes a local processing server or a cloud processing server). As Figure 2 shown, the data synchronization system based on the RPA robot can include:

[0119] The determining module 201 is configured to determine at least two data systems that need to be synchronized.

[0120] The deployment module 202 is configured to deploy a synchronization script between the data systems based on the RPA technology and a data synchronization rule of the data systems.

[0121] The acquisition module 203 is configured to acquire the input data when the input data exists in the target data reporting port.

[0122] The synchronization module 204 is configured to execute the synchronization script and synchronize the input data to all the data systems.

[0123] It can be seen that the above embodiments can deploy a synchronization script between data systems that need to be synchronized through the RPA technology, so that the input data can be automatically and quickly synchronized to the databases of all the data systems through the synchronization script when the input data is input, thereby improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and reducing the development cost without changing the underlying data systems.

[0124] As an optional embodiment, the specific manner in which the deployment module deploys the synchronization script between the data systems based on the RPA technology and the data synchronization rule of the data systems includes:

[0125] determining a source data object and a target data object in each data system;

[0126] binding the source data object and the target data object based on the data synchronization rule of each data system to generate an RPA synchronization script;

[0127] deploying the RPA synchronization script in each data system and a target data reporting port in which the source data object is input.

[0128] It can be seen that through the above optional embodiment, the source data object and the target data object can be bound to generate an RPA synchronization script based on a preset data synchronization rule, and the RPA synchronization script can be deployed to implement data synchronization subsequently, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and reducing the development cost without changing the underlying data systems.

[0129] As an optional embodiment, the source data object or the target data object is a database data object, an API synchronization data template, or a table data object.

[0130] It can be seen that through the above optional embodiment, the type of the data object is specified, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and reducing the development cost without changing the underlying data systems.

[0131] As an optional embodiment, the specific manner in which the deployment module binds the source data object and the target data object based on the data synchronization rule of each data system to generate the RPA synchronization script includes:

[0132] generate the automatic data filling operation corresponding to each data system based on the data filling process corresponding to each data system;

[0133] bind the source data object and the target data object, and generate an RPA synchronization script based on the automatic data filling operation.

[0134] As can be seen, through the above optional embodiments, the corresponding automatic data filling operation can be generated based on the data filling process corresponding to each data system, to generate an accurate and reasonable RPA synchronization script, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the underlying data system, reducing development costs.

[0135] As an optional embodiment, the deployment module generates the automatic data filling operation corresponding to each data system based on the data filling process corresponding to each data system in the following specific manner:

[0136] obtain the guidance file of the data filling process corresponding to each data system;

[0137] determine the data filling operation text corresponding to each data system based on a preset keyword matching rule according to the guidance file;

[0138] input the data filling operation text into a trained code generation algorithm model to obtain the automatic filling code corresponding to each data system as the automatic data filling operation corresponding to the data system.

[0139] As can be seen, through the above optional embodiments, the data filling operation text corresponding to the data system is determined based on the keyword matching rule, and the automatic filling code corresponding to the data system is generated based on the code generation algorithm model, which is used for the generation of the synchronization script, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the underlying data system, reducing development costs.

[0140] As an optional embodiment, the synchronization mode of the RPA synchronization script is an API synchronization mode or a database synchronization mode.

[0141] As can be seen, through the above optional embodiments, the type of the synchronization mode of the RPA synchronization script is determined, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the underlying data system, reducing development costs.

[0142] As an optional embodiment, the determination module determines the at least two data systems that need to be synchronized in the following specific manner:

[0143] obtain data transmission records of a plurality of candidate data systems;

[0144] calculate a synchronization rate parameter between data transmission records of any two candidate data systems;

[0145] calculate an average value of all synchronization rate parameters corresponding to each candidate data system, to obtain a synchronization necessity parameter of each candidate data system;

[0146] determine all candidate data systems with a synchronization necessity parameter greater than a parameter threshold value as data systems that need to be synchronized.

[0147] It can be seen that through the above optional embodiments, the data transmission records of the candidate data systems can be calculated to obtain the synchronization necessity parameter of the candidate data systems, so as to accurately screen the data systems that need to be synchronized, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the bottom layer of the data system, reducing the research and development cost.

[0148] As an optional embodiment, the synchronization rate parameter is obtained by calculating the number of data records with the same data content and the time difference between upload times being less than a time threshold value in any two data transmission records.

[0149] It can be seen that through the above optional embodiments, the calculation rule of the synchronization rate parameter is defined, which is used for subsequent calculation of the synchronization necessity parameter, so as to accurately screen the data systems that need to be synchronized, thereby assisting in improving the accuracy and efficiency of data synchronization, reducing errors in data synchronization, and without changing the bottom layer of the data system, reducing the research and development cost.

[0150] Embodiment three

[0151] Please refer to Figure 3 , Figure 3 is another data synchronization system based on RPA robot disclosed by the embodiments of the present application. Figure 3 The described data synchronization system based on RPA robot is applied in a data processing system / data processing device / data processing server (wherein the server includes a local processing server or a cloud processing server). As shown in Figure 3 The data synchronization system based on RPA robot can include:

[0152] a memory 301 storing executable program codes;

[0153] a processor 302 coupled with the memory 301;

[0154] The processor 302 calls the executable program codes stored in the memory 301, which is used to execute the steps of the data synchronization method based on RPA robot described in embodiment one.

[0155] Embodiment four

[0156] The embodiment of the application discloses a computer readable storage medium which stores a computer program for electronic data exchange, wherein the computer program causes a computer to execute the steps of the data synchronization method based on the RPA robot described in embodiment one.

[0157] Embodiment five

[0158] The embodiment of the application discloses a computer program product, which comprises a non-transitory computer readable storage medium storing a computer program, and the computer program is operable to cause a computer to execute the steps of the data synchronization method based on the RPA robot described in embodiment one.

[0159] The above describes specific embodiments of the present specification, and other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims can be performed in an order different than the order in the embodiments and still achieve the desired result. In addition, the processes depicted in the figures do not necessarily have to be performed in the specific order shown and / or sequentially. In some embodiments, multitasking and parallel processing can be advantageous or possible.

[0160] The systems, apparatuses, modules or units illustrated by the above embodiments can be specifically implemented by a computer chip or entity, or by a product with certain functions. A typical implementation device is a computer. Specifically, the computer may, for example, be a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.

[0161] For the convenience of description, the above apparatus is described as various units respectively by functions. Of course, the functions of each unit can be implemented in the same or multiple software and / or hardware in the implementation of the present specification.

[0162] Those skilled in the art will understand that the embodiments of the present specification can be provided as a method, a system, or a computer program product. Therefore, the embodiments of the present specification can take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Moreover, the embodiments of the present specification can take the form of a computer program product implemented on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0163] The specification is presented with reference to flow diagrams and / or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the specification. It will be understood that each block of the flow diagrams and / or block diagrams, and combinations of blocks in the flow diagrams and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general purpose computer, special purpose computer, embedded processing element or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flow diagrams and / or block diagrams block or blocks. Figure 1 The flow diagrams and / or block diagrams in the specification can present a method, apparatus or computer program product according to embodiments of the specification. Flow diagrams and / or block diagrams can also present a method, apparatus or computer program product to achieve functions specified in flow diagrams and / or block diagrams block or blocks. Figure 1 The flow diagrams and / or block diagrams in the specification can present a method, apparatus or computer program product according to embodiments of the specification. Flow diagrams and / or block diagrams can also present a method, apparatus or computer program product to achieve functions specified in flow diagrams and / or block diagrams block or blocks.

[0164] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instructions which implement the flow diagrams and / or block diagrams block or blocks. Figure 1 The flow diagrams and / or block diagrams in the specification can present a method, apparatus or computer program product according to embodiments of the specification. Flow diagrams and / or block diagrams can also present a method, apparatus or computer program product to achieve functions specified in flow diagrams and / or block diagrams block or blocks. Figure 1 The flow diagrams and / or block diagrams in the specification can present a method, apparatus or computer program product according to embodiments of the specification. Flow diagrams and / or block diagrams can also present a method, apparatus or computer program product to achieve functions specified in flow diagrams and / or block diagrams block or blocks.

[0165] These computer program instructions can also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the flow diagrams and / or block diagrams block or blocks. Figure 1 The flow diagrams and / or block diagrams in the specification can present a method, apparatus or computer program product according to embodiments of the specification. Flow diagrams and / or block diagrams can also present a method, apparatus or computer program product to achieve functions specified in flow diagrams and / or block diagrams block or blocks. Figure 1 The flow diagrams and / or block diagrams in the specification can present a method, apparatus or computer program product according to embodiments of the specification. Flow diagrams and / or block diagrams can also present a method, apparatus or computer program product to achieve functions specified in flow diagrams and / or block diagrams block or blocks.

[0166] In a typical configuration, a computing device includes one or more processors (CPUs), input / output interfaces, network interfaces, and memory.

[0167] The memory can include non-persistent memory and / or persistent memory, such as flash memory, read-only memory (ROM), and / or volatile or non-volatile random access memory (RAM), among others. The memory is an example of computer-readable media.

[0168] Computer-readable media includes permanent and non-permanent, movable and non-movable media that can be implemented by any method or technology to store information. The information can be computer-readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassette, magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information accessible by a computing device. According to the definition herein, computer-readable media does not include transitory media such as modulated data signals and carriers.

[0169] It should also be noted that the terms "comprising", "containing", or any other variant thereof are intended to encompass non-exclusive inclusion, such that processes, methods, articles or devices that comprise a list of elements not only include those elements, but also include other elements not expressly listed or inherent to such processes, methods, articles or devices. Without more limitations, the element defined by the statement "comprising a" does not exclude the presence of additional identical elements in the process, method, article or device comprising the element.

[0170] The specification can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. The specification can also be practiced in a distributed computing environment, in which tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media, including storage devices.

[0171] Each embodiment in the specification is described in a progressive manner, and the same or similar parts between each embodiment can be referred to each other, and each embodiment focuses on the difference from other embodiments. In particular, for system embodiments, since they are basically similar to method embodiments, the description is relatively simple, and the relevant parts can be referred to the part of the method embodiment.

[0172] Finally, it should be noted that: the data synchronization method and system based on the RPA robot disclosed in the embodiments of the present application are only the preferred embodiments of the present application, and are only used to illustrate the technical solutions of the present application, but not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand; the technical solutions recorded in the foregoing embodiments can still be modified, or some technical features can be replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A data synchronization method based on RPA robot, characterized in that: The method comprises: Identify at least two data systems that need to be synchronized, including: Obtain data transmission records of multiple candidate data systems; Calculating a synchronization rate parameter between data transmission records of any two candidate data systems; the synchronization rate parameter is obtained by calculating the proportion of data records with the same data content in any two data transmission records and a time difference between upload times less than a time threshold; Calculating an average value of all the synchronization rate parameters corresponding to each of the candidate data systems to obtain a synchronization necessity parameter for each of the candidate data systems; Determine all the candidate data systems whose synchronization necessity parameters are greater than a parameter threshold as data systems that need to be synchronized; Deploy synchronization scripts between the data systems based on RPA technology and the data synchronization rules of the data systems, including: determining a source data object and a target data object in each of said data systems; Obtain guidance documents on the data reporting process corresponding to each of the aforementioned data systems; According to the guidance document, based on preset keyword matching rules, determine the data filling operation text corresponding to each of the data systems; Inputting the data reporting operation text into a trained code generation algorithm model to obtain an automatic reporting code corresponding to each data system as the automatic data reporting operation corresponding to the data system; Binding the source data object and the target data object, and generating an RPA synchronization script based on the automated data reporting operation; Deploy the RPA synchronization script in each of the data systems and the target data reporting port for filling in the source data object; When there is input data in the target data reporting port, obtaining the input data; Execute the synchronization script to synchronize the input data to all the data systems.

2. The data synchronization method based on RPA robot according to claim 1 is characterized in that: The source data object or the target data object is a database data object, an API synchronization data template or a table data object.

3. The data synchronization method based on RPA robot according to claim 1 is characterized in that: The synchronization mode of the RPA synchronization script is API synchronization mode or database synchronization mode.

4. A data synchronization system based on RPA robots, characterized in that: The system comprises: A determination module, configured to determine at least two data systems that need to be synchronized, includes: Obtain data transmission records of multiple candidate data systems; Calculating a synchronization rate parameter between data transmission records of any two candidate data systems; the synchronization rate parameter is obtained by calculating the proportion of data records with the same data content in any two data transmission records and a time difference between upload times less than a time threshold; Calculating an average value of all the synchronization rate parameters corresponding to each of the candidate data systems to obtain a synchronization necessity parameter for each of the candidate data systems; Determine all the candidate data systems whose synchronization necessity parameters are greater than a parameter threshold as data systems that need to be synchronized; A deployment module is used to deploy synchronization scripts between the data systems based on RPA technology and the data synchronization rules of the data systems, including: determining a source data object and a target data object in each of said data systems; Obtain guidance documents on the data reporting process corresponding to each of the aforementioned data systems; According to the guidance document, based on preset keyword matching rules, determine the data filling operation text corresponding to each of the data systems; Inputting the data reporting operation text into a trained code generation algorithm model to obtain an automatic reporting code corresponding to each data system as the automatic data reporting operation corresponding to the data system; Binding the source data object and the target data object, and generating an RPA synchronization script based on the automated data reporting operation; Deploy the RPA synchronization script in each of the data systems and the target data reporting port for filling in the source data object; An acquisition module, configured to acquire input data when input data exists in the target data reporting port; The synchronization module is used to execute the synchronization script to synchronize the input data to all the data systems.

5. A data synchronization system based on RPA robots, characterized in that: The system comprises: a memory storing executable program code; a processor coupled to the memory; The processor calls the executable program code stored in the memory to execute the data synchronization method based on the RPA robot according to any one of claims 1 to 3.

Images