Tables
The driver models the data in Tableau CRM into a list of tables that can be queried using standard SQL statements.
Generally, querying Tableau CRM tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for Tableau CRM Analytics Tables
| Name | Description |
| Dataset_Account | The Tableau CRM dataset Dataset_Account. |
| Dataset_Activity | The Tableau CRM dataset Dataset_Activity. |
| Dataset_Analytics | The Tableau CRM dataset Dataset_Analytics. |
| Dataset_Case | The Tableau CRM dataset Dataset_Case. |
| Dataset_DTC_Opportunity_SAMPLE | The Tableau CRM dataset Dataset_DTC_Opportunity_SAMPLE. |
| Dataset_Fashion | The Tableau CRM dataset Dataset_Fashion. |
| Dataset_OneMillion | The Tableau CRM dataset Dataset_OneMillion. |
| Dataset_Opportunity | The Tableau CRM dataset Dataset_Opportunity. |
| Dataset_Opportunity_products | The Tableau CRM dataset Dataset_Opportunity_products. |
| Dataset_Pipeline_trending | The Tableau CRM dataset Dataset_Pipeline_trending. |
| Dataset_Plain_quota | The Tableau CRM dataset Dataset_Plain_quota. |
| Dataset_Product | The Tableau CRM dataset Dataset_Product. |
| Dataset_Quota | The Tableau CRM dataset Dataset_Quota. |
| Dataset_User | The Tableau CRM dataset Dataset_User. |
| Dataset_User_role | The Tableau CRM dataset Dataset_User_role. |