The Grid-Tools Datamaker™ basic product features

Control any database with one powerful press of a button

Good quality test data is the key to the success of new and existing applications. Being able to create test data quickly for a range of test cases will save organizations time and money. Grid-Tools Datamaker™ is an easy to use tool that lets you edit and copy data between schemas as well as build related sets of table data which can then be published to development and test databases.

Grid-Tools software also enables database users to achieve legal compliance through using data de-identification methods and synthetic data creation. Datamaker seeks to increase the productivity of IT staff and improve the and performance of IT infrastructures.

Datamaker ™ features and descriptions

Model data

Build up a picture of how your tables link together with rapid discovery techniques such as database constraints, naming standards, scanning table joins and output from case tools. Extract and store production data characteristics, including lists of values, maximums, minimums and data ranges.

Multi-function SQL Window

One powerful, multi-function SQL window allows you to intelligently browse your data and manage all database objects – across all schema. You can save, copy and edit data in spreadsheet format. Write, store and run your SQL files, create parameters for standard SQL queries, as well as retrieve, edit and compile procedural SQL.

Other features include:

• Multiple tab support for queries
• Can allow multiple connections
• Maintenance wizard support for objects, such as indexes and constraints
• View and edit database synonyms
• Automatic copying and pasting of objects based on context
• Virtual delete of columns when copying between schemas or to files
• Powerful column functions, such as increment and randomiser
• Multiple save formats including Excel, SQL files & XML
• Import data from external data files
• Edit and extract from one schema to another
• Formatted printing of data
• Identify and manage ‘nulls’ in columns
• Sort data by selected column
• Commit and rollback data within a current session
• Insert, modify and delete rows via the data viewer
• Filter selected rows using complex functions
• Multiple window support for easy data comparison
• Graphical visualisation of data trends

Data integrity checker

Check any application rules you create against your actual data to verify its integrity. Can be used to check data in production, or before and after a system test, to make sure system tests have been successful.

Schema definition comparison

Quickly compare schemas to identify differences (such as missing, new or changed objects) between table definitions. Underlying objects such as Indexes, Primary Keys and PL/SQL are also identified.

Version tracking

Version or build information can be stored so that the exact definition of your database structure is captured. This can be compared across schemas or versions to identify any differences between various releases.

Data comparison

Identify data that has changed in your database during development, system testing or problem tracking. Allows you to identify updates, inserts and deletes that have occurred during a specified period and produce HTML and XML reports (in either summary or detailed format) of all changed data. Run high performance parallel compares by selecting specific groups of tables, or compare one schema to another.

Data browsing

Quickly browse from selected rows to related rows in other tables. Use any database or application relationship to travel through your data.

Back to the top