Very fast replication tool, handle huge volume of data
Use Cases and Deployment Scope
HVR is being used as a replication tool in my organization, We have SAP as one of the major OLTP systems and all finance and manufacturing data goes to the SAP system. HVR plays a vital role to replicate SAP data to the Snowflake system which is further used for Analytics and reporting purposes. HVR is being used by "Data Anaytics and reporting " currently. Data replication is very fast from SAP to Snowflake compare to any other tool which we have tried. We are pulling almost 100 tables from SAP to Snowflake for data warehouse.
Pros
- Data replication from source to target system
- Almost Realtime data refresh
- CDC solution
Cons
- Connectivity with more source such as salesforce
- Missing Enterprise manager
Most Important Features
- SAP to snowflake replication
- Very fast and work in hybrid environment
- Handle very large volume of data
Return on Investment
- Almost Real time data availability
- Makes Reporting easy for BI team
- Quick development saves human efforts
Alternatives Considered
Qlik Replicate, Rubrik and SharePlex
Other Software Used
Snowflake, QlikView, Power BI For Office 365 (discontinued), Tableau CRM (formerly Einstein Analytics)
