Skip to main content
Why use HVR over MSSQL Replication?

Why use a Third-Party Tool over SQL Server Replication? (updated April 22, 2019)   Most database vendors provide their own native transactional replication solution. Microsoft is no exception. If your use case is database replication between two Microsoft SQL Server…

Read on
Real-Time Analytics Transforms Industries

Five Industries That Are Being Transformed By Real-Time Analytics In past blogs, I’ve defined real-time analytics and discussed alternative architectural approaches to implementing real-time analytic solutions. I’ve also touched on how some of our customers, such as Lufthansa, Aspen Marketing Services (a division of…

Read on
What Is Real-Time Data Replication?

Do You Need It, and How Do You Do It? The term “real-time” is used extensively in the information technology industry, but the definition is somewhat ambiguous. Since we describe our product offering as “real-time data replication software”, we thought…

Read on
How fast can you replicate your data?

Oracle to SQL Server in 10 Minutes For some time I have been showing HVR demos because I think it is more interesting than showing PowerPoint slides. This applies both to the audience, and to me. Of course, things can…

Read on
Why have a real-time Data Warehouse?

5 Benefits of Real-Time Data Warehousing Going from an infrequently updated data warehouse or data mart environment to a near real-time data warehouse has a number of benefits: 1. FASTER DECISIONS: Make decisions quicker based on more current and more…

Read on
Different Approaches to Real-Time Analytics

The Case for Real-Time Analytics Imagine you are driving your family to a holiday destination. You are looking forward to a relaxing couple of weeks at the beach. Four hours into the journey, as you get close to your destination,…

Read on
Ultimate Flexibility

Is too much flexibility a bad thing? Flexibility in software often leads to complexity. However, power users want the knobs to change things for optimum results and squeeze the last few percents of performance out of the system. The complexity,…

Read on
Best Practices for Database Migrations

Best-Practices for Database Migrations Data migration, even when dealing with a single database is rarely as simple as it sounds especially if the database that is being migrated supports one or more production applications. In this blog, we will discuss…

Read on
Customer Story: Building a Real-Time Enterprise

Three Lessons One Global Financial Institution Learned When Building a Real-Time Enterprise Many organizations talk about the need to be a “real-time enterprise”, but very few organizations achieve this model when faced with the business, cultural, and technical challenges that go with…

Read on
Cloud Integration

At the 2016  AWS Summit in New York we addressed lots of questions about what the move to the Cloud means to HVR. Numerous long-time HVR clients have started the move to the Cloud, and many new opportunities consider the…

Read on
Cloud Reporting Challenges: Security, Connectivity, & Latency

Common Challenges in Cloud Reporting When embarking on a cloud initiative, the first use case most organizations consider is reporting and analysis. Why is that? An analytical environment deals with a lot of data. Cloud-based technologies provide scale using a…

Read on
Diving into the Data Lake

The idea is simple: instead of placing data in a purpose-built data store, you move it into a data lake in its original format. This eliminates the upfront costs of data ingestion, like transformation. Once data is placed into the…

Read on
Geographical Replication

Challenges and Solutions for Geographical Replication Still one of the most common real-time data integration scenarios is on-premises real-time reporting and Business Intelligence. Such a scenario involves one or more source databases (e.g. Oracle, SQL Server, DB2) and one target…

Read on
Data Integration Easier Than Watching TV

Whoever said watching TV rots the brain has never tried watching TV at my house. Determining which boxes to turn on, following the proper sequence, and finding a specific show or movie is a strenuous mental exercise. Memory, applied logic,…

Read on
SQL Server Replication

Forgive us, we get pretty excited about what we can do with SQL Server There are numerous options if you are looking for data replication out of and into SQL Server. One of these has been (and continues to be)…

Read on
Database Centralization

Same problem, different tools Back around the turn of the century, I worked for a client – an employment agency – who had to centralize data from multiple databases in local branches into a central database. We used Oracle 7.3.4…

Read on
1 7 8 9 10