Customer relationship management system data synchronization method, system, device and storage medium

By monitoring the differences between the CRM system and internal data from the enterprise, generating incremental tables and automatically supplementing missing data, the problem of data import in CRM system is solved, reducing maintenance costs and improving data real-time and integrity.

CN114416882BActive Publication Date: 2024-11-05CTRIP BUSINESS TRAVEL INFORMATION SERVICE (SHANGHAI) CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202210093111.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-01-26
Publication Date
2024-11-05
Estimated Expiration
2042-01-26

AI Technical Summary

Technical Problem

When corporate users use CRM systems, due to problems such as SAP interface and API timeout, customer information is not fully imported or updated, resulting in missing data, affecting customer satisfaction and maintenance costs.

Method used

By monitoring the differences between the customer relationship management system and internal data of the enterprise, using data warehouses and tools such as Hive and MySQL to generate incremental tables and automatically supplement missing data in the CRM system to ensure data integrity and real-timeness.

Benefits of technology

It realizes timely completion of data in the customer relationship management system, reduces maintenance costs and development workload, improves data real-time and integrity, and makes use more flexible.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114416882B_ABST
    Figure CN114416882B_ABST
Patent Text Reader

Abstract

The present invention provides a method, system, device and storage medium for synchronizing customer relationship management system data, the method comprising: synchronizing enterprise internal customer data and customer relationship management system data to a data warehouse; extracting first data and second data of a specified field from the enterprise internal customer data and the customer relationship management system respectively; performing offline comparison on the first data and the second data to generate an incremental table to be added to the customer relationship management system; and transmitting the data of the incremental table to the customer relationship management system. The present invention monitors the difference between the data in the customer relationship management system and the enterprise internal customer data, timely completes the data in the customer relationship management system, maintains the integrity and real-time performance of the data in the customer relationship management system, reduces the development and workload and maintenance costs of the customer relationship management system, and is more flexible in use.
Need to check novelty before this filing date? Find Prior Art

Description

Background Art

[0002] When enterprise users use the CRM (Custom Relationship Management) system, due to problems such as SAP (System Applications and Products) interface and API (Application Programming Interface) timeout, customer information is not fully imported or updated into the CRM system. Users lose the service matching relationship with customers, are unable to respond to customer requests in a timely manner, reduce customer satisfaction, and even affect subsequent long-term cooperation.

[0003] With the rapid development of business, when CRM system administrators find data missing problems, they need to spend a lot of time to manually repair them, and the maintenance cost is very high, so they create automated processes to deal with this situation. Summary of the invention

[0004] In view of the problems in the prior art, the purpose of the present invention is to provide a customer relationship management system data synchronization method, system, device and storage medium, which can timely supplement the data in the customer relationship management system by monitoring the differences between the data in the customer relationship management system and the internal customer data of the enterprise, so as to maintain the integrity and real-time nature of the data in the customer relationship management system.

[0005] An embodiment of the present invention provides a method for synchronizing customer relationship management system data, comprising the following steps:

[0006] Synchronize the internal customer data and customer relationship management system data to the data warehouse;

[0007] Extracting first data and second data of designated fields from the internal customer data of the enterprise and the customer relationship management system respectively;

[0008] Comparing the first data and the second data offline to generate an incremental table to be added to the customer relationship management system;

[0009] The data of the incremental table is transmitted to the customer relationship management system.

[0010] In some embodiments, performing an offline comparison on the first data and the second data to generate an incremental table to be added to the customer relationship management system comprises the following steps:

[0011] Compare the first data and the second data offline, and generate a comparison table in Hive;

[0012] The missing data in the customer relationship management system is extracted according to the comparison table, and an incremental table that needs to be added to the customer relationship management system is generated in Hive.

[0013] In some embodiments, extracting missing data in the customer relationship management system according to the comparison table and generating an incremental table to be added to the customer relationship management system in Hive includes the following steps:

[0014] According to the comparison table, the data of the fields at each level missing in the customer relationship management system are respectively extracted, and m incremental tables that need to be added to the customer relationship management system are generated in Hive, where m is the number of field levels.

[0015] In some embodiments, m is 2, the first level fields include a customer number field, and the second level fields include an account manager and / or project manager field;

[0016] Extracting data of each level field missing in the customer relationship management system according to the comparison table, and generating m incremental tables to be added to the customer relationship management system in Hive, including the following steps:

[0017] Generate a first incremental table in Hive according to the data comparison result of the customer number field in the comparison table;

[0018] A second incremental table is generated in Hive according to the data comparison result of the customer manager and / or project manager fields in the comparison table.

[0019] In some embodiments, transmitting the data of the incremental table to the customer relationship management system comprises the following steps:

[0020] Transferring the m incremental tables to a MySQL database;

[0021] Create m data transmission tables corresponding to the m incremental tables respectively in the MySQL database;

[0022] The data in the m data transmission tables in the MySQL database are transmitted to the customer relationship management system.

[0023] In some embodiments, a SOA interface is used to transfer the data in the m data transfer tables in the MySQL database to the customer relationship management system.

[0024] In some embodiments, performing an offline comparison on the first data and the second data and generating a comparison table in Hive includes the following steps:

[0025] Establishing a comparison table in the data warehouse, wherein the comparison table includes 2n fields, where n is the number of fields of the first data;

[0026] The first data and the second data are filled into the comparison table, wherein the odd columns in the comparison table are data corresponding to each field in the first data, and the even columns are data corresponding to each field in the second data, and the fields in each even column are the same as the fields in the previous odd column.

[0027] In some embodiments, extracting missing data in the customer relationship management system according to the comparison table and generating an incremental table to be added to the customer relationship management system in Hive includes the following steps:

[0028] Establishing at least one incremental table in the data warehouse;

[0029] Determine whether all the data in the odd-numbered column of the comparison table are contained in the next even-numbered column and whether the data in the same row of the odd-numbered column and the next even-numbered column are the same;

[0030] If there is data that is not included in the next even-numbered column or data in the same row of an odd-numbered column and the next even-numbered column that are different, the data is determined as missing data in the customer relationship management system;

[0031] A row of data missing from the customer relationship management system is extracted from the comparison table and added to the incremental table.

[0032] In some embodiments, SPARK is used to compare the first data and the second data, a comparison table is generated in Hive, and an incremental table that needs to be added to the customer relationship management system is generated in Hive based on the comparison table.

[0033] The embodiment of the present invention further provides a customer relationship management system data synchronization system, which is used in the customer relationship management system data synchronization method, and the system includes:

[0034] Data synchronization module, used to synchronize the internal customer data of the enterprise and the customer relationship management system data to the data warehouse;

[0035] A data extraction module, used to extract first data and second data of a specified field from the internal customer data of the enterprise and the customer relationship management system respectively;

[0036] An incremental table generating module, used for performing an offline comparison between the first data and the second data, and generating an incremental table to be added to the customer relationship management system;

[0037] A data transmission module is used to transmit the data of the incremental table to the customer relationship management system.

[0038] The embodiment of the present invention also provides a customer relationship management system data synchronization device, including:

[0039] processor;

[0040] a memory storing executable instructions of the processor;

[0041] Wherein, the processor is configured to perform the steps of the customer relationship management system data synchronization method by executing the executable instructions.

[0042] The embodiment of the present invention further provides a computer-readable storage medium for storing a program, wherein the program, when executed by a processor, implements the steps of the customer relationship management system data synchronization method.

[0043] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure.

[0044] The customer relationship management system data synchronization method, system, device and storage medium of the present invention have the following beneficial effects:

