Easily Integrate Information between File Systems and Databases
Organizations store a considerable amount of information in file systems such as the Hadoop Distributed File System (HDFS) or in content management environments.
Because this data is often shared on an ad-hoc basis through ftp, sftp or hdfs scripts, organizations end up with multiple copies of the same information, making it difficult to determine what data to use to make decisions.
Organizations have addressed this challenge for relational databases by consolidating systems or replicating data in real-time. But for file systems, this issue remains largely unresolved. HVR offers a solution. HVR replicates and integrates between file systems and databases, allowing you to make file system sources or targets an integral part of your replication implementation.
Move Data Uni- or Bi- Directionally
Using file replication and Managed File Transfer (MFT) capabilities, HVR can integrate data across file systems or between relational databases and file systems, including Hadoop/HDFS, and vice versa. HVR can route data from one or more sources to one or more destinations.
Bi-directional integration is available between:
- Table data and delimited files.
- Table data and XML files
- BLOB columns in a table and binary data on a file system.
Simplify movement of large volumes of data:
- Accelerate queries
- Easily integrate with many different types of databases and applications