Wednesday, April 17, 2024
Request a Demo Today
403.775.0007
Databases Simplified
Home
News & Events
About
Contact
Client Login
Register Now
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
Integration Partners
Some of our integrated & strategic partners...