Introduction
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.
Introduction
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.
Setting Up Progress DataDirect Hybrid Data Pipeline
- Install Hybrid Data Pipeline in your DMZ or in the cloud by following the below tutorials.
- To connect to On-Premises databases, you need to install an On-Premises agent on one of your servers behind the firewall, that lets the Hybrid Data Pipeline Server communicate with the database.
- To Install Hybrid Data Pipeline’s On-Premise Agent and configure it the cloud service where you installed Hybrid Data Pipeline Server, please follow the below tutorials.
- Also install the Hybrid Data Pipeline’s JDBC driver which can be found on the same download page of Hybrid Data Pipeline Server and On-Premise Connector. Follow this documentation to install the driver.
- Once you have everything setup, navigate to http://<server-address>:8080/d2c-ui or https://<server-address>:8443/d2c-ui to view the Hybrid Data Pipeline’s UI.
- Log in with the default credentials d2cadmin/d2cadmin
- Once you have logged in, create a New DataSource, by clicking on New Data Source button as shown below.

- You should now see list of all Data stores as shown below. Choose Oracle as your data store.

- On the Configuration, fill out all the connection parameters that you would generally use to connect to your Oracle database and set the Connector ID. The Connector ID is the ID of the On-premises connector that you have installed for this server and account in Step – 3. If you have installed and configured the On-Premise connector, you should automatically see the Connector ID In drop down.

- Now Click on Test Connection and you should now be able to connect to your Oracle database On-Premise.
- Go to OData tab and click on “Configure Schema” button. You should now see list of schema’s in your database, select the schema that you want to access via OData.
- Once you select the schema, you should now see all the tables in your schema as shown below. Select the tables that you would want to expose through OData (REST) API and click on Save button.

- Now you should be back on OData config tab. Copy the OData Access URI and click on Update button to save all the configurations.
- Paste the OData Access URI into a new tab to test it. Give your Hybrid Data Pipeline credentials when prompted for authentication and you should now see the response from the server listing your tables as shown below.
Setting Up Progress DataDirect Hybrid Data Pipeline
- Install Hybrid Data Pipeline in your DMZ or in the cloud by following the below tutorials.
- To connect to On-Premises databases, you need to install an On-Premises agent on one of your servers behind the firewall, that lets the Hybrid Data Pipeline Server communicate with the database.
- To Install Hybrid Data Pipeline’s On-Premise Agent and configure it the cloud service where you installed Hybrid Data Pipeline Server, please follow the below tutorials.
- Also install the Hybrid Data Pipeline’s JDBC driver which can be found on the same download page of Hybrid Data Pipeline Server and On-Premise Connector. Follow this documentation to install the driver.
- Once you have everything setup, navigate to http://<server-address>:8080/d2c-ui or https://<server-address>:8443/d2c-ui to view the Hybrid Data Pipeline’s UI.
- Log in with the default credentials d2cadmin/d2cadmin
- Once you have logged in, create a New DataSource, by clicking on New Data Source button as shown below.

- You should now see list of all Data stores as shown below. Choose Oracle as your data store.

- On the Configuration, fill out all the connection parameters that you would generally use to connect to your Oracle database and set the Connector ID. The Connector ID is the ID of the On-premises connector that you have installed for this server and account in Step – 3. If you have installed and configured the On-Premise connector, you should automatically see the Connector ID In drop down.

- Now Click on Test Connection and you should now be able to connect to your Oracle database On-Premise.
- Go to OData tab and click on “Configure Schema” button. You should now see list of schema’s in your database, select the schema that you want to access via OData.
- Once you select the schema, you should now see all the tables in your schema as shown below. Select the tables that you would want to expose through OData (REST) API and click on Save button.

- Now you should be back on OData config tab. Copy the OData Access URI and click on Update button to save all the configurations.
- Paste the OData Access URI into a new tab to test it. Give your Hybrid Data Pipeline credentials when prompted for authentication and you should now see the response from the server listing your tables as shown below.
Creating the Plugin for Google Sheets
Creating the Plugin for Google Sheets