Red Gate forums :: View topic - BI Stack Dependency Tracker
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

BI Stack Dependency Tracker

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lucazav



Joined: 26 Aug 2010
Posts: 7
Location: Italy

PostPosted: Fri Jun 17, 2011 10:12 am    Post subject: BI Stack Dependency Tracker Reply with quote

I'm working on a BI project. It'd be very interesting to use an evolution of Dependency Tracker (e.g. BI Dependency Tracker) that is able to track all the dependencies beetwen SQL Engine, SSIS, SSAS and SSRS.
According to some naming convention you can set in, it'd be very useful to group all these related object in customizable layers like 'Staging', 'DWH' and so on...
Today we miss such an instrument to document our BI projects.

Thank you!
Back to top
View user's profile Send private message
Sian.Williams



Joined: 26 Aug 2010
Posts: 32

PostPosted: Mon Jun 20, 2011 1:31 pm    Post subject: BI Stack Dependency Tracker Reply with quote

Thanks for your comments.

This has already been requested by other users, it has been logged as DT-577 if you wish to chase it up in the future.

I will add your comments to the request Smile

Thanks
_________________
--------------------------------------
Siān Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------
Back to top
View user's profile Send private message Send e-mail
lucazav



Joined: 26 Aug 2010
Posts: 7
Location: Italy

PostPosted: Mon Jun 20, 2011 2:55 pm    Post subject: Reply with quote

Quote:
This has already been requested by other users, it has been logged as DT-577 if you wish to chase it up in the future.


Is there a public requests repository so that I can browse other users requests?

Thank you so much.
Back to top
View user's profile Send private message
Nick Sutherland



Joined: 20 Jun 2011
Posts: 1

PostPosted: Mon Jun 20, 2011 4:14 pm    Post subject: Reply with quote

Hi,
Thanks for your interest in Red Gate. We are investigating the BI sector at the moment so your Dependency Tracker request is very welcome. It would be very helpful if you could describe how you use the Microsoft BI tools and if there are other areas where you think Red Gate could make these more useful.

Thanks
Nick
_________________
Nick Sutherland
Product Manager
Red Gate Software
Back to top
View user's profile Send private message
lucazav



Joined: 26 Aug 2010
Posts: 7
Location: Italy

PostPosted: Thu Jun 23, 2011 1:28 pm    Post subject: Reply with quote

Hi Nick,

basically we start to load/transform data from the ERP system through several databases (Helper, Config, Staging) and

finally all the cleansed data is stored in the Datawarehouse database. So we have some SSIS packages between these db
that do the "dirty" work; we also can have SSIS packages that move/transform data into the same db.
We also create SSAS databases and SSRS reports based on the Datawarehouse db.
All this work is based on an Adaptive BI Framework, the rules of which will be described by my collegue Davide Mauri in a
website (http://www.engineeringbi.com, work in progress).

It'd be nice to have a tool that traces all the dependencies between all the objects of the BI stack.
E.g. starting from a dimension in a SSAS database, this tool will trace all the dependencies down to the staging database
table (passing through SSIS packages that may occur between objects, views or stored procedures, etc. etc.). Even parsing of SSIS SQL Tasks (in general of all SQL Commands) should be traced.
You should be able to group selected objects into logical layers. After you select one or more layers, or independent
objects in this tool, you'd be able to export a dependencies matrix of selected layers/object in Excel, or an XML file containing these dependencies.

More features like these can be implemented in order to facilitate the BI developer daily work. But I think the ones upon described are the most important.
Let me know by personal e-mail if you need further help.

Thank you
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group