| D&B eDATE (Enterprise Data Acquisition and Transformation Engine) is a platform agnostic Data Management tool that facilitates automated extraction, transformation, validation, and syndication of data.
|
| eDATE is a Data Integration Middleware Product that enables information integration across heterogeneous systems and data quality management.
|
| It has added tremendous value to businesses by providing the following benefits:
|
| Data Integration or Migration - Integrating data across heterogeneous data sources such as Standard File Formats (delimited, fixed length, variable length, and xml) and relational databases (Oracle, SQL Server, and MySQL), local or remote, and providing the user with a unified view of these data. eDATE provides Scheduled or Manually Triggered modes of acquisition and Data Entry screens for non-electronic data sources. |
| Data Cleansing, Data Enrichment, and Transformation of Data - To achieve a high level of data quality, eDATE helps to replace, modify or delete the incorrect and inconsistent data that can lead to false information and in the process, enrich the data. Creation of data conversion rules based on data types and catalogue facilitates the transformation of data from one format to another and from one value to another to create a database having standard format and values. |
| Data Quality Assessment - The eDATE Data Quality Assessment component helps to quickly identify and validate data quality issues. It provides a benchmark to explain the delta between current state and achievable future state environments. |
| eDATE Technical Architecture |
| eDATE is a Data Management middleware that enables seamless data integration between various systems. |
|
 |
|
| D&B's eDATE is built on open source J2EE framework. It has a component-based architecture with the following components: |
|
Open All
|
Data Dictionary and Segment Definitions
| Creation of data dictionary |
| Grouping data elements into Segments based on information type |
Multi-tenancy through Workspaces
| Creation of Workspaces to support simultaneous data processing activities in a single installation |
| Isolation of configurations for each information type and system |
Acquisition and Consolidation
| Acquisition of data from multiple heterogeneous data sources |
| Supports Standard File Formats (delimited, fixed length, variable length, and xml) and relational databases (Oracle, SQL Server, and MySQL). Supports Acquisition of data from local and remote sources(FTP) |
| Scheduled or Manually Triggered modes of acquisition |
| Consolidation of data acquired from different data sources |
| Data Entry screens for non-electronic data sources |
Data Transformation
| Creation of data conversion rules based on data types and catalog-based conversions |
| SQL-based custom rules |
| Conditional rules for selective data transformation |
Data Validation
| Creation of validation rules |
| Rules based on data types and SQL-based custom rules and conditional rules for selective data validation |
| Severity levels added to each rule to segregate warnings and errors |
Data Syndication
| Syndication of validated data into files (delimited, fixed length, variable length, and xml) and relational databases (Oracle, SQL Server, and MySQL) |
| Creation of files as per bureau specified custom formats |
Collaboration
| Workbench for data managers to trigger acquisition |
| Viewing data validation errors |
| Exporting error records and providing consolidated validation errors for each invalid record |
| Dashboard to monitor and perform data processing activities and take corrective actions when required |
| Downloading the error data in the excel format facilitates the bank to correct the data related errors |
|
|
| eDATE Deployment Methodology |
| eDATE effectively addresses the data integration & data quality management challenges through technology and D&B TransUnion ADC's data quality methodology. D&B TransUnion ADC's data quality methodology ensures the desired data quality is achieved through: |
| Proven data quality management processes and built-in domain content |
| Collaborative workbench to monitor the Data Management activities and take any corrective actions at all stages |
|
| eDATE Implementation Highlights |
| Today eDATE has evolved into a business enabler for enterprise data integration & data quality management for Credit Bureau, Financial Infrastructure, Risk & Rating, and Analytics solutions. |
|
| eDATE in International Projects: |
| Currently there are several leading banks in African countries including Nigeria where the implementation of eDATE is in progress
|
| eDATE has been successfully deployed in a leading Middle East bank for Data Migration within the bank and between existing systems and D&B TransUnion ADC's risk management products
|
| eDATE was instrumental in performing data rationalization for a leading World Trade Centre in the Middle East
|
| Performed complete Cleansing and Data Consolidation in 5 banks worldwide. Non-Electronic Data Submission and Data Consolidation in a Sri Lankan bank |
| Performed Data Submission and Consolidation from disparate Data Sources in 5 bureaus and 50 member banks (Sri Lanka, Egypt, Nigeria, Bhutan and Oman) |
| Distributed High Volume Batch Scorecard Implementation for D&B International (Italy) involving Mainframes Integration |
|
|
- Salient Features
- Benefits
- Value Proposition
- Hardware / Software Requirements
|
| Key Features of D&B TransUnion ADC eDATE include: |
| Acquisition of data from multiple systems and data present in various File Formats locally or from remote systems |
| Consolidation and linking of data from different systems and de-duplication of data |
| Transformation to standardize data in the required format |
| Enrichment of inadequate or poorly enriched data |
| Validation of data to ensure data conforms to the specified quality standards |
| Collaborative workbench to monitor the Data Management activities and take any corrective actions at all stages |
| Collaboration to view and correct data validation errors and to feed non-electronic data |
| Syndication of data in the desired File Formats to local or remote destinations |
| Context sensitive help to assist users through the product functionalities |
| Role based User Management - Supports configuration of roles for Auditor, User Manager, Operator and Administrator |
| Strong User Security features |
| Provision of User Log or Audit Trail |
| Options for downloading the error in the following categories either in the CSV Format or TEXT format
|
| Branch wise Error Download |
| Rule Wise Error Download |
| Import and exporting workspaces enables to replicate the configurations very easily in similar environment
|
|
|
| Extensibility of use as a common middleware for Data Management |
| Off-the-shelf Data Management tool |
| Enables faster time for deployment with pre-configured domain content (IFF, Transformation, Validation & Syndication rules) for credit data submission |
| Platform agnostic |
| Lower cost of ownership |
| Data Capture Component to feed in the non-electronic data |
| Ease of configuration and implementation |
|
|
| Extensive hands-on as well as structured training to users |
| D&B provides robust Help-Desk support post implementation |
| Extensibility of use as a common middleware for Data Management purposes other than Bureau data submission |
| Faster time for deployment (pre-configured domain content) for credit data submission |
| Comprehensive user friendly documentation |
| Wide Experience in eDATE implementation for Bureau Specific requirements |
|
|
| Hardware Requirements |
| The minimum recommended hardware requirements are as follows but depending upon the data volume and frequency of submission, the hardware requirements can be evaluated. |
|
| Application Server Configuration: |
| Operating System: Windows Server 2003 and above |
| Processor: Intel Pentium IV CPU 2.8 GHz |
| RAM: 2 GB |
|
| Database Server Configuration: |
| Operating System: Windows Server 2003 and above |
| Processor: Intel Pentium IV CPU 2.8 GHz |
| RAM: 2 GB |
| Database Space requirement: Will be suggested after volume estimation |
|
 |
|
| Software Requirements |
| JBoss 4.2.1 |
| Oracle 9i / 10g Release 2.0, MySQL 5.5 |
| JDK 1.5 |
J2EE 1.4
|
|
|