Midrange News for the IBM i Community


Posted by: GL Slone
Impact Analysis Tools
has no ratings.
Published: 08 Jan 2015
Revised: 19 Jan 2015 - 920 days ago
Last viewed on: 27 Jul 2017 (2210 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Impact Analysis Tools Published by: GL Slone on 08 Jan 2015 view comments(6)

We are in the process of looking for, and purchasing, impact analysis tools for our iSeries - V7r1. We have no tools to tell us where fields, files, etc are being used within our applicatons. I used Hawkeye Pathfinder in a different life, but i cant find out how up-to-date they are?

What are some of the others that you all are aware of? Bob, does your toolboxes have anything like that?

As part of the tool, we want to be able to use it on RPG400, Free, Embedded SQL, .NET apps hitting the i, stored procedures, etc.

 

thanks

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: Impact Analysis Tools
Posted: 2 years 6 months 20 days 3 hours 29 minutes ago

Probe/Abstract from ASC was usually better tha Hawkeye, but they were purchsed by HelpSystems a while back and I have no idea if they still over Abstract.

Hawkeye is usually on maintenance-mode only--not sure they update it much, but you could call them to find out.

I built a "Field Where Used" for IBM in the pre-Y2K Era that found where all fields and files were being used, but that was 400 code only and I don't even know if they still offer it--I would assume not.

So to me, Google and/or look at Abstract.

Posted by: Viking
Premium member *
CA
Comment on: Impact Analysis Tools
Posted: 2 years 6 months 20 days 3 hours 9 minutes ago

Yes, Help Systems offers it:  http://www.helpsystems.com/abstract

I used it at my last place and liked it.

Posted by: Midnite1
Premium member *
Comment on: Impact Analysis Tools
Posted: 2 years 6 months 19 days 12 hours 13 minutes ago

Thanks for responding.

I talked to HelpSystems yesterday about Abstract. They seem to be updating regularly. She is sending me more info.

Looks like from what i have gotten from Hawkeye, Bob you are dead on it. They donot seem to be doing any more development, which means it probably dont do plugins, etc.

Viking, was Abstract able to track fields/files used in embedded SQL and subprocedures, especially those created on a SQL server like .NET?

i will continue to do my research/googling today and give my recommendation.

Posted by: Viking
Premium member *
CA
Comment on: Impact Analysis Tools
Posted: 2 years 6 months 19 days 9 hours 37 minutes ago

As I recall, the last time I worked on it (a few years ago) they were working on an update to be able to keep track of usage within embedded SQL, etc.  That was important to me since we had a lot of embedded SQL, so that was lacking at that time.  However, we never had .NET or the need to use it on any SQL Server database so I don't know that answer.

Posted by: starbuck5250
Premium member *
Comment on: Impact Analysis Tools
Posted: 2 years 6 months 19 days 9 hours 6 minutes ago

We use Total/400 and are mostly happy with it (who is ever completely happy with software?)

It does handle fully free RPG and SQL.

It does get regular updates.

The developer is very attentive when it comes to support.

No RDi plugin.

I don't understand how any cross reference tool is going to know about a .NET app that reaches in through ODBC.

Posted by: SteveCCNJ
Premium member *
Egg Harbor Twp., NJ
Comment on: Impact Analysis Tools
Posted: 2 years 6 months 9 days 7 hours 29 minutes ago

There is also X-Analysis from Databorough (just acquired by Fresche Legacy)  I don't know anything about it other than that it exists and is pushed somewhat by IBM.  IBM had them do a Redbook on modernization using their tool: 

http://www.databorough.com/IBMi-as400-iseries-redbook-maintenance-modernization-x-analysis.html

It appears to be much more than just a "where used" tool, but it does include that.