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: Applicable 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/userlibs directory 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 Authentication Mode: Connection URL Example Notes
Aha! Application Yes Yes Yes No
  • UrlParameter: jdbc:weblogic:aha:servername;AuthenticationMethod=UrlParameter; SecurityToken=security_token;[propert y=value[;...]];
  • OAuth2:

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

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

  • method: jdbc:weblogic:aha:servername;ProxyHost=proxy_host;ProxyPassword=proxy_password; ProxyPort=proxy_port;ProxyUser=proxy_user;AuthenticationMethod=method;[property=value[;...]];
  
Ahrefs Application Yes Yes Yes No
  • URLParameter: jdbc:weblogic:autorest:ServerName=https://apiv2.ahrefs.com; AuthenticationMethod=URLParameter; SecurityToken=xxxxxxxx;AuthParam=token;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Amazon Aurora Database Yes Yes Yes Yes
  • userIDPassword: jdbc:weblogic:postgresql://servername:port; AuthenticationMethod=userIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:postgresql://servername:port; AuthenticationMethod=kerberos;ServicePrincipalName=servicePrincipalName; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • EntraIDPassword: jdbc:weblogic:postgresql://servername:port; AuthenticationMethod=EntraIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • EntraIDServicePrincipal: jdbc:weblogic:postgresql://servername:port; AuthenticationMethod=EntraIDServicePrincipal; ServicePrincipal=your_service_principal;Secret=your_client_secret; [property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  
Amazon EMR Hive Database Yes Yes Yes No
  • none: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=none;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • userIdPassword: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • delegationToken: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=delegationToken;DelegationToken=delegationToken; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  
Amazon Redshift Database Yes Yes Yes Yes
  • userIdPassword: jdbc:weblogic:redshift://server_name:port_number;DatabaseName=database_name;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • Proxy server: jdbc:weblogic:redshift://server_name:port_number;DatabaseName=database_name;ProxyHost=proxy_host; ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;[property=value[;...]];
  
Apache Hive Database Yes Yes Yes No
  • none: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=none;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • userIdPassword: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • delegationToken: jdbc:weblogic:hive://servername:port;DatabaseName=database; AuthenticationMethod=delegationToken;DelegationToken=delegationToken; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  
Apache Iceberg Database Yes Yes Yes Yes

Authentication modes supported are None, Simple, and OAuth2.0.

http://<host>:<port>/iceberg		 For information about creating a connection using Apache Iceberg, see Create an Apache Iceberg Connection.
Apache Impala Database Yes Yes Yes No
  • none: jdbc:weblogic:impala://servername:port;DatabaseName=databaseName; AuthenticationMethod=none;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • userIdPassword: jdbc:weblogic:impala://servername:port;DatabaseName=databaseName; AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:impala://servername:port;DatabaseName=databaseName; AuthenticationMethod=kerberos;ServicePrincipleName=serviceprincipalname; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • Proxy server: jdbc:weblogic:impala://servername:port;DatabaseName=database_name;ProxyHost=proxy_host; ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;[property=value[;...]];
  
Apache Spark SQL Database Yes Yes Yes No
  • userIdPassword: jdbc:weblogic:sparksql://servername:port;DatabaseName=database; AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:sparksql://servername:port;DatabaseName=database; AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • jdbc:weblogic:sparksql://servername:port;DatabaseName=database; TransportMode=http;[property=value[;...]]
 
AWS S3 Database Yes Yes Yes No
  • AWS: jdbc:weblogic:autorest:AuthenticationMethod=AWS;servicename=s3; accesskey=*******;secretkey=*******;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Azure Billing Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Azure Compute Database Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Azure Data Lake Storage Database Yes Yes Yes No
  • OAuth2: 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;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Azure Reserved VM Instances Database Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Azure Resource Health Application Yes Yes Yes No
  • OAuth2: 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/;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Azure SQL Database Database Yes Yes Yes Yes
  • userIdPassword: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • activeDirectoryPassword: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=activeDirectoryPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ActiveDirectoryServicePrincipal: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ActiveDirectoryServicePrincipal;ServicePrincipal=clientID;Secret=clientSecret;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • auto: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=auto;[property=value[;...]];

    User: [Optional]

    Password: [Optional]

  • kerberos: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipalName=service_principal_name; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • ntlm: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ntlm;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ntlmjava: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ntlmjava;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ntlm2java: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ntlm2java;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  
