Welcome!

Progress Blog

Subscribe to Progress Blog: eMailAlertsEmail Alerts
Get Progress Blog via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Related Topics: MySQL Journal, Google, cloudbigdataajaybudhraja

Blog Feed Post

Easy Alternative to VPN, SSH for Accessing On-Premises Data

Need to access data from a customer’s network for a PoC? Waiting on IT to punch a hole in the firewall? Our vendor-agnostic hybrid data gateway makes it easier.

Let’s face it, a lot of data still exists on premises. Wouldn’t it be nice to easily access that critical data from cloud services? For most organizations, it’s not that easy. SaaS adoption continues to explode. And employees demand access to data within the firewall, from anywhere, using any device.

However, sensitive data has to be stored inside a firewall and sometimes regulatory compliance requires it. To access this data from cloud services like BI tools typically involves setting up VPNs, SSH tunneling or changing the firewall configuration to expose a database port. In other words, it takes valuable time and IT resources, and could leave your company vulnerable to hacking and data breaches.

You need a simple way to bring your data together, keep it fresh and benefit from your existing legacy data sources. It’s the only way to ensure your data is comprehensive, up-to-date and secure—and that you have the full advantage when driving business forward.

Patented On-Premises Connectivity Technology: A Great Alternative to VPN, SSH

Our vendor-agnostic hybrid data gateway offers the only On-Premises Connector that provides secure, real-time access to on-premises data that works with your existing network security.

Hybrid Data Pipeline is a lightweight, self-hostable data gateway that you can run in the cloud or on-premises. Applications can securely access data in the cloud or behind the firewall without complex network/firewall configurations. You can also share data securely between data centers, even when the data centers are behind multiple firewalls.

The On-Premises Connector uses standard ODBC/JDBC data connectivity over HTTPS. Unlike VPN, SSH and other traditional solutions, our service is engineered for the cloud with a scalable architecture, access management, security and data compression. Easily connect to numerous disparate data sources for quicker integration and more comprehensive business analysis.

On-Premises Connector

Vendor-Agnostic Hybrid Data Gateway

Our vendor-agnostic solution allows you to access a wider range of data sources from any ODBC or JDBC compliant tool or application. You get a solution that meets your specific requirements without dependence on any particular application or database vendor’s product.

You can deploy Hybrid Data Pipeline on cloud servers anywhere in the world. This offers a flexible, secure strategy for cloud-based analytics and data management projects that need to access on-premises systems.

Hybrid connectivity can also accelerate cloud platform deployments because you don’t have to struggle with back-office integrations using VPN or other firewall configurations. Leading cloud platforms supported include:

  • Amazon Web Services
  • Amazon Lightsail
  • Digital Ocean
  • Google Cloud
  • Microsoft Azure
  • Oracle Cloud

The On-Premises Connector supports a wide variety of database types and the list keeps growing:

  • Amazon EMR Hive
  • Apache Hadoop (Apache Hive)
  • Cloudera CDH Hive
  • Hortonworks
  • IBM BigInsights Hive
  • MapR Hive
  • Pivotal HD Hive
  • Amazon RedShift
  • IBM DB2
  • Microsoft SQL Server
  • MySQL Community
  • MySQL Enterprise
  • Oracle
  • Pivotal Greenplum
  • PostgreSQL
  • Progress OpenEdge
  • SAP Sybase

Universal Connectivity

Along with connectivity to on-premises Hadoop Hive and SQL databases, Hybrid Data Pipeline provides standards-based, real-time access to the latest big data, NoSQL and SaaS/cloud data sources such as Salesforce, Marketo, Eloqua, Oracle Sales Cloud, Google Analytics and many more. You can also make your data accessible to analytics platforms, SaaS apps, Python, Java, JavaScript, .NET, R and SAS.

Secure and Scalable

All customer-sensitive data elements are protected by encryption, both at rest (AES-256) and in transit (SSL/TLS). You can also limit the API to throttle the number of rows returned from a single query to protect shared database resources. We also support horizontal scalability across multiple server nodes using commercial load balancers.

Easy Setup

Installation is easy with the On-Premises Connector. You simply download and install the connector on the machine that has network access to the on-premises data store. Configure the data source in Hybrid Data Pipeline, and then configure the connection to the on-premises data source. No coding. No complex configurations. No wasting IT resources.

To get started, download Hybrid Data Pipeline today.

try now for free

Read the original blog entry...

More Stories By Progress Blog

Progress offers the leading platform for developing and deploying mission-critical, cognitive-first business applications powered by machine learning and predictive analytics.