Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-data-source access method, device and system, and readable storage medium

A multi-data source and data system technology, applied in the field of data processing, can solve the problems of high difficulty, large data source access, difficulty, etc., and achieve strong data access capabilities, flexible data access methods, and improved flexibility in calculation and access Effect

Pending Publication Date: 2021-03-30
YONYOU NETWORK TECH
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, due to changes in organizational structures and data sources for accessing data in various versions of business systems, it is very difficult to access data across versions and data sources, and it is necessary to process the access of different data sources in the same transaction. Number of requests, more difficult

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Multi-data-source access method, device and system, and readable storage medium
  • Multi-data-source access method, device and system, and readable storage medium
  • Multi-data-source access method, device and system, and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] Such as figure 1 As shown, Embodiment 1 provides a method for fetching numbers from multiple data sources, including:

[0050] Step 102, obtaining the setting information of the target data source;

[0051] Step 104, setting the environment parameters of the target data source according to the setting information of the target data source;

[0052] Step 106, according to the environmental parameters of the target data source, send a data fetching request to the target data fetching system corresponding to the target data source, so that the target data fetching system can fetch data according to the data fetching request;

[0053] Step 108, receiving the number fetching result set sent by the target number fetching system.

[0054] The multi-data source access method provided by the embodiment of the present invention obtains the setting information of the user-defined data source to be accessed by obtaining the setting information of the target data source, thereby p...

Embodiment 2

[0060] Such as figure 2 As shown, on the basis of Embodiment 1, Embodiment 2 provides a multi-data source access method, which further defines that before the step of obtaining the report organization information of the current system, the multi-data source access method also includes:

[0061] Step 202, setting the mapping relationship information between the current report organization and the target data source;

[0062] Step 204, according to the mapping relationship information, send a verification request to the target data access system corresponding to the target data source, so that the target data access system can perform information verification;

[0063] Step 206, receiving the verification result sent by the target data retrieval system;

[0064] Step 208, judging whether the verification result is verified, if the judgment result is yes, execute step 210, and when the judgment result is no, end;

[0065] Step 210, storing the setting information of the target...

Embodiment 3

[0070] Such as image 3 As shown, on the basis of any of the above embodiments, the third embodiment defines the steps of storing the setting information of the target data source, which specifically includes:

[0071] Step 302, encrypting the setting information of the target data source;

[0072] Step 304, storing the encrypted setting information of the target data source.

[0073] In this embodiment, when storing the setting information of the target data source, the setting information of the target data source is encrypted first, and then stored, so as to ensure data security during data transmission and network transmission during data retrieval. security.

[0074] In one embodiment, when storing the setting information of the target data source, the current report organization information is also stored, and the current report organization information and the setting information of the target data source are only symmetrically encrypted to further improve the securit...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention provides a multi-data-source access method, device and system, and a readable storage medium. The multi-data-source access method comprises the steps of obtaining setting information of a target data source; setting environmental parameters of the target data source according to the setting information of the target data source; sending an access request to a targetaccess system corresponding to the target data source according to the environmental parameters of the target data source, so that the target access system performs access according to the access request; and receiving an access result set sent by the target access system. Environment parameters of a target data source are set according to setting information of the target data source, so that atarget access system capable of accessing from the target data source is determined according to the environment parameters of the target data source, an access request is sent to the target access system corresponding to the target data source, and the target access system accesses the corresponding target data source according to the access request, so that cross-system and cross-data-source access to data sources of different ERP systems is realized.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a multi-data source access method, a multi-data source access device, a multi-data source access system and a readable storage medium. Background technique [0002] As an important part of enterprise management, the group report is largely based on the data obtained from various business systems, such as general ledger, assets, cash flow, etc. In the related art, in the same ERP system, many products have already been retrieved. However, most of the products in the existing ERP system are retrieved based on the same data source. If the product is upgraded to a new version or upgraded to a new product, multiple systems and multiple data sources will coexist. In the process of enterprise development, the acquisition of data from the original data source in the new system will play a very important role in enterprise decision-making and data analysis. [0003] Howe...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F40/166G06F21/60G06Q10/10
CPCG06F21/602G06Q10/10G06F40/166
Inventor 赵剑刘永帅
Owner YONYOU NETWORK TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products