Azure Synapse Analytics Database Yes Yes Yes Yes
  • userIdPassword: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • activeDirectoryPassword: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=activeDirectoryPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ActiveDirectoryServicePrincipal: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ActiveDirectoryServicePrincipal;ServicePrincipal=clientID;Secret=clientSecret;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • auto: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=auto;[property=value[;...]];

    User: [Optional]

    Password: [Optional]

  • kerberos: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipalName=service_principal_name; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • ntlm: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ntlm;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ntlmjava: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ntlmjava;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ntlm2java: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database;AuthenticationMethod=ntlm2java;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  
BigCommerce Application Yes Yes Yes No
  • HTTPHeader: jdbc:weblogic:autorest:servername=https://api.bigcommerce.com/stores/{store_hash};AuthenticationMethod=HTTPHeader;securitytoken=**************;authheader=X-Auth-Token;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Cassandra Database Yes Yes Yes Yes
  • none: jdbc:weblogic:cassandra://server:port;KeyspaceName=keyspace;AuthenticationMethod=none;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

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

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:cassandra://server:port;KeyspaceName=keyspace;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Ignored

    Password: [Ignored]

  
Cloudera CDH Hive Database Yes Yes Yes No
  • none: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=none;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • userIdPassword: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • delegationToken: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=delegationToken;DelegationToken=delegationToken;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  
Confluence Cloud Database Yes Yes Yes No
  • Basic: jdbc:weblogic:autorest:servername=https://<your-domain.atlassian.net>;authenticationmethod=Basic;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Data Transforms Service Yes Yes Yes No http://<host>:<port>/odi-rest 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
  • userIdPassword: jdbc:weblogic:cassandra://server:port;KeyspaceName=keyspace;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:cassandra://server:port;KeyspaceName=keyspace;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

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

    User: [Ignored]

    Password: [Ignored]

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

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

Delta Share Application Yes Yes Yes No Enter the Token Endpoint URL. For instructions on creating a connection using Delta Share, see Create a Delta Share Connection
DocuSign Database Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
eBay Application Yes Yes Yes No
  • OAuth2: 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/;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
