Using the Tableau Metadata API, you can access connection information used by Tableau content like data sources, workbooks, and flows.
In some cases you might need to identify the connection type used by the content. When you query a database object or an object that supports the “ConnectionType” property, such as UpstreamDatabases, the query returns the connection type name.
Note: CustomSQL database object does not support the ConnectionType property.
In this section
Use the table below to map the ConnectionType name to the connection name that’s displayed in various places on the Tableau platform.
ConnectionType | Display Name |
---|---|
asterncluster | Aster Database |
athena | Amazon Athena |
aurora | Amazon Aurora for MySQL |
awshadoophive | Amazon EMR Hadoop Hive |
azure_sql_dw | Azure SQL Data Warehouse |
bigquery | Google BigQuery (ODBC) |
bigsql | IBM BigInsights |
box | Box |
cloudfile:box-excel-direct | Microsoft Excel (Box) |
cloudfile:box-semistructpassivestore-direct | JSON file (Box) |
cloudfile:box-textscan | Text file (Box) |
cloudfile:dropbox-excel-direct | Microsoft Excel (Dropbox) |
cloudfile:dropbox-semistructpassivestore-direct | JSON file (Dropbox) |
cloudfile:dropbox-textscan | Text file (Dropbox) |
cloudfile:googledrive-excel-direct | Microsoft Excel (Google Drive) |
cloudfile:googledrive-semistructpassivestore-direct | JSON file (Google Drive) |
cloudfile:googledrive-textscan | Text file (Google Drive) |
cloudfile:onedrive-excel-direct | Microsoft Excel (OneDrive) |
cloudfile:onedrive-semistructpassivestore-direct | JSON file (OneDrive) |
cloudfile:onedrive-textscan | Text file (OneDrive) |
composite | TIBCO Data Virtualization |
csv | Text File (legacy) |
databricks | Databricks |
dataengine | Tableau Data Engine |
db2 | IBM DB2 |
denodo | Denodo |
denormalized-cube | Denormalized Cube |
drill | Apache Drill |
dropbox | Dropbox |
essbase | Oracle Essbase |
exasolution | Exasol |
excel | Microsoft Excel (legacy) |
excel-direct | Microsoft Excel |
excel-reader | Microsoft Excel Reader |
federated | Federated |
firebird | Firebird |
genericjdbc | Other Databases (JDBC) |
genericodbc | Other Databases (ODBC) |
google-analytics | Google Analytics |
google-sheets | Google Sheets |
googlebigquery | Google BigQuery (JDBC) |
googlecloudsql | Google Cloud SQL |
googledrive | Google Drive |
greenplum | Pivotal Greenplum Database |
hadoophive | Cloudera Hadoop |
hive | Apache Hive |
hortonworkshadoophive | Hortonworks Hadoop Hive |
hyper | Tableau Data Engine |
inmemfederating | In-memory Federating (multi-connection data source) |
jdbc | Other Databases (JDBC) Note: This connectionType might display as “unknown.” |
kognitio | Kognitio |
maprhadoophive | MapR Hadoop Hive |
mariadb | MariaDB |
marklogic | MarkLogic |
memsql | MemSQL |
monetdb | MonetDB |
mongodb | MongoDB BI Connector |
msaccess | Microsoft Access |
msolap | Microsoft Analysis Services |
mysql | MySQL |
mysql_odbc | unknown |
netezza | IBM PDA (Netezza) |
odata | OData |
odbc | Other Databases (ODBC) Note: This connectionType might display as “unknown.” |
ogr | Spatial File |
ogrdirect | Spatial file |
onedrive | OneDrive |
oracle | Oracle |
paraccel | Actian Matrix |
PDF file | |
pdf-reader | PDF Reader |
postgres | PostgreSQL |
powerpivot | Microsoft PowerPivot |
presto | Presto |
progressopenedge | Progress OpenEdge |
redshift | Amazon Redshift |
remote-domain | Tableau Server |
salesforce | Salesforce |
sapbw | SAP NetWeaver Business Warehouse |
saphana | SAP HANA |
semistructpassivestore | JSON file Note: Sometimes this displays as blank. |
semistructpassivestore-direct | JSON file |
sharepoint | SharePoint Lists |
snowflake | Snowflake |
spark | Spark SQL |
splunk | Splunk |
sqlproxy | Tableau Server |
sqlserver | Microsoft SQL Server |
stat | Statistical File |
stat-direct | Statistical file |
sybasease | SAP Sybase ASE |
sybaseiq | SAP Sybase IQ |
tbio | Teradata OLAP Connector |
teradata | Teradata |
textclean | Text file |
textscan | Text file |
textscan-reader | Text file reader |
vectorwise | Actian Vector |
vertica | Vertica |
vizengine | VizEngine |
webdata | Web Data Connector |
webdata-direct | Web Data Connector |
webdata-direct:anaplan-anaplan | Anaplan |
webdata-direct:google-ads | Google Ads |
webdata-direct:intuit-quickbooks | Intuit QuickBooks Online (9.3-2018.1) |
webdata-direct:intuit-quickbooks-v3 | Intuit QuickBooks Online |
webdata-direct:marketo-marketo | Marketo |
webdata-direct:oracle-eloqua | Oracle Eloqua |
webdata-direct:ServiceNowITSM-ServiceNowITSM | ServiceNow ITSM |