SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Michael DeYoung / ETL for Free-Form Data / Latest Posts

RE: ETL for Free-Form Data

Harit Gohel — Mon, 24 Mar 2008 10:24:17 GMT

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?

RE: ETL for Free-Form Data

Mike C — Thu, 20 Mar 2008 10:38:24 GMT

[quote][b]noeld (3/20/2008)[/b][hr]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[/quote]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.

RE: ETL for Free-Form Data

noeld — Thu, 20 Mar 2008 09:54:43 GMT

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

RE: ETL for Free-Form Data

Jeff Moden — Thu, 20 Mar 2008 09:51:41 GMT

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

RE: ETL for Free-Form Data

Mike C — Thu, 20 Mar 2008 09:21:08 GMT

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.

RE: ETL for Free-Form Data

Jeff Moden — Thu, 20 Mar 2008 08:57:20 GMT

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.

RE: ETL for Free-Form Data

webooth — Thu, 20 Mar 2008 07:03:46 GMT

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.

RE: ETL for Free-Form Data

Anipaul — Thu, 20 Mar 2008 02:48:49 GMT

I am not impressed with the article. I am not clear what the author wants to say bythese lines in step 1:[i]' 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]I may not be clear but someone can explain me on this.RegardsAnirban

ETL for Free-Form Data

Michael DeYoung — Wed, 19 Mar 2008 23:17:19 GMT

Comments posted to this topic are about the item [B]ETL for Free-Form Data[/B]