“Data discovery and integration steps take between 50% and 80% of any business intelligence effort… and are where many initiatives fail.” - Forrester Research
Harvester simplifies, automates and accelerates the entire process of data integration. This unique toolset offers design-time discovery and mapping to slash the time, effort and cost involved while enhancing quality.
Data integration is both critical and complex. It’s vital for a broad range of business needs—everything from mergers/acquisitions and regulatory compliance to routine operating procedures—yet the process is mostly manual, largely unpredictable, invariably time-consuming and always costly.
Harvester is a powerful and flexible platform that eases the ongoing need to manage relationships across critical data assets.
Harvester provides central management and administration for all of the application’s analyses, generated relationships, and both automated and manual mappings.
- Harvester provides a consistent and reusable methodology for the entire data discovery, mapping, and pre-ETL (extract, transform, and load) process.
- It offers a flexible, shareable platform that can be leveraged across multiple data integration initiatives. The common platform in turn helps organizations transition from one-off projects to embedded best practices.
- Harvester automatically identifies key information, including metadata, database statistics, sample data and data profiling metrics from myriad data sources (relational, non-relational and non-traditional.) It leverages this information to determine where relationships exist across systems.
- The software also enhances project collaboration, offering the ability to partition and assign individual mapping and ETL tasks based on specific schemas/tables in designated sources and targets. Once complete, these individual tasks can be imported back into the master project.
Harvester Analyzer
Harvester Analyzer speeds the analysis of relationships across multiple data sources.
- The patented technology matches heuristics to examine both the database field content and the field metadata (such as field names and field attributes).
- In a discipline noted for complex and time-consuming processes, this analysis can be performed on multiple systems simultaneously—a critical advantage when there is limited information or domain expertise about disparate data sources and their contents.
- Users can define the data source and which are the target.
Harvester Relationship Manager
Harvester Relationship Manager greatly eases the process of managing the results of data discovery and mapping.
- With an intuitive point-and-click interface, data specialists can review, approve and manage the results of the entire process.
- Data architects and analysts can analyze direct and indirect database relationships, and well as the underlying source data.
- The visual feedback provides makes it easier than ever before to track the mapping process from start to finish, and map of exceptions identified during the automated discovery and mapping process.
Harvester Integrator
Low-cost, high-value acceleration of data integration.
Harvester Integrator provides robust, high-performance data movement capabilities, including extracting, transforming and loading ETL data into target applications. Built on open source technology, this solution accelerates data integration projects while cutting project costs and reducing related risks.
Harvester Integrator is a full-featured ETL solution that includes:
- Proven enterprise-class performance and scalability
- A rich transformation library with over 100 out-of-the-box mapping objects
- Broad data source support for packaged applications, including more than 30 open source and proprietary database platforms, flat files, and MS Excel documents
- Integration with the Pentaho BI Suite for Enterprise Information Integration (EII), advanced scheduling, and process integration
- Advanced data warehousing support for Slowly Changing and Junk Dimensions
- Data cleansing plug-in objects
- An extensible architecture
Easy to use:
The graphical drag-and-drop interface and extensible standards-based architecture enhances productivity and prevents proprietary methodologies in the ETL solution.
- Harvester Integrator’s metadata-driven approach makes it easy to create complex transformations and jobs in a graphical, drag-and-drop environment (without having to generate custom code).
- Harvester Integrator utilizes metadata from Harvester for mappings and business rules. Harvester Integrator is used to implement and optimize the business rules through ETL transformations and run-time jobs.
Cloud ready:
Harvester Integrator is available in a cloud-ready platform. It can be deployed on a distributed computing platform using multi-server, multi-threaded resources to distribute the processing required to complete a job or set of data transformations.