EnterpriseDB Database Yes Yes Yes Yes
  • userIDPassword: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=userIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=kerberos;ServicePrincipalName=servicePrincipalName;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • EntraIDPassword: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=EntraIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • EntraIDServicePrincipal: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=EntraIDServicePrincipal; ServicePrincipal=your_service_principal;Secret=your_client_secret; [property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  
FinancialForce Application Yes Yes Yes Yes
  • jdbc:weblogic:sforce://servername;SecurityToken=value[;property=value[;...]]
  • userIDPassword: jdbc:weblogic:sforce://servername;AuthenticationMethod=userIDPassword;[property=value[;...]];
  • oauth2.0:

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; AccessToken=access-token;[property=value[;...]];

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; RefreshToken=refresh-token;[property=value[;...]];

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; JWTCertStore=file-path;ClaimsIssuer=client-ID;ClaimsSubject=user-name; JWTCertPassword=certificate-password;JWTCertAlias=certificate-alias;[property=value[;...]];

  
FourSquare Application Yes Yes Yes No
  • URLParameter: jdbc:weblogic:autorest:servername=https://api.foursquare.com;AuthenticationMethod=URLParameter;securitytoken=**********;authparam=oauth_token;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Generic Rest Application Yes Yes Yes No Enter the REST Service URL. 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;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
 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:github:ServerName=server_name;SecurityToken=security_token;[property=value[;...]];
  • Basic: jdbc:weblogic:github:ServerName=server_name;AuthenticationMethod=Basic;[property=value[;...]];
  • OAuth2:

    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 Ads Application Yes No No Depends on the driver Depends on the driver Requires driver installation
Google AdSense Application Yes Yes Yes No
  • OAuth2: 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=**************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Google Analytics Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  • OAuth2: jdbc:weblogic:googleanalytics4:AddTables='{myTableDefinitionString}'; ClientID=clientID;ClientSecret=client_secret;AuthenticationMethod=OAuth2; RefreshToken=refresh_token;Scope=scope;[property=value[;...]];
  
Google BigQuery Database Yes Yes Yes No
  • oauth2: jdbc:weblogic:googlebigquery:Project=project;Dataset=dataset; AccessToken=accesstoken;RefreshToken=refreshtoken;ClientID=clientid; ClientSecret=clientsecret;AuthenticationMethod=oauth2;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • serviceaccount: jdbc:weblogic:googlebigquery:Project=project;Dataset=dataset; ServiceAccountEmail=serviceAccountEmail; ServiceAccountKeyContent=private_key_content; AuthenticationMethod=serviceaccount;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  
Google Calendar Application Yes Yes Yes No
  • OAuth2: 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=**************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Google Campaign Manager Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Google Contacts Application Yes Yes Yes No
  • OAuth2: 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: **************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
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
  • OAuth2: 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=**************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Google Search Ads 360 Application Yes Yes Yes No
  • OAuth2: 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: **************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Greenplum Database Yes Yes Yes No
  • userIdPassword: jdbc:weblogic:greenplum://servername:port;KeyspaceName=keyspace; AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:greenplum://servername:port;DatabaseName=databaseName;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

 
Hortonworks Hive Database Yes Yes Yes No
  • none: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=none;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • userIdPassword: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • delegationToken: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=delegationToken;DelegationToken=delegationToken;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

 
HubSpot Application Yes Yes Yes No OAuth2: jdbc:weblogic:hubspot:AuthenticationMethod=OAuth2;ClientID=client_id; ClientSecret=client_secret;RefreshToken=refresh_token;Scope=scope;[property=value[;...]];  
Hypersonic SQL Database Yes Yes Yes Yes jdbc:hsqldb:<protocol>:<databasePath>[;ifexists=true][;<property>=<value>...];  
IBM BigInsights Database Yes Yes Yes No
  • none: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=none;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • userIdPassword: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • delegationToken: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=delegationToken;DelegationToken=delegationToken;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

 
IBM DB2 Hosted Database Yes Yes Yes Yes
  • cleartext: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=cleartext;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • client: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=client;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • encryptedPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • pluginSecurity: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=pluginSecurity;PluginName=pluginName; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

 
IBM DB2 UDB Database Yes Yes Yes Yes
  • cleartext: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=cleartext;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • client: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=client;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • encryptedPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • pluginSecurity: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=pluginSecurity;PluginName=pluginName; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

 
IBM DB2 Warehouse Database Yes Yes Yes Yes
  • cleartext: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=cleartext;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • client: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=client;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • encryptedPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • pluginSecurity: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=pluginSecurity;PluginName=pluginName; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

 
IBM DB2/400 Database Yes Yes Yes Yes
  • cleartext: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=cleartext;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • client: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=client;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • encryptedPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPassword: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • encryptedUIDPasswordAES: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=encryptedUIDPasswordAES;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • pluginSecurity: jdbc:weblogic:db2://servername:port;DatabaseName=database;AuthenticationMethod=pluginSecurity;PluginName=pluginName; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

 
Informix Database Yes Yes Yes No
  • jdbc:weblogic:informix://servername:port;InformixServer=informixserver; Database=databasename;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • jdbc:weblogic:informix://servername:port;InformixServer=informixserver; DatabaseName=databasename;AlternateServers=(alternateserver); ConnectionRetryCount=connectionretrycount; ConnectionRetryDelay=connectionretrydelay;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  
Jira Application Yes Yes Yes No jdbc:weblogic:jira:servername;[property= value[;...]];  
Klaviyo Application Yes Yes Yes No
  • URLParameter: jdbc:weblogic:autorest:servername=https://a.klaviyo.com/api; AuthenticationMethod=URLParameter;securitytoken=*****;authparam=api_key;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Magento Application Yes No No Depends on the driver Depends on the driver Requires driver installation
Mailchimp Application Yes Yes Yes No
  • BearerToken: jdbc:weblogic:autorest:servername=us20.api.mailchimp.com;AuthenticationMethod=BearerToken;securitytoken=*******;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
MapR Hive Database Yes Yes Yes No
  • none: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=none;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • userIdPassword: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • delegationToken: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=delegationToken;DelegationToken=delegationToken;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

 
Marketo Application Yes Yes Yes No
  • OAuth2: jdbc:weblogic:autorest:servername=https://{api_id}.mktorest.com; AuthenticationMethod=OAuth2;clientid=a1234bc5-67d8-9e01-f23g-4h567ijk89l0;clientsecret=******************; tokenuri=https://{api_id}.mktorest.com/identity/oauth/token;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Microsoft Dynamics 365 Application Yes Yes Yes Yes
  • OAuth2:

    jdbc:weblogic:dynamics365:ServiceURL=serviceurl;AuthenticationMethod=OAuth2; AccessToken=access_token;[property=value[;...]];

    jdbc:weblogic:dynamics365:ServiceURL=serviceurl;AuthenticationMethod=OAuth2; ClientID=client_id;ClientSecret=client_secret; TokenURI=POSTtoken_uri;Scope=scope;[property=value[;...]];

    jdbc:weblogic:dynamics365:ServiceURL=serviceurl;AuthenticationMethod=OAuth2; ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri; RefreshToken=refresh_token;[property=value[;...]];

    jdbc:weblogic:dynamics365:ServiceURL=serviceurl;ProxyHost=proxy_host; ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user; AuthenticationMethod=OAuth2;ClientID=client_id;ClientSecret=client_secret; TokenURI=token_uri;RefreshToken=refresh_token;[property=value[;...]];

  • NTLM: jdbc:weblogic:dynamics365:ServiceURL=serviceurl; AuthenticationMethod=NTLM;NTLMDomain=nTLMDomain;[property=value[;...]];
  
Microsoft SharePoint Application Yes Yes Yes Yes
  • 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[;...]];
  