[0045] In the customer relationship management system data synchronization method of the present invention, firstly, the data to be compared of the specified fields are extracted from the customer relationship management system and the internal customer data of the enterprise respectively, and then the difference between the data in the customer relationship management system and the internal customer data of the enterprise is monitored, and an incremental table to be added to the customer relationship management system is generated, and the data is supplemented to the customer relationship management system, thereby achieving timely completion of the data in the customer relationship management system, maintaining the integrity and real-time nature of the data in the customer relationship management system, reducing the development and workload and maintenance costs of the customer relationship management system, and making the usage more flexible. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] Other features, objectives and advantages of the present invention will become more apparent from a reading of the detailed description of non-limiting embodiments made with reference to the following accompanying drawings.

[0047] Figure 1 is a flow chart of a method for synchronizing customer relationship management system data according to an embodiment of the present invention;

[0048] Figure 2 is a flow chart of generating an incremental table to be added to the customer relationship management system according to an embodiment of the present invention;

[0049] Figure 3 is a schematic diagram of a data processing process according to an embodiment of the present invention;

[0050] Figure 4 It is a structural diagram of a customer relationship management system data synchronization system according to an embodiment of the present invention;

[0051] Figure 5 It is a structural diagram of a data synchronization device for a customer relationship management system according to an embodiment of the present invention;

[0052] Figure 6 It is a schematic diagram of the structure of a computer-readable storage medium according to an embodiment of the present invention. DETAILED DESCRIPTION

[0053] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in a variety of forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that the disclosure will be more comprehensive and complete and to fully convey the concepts of the example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

[0054] In addition, the accompanying drawings are only schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the figures represent the same or similar parts, and their repeated description will be omitted. Some of the block diagrams shown in the accompanying drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities can be implemented in software form, or implemented in one or more hardware modules or integrated circuits, or implemented in different networks and / or processor devices and / or microcontroller devices.

[0055] The flowcharts shown in the accompanying drawings are only exemplary and do not necessarily include all the steps. For example, some steps may be decomposed, while some steps may be combined or partially combined. Therefore, the actual execution order may be changed according to the actual situation.

[0056] like Figure 1 As shown, an embodiment of the present invention provides a customer relationship management system data synchronization method, comprising the following steps:

[0057] S100: Synchronizing the internal customer data of the enterprise and the customer relationship management system data to the data warehouse. In this embodiment, the internal customer data of the enterprise may be the internal customer information data and business data of the enterprise, for example, which may be obtained from the internal customer information maintenance system of the enterprise;

[0058] S200: extracting first data and second data of designated fields from the internal customer data of the enterprise and the customer relationship management system respectively;

[0059] S300: performing an offline comparison on the first data and the second data to generate an incremental table to be added to the customer relationship management system;

[0060] S400: Transmitting the data of the incremental table to the customer relationship management system.

[0061] In the customer relationship management system data synchronization method of the present invention, firstly, through steps S100 and S200, the data to be compared of the specified fields are extracted from the customer relationship management system and the internal customer data of the enterprise respectively, and then through step S300, the difference between the data in the customer relationship management system and the internal customer data of the enterprise is monitored, and an incremental table to be added to the customer relationship management system is generated, and the data is supplemented to the customer relationship management system through step S400, so as to realize timely completion of the data in the customer relationship management system, maintain the integrity and real-time of the data in the customer relationship management system, reduce the development and workload and maintenance costs of the customer relationship management system, and make the usage more flexible.

[0062] In this embodiment, the designated field may include, for example, at least one field such as customer number, company name, customer manager, project manager, etc. The step S200: extracting first data and second data of the designated field from the internal customer data of the enterprise and the customer relationship management system, respectively, includes:

[0063] Extracting data in fields such as customer number, company name, customer manager, project manager, etc. from the internal customer data of the enterprise as first data; and

[0064] Data in fields such as customer number, company name, account manager, project manager, etc. are extracted from the customer relationship management system as second data.

[0065] like Figure 2 As shown, the step S300: performing offline comparison on the first data and the second data to generate an incremental table to be added to the customer relationship management system includes the following steps;

