Importing Data into Sparx EA

[@q34dana]

I have use Export to create and Excel document gather data and Import data back in. Recently I learned how to use it to create Tag Values I needed. Creating Tags (Key:Value) pairs is probably a good video. My purpose was to allow 10-15 folks to update the excel with controlled tags. It worked wonders.

[@UMLOperator]

Yes, this is very beneficial 😃...QQs, Is the source of record, that defines your Tagged Values, maintained outside of Sparx? Or, are some or all Tagged Values defined in Sparx? WOW! Great post! Thank you!!

[@q34dana]

@@UMLOperator I just made them up in the Excel to Identify just a few like Area, Function etc... as needed by the teams.

[@UMLOperator]

@@q34dana Thanks again. It was great to come back to 'flat files" or CSV again. They certainly are great sources of 'data' in action. Here, we built our own Web UI over a simple database, that does the same thing as we were doing in Excel (video coming soon ). This allows us to integrate with other external ALM/DevSecOps third party platforms. Then we use scripting to access that table for import/export with Sparx EA. However, we still have clients that give us their Requirements/Scope in Excel. We also use BI Tooling (e.g., PowerBI) to analyze data to support these table views. This is what is wonderful about 'data first' tools such as Sparx EA vs other tools in the industry. Thank you for your leadership in this area. HAPPY MODELING!