Microsoft SQL Server Database Yes Yes Yes Yes
  • userIdPassword: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • activeDirectoryPassword: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=activeDirectoryPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ActiveDirectoryServicePrincipal: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=ActiveDirectoryServicePrincipal; ServicePrincipal=clientID;Secret=clientSecret;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • auto: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=auto;[property=value[;...]];

    User: [Optional]

    Password: [Optional]

  • kerberos: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=kerberos;ServicePrincipalName=service_principal_name; [property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • ntlm: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=ntlm;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ntlmjava: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=ntlmjava;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • ntlm2java: jdbc:weblogic:sqlserver://hostname:port;DatabaseName=database; AuthenticationMethod=ntlm2java;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

 
Mongo DB Database Yes Yes Yes Yes
  • None:

    jdbc:weblogic:mongodb://host:port;AuthenticationMethod=None;DatabaseName=database;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

    jdbc:weblogic:mongodb://host:port;AuthenticationMethod=None;DatabaseName=database;ReplicaSetName=replica_set;[property=value[;...]];

  • auth_db:

    jdbc:weblogic:mongodb://host:port;AuthenticationDatabase=auth_db;DatabaseName=database;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

    jdbc:weblogic:mongodb://host:27017;AuthenticationDatabase=auth_db; DatabaseName=database;EncryptionMethod=SSL;[property=value[;...]];

  • kerberos: jdbc:weblogic:mongodb://host:port;AuthenticationMethod=kerberos;DatabaseName=database; ServicePrincipalName=principal_name;User=username;[property=value[;...]]; User: [Ignored] Password: [Ignored]

  • plain: jdbc:weblogic:mongodb://host:port;AuthenticationMethod=plain; DatabaseName=database;[property =value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • jdbc:weblogic:mongodb://host:port;CryptoProtocolVersion=protocol; DatabaseName=database;EncryptionMethod=[SSL | requestSSL]; HostNameInCertificate=host_name;KeyPassword=key_password;KeyStore=key_store; TrustStore=trust_store;TrustStorePassword=ts_password; ValidateServerCertificate=vsc_value;[property=value[;...]];

  • jdbc:weblogic:mongodb://host:port;DatabaseName=database; EncryptionMethod=SSL;ValidateServerCertificate=false;[property=value[;...]];

  • jdbc:weblogic:mongodb://host:port;AuthenticationDatabase=auth_db;DatabaseName=database; ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port; ProxyUser=proxy_user;[property=value[;...]];

  
MySQL Database Yes Yes Yes Yes jdbc:mysql://<host>[:<port>]/[<database>]?relaxAutoCommit=true&useCursorFetch=true[&<property>=<value>...] 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://<host>[:<port>]/[<database>]?relaxAutoCommit=true&useCursorFetch=true[&<property>=<value>...]

If MySQL Heatwave database is created with high availability, then write operation is not supported.

Make sure that the system variable property sql_require_primary_key is set to OFF. Otherwise, an ADW to MySQL Heatwave mapping could fail with a “Table does not exist” error.

Netezza Database Yes No No Depends on the driver 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
  • jdbc:oracle:thin:@<host>:<port>:<sid>
  • jdbc:oracle:thin:@<host>:<port/ServiceName>
  • jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<Service Name>)))
 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 (Oracle BI Cloud Service) Application Yes Yes Yes No Enter the BI Cloud Connector Service URL.  
