Adapter and method for outputting data in data stream to XML document

A data flow and adapter technology, applied in the field of database ETL, can solve problems such as not provided, and achieve the effect of convenient configuration and operation

Active Publication Date: 2008-06-18
NEW FOUNDER HLDG DEV LLC +2
View PDF0 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, in many applications, it is necessary to output the data found in the database or the data combined in the Microsoft SQL Server 2005 integration service data flow task into an XML file according to a certain format. Although the SQL Server2005 integration service provides XML tasks, But it does not provide a destination to output the data in the data flow pipeline directly to an XML file

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
  • Adapter and method for outputting data in data stream to XML document
  • Adapter and method for outputting data in data stream to XML document

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0030] As shown in Figure 1, an adapter 1 that outputs data in a data stream to an XML file, the adapter 1 includes the following modules:

[0031] The XML file reading module 2 includes an input connection manager 21 for verifying whether the template file exists and whether it is an XML format, and connects the verified XML template file 6 data sources and reads the content of the XML template file 6, and store it into an XML template object in memory;

[0032] The data management module 3 is used to read the data in the data flow pipeline, and store these data in the row object set in the form of row objects;

[0033] A data organization module 4, configured to organize the data in the data flow pipeline according to the description format of the XML template file 6;

[0034] The XML target output module 5 includes an output connection manager ...

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 an adapter used for outputting data in data flow to XML files and a method thereof, belonging to the field of database ETL. In the prior art, the data flow task of SQLServer2005 integration service does not provide a function which can directly output the data in the data flow to an XML file. By using the adapter and the method of the invention, users can output the data obtained from a pipeline of the data flow task to the target XML files through an instruction template of the target XML files generated by a certain format in advance. By adopting the adapter and the method of the invention, the data of the pipeline of the data flow task can be output to the target XML files effectively and flexibly according to a set format.

Description

technical field [0001] The invention belongs to the field of database ETL, and in particular relates to an adapter and a method for outputting data in a data stream to an XML file. Background technique [0002] Microsoft SQL Server 2005 is a comprehensive database platform that provides enterprise-class data management using integrated business intelligence (BI) tools. Microsoft SQL Server 2005 Integration Services (SSIS) is one of the powerful features of Microsoft SQL Server 2005. Technically, it is classified as a business intelligence function, and at the same time it is a powerful way to load data and perform tasks in the data flow , which is primarily used for data loading, but can also be used for other tasks in the workflow. Integration Services can generate high-performance data integration solutions, including extract, transform and load (ETL) packages for data warehouses. A task in an integration service can be described as a single unit of work. An integration ...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/21G06F17/30
Inventor 崇晓云李新夏松江
Owner NEW FOUNDER HLDG DEV LLC
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