TeraData(tm) is an efficient and continuous data governance, purification, cleansing, conversion, and exception processing that integrates Legacy and Modern databases and systems.
TeraData TM elegantly solves most common problems associated with the competing Extract Transfer and Load (ETL) systems used to prepare data stores for conversion or interfaces.
- True Web-enabled solutions for zero client-side footprints accessible from any modern Web browser.
- Customized GUI’s to match agency branding schemes and preferences.
- Ad-hoc status reporting tools for seamless printing (export to MS Excel or CVS files), storing, and sharing of files.
- Central security administration for managing role-based permissions and user log-in credentials to supplement MS Active Directory (if used)
TeraData allows for the management and control of the data model from a web based user interface. This abstracts the process of data modeling to a level that the standard users can understand. By allowing the administrators or users to update and configure the data model, TeraData facilitates easy and effective reorganization of the data stored within the system in a centralized manner.
Based on a scalable Relational Database Management System (RDMS), TeraData provides data persistence according to a customized relational table configuration.
At the heart of the TeraData Framework are the TeraData Web Services. This set of web services provide access to all Create, Retrieve, Update, Delete and Search (CRUDS) functionality.
Facilitating easy access to the TeraData Web Services, TeraData comes bundled with the TeraClient API.
A number of web user interface modules are made available out of the box, ready for customer configuration and setup.
TeraData provides for dynamic addition of custom data sources. While, other ETLs provide functionality to allow for the “definition” of custom data sources, this definition is a complex endeavor and requires significant knowledge of customized components that require extensive management of data sources. Some competing products to TeraData, such as ODI, do not even provide for the acceptance of proprietary data protocols and formats such as IDMS or DB2.
Allows for configurations (not code) to be used to identify the actual ETL process to change the functional operation of each ETL process you run.
Enables agencies to tie a single processor to multiple watchers to allow access to multiple data input sources such as database, Web applications, etc.
Each configured processor provides the ability to configure 0 or more transformations to the input data (such as looking up primary keys within your database)
Prior to extraction from the source database, TeraReceiver can configure one or more cleaners to account for known problems with the input data store (fixing Unix/WIndows/Mac Line breaks, Search and Replace Regular Expressions, etc.)
Enables agency administrators to further configure backend functionality and security setting from a single interface. TeraData provides a user interface to define the custom objects of a system as well as the properties comprising those objects. It also allows end users to create associations between various objects and object types in real time and continuous mode.
Use TeraData to control access to custom data types through the Web application interface.
View the state of a data object at any time, all recent modification history, and control data integrity and data governance centrally.
Identify fields (and groups of fields) that may be better implemented as their own objects to streamline data flow and daily business operations.
TeraData enables administrators to create and modify structures stored within a database controlled by Web Services generated using TeraData. Administrators can then define custom data elements for storage and retrieval by the end users.