Open Hybrid Data Pipeline and create a data source

Open the Hybrid Data Pipeline Web UI

To open the Web UI, enter the URL of your Hybrid Data Pipeline server in your browser. Then, provide either the d2cadmin or d2cuser credentials.

The URL you provide depends on whether you are using a public DNS defined as a CNAME or the Public IPv4 DNS associated with your EC2 instance. In each case, the URL must end with the hdpui path.

CNAME

The following example shows a URL that uses a public DNS defined as a CNAME, where the CNAME is example.hybridpipe.com.

https://example.hybridpipe.com/hdpui

EC2 Public IPv4 DNS

The following example shows a URL that uses the Public IPv4 DNS associated with your EC2 instance, where the Public IPv4 DNS is ec2-user@ec2-12-34-56-78.compute-1.amazonaws.com and 8443 is the EC2 port listening for connections to the service.

https://ec2-user@ec2-12-34-56-78.compute-1.amazonaws.com:8443/hdpui

Result

After successfully logging in, you may proceed with creating tenants, users, and data sources. Refer to Using the Web UI for an overview of the features available through the Web UI.

Create and connect to a data source

Hybrid Data Pipeline provides connectivity to a wide range of data sources.

• Supports connectivity to over twenty relational and non-relational database management systems. For a list of supported data stores, refer to Supported data stores.
• Supports connectivity to REST sources with a built-in Autonomous REST Connector. For details, refer to Creating and using REST data sources.
• Supports the integration of third party JDBC drivers. For details, refer to Using third party JDBC drivers.

Take the following steps to create a Hybrid Data Pipeline data source.

1. From the Hybrid Data Pipeline Web UI, navigate to the Data Sources view by clicking the data sources icon .
2. Click + NEW DATA SOURCE to open the Data Stores page.
3. From the list of data stores, click data store to which you want to connect.
   Note:

   • To connect to REST sources, click Progress REST (Autonomous REST Connector).
   • To connect to a data source using a third party JDBC driver, click JDBC. Note that the third party JDBC driver must first be integrated with the Hybrid Data Pipeline service as described in Using third party JDBC drivers.
4. Define the data source by providing values for the parameters under each tab.
   Note:

   • If you are connecting to data sources behind a firewall, the On-Premises Connector must first be installed and configured on a machine that resides on the same network as the data store. See Connect to an on-premises data source for details.
   • You may expose any data source as an OData endpoint by providing parameter information on the OData tab. The OData Access URI field is automatically populated. After creating your data source, OData queries can be made to this URI. See Configure data sources for OData connectivity for details.
5. Click Save to create the data source definition.
6. Click TEST to establish a connection with the data store.

Result

You have created a data source and connected to a backend data store using Hybrid Data Pipeline. For more information on managing data sources, refer to Editing, deleting, sharing, and testing data sources with the Web UI.