Combining on-premises data with cloud technologies almost always raises immediate concerns about security, but the DataDirect Hybrid Data Pipeline lets you securely access data behind any firewall without the requirement to make complex network configurations such as SSH tunnels, reverse proxies or VPNs.
In this tutorial, you'll learn how to easily extract your on-premises Oracle data to Google Sheets using Progress Hybrid Data Pipeline and Google App Scripts. We will be using OData(REST) generated by Progress Hybrid Data Pipeline service to load the data to Google Sheets.