[0066] S310: performing offline comparison on the first data and the second data, and generating a comparison table in Hive;

[0067] S320: Extract missing data in the customer relationship management system according to the comparison table, and generate an incremental table that needs to be added to the customer relationship management system in Hive.

[0068] In this embodiment, the step S310: performing offline comparison on the first data and the second data and generating a comparison table in Hive includes the following steps:

[0069] Establishing a comparison table in the data warehouse, wherein the comparison table includes 2n fields, where n is the number of fields of the first data;

[0070] Fill the first data and the second data into the comparison table, wherein the odd-numbered columns in the comparison table are the data corresponding to each field in the first data, and the even-numbered columns are the data corresponding to each field in the second data, and the fields in each even-numbered column are the same as the fields in the previous odd-numbered column. An example comparison table is given in the following table. Among them, the fields in the odd-numbered columns in the comparison table: customer number_module, company name_module, account manager id_module, project manager id_module are the fields in the first data, and the fields in the even-numbered columns: customer number_crm, company name_crm, account manager id_crm, project manager id_crm are the fields in the second data.

[0071] Comparison Table

[0072]

[0073] By comparing the fields of two adjacent columns in the above comparison table, the missing data in the customer relationship management system can be determined.

[0074] In this embodiment, the step S320: extracting the missing data in the customer relationship management system according to the comparison table, and generating an incremental table to be added to the customer relationship management system in Hive, includes the following steps:

[0075] Establishing at least one incremental table in the data warehouse;

[0076] Determine whether all the data in the odd-numbered column of the comparison table are contained in the next even-numbered column and whether the data in the same row of the odd-numbered column and the next even-numbered column are the same;

[0077] If there is data that is not included in the next even-numbered column or data in the same row of an odd-numbered column and the next even-numbered column that are different, the data is determined as missing data in the customer relationship management system;

[0078] A row of data missing from the customer relationship management system is extracted from the comparison table and added to the incremental table.

[0079] Furthermore, multiple fields can be graded and divided into multiple levels of fields. The level classification standard of the field can be based on the importance of the field or the relationship between the upper and lower levels of the fields. In this embodiment, the step S320: extracting the missing data in the customer relationship management system according to the comparison table, and generating an incremental table in Hive that needs to be added to the customer relationship management system, includes the following steps:

[0080] According to the comparison table, the data of the fields at each level missing in the customer relationship management system are respectively extracted, and m incremental tables that need to be added to the customer relationship management system are generated in Hive, where m is the number of field levels.

[0081] In this embodiment, m is 2 for illustration, that is, each field is divided into two levels, the first level field includes the customer number field, and the second level field includes the account manager and / or project manager field. According to the comparison table, the data of each level field missing in the customer relationship management system is extracted respectively, and m incremental tables that need to be added to the customer relationship management system are generated in Hive, including the following steps:

[0082] Generate a first incremental table in Hive according to the data comparison result of the customer number field in the comparison table;

[0083] A second incremental table is generated in Hive according to the data comparison result of the customer manager and / or project manager fields in the comparison table.

[0084] like Figure 3 The data processing process of a specific embodiment is shown in FIG. 1 , wherein the internal customer data of the enterprise is obtained from the internal customer data maintenance module of the enterprise, and the customer relationship management system data is directly obtained from the CRM system.

[0085] After the first data and the second data are extracted in step S200, a company information table and a CRM system information table are obtained respectively, wherein the company information table stores the first data and the CRM system information table stores the second data. Then, SPARK is used to compare the first data and the second data, and a comparison table is generated in Hive, namely, the company information + CRM system information table.

[0086] And based on the comparison table, generate the incremental table that needs to be added to the customer relationship management system in Hive. Specifically, the first incremental table is generated as the CRM company missing table, and the second incremental table is generated as the CRM account manager / project manager missing table. Specifically, perform offline hive T+1 operations on the data in the above comparison table, obtain the data of the CRM system that is missing the company number or the entire information such as the company information and account manager, and create and insert the data into the following first incremental table. T refers to the current day, and T+1 refers to the synchronization of the current day's data to the CRM system the next day.

