CN113946629A - Workday data synchronization method and system, electronic device and medium - Google Patents

Workday data synchronization method and system, electronic device and medium Download PDF

Info

Publication number
CN113946629A
CN113946629A CN202111332015.4A CN202111332015A CN113946629A CN 113946629 A CN113946629 A CN 113946629A CN 202111332015 A CN202111332015 A CN 202111332015A CN 113946629 A CN113946629 A CN 113946629A
Authority
CN
China
Prior art keywords
report
workday
tiled
data synchronization
data table
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111332015.4A
Other languages
Chinese (zh)
Inventor
沙斌
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ctrip Travel Network Technology Shanghai Co Ltd
Original Assignee
Ctrip Travel Network Technology Shanghai Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ctrip Travel Network Technology Shanghai Co Ltd filed Critical Ctrip Travel Network Technology Shanghai Co Ltd
Priority to CN202111332015.4A priority Critical patent/CN113946629A/en
Publication of CN113946629A publication Critical patent/CN113946629A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/12—Use of codes for handling textual entities
    • G06F40/14—Tree-structured documents
    • G06F40/146—Coding or compression of tree-structured data

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Computing Systems (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a Workday data synchronization method and system, electronic equipment and a medium, wherein the Workday data synchronization method comprises the following steps: unifying encryption and decryption of the abstract xml file and analysis of the xml element, and mapping the xml element to a mysql data table field by using a configuration file; and packaging the logic usage into a jar packet by using Java, deploying the jar packet to a resource scheduling system, and scheduling by using the resource scheduling system to complete automation of Workday data synchronization. The invention greatly simplifies the process of Workday data synchronization, and through the scheme of the invention, when a Workday data synchronization object is newly added, code development and release are not needed, thereby greatly accelerating the speed of Workday data synchronization and reducing the difficulty of operation, maintenance and troubleshooting.

Description

Workday data synchronization method and system, electronic device and medium
Technical Field
The invention relates to the technical field of data synchronization, in particular to a Workday data synchronization method and system, electronic equipment and a medium.
Background
In the implementation and operation process of Workday (a reporting tool), a large number of basic and business reports need to be output to a downstream system, for example, a job sequence of basic data, a national city, a company, a school, and the like, daily job entry and exit of business data, cross-department movement, job level change, to-be-handled message pushing, and the like.
The traditional method for synchronizing the Workday data is to encrypt and decrypt each output xml (Extensible Markup Language) file, analyze xml elements, create a data table, develop code manual pairs of fields, and run jobs (for describing synchronous operation from a source to a destination) in a synchronous ground database. In the face of each data object, the processes are completely performed, the development, operation, test and maintenance workload is huge, and the operation, maintenance and troubleshooting are difficult.
Disclosure of Invention
The invention provides a method and a system for synchronization of Workday data, electronic equipment and a medium, aiming at overcoming the defect that the method for synchronization of Workday data in the prior art is complex.
The invention solves the technical problems through the following technical scheme:
the invention provides a Workday data synchronization method based on a resource scheduling system, which comprises the following steps:
developing a tiled report at a Workday server side;
transmitting the tiled report to a server appointed directory file in a preset format file form;
creating a data table in mysql (database management system), and storing the data table under a specified database, wherein the field names in the data table correspond to the field names in the tiled report;
establishing a configuration file in a configuration platform, wherein the configuration file is used for configuring the mapping relation between the address of the server, the login account of the server, the name of the specified directory file, the name of the file in the preset format, the name of the specified database, the name of the data table, the field name in the tiled report and the field name in the data table;
deploying a jar package (a File format of Java) of an exclusive component on a resource scheduling system, wherein the jar package is used for mapping fields in the tiled report and fields in the data table, updating the data table and deleting files in the preset format under the specified directory File.
Preferably, the Workday data synchronization method further includes:
and establishing a timing plan task at the Workday server side.
Preferably, the Workday data synchronization method further includes:
and encrypting the tiled report by PGP (Pretty Good Privacy, a set of application programs for message encryption and verification) and then transmitting the encrypted tiled report in an xml format.
Preferably, the jar package is further configured to decrypt the tiled report and parse xml elements in the tiled report.
The invention also provides a Workday data synchronization system based on the resource scheduling system, which comprises:
the report development module is used for developing a tiled report at a Workday server side;
the report transmission module is used for transmitting the tiled report to a server specified directory file in a preset format file form;
the data table creating module is used for creating a data table in mysql, storing the data table in a specified database, and enabling field names in the data table to correspond to field names in the tiled report;
the configuration module is used for establishing a configuration file in a configuration platform, wherein the configuration file is used for configuring the address of the server, the login account of the server, the name of the specified directory file, the name of the file in the preset format, the name of the specified database, the name of the data table, the field name in the tiled report and the mapping relation of the field name in the data table;
and the scheduling module is used for deploying an exclusive component jar package on a resource scheduling system, wherein the jar package is used for mapping fields in the tiled report and fields in the data table, updating the data table and deleting the file in the preset format under the specified directory file.
Preferably, the Workday data synchronization system further comprises:
and the timing module is used for establishing a timing plan task at the Workday server side.
Preferably, the Workday data synchronization system further comprises:
and the encryption module is used for encrypting the tiled report by PGP and then transmitting the encrypted tiled report in an xml format.
Preferably, the jar package is further configured to decrypt the tiled report and parse xml elements in the tiled report.
The invention also provides electronic equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein when the processor executes the computer program, the Workday data synchronization method based on the resource scheduling system is realized.
The invention also provides a computer readable storage medium, on which a computer program is stored, and the computer program is executed by a processor to implement the aforementioned Workday data synchronization method based on the resource scheduling system.
The positive progress effects of the invention are as follows: the method completes the analysis of the xml, the data table and the field mapping through the configuration platform, and schedules the operation plan by virtue of the resource scheduling system, thereby greatly simplifying the process of Workday data synchronization; by the scheme, when a Workday data synchronization object is newly added, code development and release are not needed, the Workday data synchronization speed is greatly increased, and operation, maintenance and troubleshooting difficulties are reduced.
Drawings
Fig. 1 is a flowchart of a Workday data synchronization method based on a resource scheduling system according to embodiment 1 of the present invention.
Fig. 2 is a schematic block diagram of a workbench data synchronization system based on a resource scheduling system according to embodiment 2 of the present invention.
Fig. 3 is a schematic structural diagram of an electronic device according to embodiment 3 of the present invention.
Detailed Description
The invention is further illustrated by the following examples, which are not intended to limit the scope of the invention.
Example 1
The embodiment provides a workbench data synchronization method based on a resource scheduling system, and as shown in fig. 1, the workbench data synchronization method includes the following steps:
and S11, developing a tiled report at the Workday server side.
And S12, establishing a timing plan task at the Workday server side.
S13, encrypting the tiled report by PGP.
And S14, transmitting the tiled report to a server specified directory file in a preset format file form.
In step S14, the preset format may be an xml format, in particular.
Specifically, the server may be an sftp (secure File Transfer Protocol, a network transport Protocol for streaming data, providing File access, Transfer, and management functions) server.
In particular, the attributes of the fields of the tiled report may be redefined, if necessary: column (for setting Column width and Column number), header, Override, XML (providing additional information about elements), Alias, and facilitate the use of simple and easy-to-read field names when mapping is subsequently configured.
S15, creating a data table in mysql, and storing the data table in a specified database, wherein the field names in the data table correspond to the field names in the tiled report.
S16, establishing a configuration file in a configuration platform, wherein the configuration file is used for configuring the mapping relation between the address of the server, the login account of the server, the name of the specified directory file, the name of the file in the preset format, the name of the specified database, the name of the data table, the field name in the tiled report and the field name in the data table.
In step S16, the configuration platform may be qconfig (configuration platform), in particular.
In particular, the configuration file is wd (workbench) jobjson.
Specific addresses, where the configuration items are described as follows:
url (Uniform Resource Locator): the directory location used for determining the sftp server;
type (class): only sftp mediation is supported at present;
table (table): a data table name for writing;
delete: for determining whether to empty the target data table, optionally true/false, before insertion;
root: a top node for storing data in the xml element mechanism;
user: the user name is used for confirming the sftp access user name;
pwd (password): for confirming the sftp access password;
dbString: a database connection string;
list: the method comprises the steps of determining field element mapping relation;
fieldname (field name): for determining field names;
xPath (path): xPath under root for locating the acquisition field value.
S17, deploying an exclusive component jar package on the resource scheduling system, wherein the jar package is used for mapping fields in the tiled report and fields in the data table, updating the data table and deleting the file in the preset format under the specified directory file.
In step S17, specifically, the jar package may be further configured to decrypt the tiled report and parse xml elements in the tiled report.
Jar packets used in this embodiment are ehrms-wd-job.
Example 2
The embodiment provides a workbench data synchronization system based on a resource scheduling system, as shown in fig. 2, the workbench data synchronization system includes: the system comprises a report development module 1, a timing module 2, an encryption module 3, a report transmission module 4, a data table creation module 5, a configuration module 6 and a scheduling module 7.
And the report development module 1 is used for developing a tiled report at a Workday server side.
And the timing module 2 is used for establishing a timing plan task at the Workday server side.
And the encryption module 3 is used for encrypting the tiled report by PGP and then transmitting the encrypted tiled report in an xml format.
And the report transmission module 4 is used for transmitting the tiled report to a server specified directory file in a preset format file form.
In the report transmission module 4, specifically, the preset format may be an xml format.
In particular, the server may be an sftp server.
In particular, the attributes of the fields of the tiled report may be redefined, if necessary: column, header, Override, XML and Alias, and are convenient for using simple and readable field names during subsequent configuration mapping.
And the data table creating module 5 is used for creating a data table in mysql, and storing the data table in a specified database, wherein the field names in the data table correspond to the field names in the tiled report.
A configuration module 6, configured to establish a configuration file in a configuration platform, where the configuration file is used to configure a mapping relationship between an address of the server, a login account of the server, a name of the specified directory file, a name of the file in the preset format, a name of the specified database, a name of the data table, a field name in the tiled report, and a field name in the data table.
In the configuration module 6, the configuration platform may be qconfig, in particular.
In particular, the configuration file is wd jobjson.
Specific addresses, where the configuration items are described as follows:
url: the directory location used for determining the sftp server;
type: only sftp mediation is supported at present;
table: a data table name for writing;
delete: for determining whether to empty the target data table, optionally true/false, before insertion;
root: a top node for storing data in the xml element mechanism;
a user: the user name is used for confirming the sftp access user name;
pwd: for confirming the sftp access password;
dbString: a database connection string;
list: the method comprises the steps of determining field element mapping relation;
field name: for determining field names;
xPath: xPath under root for locating the acquisition field value.
And the scheduling module 7 is used for deploying a jar package of an exclusive component on a resource scheduling system, wherein the jar package is used for mapping fields in the tiled report and fields in the data table, updating the data table and deleting the file in the preset format under the specified directory file.
In the scheduling module 7, specifically, the jar packet may be further configured to decrypt the tiled report and analyze xml elements in the tiled report.
Jar packets used in this embodiment are ehrms-wd-job.
Example 3
Fig. 3 is a schematic structural diagram of an electronic device according to embodiment 3 of the present invention. The resource scheduling system comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor realizes the Workday data synchronization method based on the resource scheduling system of the embodiment 1 when executing the computer program. The electronic device 30 shown in fig. 3 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiment of the present invention.
The electronic device 30 may be embodied in the form of a general purpose computing device, which may be, for example, a server device. The components of the electronic device 30 may include, but are not limited to: the at least one processor 31, the at least one memory 32, and a bus 33 connecting the various system components (including the memory 32 and the processor 31).
The bus 33 includes a data bus, an address bus, and a control bus.
The memory 32 may include volatile memory, such as Random Access Memory (RAM)321 and/or cache memory 322, and may further include Read Only Memory (ROM) 323.
Memory 32 may also include a program/utility 325 having a set (at least one) of program modules 324, such program modules 324 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 thereof, may comprise an implementation of a network environment.
The processor 31 executes various functional applications and data processing, such as the Workday data synchronization method based on the resource scheduling system of embodiment 1 of the present invention, by running the computer program stored in the memory 32.
The electronic device 30 may also communicate with one or more external devices 34 (e.g., keyboard, pointing device, etc.). Such communication may be through input/output (I/O) interfaces 35. Also, model-generating device 30 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 network adapter 36. As shown, network adapter 36 communicates with the other modules of model-generating device 30 via bus 33. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the model-generating device 30, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID (disk array) systems, tape drives, and data backup storage systems, etc.
It should be noted that although in the above detailed description several units/modules or sub-units/modules of the electronic device are mentioned, such a division is merely exemplary and not mandatory. Indeed, the features and functionality of two or more of the units/modules described above may be embodied in one unit/module according to embodiments of the invention. Conversely, the features and functions of one unit/module described above may be further divided into embodiments by a plurality of units/modules.
Example 4
The present invention also provides a computer-readable medium, on which a computer program is stored, which, when executed by a processor, implements the Workday data synchronization method based on the resource scheduling system of the foregoing embodiment 1.
More specific examples, among others, that the readable storage medium may employ may include, but are not limited to: a portable disk, a hard disk, random access memory, read only memory, erasable programmable read only memory, optical storage device, magnetic storage device, or any suitable combination of the foregoing.
In a possible implementation manner, the present invention can also be implemented in the form of a program product, which includes program code for causing a terminal device to execute the Workday data synchronization method based on the resource scheduling system of embodiment 1 when the program product runs on the terminal device.
Where program code for carrying out the invention is written in any combination of one or more programming languages, the program code may be executed entirely on the user device, partly on the user device, as a stand-alone software package, partly on the user device and partly on a remote device or entirely on the remote device.
While specific embodiments of the invention have been described above, it will be appreciated by those skilled in the art that this is by way of example only, and that the scope of the invention is defined by the appended claims. Various changes and modifications to these embodiments may be made by those skilled in the art without departing from the spirit and scope of the invention, and these changes and modifications are within the scope of the invention.

Claims (10)

1. A Workday data synchronization method based on a resource scheduling system is characterized by comprising the following steps:
developing a tiled report at a Workday server side;
transmitting the tiled report to a server appointed directory file in a preset format file form;
creating a data table in mysql, and storing the data table in a specified database, wherein the field names in the data table correspond to the field names in the tiled report;
establishing a configuration file in a configuration platform, wherein the configuration file is used for configuring the mapping relation between the address of the server, the login account of the server, the name of the specified directory file, the name of the file in the preset format, the name of the specified database, the name of the data table, the field name in the tiled report and the field name in the data table;
deploying an exclusive component jar package on a resource scheduling system, wherein the jar package is used for mapping fields in the tiled report and fields in the data table, updating the data table and deleting the files in the preset format under the specified directory files.
2. The Workday data synchronization method based on a resource scheduling system of claim 1, wherein the Workday data synchronization method further comprises:
and establishing a timing plan task at the Workday server side.
3. The Workday data synchronization method based on a resource scheduling system of claim 1, wherein the Workday data synchronization method further comprises:
and encrypting the tiled report by PGP and then transmitting the encrypted tiled report in an xml format.
4. The resource scheduling system based Workday data synchronization method of claim 1, wherein the jar package is further used for decrypting the tiled report, parsing xml elements in the tiled report.
5. A Workday data synchronization system based on a resource scheduling system, the Workday data synchronization system comprising:
the report development module is used for developing a tiled report at a Workday server side;
the report transmission module is used for transmitting the tiled report to a server specified directory file in a preset format file form;
the data table creating module is used for creating a data table in mysql, storing the data table in a specified database, and enabling field names in the data table to correspond to field names in the tiled report;
the configuration module is used for establishing a configuration file in a configuration platform, wherein the configuration file is used for configuring the address of the server, the login account of the server, the name of the specified directory file, the name of the file in the preset format, the name of the specified database, the name of the data table, the field name in the tiled report and the mapping relation of the field name in the data table;
and the scheduling module is used for deploying an exclusive component jar package on a resource scheduling system, wherein the jar package is used for mapping fields in the tiled report and fields in the data table, updating the data table and deleting the file in the preset format under the specified directory file.
6. The Workday data synchronization system based on a resource scheduling system of claim 5, wherein the Workday data synchronization system further comprises:
and the timing module is used for establishing a timing plan task at the Workday server side.
7. The Workday data synchronization system based on a resource scheduling system of claim 5, wherein the Workday data synchronization system further comprises:
and the encryption module is used for encrypting the tiled report by PGP and then transmitting the encrypted tiled report in an xml format.
8. The resource scheduling system based Workday data synchronization system of claim 5, wherein the jar package is further configured to decrypt the tiled report, parse xml elements in the tiled report.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the Workday data synchronization method based on the resource scheduling system according to any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, the computer program, when being executed by a processor, implementing the Workday data synchronization method based on a resource scheduling system according to any one of claims 1 to 4.
CN202111332015.4A 2021-11-11 2021-11-11 Workday data synchronization method and system, electronic device and medium Pending CN113946629A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111332015.4A CN113946629A (en) 2021-11-11 2021-11-11 Workday data synchronization method and system, electronic device and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111332015.4A CN113946629A (en) 2021-11-11 2021-11-11 Workday data synchronization method and system, electronic device and medium

Publications (1)

Publication Number Publication Date
CN113946629A true CN113946629A (en) 2022-01-18

Family

ID=79337746

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111332015.4A Pending CN113946629A (en) 2021-11-11 2021-11-11 Workday data synchronization method and system, electronic device and medium

Country Status (1)

Country Link
CN (1) CN113946629A (en)

Similar Documents

Publication Publication Date Title
CN109670297B (en) Method and device for opening service permission, storage medium and electronic equipment
US10452407B2 (en) Adapter configuration
US9646088B1 (en) Data collection and transmission
JP2019149160A (en) System for building and modeling web pages
CN109495392B (en) Message conversion processing method and device, electronic equipment and storage medium
US20100319060A1 (en) Process and system for comprehensive it discovery without credentials
CN112507027A (en) Incremental data synchronization method, device, equipment and medium based on Kafka
WO2021203979A1 (en) Operation and maintenance processing method and apparatus, and computer device
US20120173679A1 (en) Adaptation method, adapter and adapter system for network service communication
CN103843308A (en) Execution of applications distributed across a plurality of computing devices
CN111881209A (en) Data synchronization method and device for heterogeneous database, electronic equipment and medium
CN109657167B (en) Data acquisition method, device, server and storage medium
CN114416169A (en) Data processing method, medium, device and computing equipment based on micro front end
CN114900448A (en) Micro-service gateway flow management method and device and electronic equipment
CN105320711A (en) Mass data access method and system using the same
Herbold et al. Combining usage-based and model-based testing for service-oriented architectures in the industrial practice
WO2024001240A1 (en) Task integration method and apparatus for multiple technology stacks
CN108595169B (en) Visual programming method, cloud server and storage medium
JP2014041610A (en) Method and system of implementing data load protocols
CN113946629A (en) Workday data synchronization method and system, electronic device and medium
Jaekel et al. Ensure OPC-UA interfaces for digital plug-and-produce
CN113360825A (en) WebUI automatic test method and device, electronic equipment and storage medium
CN112632362A (en) Automatic patrol method and patrol platform for state network information management system
Nakandala et al. Anatomy of the SEAGrid science gateway
CN113377867B (en) Data synchronization method and device and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination