1. Connectivity and Knowledge Modules Guide for Oracle Data Integrator
  2. Applications
  3. Other Applications

38 Other Applications

Oracle Data Integrator includes support for applications that use drivers from Progress and generic JDBC drivers.

This chapter includes the following section:

38.1 Supported Applications

This topic lists the applications that are additionally supported in Oracle Data Integrator.

In the following table you can find details about each supported application such as the supported versions, whether it supports write operation, the JDBC URL templates that are available for each application along with the additional properties that can be used in the JDBC URL.
Name Supported Version Supports Write Operation Connection URL Examples Notes
Aha! Any No

  • jdbc:weblogic:aha://servername;[property=value[;...]];

  • jdbc:weblogic:aha:servername;AuthenticationMethod=UrlParameter;SecurityToken=security_token;[property=value[;...]];

    where SecurityToken specifies the security token required to make a connection to your endpoint.

  • jdbc:weblogic:aha:servername;AuthenticationMethod=OAuth2;AccessToken=access_token;[property=value[;...]];

    where AccessToken specifies the access token required to authenticate to a REST service.

  • jdbc:weblogic:aha:servername;AuthenticationMethod=OAuth2;oauthCode=auth_code;ClientID=client_id;ClientSecret=client_secret;RedirectURI=redirect_uri;[property=value[;...]];

    where ClientID specifies the client ID key for your application. ClientSecret specifies the client secret for your application, and RedirectURI specifies the endpoint that the client is returned to after authenticating with a third-party service. Note that the value of the RedirectURI property must include the port number. For example, RedirectURI=http://localhost:80 or RedirectURI=http://localhost:8080.

  • jdbc:weblogic:aha:servername;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;AuthenticationMethod=method;[property=value[;...]];
Ahrefs Any No

  • jdbc:weblogic:autorest://servername;[property=value[;...]]

  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];

  • jdbc:weblogic:autorest:ServerName=https://apiv2.ahrefs.com;AuthenticationMethod=URLParameter;SecurityToken=xxxxxxxx;AuthParam=token;

    where SecurityToken specifies the security token required to make a connection to your endpoint and AuthParam specifies the name of the URL parameter used to pass the security token.

Azure Billing Any No

  • jdbc:weblogic:autorest://servername;[property=value[;...]]

  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
Azure Resource Health Any No

  • jdbc:weblogic:autorest://servername;[property=value[;...]]

  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];

  • jdbc:weblogic:autorest:ServerName=https://management.azure.com;AuthenticationMethod=OAuth2;TenantId=xxxxxxxx;ClientID=xxxxxxxx;ClientSecret=xxxxxxxx;AccessToken=xxxxxxxx;RefreshToken=xxxxxxxx;Scope=https://management.azure.com/.default offline_access;TokenURI=https://login.microsoftonline.com/{tenantId}/oauth2/token;RedirectURI=http://localhost/;
BigCommerce Any No

  • jdbc:weblogic:autorest://servername;[property=value[;...]]

  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];

  • jdbc: weblogic:autorest:servername=https://api.bigcommerce.com/stores/{store_hash};authenticationmethod=HTTPHeader;securitytoken=**************;authheader=X-Auth-Token;

    where SecurityToken specifies the security token required to make a connection to your endpoint.

DataStax 3 Yes

jdbc:weblogic:cassandra://server:port;KeyspaceName=keyspace;[property=value[;...]]

where KeyspaceName specifies the default name of the Cassandra keyspace to which the driver connects.

Apache Cassandra 3.0 and higher
eBay Any No

  • jdbc:weblogic:autorest://servername;[property=value[;...]]

  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];

  • jdbc:weblogic:autorest:ServerName=https://api.eBay.com;AuthenticationMethod=OAuth2;ClientID=client_id;ClientSecret=xxxxxxxx;AccessToken=xxxxxxxx;RefreshToken=xxxxxxxx;Scope=https://api.eBay.com/oauth/api_scopeTokenURI=https://api.eBay.com/identity/v1/oauth2/tokenRedirectURI=http://localhost/;

    where ClientID specifies the client ID key for your application, ClientSecret specifies the client secret for your application, AccessToken and RefreshToken specify the tokens that you can use to implement OAuth 2.0, Scope specifies a space-separated list of OAuth scopes to limit the permissions granted by the access token., TokenURI specifies the endpoint used to exchange authentication credentials for access tokens, and RedirectURI specifies.

FinancialForce Any Yes

jdbc:weblogic:sforce://servername;SecurityToken=value[;property=value[;...]]

where SecurityToken specifies the security token required to make a connection to an instance that is configured for a security token.

 
FourSquare Any No

  • jdbc:weblogic:autorest://servername;[property=value[;...]]

  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];

  • jdbc:weblogic:autorest:servername=https://api.foursquare.com;authenticationmethod=URLParameter;securitytoken=**********;authparam=oauth_token;
Generic Rest Config Any No -
GitHub Any No

  • jdbc:weblogic:github:ServerName=server_name;SecurityToken=security_token;[property=value[;...]];

  • jdbc:weblogic:github:ServerName=server_name;AuthenticationMethod=Basic;[property=value[;...]];

  • jdbc:weblogic:github:ServerName=server_name;AuthenticationMethod=OAuth2;AccessToken=access_token;[property=value[;...]];

  • jdbc:weblogic:github:ServerName=server_name;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;AuthenticationMethod=OAuth2;AccessToken=access_token;[property=value[;...]];
Google AdSense Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://adsense.googleapis.com/v2;clientId=***********;clientSecret=**************;authUri=https://accounts.google.com/o/oauth2/auth;tokenUri=https://oauth2.googleapis.com/token;redirectUri=http://localhost;authenticationMethod=OAuth2;scope=https://www.googleapis.com/auth/adsense;refreshtoken=**************;
Google Analytics 3+ No
  • jdbc:weblogic:googleanalytics:AccessToken=access_token;[property=value[;...]];
  • jdbc:weblogic:googleanalytics:RefreshToken=refresh_token;[property=value[;...]];
  • jdbc:weblogic:googleanalytics:ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;RefreshToken=refresh_token;[property=value[;...]];
 Google Analytics Management API Version 3
Google Calendar Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://www.googleapis.com/calendar/v3;clientId=************;clientSecret=**************;authUri=https://accounts.google.com/o/oauth2/auth;tokenUri=https://accounts.google.com/o/oauth2/token;redirectUri=http://localhost;AuthenticationMethod=OAuth2;scope=https://www.googleapis.com/auth/calendar https://www.googleapis.com/auth/calendar.readonly https://www.googleapis.com/auth/calendar.events https://www.googleapis.com/auth/calendar.events.readonly https://www.googleapis.com/auth/calendar.settings.readonly https://www.googleapis.com/auth/calendar.addons.execute;authuri=https://accounts.google.com/o/oauth2/auth;tokenuri=https://accounts.google.com/o/oauth2/token;refreshtoken=**************;
Google Campaign Manager Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
Google Contacts Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=people.googleapis.com/v1;clientId=*********;clientSecret=**************;authUri=https://accounts.google.com/o/oauth2/auth;tokenUri=https://accounts.google.com/o/oauth2/token;redirectUri=http://localhost;authenticationMethod=OAuth2;scope=https://www.googleapis.com/auth/contacts.other.readonly;refreshtoken=**************;
Google Search Ads 360 Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://www.googleapis.com/doubleclicksearch/;clientId=**********,clientSecret=**************,authUri=https://accounts.google.com/o/oauth2/auth,tokenUri=https://oauth2.googleapis.com/token,redirectUri=http://localhost,authenticationMethod=OAuth2,scope=https://www.googleapis.com/auth/doubleclicksearch,refreshtoken=**************;
HubSpot Any No jdbc:weblogic:hubspot:AuthenticationMethod=OAuth2;ClientID=client_id;ClientSecret=client_secret;RefreshToken=refresh_token;Scope=scope;[property=value[;...]];
Jira Any No jdbc:weblogic:jira:servername;[property=value[;...]];
Klaviyo Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://a.klaviyo.com/api;authenticationmethod=URLParameter;securitytoken=*****;authparam=api_key;
Mailchimp Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=us20.api.mailchimp.com;authenticationmethod=BearerToken;securitytoken=*******;
Marketo Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://{api_id}.mktorest.com;authenticationmethod=OAuth2;clientid=*********;clientsecret=******************;tokenuri=https://{api_id}.mktorest.com/identity/oauth/token;
Microsoft Dynamics 365 Any Yes
  • jdbc:weblogic:dynamics365:ServiceURL=serviceurl;AuthenticationMethod=method;AccessToken=access_token;[property=value[;...]];
  • jdbc:weblogic:dynamics365:ServiceURL=serviceurl;AuthenticationMethod=method;ClientID=client_id;ClientSecret=client_secret;TokenURI=POST token_uri;Scope=scope;[property=value[;...]];
  • jdbc:weblogic:dynamics365:ServiceURL=serviceurl;AuthenticationMethod=method;ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri;RefreshToken=refresh_token;[property=value[;...]];
  • jdbc:weblogic:dynamics365:ServiceURL=serviceurl;AuthenticationMethod=method;NTLMDomain=domain;[property=value[;...]];
  • jdbc:weblogic:dynamics365:ServiceURL=serviceurl;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;AuthenticationMethod=method;ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri;RefreshToken=refresh_token;[property=value[;...]];
 CRM Apps, Customer Service, Field Service, Marketing, Project Service Automation, Sales, ERP Apps, Finance, Human Resources, Retail, Supply Chain Management