[0087] First increment table

[0088]

[0089]

[0090] Perform offline operations on the data in the above comparison table to obtain information about inconsistent or missing account managers / project managers in the CRM system without losing the company number, and create and insert the data into the following second incremental table.

[0091] Second increment table

[0092]

[0093] In this embodiment, the step S400: transmitting the data of the incremental table to the customer relationship management system includes the following steps:

[0094] The m incremental tables are transmitted to the MySQL database. In this embodiment, the first incremental table and the second incremental table are transmitted to the MySQL database.

[0095] In the MySQL database, m data transmission tables corresponding to the m incremental tables are created, that is, a first data transmission table and a second data transmission table are generated in the MySQL database. Figure 3 For example, generate a missing table of CRM system companies and account managers / project managers in the MySQL database;

[0096] The data in the m data transmission tables in the MySQL database are transmitted to the customer relationship management system.

[0097] Specifically, in this embodiment, a SOA (Service-Oriented Architecture) interface is used to transfer the data in each data transfer table in the MySQL database to the customer relationship management system, thereby completing the data in the customer relationship management system and maintaining the consistency of the data in the customer relationship management system and the internal customer information maintenance module of the enterprise.

[0098] The following specifically introduces a method of performing hive T+1 offline data operations on the data of the CRM system and the internal customer information maintenance module of the enterprise, generating an incremental table including the data missing or different from the CRM system according to logic, and transmitting it to the CRM system through the SOA interface.

[0099] Specific implementation plan:

[0100] 1. First, the hive T+1 offline data of the CRM system and the internal customer data maintenance module of the enterprise is associated with the data table in the CRM system through the account manager ID and project manager ID. After offline calculation, the missing and different data of the CRM system and the internal customer data maintenance module of the enterprise are extracted and inserted into the incremental table;

[0101] 2. Transfer the data in the incremental table to the CRM system through the SOA interface.

[0102] The specific SQL (Structured Query Language) implementation is as follows:

[0103] (1) The CRM system customer number is missing:

[0104] select a.a_s--Customer Number_Management System

[0105] ,b.a_crm--customer number_crm

[0106] ,a.b_s--Company Name_Management System

[0107] ,b.b_crm--company name_crm

[0108] ,a.c_s--Customer Manager ID_Management System

[0109] ,c.c_crm--account manager id_crm

[0110] ,a.d_s--Project Manager ID_Management System

[0111] ,c.d_crm--project manager id_crm

[0112] from corp_table a

[0113] left join crm_table b on a.id=b.id

[0114] left join crm_s_table c on b.id=c.id

[0115] where coalesce(b.a_crm,”)="

[0116] (2) The account manager or project manager in the CRM system is inconsistent with the internal customer data maintenance module of the enterprise:

[0117] select a.a_s--Customer Number_Management System

[0118] ,b.a_crm--customer number_crm

[0119] ,a.b_s--Company Name_Management System

[0120] ,b.b_crm--company name_crm

[0121] ,a.c_s--Customer Manager ID_Management System

[0122] ,c.c_crm--account manager id_crm

[0123] ,a.d_s--Project Manager ID_Management System

[0124] ,c.d_crm--project manager id_crm

[0125] from corp_table a

[0126] left join crm_table b on a.id=b.id

[0127] left join crm_s_table c on b.id=c.id

