A visual multi-data source ETL tool

A technology with multiple data sources and data sources, applied in structured data retrieval, database management systems, database distribution/replication, etc., can solve problems such as difficulty in getting started, save time and energy, and achieve the effect of simple configuration and no need for programming

Active Publication Date: 2019-04-23
杭州火树科技有限公司
View PDF5 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention aims to solve the problem that it is difficult to get started when synchronizing business data to the target database, and provides a method that is easy to synchronize business d

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
  • A visual multi-data source ETL tool
  • A visual multi-data source ETL tool
  • A visual multi-data source ETL tool

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0076] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0077] For an example, a visualized multi-data source ETL tool, see Figure 1-Figure 3 Shown, comprise on-the-spot visualization unit, on-the-spot visualization unit comprises database and ETL tool, is stored with multiple data sources in the database; The visualization operation method of described ETL tool is as follows:

[0078] S1. ETL tools are connected to various data sources in the database;

[0079] S2. Obtain the source table SQL of the data source database through the table structure or fields of the source database and the ETL tool configuration;

[0080] S3. Optimize the SQL of the source table, obtain multiple data source data after optimizing the SQL of the source table, and inject the data source data into the target table of the ODS target database;

[0081] S4. Scheduling data sources, scheduling task management, scheduling task exec...

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 invention discloses a visual multi-data source ETL tool and belongs to the technical field of visualization of ETL tools. The ETL tool is easy to synchronize business data to a target database, sothat a user can conveniently perform online business analysis and visualization on the business data without programming. The method comprises the steps of S1, connecting various data sources; S2, obtaining a source table SQL of the data source library through configuration of a table structure or field of the source database and an ETL tool; S3, optimizing the source table SQL, obtaining a plurality of pieces of data source data after the source table SQL is optimized, and injecting the data source data into a target table of an ODS target library; and S4, respectively scheduling the data source, scheduling task management, scheduling task execution condition and scheduling OSD list management from the target table of the ODS target library, thereby facilitating the user to perform online business analysis on the business data. The method is simple and easy to learn.

Description

technical field [0001] The invention relates to the technical field of visualization of ETL tools, in particular to a visualized multi-data source ETL tool. Background technique [0002] Now, when you want to synchronize business data to the target database for online business analysis, you need technical personnel who understand database synchronization access to achieve it. It is difficult for people who are not proficient in database synchronization access to synchronize business data to the target database for online business analysis. For business analysis, this greatly increases the difficulty of getting started for relevant personnel who need to synchronize business data to the target database for online business analysis. Therefore, it is very necessary to design a simple and easy-to-understand ETL tool that can easily synchronize business data to the target database and facilitate online business analysis for users. [0003] The two nouns used in this patent are ex...

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): G06F16/25G06F16/27
Inventor 黄泽明
Owner 杭州火树科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap