Tableau is business intelligence software that can integrate with various data sources. When you ingest Tableau metadata, Collibra Data Lineage tries to automatically stitch the metadata to data sources registered in Data Catalog. It also creates a technical lineage that shows where metadata is used and how it transforms.
The following table shows the supported data sources in Tableau that have been tested, and whether or not technical lineage and stitching is supported for the data source. We cannot guarantee that stitching works as expected for other data sources or versions.
- If you use custom SQL that is not supported by the Tableau metadata API, the technical lineage might not be complete. For complete information, see the Tableau documentation on Tableau Catalog support for custom SQL and Tableau Lineage and custom SQL connections.
- If you use stored procedures, lineage is shown between the Tableau Data Source and the Tableau Worksheet, but the database information is missing, so stitching cannot be achieved.
Tip For stitching, you must correctly prepare the Data Catalog physical data layer.
|
Data source |
Version |
Support for technical lineage |
Support for stitching |
|---|---|---|---|
|
Amazon Redshift |
1.2.34.1058 and newer |
Yes | Yes |
|
Azure SQL server |
Newest version |
Yes | Yes |
|
Azure SQL Data Warehouse |
Newest version |
Yes | Yes |
|
Azure Synapse Analytics |
Newest version |
Yes | Yes |
| Dremio | 20.0.0 | Yes | Yes |
| Google BigQuery |
Newest version |
Yes | Yes |
|
Greenplum |
6.10 and newer |
Yes | Yes |
|
HiveQL (SQL-like statements) |
2.3.5 and newer |
Yes | Yes |
|
IBM DB2 |
11.5 and newer |
Yes | Yes |
|
Oracle |
11g, 12c and newer |
Yes | Yes |
|
PostgreSQL |
9.4, 9.5 and newer |
Yes | Yes |
|
Microsoft SQL Server |
2014, 2016 and newer |
Yes | Yes |
|
MySQL |
5.7, 8 and newer |
Yes | Yes |
|
Netezza |
7.2.1.0 and newer |
Yes | Yes |
| Salesforce Data Cloud | Newest version | Yes |
Yes Important See the Salesforce section below this table for an important requirement. |
|
SAP HANA |
2.00.40 and newer |
Yes | Yes |
| Snowflake |
Newest version |
Yes | Yes |
|
Spark SQL |
2.4.3 and newer |
Yes | Yes |
|
Sybase Adaptive Server Enterprise |
16.0 SP02 and newer |
Yes | Yes |
|
Teradata |
15.0, 16.20.07.01 and newer |
Yes | Yes |
Salesforce Data Cloud requirement
The Tableau integration supports Salesforce Data Cloud data sources; however, to obtain stitching, you have to configure host name mapping in your <source ID> configuration file with found_hostname=* because the Tableau APIs don’t return a host name.
"hostnameMapping": {
"found_dbname=databasename1;found_hostname=*;found_schema=test": {
"dbname": "mssql-database-name",
"schema": "mssql-schema-name",
"dialect": "mssql",
"collibraSystemName": "mssql-system-name"
}
}
Incidentally, extracts are also not returned by the Tableau APIs; only live connections.
For complete information, see the Salesforce documentation on connecting to Tableau in Data Cloud.