Focal Point
[CASE OPENED] DataMigrator Report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/9877055096

July 16, 2018, 06:44 PM
ray_In_Vancouver
[CASE OPENED] DataMigrator Report
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
July 17, 2018, 10:55 AM
Clif
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.


N/A
July 18, 2018, 05:01 PM
ray_In_Vancouver
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
July 19, 2018, 09:18 AM
Clif
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.


N/A
July 23, 2018, 03:49 PM
ray_In_Vancouver
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
July 26, 2018, 10:29 AM
Marina
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.
August 22, 2018, 10:00 AM
Marina
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.