Supported Database Platforms

You can use any of the following database platforms in Team Studio. Deprecated versions of databases will be removed from support in a future version of Team Studio.

Platform Version Data source Analytic data source Sandbox
Amazon RedShift JDBC 4.2 compatible driver Yes
Apache Impala 2.2 Yes
Azure SQL Data Warehouse Yes
Google BigQuery BigQuery JDBC 4.2 Yes
Greenplum database 5 Yes Yes Yes
Hive JDBC 13 Yes
MS SQL Server Recommended: 12.0, 13.0 (2014, 2016) or higher

Deprecated in 6.5.0: 11.0 (2012)

Yes
Oracle database 10g, 11g, 18c, Exadata Yes Yes
Pivotal HAWQ Deprecated in 6.5.0: 1.2 Yes Yes Yes
PostgreSQL

9.4 or higher.

Deprecated in 6.5.0:
  • 8.4
  • 9.3
Yes Yes Yes
SAP Hana 1.0 SPS 11 or higher Yes
Vertica 7.1 or higher Yes
Related reference