Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE OPENED] DataMigrator Report
Go
New
Search
Notify
Tools
Reply
  
[CASE OPENED] DataMigrator Report
 Login/Join
 
Gold member
posted
Looking to export a report on all flows in IDM, need to have Data Origin and Destination, Schedule, flow Name, anyone ever done this

This message has been edited. Last edited by: FP Mod Chuck,


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 84 | Registered: February 27, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
You can get a list of all flows easily:

Right click on Application Directories (or an application directory) select Impact Analysis > Flow Report > Summary. This shows you the name, description, user, etc. with one line for each flow. If you want to see the TABLE request that was generated you can right click on the server > Other Options > Server Log and find the line
TABLE FILE _EDAHOME/CATALOG/SYSAPPS 


You can also get a report with Data Origin and Destination but there can be more than one source or target per flow so you need a different report. From Impact Analysis select Synonyms by Procedure.

Also note that under Flow Report there is a Detail report that is printable version of a flow and it's possible to export flows as XML.
 
Posts: 362 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
this works but has no export to excel option if you select Detail Report.


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 84 | Registered: February 27, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
There are currently two ways to save the detail report:
(1) In the report press Ctrl-A and Ctrl-C to copy to the clipboard. Then open Word and Paste.
(2) On the ribbon click on Print and then select Microsoft Print to PDF or other PDF printer.

I should have listed "export flows as XML" separately. We supply a stored procedure for this. In the DataMigrator Users Guide Please see Chapter 8, " Generating Reports, Viewing the Log File, and Printing Flows" in the section "Viewing a Detailed Flow Report and Log File" see Tip 2 for instructions.
 
Posts: 362 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
thanks Clif getting closer.

I need to export a report to a file that contains the flow name, data origin, data dest and the schedule.

I do not see that info on the Flow2xml and I also need to run it one at a time.


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 84 | Registered: February 27, 2009Reply With QuoteReport This Post
Silver Member
posted Hide Post
Hi Ray,
As you opened a hottrack case, I see your explanations that you are planning to use such XML files for building the flow charts of your ETL processes. Thank you.
Since you are now in contact with our support department, the work on this will continue via the hottrack case.
 
Posts: 30 | Registered: February 13, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
As per the hottrack case that was opened, now all information from a flow is exported into an XML file, including the information about the schedule.
And as per the additional hottrack case, the menu item shall be added to the flow and to the application level.
 
Posts: 30 | Registered: February 13, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE OPENED] DataMigrator Report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.