5.2 Supported Connection Types
This topic lists the connection types that are supported for connecting to Data Transforms.
Government cloud regions are required to support FIPS compliance standards for data protection. Data Transforms in Government realms is FIPS 140-2 Level 1 compliant. Make sure the connections sources are FIPS compliant to ensure secure communication between the servers.
Note:
APPLIES TO:
Data Transforms that is available as a separate listing on Marketplace called Data Integrator: Web Edition.- For the connectors that require driver installation, you
need to copy the jar files to the
/u01/oracle/transforms_home/userlibsdirectory before you add the connection. - Apart from the connection types listed here you can create custom connectors, which you can use to connect Data Transforms to any JDBC supported data sources. See Create Custom Connectors.
| Name | Type | Supported in Data Integrator: Web Edition | Supported in Data Transforms built into Autonomous Database | Supported in Data Transforms built into OCI GoldenGate | Supports Write Operation | Connection URL Examples | Notes |
|---|---|---|---|---|---|---|---|
| Aha! | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://{yourdomain}.aha.io;
AuthenticationMethod=OAuth2;
clientid=**********;clientsecret=*************;
authuri=https://{yourdomain}.aha.io/oauth/authorize;
tokenuri=https://{yourdomain}.aha.io/oauth/token;
redirectUri=http://localhost; |
|
| Ahrefs | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:ServerName=https://apiv2.ahrefs.com;AuthenticationMethod=URLParameter;SecurityToken=xxxxxxxx;AuthParam=token; |
|
| Amazon Aurora | Database | Yes | Yes | Yes | Yes |
|
|
| Amazon EMR Hive | Database | Yes | Yes | Yes | No |
|
|
| Amazon Redshift | Database | Yes | Yes | Yes | Yes | jdbc:weblogic:redshift://server_name:port_number;DatabaseName=database_name;[property=value[;...]];
User: [Mandatory] Password: [Mandatory] |
|
| Apache Hive | Database | Yes | Yes | Yes | No |
|
|
| Apache Impala | Database | Yes | Yes | Yes | No |
|
|
| Apache Spark SQL | Database | Yes | Yes | Yes | No |
|
|
| AWS S3 | Database | Yes | Yes | Yes | No | jdbc:weblogic:autorest:AuthenticationMethod=AWS;servicename=s3;accesskey=*******;secretkey=*******; |
|
| Azure Billing | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
|
| Azure Compute | Database | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]] |
|
| Azure Data Lake Storage | Database | Yes | Yes | Yes | No | jdbc:weblogic:autorest:
ServerName=https://{accountName}.dfs.core.windows.net;AuthenticationMethod=OAuth2;ClientID=xxxxxxxx;ClientSecret=xxxxxxxx;
RefreshToken=xxxxxxxx;Scope=https://storage.azure.com/user_impersonation
offline_access;TokenURI=https://login.microsoftonline.com/{tenantID}/oauth2/v2.0/token;AuthorizationURI=https://login.microsoftonline.com/{tenantID}/oauth2/v2.0/authorize;RedirectURI:
http://localhost; |
|
| Azure Reserved VM Instances | Database | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
|
| Azure Resource Health | Application | Yes | Yes | Yes | No | 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/; |
|
| Azure SQL Database | Database | Yes | Yes | Yes | Yes |
|
|
| Azure Synapse Analytics | Database | Yes | Yes | Yes | Yes |
|
|
| BigCommerce | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://api.bigcommerce.com/stores/{store_hash};AuthenticationMethod=HTTPHeader;securitytoken=**************;authheader=X-Auth-Token; |
|
| Cassandra | Database | Yes | Yes | Yes | Yes |
|
|
| Cloudera CDH Hive | Database | Yes | Yes | Yes | No |
|
|
| Confluence Cloud | Database | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://<your-domain.atlassian.net>;authenticationmethod=Basic; |
|
| Data Transforms | Service | Yes | Yes | Yes | No | - | For instructions on connecting to an existing Data Transforms instance, see Create a Data Transforms Connection for Remote Data Load. |
| DataStax | Application | Yes | Yes | Yes | Yes |
|
where |
| Delta Share | Application | Yes | Yes | Yes | No | - | For instructions on creating a connection using Delta Share, see Create a Delta Share Connection |
| DocuSign | Database | Yes | Yes | Yes | No |
|
|
| eBay | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:ServerName=https://api.eBay.com;AuthenticationMethod=OAuth2;ClientID=NameHere-APIUserA-BCD-1234e5f6g-h7i8j890;ClientSecret=xxxxxxxx;AccessToken=xxxxxxxx;RefreshToken=xxxxxxxx;Scope=https://api.eBay.com/oauth/api_scopeTokenURI=https://api.eBay.com/identity/v1/oauth2/tokenRedirectURI=http://localhost/; |
|
| EnterpriseDB | Database | Yes | Yes | Yes | Yes |
|
|
| FinancialForce | Application | Yes | Yes | Yes | Yes |
|
|
| FourSquare | Application | Yes | Yes | Yes | No |
|
|
| Generic Rest | Application | Yes | Yes | Yes | No | - | For information about connecting to any REST service endpoint to create a connection, see Create a REST Server Connection. |
| Generic Rest Config | Application | Yes | No | No | No | jdbc:weblogic:autorest:
ServerName=https://{accountName}.dfs.core.windows.net;AuthenticationMethod=OAuth2;ClientID=xxxxxxxx;ClientSecret=xxxxxxxx;
RefreshToken=xxxxxxxx;Scope=https://storage.azure.com/user_impersonation
offline_access;TokenURI=https://login.microsoftonline.com/{tenantID}/oauth2/v2.0/token;AuthorizationURI=https://login.microsoftonline.com/{tenantID}/oauth2/v2.0/authorize;RedirectURI:
http://localhost; |
For information about connecting to any REST service endpoint to create a connection, see Create a REST Server Connection. |
| GitHub | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:clientId=123a4b567c8901234567d8901e234fg5;clientSecret=**************;authUri=https://github.com/login/oauth/authorize;AuthenticationMethod=OAuth2;
tokenUri=https://github.com/login/oauth/access_token;redirectUri=http://localhost;authenticationMethod=OAuth2;refreshtoken=**************; |
|
| Google Ads | Application | Yes | No | No | Depends on the driver | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
Requires driver installation |
| Google AdSense | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://adsense.googleapis.com/v2;clientId=123456789012-abc123def456ghi789jkl012mno345pq.apps.googleusercontent.com;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 | Application | Yes | Yes | Yes | No |
|
|
| Google BigQuery | Database | Yes | Yes | Yes | No |
|
|
| Google Calendar | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://www.googleapis.com/calendar/v3;
clientId=123456789012-abc123def456ghi789jkl012mno345pq.apps.googleusercontent.com;
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.eventshttps://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 | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
|
| Google Contacts | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=people.googleapis.com/v1;
clientId=123456789012-abc123def456ghi789jkl012mno345pq.apps.googleusercontent.com;
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
https://www.googleapis.com/auth/contactshttps://www.googleapis.com/auth/contacts.readonly
https://www.googleapis.com/auth/directory.readonlyhttps://www.googleapis.com/auth/profile.agerange.read
https://www.googleapis.com/auth/profile.emails.readhttps://www.googleapis.com/auth/profile.language.read
https://www.googleapis.com/auth/user.addresses.readhttps://www.googleapis.com/auth/user.birthday.read
https://www.googleapis.com/auth/user.emails.readhttps://www.googleapis.com/auth/user.gender.read
https://www.googleapis.com/auth/user.organization.readhttps://www.googleapis.com/auth/user.phonenumbers.read
https://www.googleapis.com/auth/userinfo.emailhttps://www.googleapis.com/auth/userinfo.profile;
refreshtoken: **************; |
|
| Google Drive | Database | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://www.googleapis.com/drive/v3;
clientId=123456789012-abc123def456ghi789jkl.apps.googleusercontent.com;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/drive;
refreshtoken=**************; |
|
| Google Search Ads 360 | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://www.googleapis.com/doubleclicksearch/;
clientId:
372185870949-v1f1h94mvnad4hkajr4tonlia51vtj2n.apps.googleusercontent.com;
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:
**************; |
|
| Greenplum | Database | Yes | Yes | Yes | No |
|
|
| Hortonworks Hive | Database | Yes | Yes | Yes | No |
|
|
| HubSpot | Application | Yes | Yes | Yes | No | jdbc:weblogic:hubspot:AuthenticationMethod=OAuth2;ClientID=<CLIENT_ID>;ClientSecret=<CLIENT_SECRET>;AccessToken=<ACCESS_TOKEN>; |
|
| Hypersonic SQL | Database | Yes | Yes | Yes | Yes | jdbc:hsqldb:hsql://<host>:<port>;[property=value[;...]]; |
|
| IBM BigInsights | Database | Yes | Yes | Yes | No |
|
|
| IBM DB2 Hosted | Database | Yes | Yes | Yes | Yes |
|
|
| IBM DB2 UDB | Database | Yes | Yes | Yes | Yes |
|
|
| IBM DB2 Warehouse | Database | Yes | Yes | Yes | Yes |
|
|
| IBM DB2/400 | Database | Yes | Yes | Yes | Yes |
|
|
| Informix | Database | Yes | Yes | Yes | No | jdbc:weblogic:informix://servername:port;InformixServer=informixserver;Database=databasename;[property=value[;...]];
User: [Mandatory] Password: [Mandatory] |
|
| Jira | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://your-domain.atlassian.net;AuthenticationMethod=Basic; |
|
| Klaviyo | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://a.klaviyo.com/api;AuthenticationMethod=URLParameter;securitytoken=*****;authparam=api_key; |
|
| Magento | Application | Yes | No | No | Depends on the driver | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
Requires driver installation |
| Mailchimp | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=us20.api.mailchimp.com;AuthenticationMethod=BearerToken;securitytoken=*******; |
|
| MapR Hive | Database | Yes | Yes | Yes | No |
|
|
| Marketo | Application | Yes | Yes | Yes | No |
|
|
| Microsoft Dynamics 365 | Application | Yes | Yes | Yes | Yes |
|
|
| Microsoft SharePoint | Application | Yes | Yes | Yes | Yes | jdbc:weblogic:sharepoint:ServiceURL=serviceurl;
AuthenticationMethod=Basic;ClientID=client_id;
ClientSecret=client_secret;TokenURI=token_uri;RefreshToken=refresh_token;
[property=value[;...]]; User: [Ignored] Password:
[Ignored] |
|
| Microsoft SQL Server | Database | Yes | Yes | Yes | Yes |
|
|
| Mongo DB | Database | Yes | Yes | Yes | Yes |
|
|
| MySQL | Database | Yes | Yes | Yes | Yes | jdbc:mysql://<hostname>:<port>/<database>?<properties> |
Make sure that the system variable property
sql_require_primary_key is set to OFF.
Otherwise, an ADW to MySQL mapping could fail with a “Table does not
exist” error.
|
| MySQL Heatwave | Database | Yes | Yes | Yes | Yes | jdbc:mysql://<hostname>:<port>/<database>?<properties> |
If MySQL Heatwave database is created with high availability, then write operation is not supported. Make sure that the system variable property
|
| Netezza | Database | Yes | No | No | Depends on the driver | - | Oracle Data Transforms uses the Netezza JDBC to
connect to a NCR Netezza database. This driver must be installed in
your Data Transforms userlibs directory. You
can download the Netezza JDBC driver from the IBM website.
|
| Oracle | Database | Yes | Yes | Yes | Yes |
|
For Data Integrator Web Edition, write operation is supported only on Oracle cloud database targets. For details refer to the Oracle terms of use before deploying the image from OCI marketplace. |
| Oracle Analytics Cloud | Application | Yes | Yes | Yes | No | - | |
| Oracle Business Intelligence Cloud (BICC) Connector | Application | Yes | Yes | Yes | No | - | For information about creating a connection using Oracle Business Intelligence Cloud (BICC) Connector, see Create an Oracle Business Intelligence Cloud Connector Connection. |
| Oracle EBS | Application | Yes | Yes | Yes | Yes | jdbc:oracle:thin:@<host>:<port>:<sid> |
|
| Oracle Financials Cloud | Application | Yes | Yes | Yes | No | - | For information about creating a connection using Oracle Financials Cloud, see Create an Oracle Financials Cloud Connection. |
| Oracle Fusion ERP | Application | Yes | Yes | Yes | No | - | |
| Oracle Fusion Sales | Application | Yes | Yes | Yes | No | - | |
| Oracle Fusion Service | Application | Yes | Yes | Yes | No | - | |
| Oracle GoldenGate – OCI | Service | Yes | Yes | Yes | Yes | - | |
| Oracle Marketing Cloud | Application | Yes | Yes | Yes | Yes | jdbc:weblogic:eloqua:Company=<company_id>;[;property=value[;...]] |
|
| Oracle NetSuite | Application | Yes | Yes | Yes | No | jdbc:ns://{Server Host}:{Server
Port};ServerDataSource={Server Data Source}; |
For information about creating a connection using Oracle Netsuite, see Create and Use an Oracle NetSuite Connection. |
| Oracle Object Storage | Database | Yes | Yes | Yes | Yes | - | For information about creating a connection using Oracle Object Storage, see Create an Oracle Object Storage Connection. |
| Oracle People Soft | Application | Yes | Yes | Yes | No | jdbc:oracle:thin:@<host>:<port>:<sid> |
|
| Oracle Sales Cloud | Application | Yes | Yes | Yes | No | jdbc:weblogic:oraclesalescloud://<base_url>;WSCompressData=none |
|
| Oracle Service Cloud | Application | Yes | Yes | Yes | No | jdbc:weblogic:oracleservicecloud:loginHost=host;[property=value[;...]] |
When using multiple JDBC connections for Oracle
Service Cloud in Oracle Data Transforms, ensure that each
connection is uniquely identified to avoid conflict. To do this,
add the For example,
where <UniqueValue> is a unique value
for each environment. For example,
This allows separate configuration files for each environment. |
| Oracle SIEBEL | Application | Yes | Yes | Yes | No | jdbc:oracle:thin:@<host>:<port>:<sid> |
|
| PayPal | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:
ServerName=https://api-m.sandbox.paypal.com;AuthenticationMethod=Basic; |
|
| Pivotal HD | Database | Yes | Yes | Yes | No | - | |
| Pivotal HDB | Database | Yes | Yes | Yes | No |
|
|
| PostgreSQL | Database | Yes | Yes | Yes | Yes |
|
|
| Qmetry | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://qtmcloud.qmetry.com;AuthenticationMethod=URLParameter;securitytoken=*****;authparam=apiKey; |
|
| QuickBooks Online | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://sandbox-quickbooks.api.intuit.com/v3/company/+++++;
clientId: AB8oHGUgVpXQnqKehrhBrnnIEQ7vNa7YI4UOr6LEX1Ja6dx0CL;
clientSecret: **************; authUri:
https://appcenter.intuit.com/connect/oauth2; tokenUri:
https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer;
redirectUri: http://localhost; AuthenticationMethod: OAuth2;
refreshtoken: **************; |
|
| QuickBooks Payments | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://sandbox.api.intuit.com;
clientId=ABCd1efGH2Ijkl3mN4OPQrsTu5vWxyZa6bCdEFgHijk7LMnOpQ;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 | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:ServerName=api.quora.com/ads;AuthenticationMethod=OAuth2;ClientID=xxxxxxxx;ClientSecret=xxxxxxxx;AccessToken=xxxxxxxx;Scope=ads_read; |
|
| Sage | Application | Yes | Yes | Yes | No | 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 | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=progresscom4-dev-ed.my.salesforce.com/services/data/v52.0;
AuthenticationMethod=OAuth2;
clientid=3MVG9SOw8KERNN08IkuAFNRo0MZbipoL4zeEhQzdT4IrNnqW7_UBvm1K7vZ4Y_OzbNxFn0.nJSfVBdqQuh4IL;
clientsecret=**************; refreshtoken=**************;
scope=full refresh_token;
authuri=https://login.salesforce.com/services/oauth2/authorize;
tokenuri=https://login.salesforce.com/services/oauth2/token; |
|
| Salesforce.com | Application | Yes | Yes | Yes | Yes |
|
|
| SAP BW/4HANA | Database | Yes | Yes | Yes | No |
|
|
| SAP HANA | Application | Yes | Yes | Yes | No |
|
|
| SAP NetWeaver | Database | Yes | Yes | Yes | No |
|
|
| SAP S/4HANA Cloud | Application | Yes | Yes | Yes | No |
|
|
| Semrush | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
|
| ServiceNow | Service | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=instance.service-now.com/api;
clientId=123a4b567c8901234567d8901e234fg5;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=**************; |
|
| Shopify | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
|
| Snowflake | Database | Yes | Yes | Yes | Yes | jdbc:weblogic:snowflake:AccountName=account_name;DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name;[property=value[;...]]; |
|
| Square | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=sandbox.api.intuit.com;AuthenticationMethod:BearerToken;securitytoken=**************************; |
|
| Stripe | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://api.stripe.com;AuthenticationMethod=BearerToken;securitytoken=**************************; |
|
| SAP Sybase ASE | Database | Yes | Yes | Yes | Yes | jdbc:weblogic:sybase://hostname:port[;property=value[;...]] |
|
| SAP Sybase IQ | Database | Yes | Yes | Yes | Yes | jdbc:weblogic:sybase://hostname:port[;property=value[;...]] |
|
| Sybase As Anywhere | Database | Yes | Yes | Yes | Yes | jdbc:weblogic:sybase://hostname:port[;property=value[;...]] |
|
| TeamCity | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:ServerName=https://{your_teamcity_servername}.com;AuthenticationMethod=BearerToken;SecurityToken=Ab12cdEfG3HIJkL.MNOpQRStuvWX4yZabcD56cD7eF8GHiJ90Klm.nOpqRst2u3VWxYZabC4DEfGhIjk; |
|
| Teradata | Database | Yes | No | No | Depends on the driver | jdbc:weblogic:teradata://<host>:<port>/<database>[;property=value[;...]] |
Data Transforms uses the Teradata JDBC Driver to
connect to a Teradata Database. To use Teradata as a data source the
Teradata Gateway for JDBC must be running, and this driver must be
installed in your Data Transforms userlibs
directory. You can download the JDBC driver from the Teradata
website.
|
| Teradata 17+ | Database | Yes | No | No | Depends on the driver | - | Data Transforms uses the Teradata JDBC Driver to
connect to a Teradata Database. To use Teradata as a data source the
Teradata Gateway for JDBC must be running, and this driver must be
installed in your Data Transforms userlibs
directory. You can download the JDBC driver from the Teradata
website..
|
| Tumblr | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]] |
|
| Veeva CRM | Application | Yes | Yes | Yes | Yes |
|
|
| Volusion | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]] |
|
| Wistia | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://api.wistia.com;authenticationmethod=Basic; |
|
| WooCommerce | Application | Yes | No | No | Depends on the driver | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
Requires driver installation |
| WordPress | Application | Yes | Yes | Yes | No | 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; |
|
| Workday | Application | Yes | No | No | Depends on the driver | jdbc:weblogic:autorest://servername;[property=value[;...]]; |
Requires driver installation |
| X | Application | Yes | Yes | Yes | No | - | |
| Xero | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest://servername;[property=value[;...]] |
|
| Yelp | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://api.yelp.com/v3;AuthenticationMethod=BearerToken;securitytoken=**************************; |
|
| Zendesk | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://example.zendesk.com;AuthenticationMethod=OAuth2;clientid=client_id_zendesk;
clientsecret=********; scope=read
write;authuri=/oauth/authorizations/new;
tokenuri=/oauth/tokens; |
|
| Zoho CRM | Application | Yes | Yes | Yes | No | 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 | Application | Yes | Yes | Yes | No | jdbc:weblogic:autorest:servername=https://api.zoom.us/v2;clientId=0aBcDeF_GhI2j_KlMnOpQr;clientSecret=**************;authUri=https://zoom.us/oauth/authorize;tokenUri=https://zoom.us/oauth/token;redirectUri=http://localhost;AuthenticationMethod=OAuth2;accesstoken:**************; |
Parent topic: Connections