Tools

SQLite Maestro

SQLite Maestro is the premier SQLite admin tool for database management, control, and development. Its key features include support for all SQLite versions 2.8 and 3.x.y, easy database object management, database designer, comfortable access to DB2 security features, data management (editing, grouping, sorting, and filtering abilities), handy SQL editor, and many more.

SQLyog

SQLyog is the most complete and easy to use MySQL GUI. It lets you apply schema and data changes visually while moving from test to production. It streamlines data transfer/migration from any ODBC compliant data source to MySQL. In short, it is a powerful means to manage your MySQL databases.

Squarehouse Commentary

Squarehouse Commentary installs as a companion to your existing Analysis Services reporting solution as a modern, responsive web interface that imports all of your Microsoft Analysis Services (SSAS) data models in minutes. From there, this simple and clean website acts as your enhanced data warehouse semantic layer, enabling agile management of key metadata, such as business descriptions, data model object lineage, dimensional attribute change policies, design decisions, support documentation, and much more.

SQuirreL SQL

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands, etc.

SSAS Documentation Generator (script)

SSAS Documentation Generator script will generate a Data Dictionary for an SSAS Cube. The script demonstrates the type of code/documentation generation Dimodelo Architect is capable of producing. Dimodelo Architect is a Data Warehouse Automation tool for the Microsoft platform. Using Dimodelo Architect you can Design, Generate, Deploy, and Execute a Data Warehouse.

SSIS Documenter

SSIS Documenter is a powerful SSIS documentation tool for SQL Server 2012. It will create documentation in HTML and text formats, export SSIS configuration to the XML format, and save you a lot of time. SSIS Documenter easily integrates into the SQL Server Management Studio.

SSRS Reports to document SSAS 2008 DB

SSAS 2008 DMVs allows you to easily access Microsoft SQL Server Analysis Services (SSAS) metadata. You can execute SSAS DMV queries directly in the Analysis Services environment.

StarDQ

Starcom Data Quality Solution, StarDQ, is a powerful, real time enterprise solution for Cleansing, Profiling, De-duping and Monitoring data. With StarDQ, organizations can create a strategic, trustworthy, valuable asset that enhances the decision making power.

StarUML

StarUML is a sophisticated software modeler for agile and concise modeling. It supports to create Entity-Relationship Diagrams (ERD), Data-flow Diagrams (DFD), and Flowchart Diagrams. It also supports many shorthands in Quick Edit to create elements and relationships at once, such as sub-classes, supporting interfaces, etc.

Stemma

Stemma is a fully managed data catalog, powered by the leading open-source data catalog, Amundsen. By bridging the gap between data producers and data consumers, Stemma enables you to gain total trust in your data. Stemma provides enterprise management (easy deployment, enterprise-grade security) and richer metadata. It makes finding trustworthy data easy and offers an always up-to-date view of your data's usage at any time through automated documentation based on common usage patterns.

See more