ETLstats

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2014 6:12 pm

Kim Duke's utility ETLstats is now also hosted on OneDrive and can be accessed from here - you should not use right click initially (as it will try to save a redir HTML).

Download both ETLstats.zip and Scripts.zip from the OneDrive folder.

kduke · Post by **kduke** » Wed Mar 19, 2014 4:47 pm

Try http://www.raywurlod.com/

kduke · Post by **kduke** » Fri Mar 28, 2014 3:43 pm

I think there is too much stuff in EtlStats. I am working on a EtlStatsLite version. Hopefully my new boss will let me post the bare minimum to get row counts in tables. If not then I can walk you thru it. Hopefully Ray will add it to the downloads. Let you know when I am done.

If interested then post a reply. I think all I need is 2 jobs and 3 routines. Just create tables, import jobs, compile and run.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 28, 2014 5:28 pm

Won't be a problem to host.

Now if only I could find the time to put the rest of my website together!

chulett · Post by **chulett** » Fri Mar 28, 2014 9:20 pm

I think that's a great idea, Kim. A 'lite' version could be an awesome framework for others to expand on as needed.

kduke · Post by **kduke** » Mon Mar 31, 2014 6:54 pm

I will not be able to post my solution. So it is very simple. All you need is the DsJobReport job and the Driver job that goes with it. Rename the jobs EtlGetRowCounts and EtlGetRowCountsDriver. Next get rid of KimD\ all the paths. Get rid of the hashed files. Get rid of the lookup for job status description. There is a routine to give the job status description. So now all you need 3 routines. 2 routines to fix elapsed time and elapsed seconds. You don't need these if you trust what is in the XML file. The other routine is the job status description one already described.

EtlStatsLite, someone do this and zip it up and give to Ray.

Thanks Kim.

kduke · Post by **kduke** » Wed Apr 02, 2014 6:14 pm

I noticed that where you get link name and row counts is different in PX jobs. You need to import the XML. Load the new Xpaths to get to instanceLinkName and instanceRowCount. You need to change the repeating element to the new link name above. Now you need to add stage name. You have to sort by stage name and the new link name. Then you need to aggregate all the instance row counts. You need to add stage name to the ETL_ROW_HIST table.

Post if you get it working.

abdullah159 · Post by **abdullah159** » Sun Oct 25, 2015 7:09 am

Good day,
i wanted to get the files of ETLStats but the website is down for now.
can anybody share the file if possible :D

chulett · Post by **chulett** » Sun Oct 25, 2015 7:19 am

Just worked fine for me. Note that "Under Construction" is not the same as "down".

johnboy3 · Post by **johnboy3** » Thu Mar 24, 2016 1:24 pm

I tried. Got msg saying try to turn on TLS this, TLS that, etc.

I guess our security just will not let me access it.

What a shame. It looks useful!
john3

chulett · Post by **chulett** » Thu Mar 24, 2016 1:31 pm

You can't get to his site or you can't get to his OneDrive file area?

johnboy3 · Post by **johnboy3** » Thu Mar 24, 2016 1:53 pm

Got to his site fine. Tried IE and FF browsers. Both refuse link to zip file.
Error seems to indicate TLS trouble?

johnboy3 · Post by **johnboy3** » Thu Mar 24, 2016 1:56 pm

MESSAGE IN FF:
Secure Connection Failed

An error occurred during a connection to onedrive.live.com. SSL received a record that exceeded the maximum permissible length. Error code: SSL_ERROR_RX_RECORD_TOO_LONG

The page you are trying to view cannot be shown because the authenticity of the received data could not be verified.
Please contact the website owners to inform them of this problem.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Thu Mar 24, 2016 1:58 pm

Kim's website is dead. Only way to get the routines is from Ray Wurlod's site...

http://www.raywurlod.com/

kduke · Post by **kduke** » Thu Mar 24, 2016 2:03 pm

A lot of those jobs are so old they do not import any more. I need to build a 8.5 or even 11.5 version so they still work. The OPSDB obsoleted most of it. So I have not updated them.

DSXchange

ETLstats

ETLstats

Not working; seems to be problem on page?