Integrating Hybrid Data Pipeline as a client application with an OAuth 2.0 grant flow

Hybrid Data Pipeline may be integrated as a client application into an OAuth 2.0 grant flow with the following data stores: REST data stores (via the Autonomous REST Connector), Google Analytics, Google BigQuery, Microsoft Dynamics 365 apps, Salesforce-based data stores, and Snowflake. The authorization code grant type is generally supported for all these data stores. Additional grant types are supported for a number of data stores as described in OAuth 2.0 grant type support. There are two methods for integrating Hybrid Data Pipeline into an OAuth 2.0 grant flow. You can integrate Hybrid Data Pipeline into an OAuth 2.0 grant flow either by creating OAuth application and profile objects, or by specifying OAuth parameters directly when creating the data source.

Creating OAuth application and profile objects

Data access may be provided by creating OAuth application and profile objects. This method is only supported for the authorization code grant. It maintains the authorization code grant's separation between the application verification process and the consent process. On the one hand, the application object holds the authorization URI, token URI, client ID, client secret, and scope. On the other hand, the profile object holds the access and refresh tokens provided by the data store upon consent. The following workflow describes this implementation.

  1. Administrator registers Hybrid Data Pipeline as a client application with the data store service.
  2. Administrator creates the OAuth application object.
  3. At the administrator's discretion, an administrator or standard user creates the OAuth profile object.
  4. When creating the Hybrid Data Pipeline data source, the user specifies the required OAuth application and profile objects.

Specifying OAuth parameters when creating the data source

Data access may be provided by entering OAuth information during the configuration of the Hybrid Data Pipeline data source. In this case, the user creating the data source must provide all the information required by the OAuth grant type. This may include the authorization URI, token URI, client ID, client secret, and scope, as well as access and refresh tokens. This information is all held in the data source definition. This implementation involves two general steps.

  1. Administrator registers Hybrid Data Pipeline as a client application with the data store service.
  2. When creating the Hybrid Data Pipeline data source, the user specifies OAuth parameters directly in the data source definition.
Note: Specifying parameters directly in a data source is not currently supported for Google Analytics. Therefore, an OAuth 2.0 connection to Google Analytics must be implemented by creating OAuth application and profile objects.