[0128] where coalesce(b.a_crm,")<>"

[0129] and(coalesce(a.c_s,”)<>coalesce(c.c_crm,”)

[0130] or coalesce(a.d_s,”)<>coalesce(c.d_crm,”))

[0131] like Figure 4 As shown, an embodiment of the present invention further provides a customer relationship management system data synchronization system, which is used in the customer relationship management system data synchronization method, and the system includes:

[0132] The data synchronization module M100 is used to synchronize the internal customer data of the enterprise and the customer relationship management system data to the data warehouse. The internal customer data of the enterprise may be the internal customer information data and business data of the enterprise, for example, which may be obtained from the internal customer information maintenance system of the enterprise;

[0133] A data extraction module M200 is used to extract first data and second data of a specified field from the internal customer data of the enterprise and the customer relationship management system respectively. In this embodiment, the specified field may include at least one field such as customer number, company name, account manager, project manager, etc.;

[0134] An incremental table generation module M300, used to compare the first data and the second data offline, and generate an incremental table in Hive that needs to be added to the customer relationship management system;

[0135] The data transmission module M400 is used to transmit the data of the incremental table to the customer relationship management system.

[0136] In the customer relationship management system data synchronization system of the present invention, firstly, the data synchronization module M100 and the data extraction module M200 are used to extract the data to be compared of the specified fields from the customer relationship management system and the internal customer data of the enterprise respectively, and then the incremental table generation module M300 is used to monitor the difference between the data in the customer relationship management system and the internal customer data of the enterprise, and generate the incremental table to be added to the customer relationship management system, and the data is supplemented to the customer relationship management system through the data transmission module M400, so as to realize timely completion of the data in the customer relationship management system, maintain the integrity and real-time of the data in the customer relationship management system, reduce the development and workload and maintenance cost of the customer relationship management system, and make the usage more flexible.

[0137] In this embodiment, the data extraction module M200 extracts the first data and the second data of the specified fields from the internal enterprise customer data and the customer relationship management system respectively, including: extracting data of fields such as customer number, company name, account manager, project manager, etc. from the internal enterprise customer data as the first data; and extracting data of fields such as customer number, company name, account manager, project manager, etc. from the customer relationship management system as the second data.

[0138] In this embodiment, the incremental table generation module M300 performs an offline comparison on the first data and the second data, and generates an incremental table in Hive that needs to be added to the customer relationship management system, including: performing an offline comparison on the first data and the second data, and generating a comparison table in Hive; extracting missing data in the customer relationship management system according to the comparison table, and generating an incremental table in Hive that needs to be added to the customer relationship management system.

[0139] In this embodiment, the data transmission module M400 transmits the data of the incremental table to the customer relationship management system, including: transmitting the m incremental tables to the MySQL database, in this embodiment, the first incremental table and the second incremental table are transmitted to the MySQL database; creating m data transmission tables corresponding to the m incremental tables respectively in the MySQL database, that is, generating the first data transmission table and the second data transmission table in the MySQL database; transmitting the data in the m data transmission tables in the MySQL database to the customer relationship management system.

[0140] An embodiment of the present invention also provides a customer relationship management system data synchronization device, comprising a processor; a memory, in which executable instructions of the processor are stored; wherein the processor is configured to execute the steps of the customer relationship management system data synchronization method by executing the executable instructions.

[0141] It will be appreciated by those skilled in the art that various aspects of the present invention may be implemented as systems, methods or program products. Therefore, various aspects of the present invention may be specifically implemented in the following forms, namely: complete hardware implementation, complete software implementation (including firmware, microcode, etc.), or a combination of hardware and software implementations, which may be collectively referred to herein as "circuits", "modules" or "platforms".

[0142] Refer to the following Figure 5 The electronic device 600 according to this embodiment of the present invention is described. Figure 5 The electronic device 600 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0143] like Figure 5 As shown, the electronic device 600 is in the form of a general computing device. The components of the electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one storage unit 620, a bus 630 connecting different system components (including the storage unit 620 and the processing unit 610), a display unit 640, etc.

[0144] The storage unit stores program codes, which can be executed by the processing unit 610, so that the processing unit 610 executes the steps of various exemplary embodiments of the present invention described in the customer relationship management system data synchronization method section of this specification. For example, the processing unit 610 can execute the following steps: Figure 1 Follow the steps shown in .

