{"id":458,"date":"2016-11-28T11:52:00","date_gmt":"2016-11-28T19:52:00","guid":{"rendered":"https:\/\/www.finditez.com\/blog\/?p=458"},"modified":"2026-03-09T04:36:07","modified_gmt":"2026-03-09T11:36:07","slug":"document-your-bi-and-database-analytics-assets","status":"publish","type":"post","link":"https:\/\/www.finditeasy.com\/blog\/document-your-bi-and-database-analytics-assets\/","title":{"rendered":"Document your BI and database analytics assets"},"content":{"rendered":"<p>For a medium to large enterprise that has grown through mergers and acquisitions or simply through years of success, just knowing what custom software source code assets you have can actually be a daunting challenge.&nbsp; However, having this knowledge can lead to better decision making and tremendous cost savings.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-462\" src=\"https:\/\/www.finditez.com\/blog\/wp-content\/uploads\/2016\/08\/Data-Refinery-Placed-1024x720.jpg\" alt=\"Analytics-Stack\" width=\"625\" height=\"439\" srcset=\"https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Data-Refinery-Placed-1024x720.jpg 1024w, https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Data-Refinery-Placed-300x211.jpg 300w, https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Data-Refinery-Placed-768x540.jpg 768w, https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Data-Refinery-Placed-624x439.jpg 624w, https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Data-Refinery-Placed.jpg 1152w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>Take this first example from a recent customer inquiry.&nbsp; &#8220;<em>We know that we need to upgrade some of our middleware and underlying database version due to advances in technology.&nbsp; We need to migrate to for security compliance, lower support costs and to benefit from improved performance.&nbsp; But we don&#8217;t even know how many Crystal and SSRS reports we have!&nbsp; We estimate there is over 5000 reports and we would like to extract and move any embedded SQL statements within them into the new target database as either a view, function or procedure.&nbsp; Where do we start?<\/em>&#8221;<\/p>\n<p>Perhaps not surprisingly, this is a very common challenge for a large organization relying on a complex, multi-language and multi-tier software applications to run their business.&nbsp;&nbsp; The software itself is big part of what distinguishes them from their competitors.&nbsp; It is a mission critical proprietary asset that needs it&#8217;s inventory ( content ) to be documented, current and relevant.&nbsp; This in turn facilitates efficient and cost effective ongoing enhancements and upgrades to the underlying operating system or middleware as needed from time to time.<\/p>\n<p>IT staff and skills come and go.&nbsp; When some of the senior staff move on, you often lose valuable knowledge and understanding of complex system inter-connections.&nbsp; You need a way to have new staff find those relationships with current and up-to-date documentation to maximize their productivity and minimize introduction of programming errors.<\/p>\n<figure id=\"attachment_463\" aria-describedby=\"caption-attachment-463\" style=\"width: 625px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-463 size-large\" src=\"https:\/\/www.finditez.com\/blog\/wp-content\/uploads\/2016\/08\/Analytics-stack-1024x480.png\" alt=\"Analytics-stack\" width=\"625\" height=\"293\" srcset=\"https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Analytics-stack.png 1024w, https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Analytics-stack-300x141.png 300w, https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Analytics-stack-768x360.png 768w, https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Analytics-stack-624x293.png 624w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><figcaption id=\"caption-attachment-463\" class=\"wp-caption-text\">FinditEZ supports technology across the entire analytics stack.<\/figcaption><\/figure>\n<p>FinditEZ has built in documentation and search supporting the entire BI analytics stack.&nbsp; Automatically generate current documentation, extract SQL statements, create database cross reference reports and more.&nbsp; <a href=\"https:\/\/www.finditez.com\/downloads\/\">Download your free trial today<\/a> or <a href=\"https:\/\/www.finditez.com\/support\/#demo\">contact us for a free one-on-one demo <\/a>with one of our product specialists.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For a medium to large enterprise that has grown through mergers and acquisitions or simply through years of success, just knowing what custom software&#8230;<\/p>\n","protected":false},"author":1,"featured_media":462,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,25,26,27,28,17],"tags":[],"class_list":["post-458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-boost-software-developer-productivity","category-pro-desktop","category-pro-server","category-365-enterprise","category-365-ultimate","category-software-estimating"],"jetpack_featured_media_url":"https:\/\/www.finditeasy.com\/blog\/wp-content\/uploads\/2016\/08\/Data-Refinery-Placed.jpg","_links":{"self":[{"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/posts\/458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/comments?post=458"}],"version-history":[{"count":0,"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/posts\/458\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/media\/462"}],"wp:attachment":[{"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/media?parent=458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/categories?post=458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finditeasy.com\/blog\/wp-json\/wp\/v2\/tags?post=458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}