Deploying Hybrid Data Pipeline on DigitalOcean

What is Hybrid Data Pipeline?

Progress DataDirect Hybrid Data Pipeline isan innovative data access service for enterprises and cloud ISVs that is designed to simplify and streamline data integration between cloud, mobile, and on-premises sources through a secure, firewall-friendly integration. It is a transformative technology, abstracting away the complexity that has inevitably followed the recent explosion of data.

This technology allows developers to build data-centric, easily manageable applications faster than ever before. SaaS ISVs can drive new wins through integration with customers’ legacy applications and data. IT can immediately provide a plug-and-play solution that extends the reach of BI and ETL, RESTify any database to improve developer productivity, and accelerate the delivery of exciting new services.

You can deploy Hybrid Data Pipeline on your servers anywhere in the world, and with explosion in the use of cloud computing platforms like Azure, AWS etc., we put together this tutorial to help you deploy Hybrid Data Pipeline on DigitalOcean.

Back to top

Setting up VM in DigitalOcean

Setting up VM in DigitalOcean:

To get started, you would need an DigitalOcean account and if you don’t have one register here and login into the portal.

Once you have logged into the portal, create a new CentOS 6.8x64 Droplet.

Choose the type of installation when prompted for. If you are trying the Hybrid Data Pipeline, choose Evaluation as your option. If you have purchased a license, choose Licensed installation and enter your license key number to proceed further.

Fig: Hybrid Data Pipeline – Installation License Type

When the installer asks you to enter the hostname for your server, enter the IP address of the Droplet.

Fig: Hybrid Data Pipeline – Hostname configuration

The installer tries to validate hostname, but it will fail. Ignore the validation and proceed ahead with the installation.

Fig: Hybrid Data Pipeline – Hostname validation

When installer prompts for a SSL certificate File, select No to use the self-signed trust store that is included with the installation. If you have an SSL Certificate file that you want to use, you can provide path to that instead of using the certificate that comes with installer, by selecting Yes.

Fig: Hybrid Data Pipeline – SSL Certificate configuration

To use default settings, you can choose Typical installation (1), but if you want to configure the installation with your own settings, choose custom installation (2).

Fig: Hybrid Data Pipeline – Installation Type

Next, you should see Ready to Install information with all the configurations that you have made. Press ENTER to install Hybrid Data Pipeline with those settings.

After the installation is complete, you will see an Install Complete message. To exit the installer, press ENTER.

Fig: Hybrid Data Pipeline – Installation Complete

Before starting the Hybrid Data Pipeline server, we should configure the VM firewall to accept connections on 8080/8443 ports that the server uses for providing the services. Note that 8080 is for HTTP and 8443 is for HTTPS.

To configure the firewall on CentOS 6.8 to accept connections on 8080, 8443 ports, run the following commands

sudo iptables -I INPUT -p tcp -m tcp --dport 8080 -j ACCEPT

sudo iptables -I INPUT -p tcp -m tcp --dport 8443 -j ACCEPT

sudo service iptables save

Now test if the ports are open from a local machine by opening your terminal and running the command. If you are not able to connect, please make sure that you have properly configured the firewall by going through steps 9 - 10.

telnet <IP Address> 8443

Restart the Droplet using the following command:

sudo shutdown -r now

Back to top

Starting Hybrid Data Pipeline Server

Starting Hybrid Data Pipeline Server:

Now that we have installed and configured everything for Hybrid Data Pipeline to run properly, it’s time to start the server.

Login on to Droplet through SSH and run the following commands to start Hybrid Data Pipeline server

Open your browser and browse to https://ip.address:8443, which opens the Hybrid Data Pipeline Login screen. Use d2cadmin/d2cadmin as username and password to login into Hybrid Data Pipeline Dashboard. Following are couple of screenshots of Hybrid Data Pipeline for your reference.

Fig: Login Screen for Progress DataDirect Hybrid Data Pipeline

Fig: Data Stores supported in Hybrid Data Pipeline

Back to top

Congratulations

Now that you have successfully deployed the world’s advanced Hybrid data access solution, feel free to configure your data sources in Hybrid Data pipeline, and integrate the data in your applications using the Hybrid Data Pipeline’s standards based ODBC, JDBC connectivity or using its REST API, one of the most advanced OData standard’s API.

Note that trial is valid for 90 days, and you will have complete access to use any of the data stores. To learn more about Progress DataDirect Hybrid Data Pipeline, you can visit this page or watch this short video overview.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.