|
SQL 2012 Compatibility NEW in version 4.5!
The ability to use all of the existing BI Documenter features against the latest version of Microsoft SQL Server 2012. This means that as you upgrade your technology,
we will be right there with you, providing the same great features you have come to trust and love.
|
|
Word Documentation Output (.docx) NEW in version 4.5!
Creating an output that is compatible with one of the best known portable documentation types gives you the flexibility to easily document, modify, store, and share
your BI Stack information. By using the open xml format, Microsoft Word does not need to be installed on computer or server to create the Microsoft Word compatible
document. The other benefit of using the open xml format is the compatibility to view the document in other products that support the format (docx).
|
|
Friendly SQL & SSAS Database Selection Wizard NEW in version 4.5!
Now selecting databases and cubes is easier by using the standard selection keys (Ctrl & Shift) combined with button clicks to select one or more packages.
The ability to select all packages with a single click eases the selection of items in systems that have a large number of packages.
|
|
Document SQL Server BI Stack in few clicks:
|
|
MetaData Editor (Edit Extended Properties) (coming soon in v5.0):
MetaData Editor allows you to edit description of SQL Server objects and all other BI Stack Objects (SSIS Packages, SSRS Reports, Cubes, Dimensions) in few clicks. You can also add/edit custom metadata columns along with description
(e.g. Owner Name, Application Name).
|
|
Compare BI Object Changes:
Find out what have been changed in your environment over time visually in few clicks. BIDocumenter has Diff Engine for SQL Server, Compare SSAS, Compare SSRS and Compare SSIS Packages.
Read More
|
|
Impact Analysis to view BI Objects dependency graph:
Find out visually how various BI Objects are interconnected. You can visually see relationships between various SQL Server Objects, SSRS Reports, SSAS Cubes and SSIS Packages in one view.
Read More
|
|
Output graphs and charts for popular statistics:
Include many charts as part of your documentation e.g. Top 10 Tables by Size, Top 10 Database By Size and many more.
|
|
Document SSIS Packages visually not Just Textually:
BIDocumenter is the only tool which documents SSIS packages visually by embedding picture of your package (Just like BIDS).
|
|
Data Quality Profiler:
Have you ever wondered how many duplicate values you may have, what could be maximum value, how many NULL values you many have in certain column? All of these questions are documented by BIDocumenter when Data Profiling feature is turned on.
|
|
Document Sample Data:
Find out how your data look like without accessing actual data source.
|
|
Workflow Diagram Editor:
Describe your own story using inbuilt diagram editor and attach diagram in documentation.
|
|
Command line support:
With command line application you can automate documentation process at your convince without going through manual steps so you are worry free and always find latest documentation at a predefined location.
Read More
|
|
Customize look and feel:
BIDocumenter provides many options to configure look and feel of output documentation file.
|
|
Support for multiple outputs formats:
BIDocumenter allows you to export database and BI object documentation in CHM /HTML formats.
|
|
Document Server Level Settings:
You can now document not only databases but also SQL Server objects like Jobs, Linked Servers, Logins, Server Triggers, Backup Locations etc.
|
|
Attach custom files/images in documentation:
BIDocumenter supports attaching user defined files as part of documentation so you have all documents in one place when you need them.
|
|
Document various recommendations:
BIDocumenter suggests
to you the best practices and places them inside the documentation (e.g. which table is missing primary key).
|
|
Feature
|
RedGate SqlDoc
|
ApexSQL
Doc
|
PragmaticWorks BIDocumenter
|
|
Document SQL Server 2000, 2005, 2008
|
|
|
|
|
Document SSIS Packages
|
|
|
|
|
Document SSAS Cubes and Databases
|
|
|
|
|
Document SSRS Reports
|
|
|
|
|
Impact Analysis for SQL Server, SSIS, SSAS and SSRS |
|
|
|
|
Compare Changes - SQL Diff, SSIS Diff, SSRS Diff, SSAS Diff |
|
|
|
|
SSIS Screenshots of Control Flow and DataFlow
|
|
|
|
|
Output CHM Format
|
|
|
|
|
Output HTML Format
|
|
|
|
|
Command Line Support
|
|
|
|
|
Document Problems (Broken Best Practices)
|
|
|
|
|
Document Sample Data
|
|
|
|
|
Profile Data Quality
|
|
|
|
|
Document Server Level Settings
|
|
|
(v5.0)
|
|
MetaData Editor For SQL Server
|
|
|
(v5.0)
|
|
MetaData Editor For SSIS, SSRS, SSAS Objects
|
|
|
(v5.0)
|