Microsoft SharePoint Any Yes
  • jdbc:weblogic:sharepoint:ServiceURL=serviceurl;AccessToken=access_token;[property=value[;...]];
  • jdbc:weblogic:sharepoint:ServiceURL=serviceurl;ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri;RefreshToken=refresh_token;[property=value[;...]];
  • jdbc:weblogic:sharepoint:ServiceURL=serviceurl;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri;RefreshToken=refresh_token;[property=value[;...]];
 SharePoint Online lists
Oracle BI Cloud Connector Any No
Oracle Marketing Cloud Any Yes jdbc:weblogic:eloqua:Company=<company_id>;[;property=value[;...]]
Oracle Sales Cloud Any No jdbc:weblogic:oraclesalescloud://base_url;[;property=value[;...]]
Oracle Service Cloud Any No jdbc:weblogic:oracleservicecloud:loginHost=host;[property=value[;...]]
PayPal Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:ServerName=https://api-m.sandbox.paypal.com;AuthenticationMethod=Basic;
Qmetry Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://qtmcloud.qmetry.com;authenticationmethod=URLParameter;securitytoken=*****;authparam=apiKey;
QuickBooks Online Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://sandbox-quickbooks.api.intuit.com/v3/company/*******************;clientId=*******;clientSecret=*******;authUri=https://appcenter.intuit.com/connect/oauth2;tokenUri=https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer;redirectUri=http://localhost;authenticationMethod=OAuth2;efreshtoken=**************;
QuickBooks Payments Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://sandbox.api.intuit.com;clientId=*********;clientSecret=**************;authUri=https://appcenter.intuit.com/connect/oauth2;tokenUri=https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer;redirectUri=http://localhost;authenticationMethod=OAuth2;scope=com.intuit.quickbooks.payment;refreshtoken=**************;
Quora Ads Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:ServerName=api.quora.com/ads;AuthenticationMethod=OAuth2;ClientID=xxxxxxxx;ClientSecret=xxxxxxxx;AccessToken=xxxxxxxx;Scope=ads_read;
Sage Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=api.accounting.sage.com;clientId=************,clientSecret=**************,authUri=https://www.sageone.com/oauth2/auth/central?filter=apiv3.1,tokenUri=https://oauth.accounting.sage.com/token,redirectUri=http://localhost,AuthenticationMethod=OAuth2,scope=full_access,refreshtoken=**************;
Salesforce Chatter Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=progresscom4-dev-ed.my.salesforce.com/services/data/v52.0;authenticationmethod=OAuth2;clientid=********;clientsecret=**************;refreshtoken=**************;scope=<scope>;authuri=https://login.salesforce.com/services/oauth2/authorize;tokenuri=https://login.salesforce.com/services/oauth2/token;
SAP HANA Any No
  • jdbc:weblogic:saphana://server_name:port_number;[property=value[;...]];
  • jdbc:weblogic:saphana://server_name:port_number;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;[property=value[;...]];
