Relevance Reactor Features Overview

Relevance Reactor Features Overview

 

Web-Based
Interface

• Very user-friendly, web-based interface designed for non-technical users
• No hardware infrastructure needed and no software installs required
• Data Manager was designed with both technical and non-technical clients in mind. All key features can be utilized through simple interfaces (running reports, querying data etc.), but clients with in-house technical staff can take the application to VERY advanced levels.
• Data Manager can effectively replace your in-house database application and eliminate the cost of hardware and maintenance

Database
Management

• Manage an unlimited number of databases
• 100% custom database structure and unlimited number of data fields
• Support for all data types (i.e. string, boolean, integer, decimal/money, date/time)
• Custom data field constraints and validation (with full regular expression support)
• Automatic indexing and partitioning (full support of custom indexes)
• 35+ pre-defined data fields (i.e. data typing, formatting and validation)
• Built-in data fields track sources of data, import dates and last export dates
• Archive and backup services included
• Query window for ad hoc SELECT, UPDATE, DELETE and INSERT/MERGE statements
• Custom import/export action scripts (SQL statements triggered on import/export)
• Powerful data de-duplication and merging features

Data Mining/Filtering/Querying

• Easily define and reuse export definitions for querying data
• Preview the data and the number of records that will be exported
• Queries can be very simple or extremely complex for advanced users (JOINS etc)
• Export definition builder makes exports simple for non-technical users

Data
Segmentation

• Custom data segmentations on unlimited number of data fields
• Segmentations support regular expressions and SQL value expressions
• Easily apply segmentations to export definitions
• Apply segmentations alone or intersect multiple segmentations

Custom Reporting and Business Intelligence

• Create ANY report imaginable because all of your data is in one place
• Custom reports support SQL scripting so the sky is the limit for advanced users
• Schedule reports to be emailed to multiple users
• 11 charting options in 2 or 3 dimensions
• Support for "dynamic" report parameters

Built-In
Reporting

• Database reports show the number of records and storage utilization
• Data preview reports allow you to see the most recent records for a database
• Import volume reports by source or data file for any date range
• Data analysis reports for rejection and duplication rates
• Export volume reports by destination for any date range
• Process queue report shows the status of all active process threads

Data
Import

• Data source tracking and segmentation (track where your data is coming from)
• Custom import templates allow you to import files in any format
• Custom XML converters (using xPath syntax) with full XSL transformation support
• Custom data mappings allow you to normalize data that comes in different forms
• Automated incoming data processing via local/remote HTTP(S)/FTP(S)/Email
• Support for real-time data feeds via HTTP(S)
• Integrate with 3rd party APIs for data import
• Automatically clean and validate data upon import with 3rd party integrations
• Easy web-based FTP site management for incoming feeds
• Data file preview tool displays the top of a file and highlights invisible characters
• Import test tool allows you to test imports and provides an analysis of the data
• Automatic extraction of ZIP/RAR files (and extract files within an archive)
• Automatic virus scanning of import data files
• Automatic line-ending conversion (support for MAC/Windows/Unix file formats)
• All original import files are kept and made available for easy download
• Apply re-formatting expressions to files before import
• Advanced import made possible by using regular expressions to "split" data fields
• Append "static" data to import data files (to append a fixed date for example)

Data Hygiene & Verification

• Automatically clean and verify data upon import via 3rd party integrations with all leading data hygiene and verification vendors

Data
Export

• Custom export templates allow you to export files in any format
• Custom XML converters (using xPath syntax) with full XSL transformation support
• Full support for MD5 encryption within export files
• Automated outgoing data processing via local/remote HTTP(S)/FTP(S)/Email
• Support for HTTP file pickup by 3rd parties and ability to secure with a password
• Integrate with 3rd party APIs for data export
• Easy web-based FTP site management for outgoing feeds
• Export test tool allows you to test exports and preview the final data file
• Support for plain text (including XML), ZIP or RAR export files

Export
Scheduling

• Create unlimited schedules to automatically build and prepare exports
• Automatically load export data onto 3rd party applications

Data Rejection and Suppression

• Maintain unlimited suppression/black/white lists
• Suppression/black/white lists are automatically validated, de-duped and indexed
• Custom inclusion or exclusion rejections allow scrubbing against black/white lists
• Rejected records are maintained for a period of time for analysis purposes
• Active data records are ensured to be "clean" and validated before exporting

Other System
Features

• Highly available and scalable network architecture with high degrees of redundancy
• SQL Server Enterprise provides state-of-the-art database management
• API access available for advanced integration with other systems
• Notifications keep you up-to-date on any import/export/system failures
• Permission system allows you to limit feature access to certain users