ETL for Free-Form Data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Michael DeYoung » ETL for Free-Form Data

ETL for Free-Form Data

Rate Topic

Display Mode

Topic Options

Author

Message

Michael DeYoung

Posted Wednesday, March 19, 2008 11:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 29, 2009 12:13 PM
Points: 0, Visits: 19

Comments posted to this topic are about the item ETL for Free-Form Data

Post #472061

Anipaul

Posted Thursday, March 20, 2008 2:48 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,815, Visits: 1,343

I am not impressed with the article. I am not clear what the author wants to say bythese lines in step 1:

' The only thing that should change is the data field value itself. For example, I created this procedure to get GPS data from web-based truck fleet reports into a Data Warehouse staging table. '

I may not be clear but someone can explain me on this.

Regards

Anirban

Post #472096

webooth

Posted Thursday, March 20, 2008 7:03 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:08 AM
Points: 80, Visits: 579

I don’t like to use third party components if I don’t have to. I think a simpler solution would be to do a page scrape and then parse it with regular expressions. No need for XML or components.

Post #472211

Jeff Moden

Posted Thursday, March 20, 2008 8:57 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

When I started reading this, even the introduction sounded like a sales pitch. This isn't an article, it's an advertisment. I suppose it will be useful to some that can't figure out how to do this with the native components of SQL Server.

I also agree about the 3rd party component thing that was previously mentioned... I avoid them.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #472318

Mike C

Posted Thursday, March 20, 2008 9:21 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276, Visits: 1,112

This could just as easily (perhaps more easily) be done by pumping the raw XML into a staging table column and using the native SQL Server XML data type's .nodes() and .value() methods.

Post #472335

Jeff Moden

Posted Thursday, March 20, 2008 9:51 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

See? That's what I mean... don't need 3rd party products for this type of stuff.

Thanks for the info, Mike...

--Jeff Moden

Post #472361

noeld

Posted Thursday, March 20, 2008 9:54 AM

SSCertifiable

Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:12 AM
Points: 6,260, Visits: 1,980

Parsing is, in my opinion, client-side responsibility. Doing these kind of things is SQL Server is not impossible neither difficult but I tend to pass that to specialized languages that are better equiped for the job.

Just my $0.02

* Noel

Post #472364

Mike C

Posted Thursday, March 20, 2008 10:38 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276, Visits: 1,112

noeld (3/20/2008)

System.Xml namespace includes several objects with methods for this type of XML parsing and manipulation as well if you wanted to do it on the client-side.

Post #472404

Harit Gohel

Posted Monday, March 24, 2008 10:24 AM

SSChasing Mays

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 12:04 PM
Points: 612, Visits: 209

When I suggested one of the site in some post on SSC. I got an email that
"We don't link/promote any sites on SSC." So I feel sorry that I did something wrong. But now SSC is forcing to read the PURE advertisement for Third party tool. I don't understand what was the purpose of this article?

Post #473578

« Prev Topic | Next Topic »

Permissions