SAP S/4HANA Cloud 2005+ No
  • jdbc:weblogic:s4hana:ServerName=servername;[property=value[;...]];
  • jdbc:weblogic:s4hana:ServerName=servername;AuthenticationMethod=HttpHeader;AuthHeader=api_key;SecurityToken=security_token;[property=value[;...]];
  • jdbc:weblogic:s4hana:ServerName=servername;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;[property=value[;...]];
  
Semrush Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
ServiceNow Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=instance.service-now.com/api;clientId=****;clientSecret=****;authUri=https://instance.service-now.com/oauth_auth.do;tokenUri=https://instance.service-now.com/oauth_token.do;redirectUri=http://localhost;authenticationMethod=OAuth2;refreshtoken=****;
Square Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=sandbox.api.intuit.com;authenticationMethod=BearerToken;securitytoken=**************************;
Stripe Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://api.stripe.com;authenticationmethod=BearerToken;securitytoken=*********;
TeamCity Any No
  • jdbc:weblogic:teamcity:ServerName=server_name;[property=value[;...]];
  • jdbc:weblogic:teamcity:ServerName=server_name;AuthenticationMethod=BearerToken;SecurityToken=security_token;[property=value[;...]];
  • jdbc:weblogic:teamcity:ServerName=server_name;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;AuthenticationMethod=BearerToken;SecurityToken=security_token;[property=value[;...]];
Tumblr No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
Veeva CRM Any Yes jdbc:weblogic:sforce://servername;SecurityToken=value[;property=value[;...]]
Volusion Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
Wistia Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://api.wistia.com;authenticationmethod=Basic;
WordPress Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=public-api.wordpress.com/rest/v1.1;authenticationmethod=OAuth2;clientid=*****;clientsecret=*********;accesstoken=**********;scope=global;oauthcode=**********;authuri=https://public-api.wordpress.com/oauth2/authorize;tokenuri=https://public-api.wordpress.com/oauth2/token;
X Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
Xero Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
Yelp Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://api.yelp.com/v3;authenticationmethod=BearerToken;securitytoken=*****;
Zendesk Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://example.zendesk.com;authenticationmethod=OAuth2;clientid=client_id_zendesk;clientsecret=********;scope={{scope}};authuri=/oauth/authorizations/new;tokenuri=/oauth/tokens;
  • jdbc:weblogic:autorest:servername=https://example.zendesk.com;authenticationmethod=Basic;
Zoho CRM Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:authenticationmethod=OAuth2;clientid=a1234bc567d89e01f23g;clientsecret=******************;scope=ZohoCRM.settings.ALL,ZohoCRM.modules.ALL,ZohoCRM.notifications.ALL,ZohoCRM.org.READ,ZohoCRM.users.READ,ZohoCRM.settings.roles.READ,ZohoCRM.settings.profiles.READ,ZohoCRM.modules.Contacts.READ,ZohoSearch.securesearch.READ;authuri=https://accounts.zoho.com/oauth/v2/auth;tokenuri=https://accounts.zoho.com/oauth/v2/token;redirecturi=http://localhost;refreshToken=********************;
Zoom No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • jdbc:weblogic:autorest:servername=https://api.zoom.us/v2;clientId=*****;clientSecret=****;authUri=https://zoom.us/oauth/authorize;tokenUri=https://zoom.us/oauth/token;redirectUri=http://localhost;authenticationMethod=OAuth2;accesstoken=*****;