Data Feeds - how do you track what is mapped and how data feed is setup?
At RSA Charge 2019 in the RSA Archer Data Feed Manager panel session, a few people asked about an easy way to see a Data Feed's mappings and other general details in a single page report. This would decrease the amount of time doing a "stare and compare" method, switching between tabs, expanding/scrolling complex mappings, etc. Since a Data Feed's exported file (.dfx5) is an XML file, the information could be processed and output to a report using something like a PowerShell script.
The session's audience was quite tough on me and requested this be done in 2 weeks time, but I barely missed the deadline. At this point, I've developed a PowerShell script that acts like an XML Stylesheet (XSLT) to transform the XML into something more readable. The current script will simply read the exported .dfx5 file and creates an HTML file with a series of tables displaying details...sample report attached below. For the general info, the report displays data in a few different ways to see what people like: text, list, table. Of course, you can extend or modify the script to display data how you like.
In the next major version, I plan to hook into the Archer API to lookup application name based on GUID and field names based on the Alias.
I'd really appreciate any feedback on the report format, data display, etc, so please add comments. One customer showed me the Excel spreadsheet they use to document the data feed. Another customer uses Visio to show the mappings. If you have other methods to get this information or examples, please share too. Thanks!
- Community Thread
- Data Feed
- Forum Thread
- REST API
- RSA Archer
- RSA Archer Suite
- tool box
This is really cool..!! Big shout-out to you..
I presume that this code works for A2A, HTTP, RSS and File transporters. Is that right?
Hoping to see the following in next version
1. Name of Target application instead of GUID.
2. Transport tab user details (not the credentials, just name will suffice) in A2A feeds.
Will ask few more questions after trying the script. Thank you so much, Jeff...!!