Connection Types


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

Map ConnectionType names

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 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