Datical DB automates complex and manual database releases by quickly and safely managing database schema and logic updates. With Datical DB, database changes are aligned with application code releases providing users with full-stack release automation.

Change Management Simulator

Upgrade from a tired and tedious script based database deployment process to an automated, safe and simplified database change management system.

• Maintain an ideal state environment
• Track the evolution of a database over time
• Simulate the impact of database changes before they are deployed

Dynamic Rules Engine

Capture DBA expertise in programmatic rules that can be enforced during the application build and release process.

• Ensure that the DBA's database change management checklist is automatically enforced across all proposed database changes
• Provide instant feed back to application developers on proposed database changes in SQL scripts
• Help application developers write better database code

Database Code Packager

Treat database code just like application code by automating and integrating database change management into the same application release process seamlessly and with zero-downtime.

• Unify application and database changes
• Develop, branch and merge database code like application code
• Improve error handling during the database deployment process

Deployment Monitoring Console

Automatically track and report the status of every database deployment across the enterprise.

• Make database auditing easy, eliminate manual tracking of deployments and errors
• Easy, on-demand access to deployment information
• Single centralized reporting for the entire organization

Pre-Requisites

• Automic Release Automation v12 or above

Installation

• Download the Action Pack from Automic marketplace
• Extract the archive to get the PCK.CUSTOM_DATICAL_DB_1.0.0.zip file, this is the actual action pack.
• Log onto the Automic Web Interface.
• Navigate to Administation tab
• Click Packs then click Install Pack
• Select the action pack that you downloaded. Upon installation, the pack PCK.CUSTOM_DATICAL_DB should appear

Includes following actions:

• Check JDBC Drivers
• Check Rules
• Deploy
• Deploy (with automatic rollback)
• Forecast
• History
• Status
• Status (Detailed)
• Test Connection

Change Management Simulator

Upgrade from a tired and tedious script based database deployment process to an automated, safe and simplified database change management system.

• Maintain an ideal state environment
• Track the evolution of a database over time
• Simulate the impact of database changes before they are deployed

 Dynamic Rules Engine

Capture DBA expertise in programmatic rules that can be enforced during the application build and release process.

• Ensure that the DBA’s database change management checklist is automatically enforced across all proposed database changes
• Provide instant feed back to application developers on proposed database changes in SQL scripts
• Help application developers write better database code

 Database Code Packager

Treat database code just like application code by automating and integrating database change management into the same application release process seamlessly and with zero-downtime.

• Unify application and database changes
• Develop, branch and merge database code like application code
• Improve error handling during the database deployment process

  Deployment Monitoring Console

Automatically track and report the status of every database deployment across the enterprise.

• Make database auditing easy, eliminate manual tracking of deployments and errors
• Easy, on-demand access to deployment information
• Single centralized reporting for the entire organization