Specializing in Support and Service Software

If you wish to modify and extend your Amdocs Clarify database schema to allow for additional features and customizations, Dovetail SchemaEditor is the answer. By optimizing database transactions, and eliminating unnecessary database changes, SchemaEditor has proven itself to be the most efficient schema tool for Clarify available. Customers have reported 10x speed improvements in schema changes by using Dovetail SchemaEditor instead of Amdocs SchemaManager.

SchemaScript

SchemaScript provides a simple way of specifying changes to a database schema. In most instances, changes are made to the schema in an incremental fashion with each iteration applying only one or a few changes at a time. Rather than working with the entire schema in a file (which can easily run into hundreds of thousands of lines), SchemaScript allows just the changes to be defined.

Key Benefts

• Safer, more structured method for conducting schema changes.
• Dramatically faster production updates for improved continuity of customer care.
• Greater efficiency in development of new functionality.
• The inclusion of XML Schema Definition (XSD) files allows you to use industry standard tools to modify and validate schema files, which enables you to be confident that the XML is valid – before going anywhere near your database.
• The powerful and flexible logging features of log4net ease troubleshooting and problem diagnoses. Also, log4net provides auditing and monitoring of the detailed processing of SchemaEditor.
• The downtime associated with an Amdocs/Clarify upgrade process can be cut as much as 90%.

Key Features

• Allows you to create, modify, and delete database objects (tables, views, columns, relations, joins, and indexes).
• Enables you to specify changes to the database schema in a simple way, taking advantage of the imperative programming paradigm.
• Uses standard XML files for defining the schema and schema changes.

Clarify Compatibility and Co-Existence

SchemaEditor makes the same changes to the database (both to the actual database tables as well as to the ADP metadata tables) as Clarify’s ddcomp and Amdocs SchemaManager, which ensures that schema changes made by SchemaEditor work as expected in every Clarify-schema-based application. Dovetail Schema Editor is compatible with the following:

• Clarify 7 through Clarify 12.x
• Amdocs 6.x
• Amdocs 7.x