[0145] The storage unit 620 may include a readable medium in the form of a volatile storage unit, such as a random access memory unit (RAM) 6201 and / or a cache memory unit 6202 , and may further include a read-only memory unit (ROM) 6203 .

[0146] The storage unit 620 may also include a program / utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including but not limited to: an operating system, one or more application programs, other program modules and program data, each of which or some combination may include the implementation of a network environment.

[0147] Bus 630 may represent one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.

[0148] The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboards, pointing devices, Bluetooth devices, etc.), may also communicate with one or more devices that enable a user to interact with the electronic device 600, and / or communicate with any device that enables the electronic device 600 to communicate with one or more other computing devices (e.g., routers, modems, etc.). Such communication may be performed via an input / output (I / O) interface 650. Furthermore, the electronic device 600 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 660. The network adapter 660 may communicate with other modules of the electronic device 600 via a bus 630. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0149] In the customer relationship management system data synchronization device, the program in the memory implements the steps of the customer relationship management system data synchronization method when executed by the processor. Therefore, the device can also obtain the technical effect of the customer relationship management system data synchronization method.

[0150] The embodiment of the present invention further provides a computer-readable storage medium for storing a program, wherein when the program is executed by a processor, the steps of the customer relationship management system data synchronization method are implemented. In some possible implementations, various aspects of the present invention may also be implemented in the form of a program product, which includes a program code, and when the program product is executed on a terminal device, the program code is used to enable the terminal device to execute the steps of various exemplary implementations of the present invention described in the customer relationship management system data synchronization method section of the present specification.

[0151] refer to Figure 6 As shown, a program product 800 for implementing the above method according to an embodiment of the present invention is described, which can adopt a portable compact disk read-only memory (CD-ROM) and include program code, and can be executed on a terminal device, such as a personal computer. However, the program product of the present invention is not limited thereto. In this document, a readable storage medium can be any tangible medium containing or storing a program, which can be used by or in combination with an instruction execution system, an apparatus or a device.

[0152] The program product may use any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples (non-exhaustive list) of readable storage media include: an electrical connection with one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0153] The computer readable storage medium may include a data signal propagated in a baseband or as part of a carrier wave, wherein a readable program code is carried. This propagated data signal may take a variety of forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. The readable storage medium may also be any readable medium other than a readable storage medium, which may send, propagate, or transmit a program for use by an instruction execution system, an apparatus, or a device or used in combination with it. The program code contained on the readable storage medium may be transmitted with any appropriate medium, including but not limited to wireless, wired, optical cable, RF, etc., or any suitable combination of the above.

[0154] Program code for performing the operations of the present invention may be written in any combination of one or more programming languages, including object-oriented programming languages ​​such as Java, C++, etc., and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user computing device, partially on the user device, as a separate software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server. In cases involving a remote computing device, the remote computing device may be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (e.g., through the Internet using an Internet service provider).

[0155] When the program in the computer storage medium is executed by the processor, the steps of the customer relationship management system data synchronization method are implemented. Therefore, the computer storage medium can also obtain the technical effect of the customer relationship management system data synchronization method.

[0156] The above contents are further detailed descriptions of the present invention in combination with specific preferred embodiments, and it cannot be determined that the specific implementation of the present invention is limited to these descriptions. For ordinary technicians in the technical field to which the present invention belongs, several simple deductions or substitutions can be made without departing from the concept of the present invention, which should be regarded as falling within the protection scope of the present invention.

Claims