Oracle Business Intelligence Cloud (BICC) Connector Application Yes Yes Yes No Enter the BI Cloud Connector Service URL. 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>
  • jdbc:oracle:thin:@<host>:<port/ServiceName>
  • jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<Service Name>)))
  
Oracle ERP Cloud Application Yes Yes No No Enter the URL of the BI Publisher web service. For information about creating a connection using Oracle ERP Cloud, see Create an Oracle Enterprise Resource Planning Cloud Connection.
Oracle Financials Cloud Application Yes Yes Yes No Enter the REST Service URL. 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 Enter the Service URL.  
Oracle Fusion Sales Application Yes Yes Yes No Enter the Service URL.  
Oracle Fusion Service Application Yes Yes Yes No Oracle Fusion Service  
Oracle GoldenGate – OCI Service Yes Yes Yes Yes Enter the deployment URL.  
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 Enter the Object Storage URL. 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>
  • jdbc:oracle:thin:@<host>:<port/ServiceName>
  • jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<host>) (PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<Service Name>)))
  
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 DatabaseName property to the JDBC URL.

For example,

jdbc:weblogic:oracleservicecloud:loginHost=host;DatabaseName=<UniqueValue>;

where <UniqueValue> is a unique value for each environment. For example, DevConnection or ProdConnection.

This allows separate configuration files for each environment.
Oracle SIEBEL Application Yes Yes Yes No
  • jdbc:oracle:thin:@<host>:<port>:<sid>
  • jdbc:oracle:thin:@<host>:<port/ServiceName>
  • jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<Service Name>)))
  
PayPal Application Yes Yes Yes No
  • Basic: jdbc:weblogic:autorest: ServerName=https://api-m.sandbox.paypal.com;AuthenticationMethod=Basic;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Pivotal HD Database Yes Yes Yes No
  • none: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=none;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • userIdPassword: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • delegationToken: jdbc:weblogic:hive://servername:port;DatabaseName=database;AuthenticationMethod=delegationToken;DelegationToken=delegationToken;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

 
Pivotal HDB Database Yes Yes Yes No
  • userIdPassword: jdbc:weblogic:greenplum://servername:port;KeyspaceName=keyspace; AuthenticationMethod=userIdPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:greenplum://servername:port;DatabaseName=databaseName;AuthenticationMethod=kerberos;ServicePrincipal=servicePrincipal;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

 
PostgreSQL Database Yes Yes Yes Yes
  • userIDPassword: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=userIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • kerberos: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=kerberos;ServicePrincipalName=servicePrincipalName; [property=value[;...]];

    User: [Optional]

    Password: [Optional]

  • EntraIDPassword: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=EntraIDPassword;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • EntraIDServicePrincipal: jdbc:weblogic:postgresql://servername:port;AuthenticationMethod=EntraIDServicePrincipal;ServicePrincipal=servicePrincipal;Secret=secret;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  
Qmetry Application Yes Yes Yes No
  • URLParameter: jdbc:weblogic:autorest:servername=https://qtmcloud.qmetry.com;AuthenticationMethod=URLParameter;securitytoken=*****;authparam=apiKey;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
