| |
Applaud's data repository is the central
location of all data throughout the project
A Dynamic Storage Facility
Applaud's data repository is a dynamic storage facility for profiling, analysis, cleansing, and transformation. The data repository provides the ability to store temporary tables, simulate target tables (without a connection to the target database), and even replicate the entire legacy system to analyze data relationships. With Applaud, the data repository is the central location of all data throughout the project.
Replicate the Complete Legacy Environment to Test Data Relationships
For example, suppose the source data is in several disparate systems including mainframe systems, PC-based systems, RDBMS systems, and homegrown add-on systems such as Access and Excel. Applaud enables you to extract all data from all sources into the repository to quickly identify duplicates, orphans, and other data content, integrity and structure issues. No other software offers anything similar to Applaud's data repository.
Dynamically Change Data Definitions
Applaud's data repository provides the unique ability to dynamically change the structure and definition of data as the requirements change. Other alternatives must rely on conventional RDBMS technology, which is much too slow in its ability to react to changes. Applaud's innovative data repository responds dynamically "on the fly" to changing needs. For example, suppose that you are developing Applaud components and you need to define a new data element (i.e., a new piece of information). When Applaud observes you are defining a new data element, built-in intelligence analyzes exactly what you are doing and asks if you would like to insert the data in the appropriate table in the data repository. If you click "yes" Applaud automatically includes the new data element in the definition of the table on the fly, eliminating the need to make a change to the table definition at a later time.
In another example, suppose that you have extracted source data into the data repository and later find that a data element that you initially thought was a character field really contains numeric data. With Applaud, you simply change the data definition and the change is complete. There is no need to re-extract the data again, as you would with conventional RDBMS technology. The Applaud data repository knows what the data definition was when the data was extracted. When it observes a change has been made, Applaud instantly knows how to process the existing data in the repository based on the new definition (without re-extracting the data). The ability to respond quickly to changes is amazing.
Gracefully Handle Data Exceptions
In addition, RDBMS tools do not offer any help when data exceptions occur. For example, if you attempt to load data from a mainframe into an RDBMS table and non-numeric data is in a numeric field for some records, the SQL insert for the affected rows fails with essentially no information.
When this occurs in Applaud's data repository, Applaud automatically produces a concise report identifying every record that had the problem and showing all key information for the affected records and the actual non-numeric data values in each field that caused the problem. Applaud then zeros out the data value and actually does the insert. This means that Applaud gives you the ability to find all data exceptions on one run and provides extensive information to help you understand the reason for the problem.
Develop Components Anywhere
The data repository offers the ability to simulate the target tables. Since the data repository operates on laptops and unconnected workstations as well as servers, users can continue to develop components while traveling, at home, etc.
Nothing Else Is Close
Applaud users agree that the data repository is an indispensable tool. No other software offers anything similar to Applaud's data repository.
|
|
|
|