1. A method for synchronizing customer relationship management system data. It is characterized in that The steps include: Synchronize the internal customer data and customer relationship management system data to the data warehouse; Extracting first data and second data of designated fields from the internal customer data of the enterprise and the customer relationship management system respectively; Comparing the first data and the second data offline to generate an incremental table to be added to the customer relationship management system; Transmitting the data of the incremental table to the customer relationship management system; Comparing the first data and the second data offline to generate an incremental table to be added to the customer relationship management system comprises the following steps: Compare the first data and the second data offline, and generate a comparison table in Hive; Extracting missing data in the customer relationship management system according to the comparison table, and generating an incremental table that needs to be added to the customer relationship management system in Hive; Performing an offline comparison on the first data and the second data and generating a comparison table in Hive includes the following steps: Establishing a comparison table in the data warehouse, wherein the comparison table includes 2n fields, where n is the number of fields of the first data; Fill the first data and the second data into the comparison table, wherein the odd-numbered columns in the comparison table are data corresponding to each field in the first data, and the even-numbered columns are data corresponding to each field in the second data, and the field of each even-numbered column is the same as the field of the previous odd-numbered column; Extracting missing data from the customer relationship management system according to the comparison table, and generating an incremental table to be added to the customer relationship management system in Hive, including the following steps: Establishing at least one incremental table in the data warehouse; Determine whether all the data in the odd-numbered column of the comparison table are contained in the next even-numbered column and whether the data in the same row of the odd-numbered column and the next even-numbered column are the same; If there is data that is not included in the next even-numbered column or data in the same row of an odd-numbered column and the next even-numbered column that are different, the data is determined as missing data in the customer relationship management system; A row of data missing from the customer relationship management system is extracted from the comparison table and added to the incremental table.

2. The customer relationship management system data synchronization method according to claim 1, It is characterized in that Extracting missing data from the customer relationship management system according to the comparison table, and generating an incremental table to be added to the customer relationship management system in Hive, including the following steps: According to the comparison table, the data of the fields at each level missing in the customer relationship management system are respectively extracted, and m incremental tables that need to be added to the customer relationship management system are generated in Hive, where m is the number of field levels.

3. The customer relationship management system data synchronization method according to claim 2, It is characterized in that m is 2, the first level fields include the customer number field, and the second level fields include the account manager and / or project manager fields; Extracting data of each level field missing in the customer relationship management system according to the comparison table, and generating m incremental tables to be added to the customer relationship management system in Hive, including the following steps: Generate a first incremental table in Hive according to the data comparison result of the customer number field in the comparison table; A second incremental table is generated in Hive according to the data comparison result of the customer manager and / or project manager fields in the comparison table.

4. The customer relationship management system data synchronization method according to claim 2, It is characterized in that The data of the incremental table is transmitted to the customer relationship management system, comprising the following steps: Transferring the m incremental tables to a MySQL database; Create m data transmission tables corresponding to the m incremental tables respectively in the MySQL database; The data in the m data transmission tables in the MySQL database are transmitted to the customer relationship management system.

5. The customer relationship management system data synchronization method according to claim 4, It is characterized in that The SOA interface is used to transmit the data in the m data transmission tables in the MySQL database to the customer relationship management system.

6. The customer relationship management system data synchronization method according to claim 1, It is characterized in that The first data and the second data are compared by using SPARK, a comparison table is generated in Hive, and an incremental table to be added to the customer relationship management system is generated in Hive according to the comparison table.

7. A customer relationship management system data synchronization system, It is characterized in that A method for synchronizing customer relationship management system data according to any one of claims 1 to 6, the system comprising: Data synchronization module, used to synchronize the internal customer data of the enterprise and the customer relationship management system data to the data warehouse; A data extraction module, used to extract first data and second data of a specified field from the internal customer data of the enterprise and the customer relationship management system respectively; An incremental table generating module, used for performing an offline comparison between the first data and the second data, and generating an incremental table to be added to the customer relationship management system; A data transmission module is used to transmit the data of the incremental table to the customer relationship management system.

8. A customer relationship management system data synchronization device, It is characterized in that include: processor; a memory storing executable instructions of the processor; The processor is configured to execute the steps of the customer relationship management system data synchronization method according to any one of claims 1 to 6 by executing the executable instructions.

9. A computer-readable storage medium for storing a program, It is characterized in that When the program is executed by a processor, the steps of the customer relationship management system data synchronization method according to any one of claims 1 to 6 are implemented.