QuickBooks Online Application Yes Yes Yes No
  • OAuth2: 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: **************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
QuickBooks Payments Application Yes Yes Yes No
  • OAuth2: 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=**************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Quora Ads Application Yes Yes Yes No
  • OAuth2: jdbc:weblogic:autorest:ServerName=api.quora.com/ads;AuthenticationMethod=OAuth2; ClientID=xxxxxxxx;ClientSecret=xxxxxxxx;AccessToken=xxxxxxxx;Scope=ads_read;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Sage Application Yes Yes Yes No
  • OAuth2: 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: **************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Salesforce Chatter Application Yes Yes Yes No
  • OAuth2: 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;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Salesforce.com Application Yes Yes Yes No
  • userIDPassword: jdbc:weblogic:sforce://servername;AuthenticationMethod=userIDPassword; [property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • OAuth2:

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; AccessToken=access-token;[property=value[;...]];

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; RefreshToken=refresh-token;[property=value[;...]];

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; JWTCertStore=file-path;ClaimsIssuer=client-ID;ClaimsSubject=user-name; JWTCertPassword=certificate-password;JWTCertAlias=certificate-alias;[property=value[;...]];

 You cannot use a Salesforce connection as a target for mapping.
SAP BW/4HANA Database Yes Yes Yes No
  • Basic: jdbc:weblogic:s4hana:ServerName=servername;AuthenticationMethod=Basic;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • HTTPHeader: jdbc:weblogic:s4hana:ServerName=servername;AccessToken=your_access_token;AuthenticationMethod=HTTPHeader;AuthHeader=api_key;SecurityToken=security_token;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • jdbc:weblogic:s4hana:ServerName=servername;ProxyHost=proxy_host; ProxyPassword=proxy_password;ProxyPort=proxy_port; ProxyUser=proxy_user;[property=value[;...]];
  
SAP HANA Application Yes Yes Yes No
  • Basic: jdbc:weblogic:s4hana:ServerName=servername;AuthenticationMethod=Basic;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • HTTPHeader: jdbc:weblogic:s4hana:ServerName=servername;AccessToken=your_access_token;AuthenticationMethod=HTTPHeader;AuthHeader=api_key;SecurityToken=security_token;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • jdbc:weblogic:s4hana:ServerName=servername;ProxyHost=proxy_host; ProxyPassword=proxy_password;ProxyPort=proxy_port; ProxyUser=proxy_user;[property=value[;...]];
  
SAP NetWeaver Database Yes Yes Yes No
  • Basic: jdbc:weblogic:s4hana:ServerName=servername;AuthenticationMethod=Basic;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • HTTPHeader: jdbc:weblogic:s4hana:ServerName=servername;AccessToken=your_access_token;AuthenticationMethod=HTTPHeader;AuthHeader=api_key;SecurityToken=security_token;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • jdbc:weblogic:s4hana:ServerName=servername;ProxyHost=proxy_host; ProxyPassword=proxy_password;ProxyPort=proxy_port; ProxyUser=proxy_user;[property=value[;...]];
  
SAP S/4HANA Cloud Application Yes Yes Yes No
  • Basic: jdbc:weblogic:s4hana:ServerName=servername;AuthenticationMethod=Basic;[property=value[;...]];

    User: [Mandatory]

    Password: [Mandatory]

  • HTTPHeader: jdbc:weblogic:s4hana:ServerName=servername;AccessToken=your_access_token;AuthenticationMethod=HTTPHeader;AuthHeader=api_key;SecurityToken=security_token;[property=value[;...]];

    User: [Ignored]

    Password: [Ignored]

  • jdbc:weblogic:s4hana:ServerName=servername;ProxyHost=proxy_host; ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;[property=value[;...]];
  
