Common Challenges in Cloud Reporting

When embarking on a Cloud initiative, the first use case most organizations consider is reporting, and more and more organizations see the benefits of real-time reporting and analytics. Relative to on-premises real-time reporting, using the Cloud as a destination for real-time reporting introduces a few challenges that must be thought through in order to implement an optimum cloud integration solution.

Challenge 1: Network connectivity & Latency

The first challenge is network connectivity. Relative to an on-premises environment network bandwidth into the Cloud may be a fair amount lower, and latency is likely a lot higher. To report on the data – assuming most of the heavy lifting in computing result sets can be pushed down into the database – this is not a major concern. However to get data into the database – in real-time – this is a challenge. Remote database connections are notoriously chatty when performing data changes (DML) so such a connection won’t work well. Also, to address the challenge with limited bandwidth data should be sent across the wire in a compressed format.

To send data compressed using large block transfer is the best approach to optimize network utilization.

Challenge 2: Data security

The second challenge is data security. Many organizations, especially smaller ones, will not set up a virtual private connection. As a result data will be sent across the internet, and unless encrypted the data may be readable by malicious programming code. Encryption takes extra CPU resources on the source (to encrypt) and on the destination (to decrypt) but for optimum security data should always be sent encrypted into the Cloud.

How we help our customers overcome these challenges:

The best practice architecture we employ in the Cloud is using an HVR installation as close as possible to the destination database. With that, the technology can address both challenges for network utilization in the Cloud: data compression and large block transfers are default, and encryption is easy to set up.

Read more about HVR’s integration for Amazon Web Services (AWS) and Microsoft Azure.

Want to learn more about Hybrid Cloud Computing? Download our solution brief to learn about typical cloud use cases, challenges, and more.

About Mark

Mark Van de Wiel is the CTO for HVR. He has a strong background in data replication as well as real-time Business Intelligence and analytics.

© 2019 HVR

Try now Contact us