1. Connectivity and Knowledge Modules Guide for Oracle Data Integrator
  2. Databases, Files, and XML
  3. Other Databases

19 Other Databases

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

This chapter includes the following section:

19.1 Supported Databases

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

In the following table you can find details about each supported databases such as the supported version, whether it supports write operation, the JDBC URL templates that are available for each database along with the additional properties that can be used in the JDBC URL.
Name Supported Version Supports Write Operation Connection URL Examples Notes
Amazon Aurora 11.18, 12.13, 13.9, 14.6+ Yes

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

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

    where ServicePrincipalName specifies a name that a client application receives from Amazon Aurora MySQL to enable Kerberos authentication.

 
Apache Hive Any No

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

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

 Doesn't require ODI installation on Hive
Apache Impala 1.3,2.0,2.3.0 No

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

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

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

    where ServicePrincipalName specifies the case-sensitive service principal name to be used for Kerberos authentication.

  • jdbc:weblogic:impala://servername:port;DatabaseName=database_name;ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;[property=value[;...]];

 Cloudera Impala 1.3 and higher, 2.0, 3.2.0
Apache Spark SQL Any No

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

  • jdbc:weblogic:sparksql://servername:port;DatabaseName=database;TransportMode=http;[property=value[;...]]

 Doesn't require ODI installation on Spark cluster
AWS S3 Any No

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

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

  • jdbc:weblogic:autorest:authenticationmethod=AWS;servicename=s3;accesskey=*******;secretkey=*******;

    where AccessKey specifies your access key ID for your IAM user or AWS account root user and SecretKey specifies your secret access key for an IAM user or AWS account root user.

Azure Compute Any No

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

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

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

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

  • 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 Any No

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

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

  • jdbc:weblogic:autorest:ServerName=management.azure.com;AuthenticationMethod=OAuth2;ClientID=xxxxxxxx;ClientSecret=xxxxxxxx;AccessToken=xxxxxxxx;RefreshToken=xxxxxxxx;Scope=https://management.azure.com/user_impersonation https://management.azure.com/.default offline_accessTokenURI=https://login.microsoftonline.com/db266a67-cbe0-4d26-ae1a-d0581fe03535/oauth2/v2.0/token;RedirectURI=http://localhost/;
Azure SQL Database 12.0+ Yes

jdbc:weblogic:sqlserver://hostname:port[;property=value[;...]]

 Microsoft Azure Synapse Analytics (formerly Microsoft Azure SQL Data Warehouse), version 12 and higher
Azure Synapse Analytics 12.0+ Yes

jdbc:weblogic:sqlserver://hostname:port[;property=value[;...]]

 Using standards compliant JDBC driver
Cassandra Any 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.

Doesn't require Spark
Confluence Cloud Any No

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

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

  • jdbc:weblogic:autorest:servername=https://<your-domain.atlassian.net>;authenticationmethod=Basic;
DocuSign Any No

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

  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];
EnterpriseDB 10.1+ Yes

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

  • jdbc:weblogic:postgresql://servername:port;DatabaseName=databasename;AuthenticationMethod=kerberos;ServicePrincipalName=serviceprincipalname[property=value[;...]];
 EDB Postgres Advanced Server 10.1 and higher
Google BigQuery Any No jdbc:weblogic:googlebigquery:Project=project;Dataset=dataset;AccessToken=accesstoken;RefreshToken=refreshtoken;ClientID=clientid;ClientSecret=clientsecret[;property=value[;...]]  
Google Drive Any No
  • jdbc:weblogic:autorest://servername;[property=value[;...]]
  • jdbc:weblogic:autorest:Sample=sample_path;[property=value[;...]];jdbc:weblogic:autorest:servername=https://www.googleapis.com/drive/v3;clientId=client_id;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=**************;
Greenplum 5.0+,6.0+ No
  • jdbc:weblogic:greenplum://servername:port;AuthenticationMethod=userIdPassword;[property=value[;...]];
  • jdbc:weblogic:greenplum://servername:port;DatabaseName=databasename;AuthenticationMethod=kerberos;ServicePrincipalName=serviceprincipalname[property=value[;...]];
  
IBM DB2 Hosted Any Yes jdbc:weblogic:db2://hostname:port;DatabaseName=value[;property=value[;...]]  
IBM DB2 Warehouse Any Yes jdbc:weblogic:db2://hostname:port;DatabaseName=value[;property=value[;...]] IBM Db2 Warehouse on Cloud
MySQL Heatwave Any Yes jdbc:mysql://<host>[:<port>]/[<database>]?relaxAutoCommit=true&useCursorFetch=true[&<property>=<value>...]  
Pivotal HDB 1.1+,2.0+ No
  • jdbc:weblogic:greenplum://servername:port;AuthenticationMethod=userIdPassword;[property=value[;...]];
  • jdbc:weblogic:greenplum://servername:port;DatabaseName=databasename;AuthenticationMethod=kerberos;ServicePrincipalName=serviceprincipalname[property=value[;...]];
 Pivotal HDB (HAWQ) 2.0 and higher, Pivotal HAWQ 1.1 and higher
SAP BW/4HANA 2 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[;...]];
  
SAP NetWeaver Any 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[;...]];
 SAP ODataV2 Services from SAP Gateway
Snowflake Any Yes
  • jdbc:weblogic:snowflake:AccountName=account_name;DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name;[property=value[;...]];
  • 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[;...]];
  • jdbc:weblogic:snowflake:AccountName=account_name;AuthenticationMethod=BrowserBasedSSO;DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name;[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[;...]];