Semrush Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
ServiceNow Service Yes Yes Yes No
  • OAuth2: 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=**************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Shopify Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[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[;...]];
  • OAuth2:

    jdbc:weblogic:snowflake:AccountName=account_name;AuthenticationMethod=OAuth2;AccessToken=access_token;DatabaseName=database_name;Schema=schema_name; Warehouse=warehouse_name;[property=value[;...]];

    jdbc:weblogic:snowflake:AccountName=account_name;AuthenticationMethod=OAuth2; AuthURI=auth_uri;DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name; ClientID=client_id;ClientSecret=client_secret;RedirectURI=redirect_uri;[property=value[;...]];

    jdbc:weblogic:snowflake:AccountName=account_name;AuthenticationMethod=OAuth2; DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name; ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri;[property=value[;...]];

    jdbc:weblogic:snowflake:AccountName=account_name;AuthenticationMethod=OAuth2; DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name; ClientID=client_id;ClientSecret=client_secret;TokenURI=token_uri;RefreshToken=refresh_token;[property=value[;...]];

  • BrowserBasedSSO: jdbc:weblogic:snowflake:AccountName=account_name;AuthenticationMethod=BrowserBasedSSO; DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name;[property=value[;...]];
  • KeyPair: jdbc:weblogic:snowflake:AccountName=account_name;AuthenticationMethod=KeyPair; DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name;PrivateKeyContent=private_key_content; PrivateKeyPassphrase=password;[property=value[;...]];
  • jdbc:weblogic:snowflake:AccountName=account_name;DatabaseName=database_name; Schema=schema_name;Warehouse=warehouse_name;ProxyHost=proxy_host;ProxyPassword=proxy_password; ProxyPort=proxy_port;ProxyUser=proxy_user;[property=value[;...]];
  
Square Application Yes Yes Yes No
  • BearerToken: jdbc:weblogic:autorest:servername=sandbox.api.intuit.com; AuthenticationMethod: BearerToken; securitytoken=**************************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Stripe Application Yes Yes Yes No BearerToken: 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:teamcity:ServerName=server_name;[property=value[;...]];
  • BearerToken:

    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[;...]];

  
Teradata Database Yes No No Depends on the driver Depends on the driver being used (com.ncr.teradata.TeraDriver) 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 Depends on the driver being used (com.teradata.jdbc.TeraDriver) 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[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Veeva CRM Application Yes Yes Yes Yes
  • jdbc:weblogic:sforce://servername;SecurityToken=value[;property=value[;...]]
  • userIDPassword: jdbc:weblogic:sforce://servername;AuthenticationMethod=userIDPassword;[property=value[;...]];
  • oauth2.0:

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; AccessToken=access-token;[property=value[;...]];

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; RefreshToken=refresh-token;[property=value[;...]];

    jdbc:weblogic:sforce://servername;AuthenticationMethod=oauth2.0;SchemaMap=schema-map-name; JWTCertStore=file-path;ClaimsIssuer=client-ID;ClaimsSubject=user-name; JWTCertPassword=certificate-password;JWTCertAlias=certificate-alias;[property=value[;...]];

  
Volusion Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Wistia Application Yes Yes Yes No
  • Basic: jdbc:weblogic:autorest:servername=https://api.wistia.com;authenticationmethod=Basic;
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
WooCommerce Application Yes No No Depends on the driver Depends on the driver. Requires driver installation
WordPress Application Yes Yes Yes No
  • OAuth2: 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;
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Workday Application Yes No No Depends on the driver Depends on the driver. Requires driver installation
X Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Xero Application Yes Yes Yes No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Yelp Application Yes Yes Yes No
  • BearerToken: jdbc:weblogic:autorest:servername=https://api.yelp.com/v3; AuthenticationMethod=BearerToken;securitytoken=**************************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Zendesk Application Yes Yes Yes No
  • OAuth2: jdbc:weblogic:autorest:servername=https://example.zendesk.com;AuthenticationMethod=OAuth2; clientid=client_id_zendesk;clientsecret=********;scope=readwrite;authuri=/oauth/authorizations/new; tokenuri=/oauth/tokens;
  • Basic: jdbc:weblogic:autorest:servername=https://example.zendesk.com;authenticationmethod=Basic;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Zoho CRM Application Yes Yes Yes No
  • OAuth2: 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=********************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  
Zoom Application Yes Yes Yes No
  • OAuth2: 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: **************;
  • jdbc:weblogic:autorest://servername;[property=value[;...]];
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
  

Parent topic: Connections