Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Create/track metadata to allow resuse of SQL objects for SSRS reporting Expand / Collapse
Posted Monday, July 21, 2014 1:45 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 18, 2016 1:35 PM
Points: 320, Visits: 1,594
We are migrating a fair number of our organization's reports out of a depreciated reporting tool and re-creating them in SSRS and some of the rest of the Microsoft BI stack.

I am looking for a good way to track SQL objects that are created for the purpose of being re-used by report devs (views, INTVFs, things that return active employees, or revenues by department, by year, etc, etc...).

Ideally, this tool would list all those objects and then contain information about how they are sourced/pulling data from as well as comments that are useful.

Then if a dev was working on a report they could search this metadata to see if what they need was already created and they could just consume/join against that.

Also, it would be useful to do a "reverse" check and look at an OLTP field to see if any of these reporting objects had already been created against that specific field.

I was thinking about ERwin for a while, as it seemed to do things similar to this.

However, an SQL dependency tracker or documentation tool might work just as well, provided all our SQL reporting objects are usefully documented using the description fields, etc...

Has anyone else already done this?

Any suggestions, wisdom, lessons learned, etc?

Post #1594808
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse