Microgen DBClarity Developer
Microgen DBClarity Developer is used to graphically define and implement SQL queries, procedures and other database logic.
Microgen DBClarity Developer provides an innovative approach to graphically design, implement and control SQL logic. Try the product today.
Current methods of accessing and manipulating enterprise data consume the bandwidth of valuable IT resources. Business teams are dependent on developers to write and edit database queries and procedures. Often, to source the right data from transactional systems, SQL queries need to be implemented multiple times.
Microgen DBClarity Developer addresses these challenges with an intuitive, graphical environment to write, implement and adapt SQL queries and procedures. The benefits of this approach include:
- Quicker, more accurate access to enterprise data
- Improved collaboration through the ability to view, understand and share responsibility for database queries and procedures
- Reduced burden on data infrastructure; writing the right query the first time means less queries and happier databases.
- Improved productivity: SQL logic that can be re-used or embedded into new procedures
- Reduced need to learn database-specific syntax
Microgen DBClarity Developer shares the same powerful graphical interface as Microgen Aptitude that enables user groups to rapidly design, implement and control business-critical, data-intensive enterprise applications.
You can download a trial version of Microgen DBClarity Developer here. Videos and tutorials are available on the 'learn more' tab. The Microgen team always appreciates hearing how you use the product. Please contact us with your feedback.
Microgen DBClarity Developer is an enterprise-class, graphical environment for defining and implementing database logic. DBClarity Developer integrates the following components:
Graphical Studio:
Rapidly develop business rules to perform database queries and procedures using an easy-to-understand graphical studio. There is no need for in-depth SQL knowledge or syntax to do complex calculations, transformations or other in-database operations.
Embedded SQL Expressions and Rules:
Maximise the re-use of logic and ensure best-practice using a truly modular database querying environment. Using Microgen DBClarity Developer, users can create SQL Expressions and reuse them by dragging the expressions into new SQL Rules. In the example the SQL Expression is included in the rule and can be viewed by expanding the filter block.
Integrated Data Design:
Create custom Data Schemas from within the graphical studio. The Microgen DBClarity Developer Data Schema element plays an auxiliary role in creating the database entities by providing a graphical representation of a relational database and can be used as the starting point for building SQL Rules.
Enterprise-class Development:
Correct and quickly implement complex queries using a powerful debugger.
Microgen DBClarity Developer SQL Debugger provides a view of the value of variables and parameters at any point during the debug process. The SQL Debugger works on the graphic editor so the path of data can be tracked through the system with user-defined breakpoints.
Database Agnostic:
Create a rule once and deploy it to Teradata, Oracle and SQL Server database. Users do not need to spend time thinking about database specific syntax, once the SQL Rule is created, deploy it to the database in question and the tool manages the syntax.
This page is dedicated to help you learn more about how to use Microgen DBClarity Developer. If you have just discovered the product, the brief Getting Started video presents key product features.
Webinar
Microgen plans to schedule a series of live webinars on DBClarity Developer over the next 12 months. We will advertise forthcoming videos and provide links to previously presented videos on this site. The first webinar is now available and provides a 30 minute overview of DBClarity Developer.
Introducing DBClarity Developer (Watch the 30-minute webinar)
Videos
The following video progressions present how Microgen DBClarity Developer can be used to connect to a database and graphically create SQL rules and procedures.
Connect to a database and create a simple SQL ruleMicrogen DBClarity Developer: Getting StartedCreating and Activating SQL Rules in Microgen DBClarity DeveloperCreating a Database Connection in Microgen DBClarity DeveloperUsing the SQL Editor in Microgen DBClarity DeveloperCreating Projects in Microgen DBClarity DeveloperViewing the Data Schema in Microgen DBClarity DeveloperAttaching Files to a Microgen DBClarity Developer ProjectDeploying Microgen DBClarity Developer Projects to the Database
Tutorials
Each of the following presentations provides an overview of Microgen DBClarity Developer core functionality. Lessons include how to connect to a database, graphically develop SQL procedures and deploy logic to a database.
The projects featured in these tutorials are included in the Microgen DBClarity Developer software download.
Introduction to Microgen DBClarity DeveloperTutorial 1 - Introducing the SQL EditorTutorial 2 - Introducing SQL RulesTutorial 3 - Data Type Mapping and SQL ToolsTutorial 4 - Data SchemasTutorial 5 - Deploying to the DatabaseTutorial 6 - Building SQL StatementsTutorial 7 - SQL ExpressionsTutorial 8 - SQL Rule IntegrationTutorial 9 - SQL ProceduresTutorial 10 - TriggersTutorial 11 - Advanced SQL Procedure Example
Please contact the Microgen DBClarity Developer Team if there is any additional training material that you would find useful or if you have any product questions or feedback.
Online Documentation
Read the DBClarity Developer Documentation.
User Guide
The Microgen DBClarity Developer User Guide is available to read online or to download and print. Use this guide in conjunction with the videos and tutorials in the Learn More section.
Product Overview
Microgen DBClarity Developer Product Overview Presentation [PDF 757 KB ]
Microgen DBClarity Developer Feature Review [PDF 1079 KB]
Get in Touch
Please contact the Microgen DBClarity Developer Team if there is any additional training material that you would find useful or if you have any product questions or feedback.
Support
For any installation queries and for customers with Gold Support license agreements, please contact Microgen using dbclarity.support@microgen.com, for assistance.
Microgen provides DBClarity Developer for purchase directly from our online store. Microgen also provides a wide range of packaged applications for banking, investment, back office trading and wealth management systems. If you wish to purchase any of the products, services or solutions that are not offered or distributed using this online store, please contact Microgen directly.
As our e-commerce service provider for this store, Component Source will process your purchase on behalf of Microgen. Once you have completed your purchase you will receive a receipt in email and your credit card statement will show a debit from Component Source. Please contact Component Source if you require any assistance during the buying process.
Microgen DBClarity Developer
Microgen DBClarity Developer provides a set of tools that help you build graphical SQL queries and deploy them to the database, saving time spent on building complex queries, updating queries and providing an easy interface for collaborative development.
From £1280
for Oracle
From £1580
for Teradata
From £1880
Developer Suite
From £1980
