|
|
|
|
| |
| Products |
| |
| SmartSYNC |
| SmartSYNC, the data synchronization and data cleansing component of WebPLEX, enables businesses to rapidly integrate information from multiple sources and cleanse it for transactional and decision support needs. With SmartSYNC, you can consolidate information from both internal and external systems, and from a variety of data formats. SmartSYNC lets you avoid costly mistakes that are the consequence of poor data and the resulting decisions. |
| |
 |
| |
Key Benefits: |
- Provide decision makers with consolidated data from diverse systems and databases
- Improve visibility and response through timely information from within and outside the company
- Allow users to focus on business processes rather than data extraction and cleansing
- Eliminate costly errors caused due to data inconsistencies and inaccessibility
- Expedite new systems implementation, consulting studies, strategic and tactical analyses, and on-going business intelligence and reporting.
|
| |
| Key Features: |
- Supports multiple data sources such as OLE DB, ODBC, XML, Text, etc.
- Supports diverse data structure like Flat, Relational, Hierarchical, etc.
- Enables configuration based job scheduling for real-time or right-time data extractions
- Provides comprehensive reporting to analyze synchronization statistics and to identify data exceptions
- Traps errors in a staging area for manual review and for quickly fixing data errors
- Supports multiple data transfer methods: Append only, Append & Update, Replace
|
| |
| Process: |
| Key steps supported by SmartSYNC in data consolidation and cleansing: |
- Extract: Extract data from source systems at specified intervals / events
- Validate: Validate data for completeness. Apply data existence, data type, and value rules – transfer erroneous data to the staging area for review and move valid data forward
- Aggregate: Aggregate validated data into a single common data store
- Normalize: Normalize and perform data integrity checks to eliminate redundancies, resolve relationship anomalies, and optimize overall performance of target systems
- Rationalize: Apply structured format to all descriptions – to enable classification and consistent access procedures within target systems
- Classify:> Organize into unified, enterprise level hierarchy and conventions – for aggregate analysis and reporting
- Update: Move valid data to the target data repository at specified intervals / events.
|
| |
|
|
|
|
|
|
|
