My associate and I have been tasked with developing a data dictionary/matrix to identify the data elements, in what application modules and screens they are used, if they are modifiable or read only and where the data originates.  We have a conceptual design for a spreadsheet that would provide this but it would be better if we had a database tool that we could enter the information into and then produce a report.  That way the information would be more manageable in the long run.  Does anyone know of a tool, preferably an open source tool, that would accomodate this?

Hi InfoSmithy,

I agree with Kimbo that Enterprise Architect is a good tool for this type of work.  It's also a very good choice if you want a tool that you can use to support many of your BA activities going forward as well.

Are there any other tools being used for requirements management, software development, and/or test management, that might be available to you?  Many of these tools would support enter and report on the type of information you need.  For example, a requirements tool such as Requisite Pro would allow you to manage the data classes and elements as data requirements, then you can build relationships between them.  Screen assocations can be handled either through attributes or by recording the screens/functions as design 'requirements'.  Microsoft's Visual Studio also has broad capabilities that would support your work, particularly if developers are already defining the screens, functions, and data classes & elements. But these are more expensive tools, and I would suggest them only if they are already available within your organization.

Sandy