Cloud

Build 23.0.8839
  • Tableau CRM Analytics
    • Getting Started
      • Establishing a Connection
      • Creating a Custom OAuth Application
      • Selecting Datasets
      • Inserting Datasets
      • Upserting Datasets
      • Deleting Datasets
      • Uploading Datasets
      • SSL Configuration
      • Firewall and Proxy
    • Data Model
      • Tables
        • Dataset_Account
        • Dataset_Activity
        • Dataset_Analytics
        • Dataset_Case
        • Dataset_DTC_Opportunity_SAMPLE
        • Dataset_Fashion
        • Dataset_OneMillion
        • Dataset_Opportunity
        • Dataset_Opportunity_products
        • Dataset_Pipeline_trending
        • Dataset_Plain_quota
        • Dataset_Product
        • Dataset_Quota
        • Dataset_User
        • Dataset_User_role
      • Views
        • Lens_Explore_Opportunities
        • Lens_Historical_Pipeline_By_Forecast
        • Lens_Historical_Pipeline_By_Stage
        • Lens_Historical_Pipeline_Forecast_By_Quarter
        • Lens_Historical_Pipeline_Stage_By_Quarter
        • Lens_Sales_Stage_Details
        • Lens_X100KLens
      • Stored Procedures
        • CreateMetadataFile
        • GetJobStatus
      • System Tables
        • sys_catalogs
        • sys_schemas
        • sys_tables
        • sys_tablecolumns
        • sys_procedures
        • sys_procedureparameters
        • sys_keycolumns
        • sys_foreignkeys
        • sys_primarykeys
        • sys_indexes
        • sys_connection_props
        • sys_sqlinfo
        • sys_identity
    • Connection String Options
      • Authentication
        • AuthScheme
        • InstanceURL
        • Subdomain
        • UseSandbox
      • Connection
        • ApiVersion
      • JWT OAuth
        • OAuthJWTCert
        • OAuthJWTCertType
        • OAuthJWTCertPassword
        • OAuthJWTCertSubject
        • OAuthJWTIssuer
        • OAuthJWTSubject
      • SSL
        • SSLServerCert
      • Logging
        • Verbosity
      • Schema
        • BrowsableSchemas
        • MetadataFilesLocation
        • TypeDetectionScheme
        • RowScanDepth
        • PrimaryKeyIdentifier
      • Miscellaneous
        • AsyncBulkOperation
        • HandleAPINullIssues
        • MaxRows
        • Pagesize
        • PseudoColumns
        • Timeout
        • UseDisplayNames
        • UseSimpleNames

Tableau CRM Analytics - CData Cloud

Overview

CData Cloud offers access to Tableau CRM across several standard services and protocols, in a cloud-hosted solution. Any application that can connect to a MySQL or SQL Server database can connect to Tableau CRM through CData Cloud.

CData Cloud allows you to standardize and configure connections to Tableau CRM as though it were any other OData endpoint, or standard SQL Server/MySQL database.

Key Features

  • Full SQL Support: Tableau CRM appears as standard relational databases, allowing you to perform operations - Filter, Group, Join, etc. - using standard SQL, regardless of whether these operations are supported by the underlying API.
  • CRUD Support: Both read and write operations are supported, restricted only by security settings that you can configure in Cloud or downstream in the source itself.
  • Secure Access: The administrator can create users and define their access to specific databases and read-only operations or grant full read & write privileges.
  • Comprehensive Data Model & Dynamic Discovery: CData Cloud provides comprehensive access to all of the data exposed in the underlying data source, including full access to dynamic data and easily searchable metadata.

CData Cloud

Getting Started

This page provides a guide to Establishing a Connection to Tableau CRM in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to Tableau CRM

Establishing a Connection shows how to authenticate to Tableau CRM and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from Tableau CRM through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

CData Cloud

Establishing a Connection

Connect to Tableau CRM by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to Tableau CRM

Tableau CRM uses the OAuth 2 authentication standard. You will need to obtain the OAuthClientId and OAuthClientSecret by registering an app with Tableau CRM. For further information, see Creating a Custom OAuth Application.

Set the AuthScheme to OAuthJWT.

Obtaining the OAuthJWT Consumer Key

To obtain the OAuthJWT consumer key:
  1. Log in to Salesforce.com.
  2. From Setup, enter Apps in the Quick Find box and then click the link to create an app. In the Connected Apps section of the resulting page, click New.
  3. Enter a name to be displayed to users when they log in to grant permissions to your app, along with a contact Email address.
  4. Click Enable OAuth Settings and enter a value in the Callback URL box. Set this value only to create the Connected App as it is required. It will not actually be needed for this type of authentication. The Callback URL is in the format: 
    http://localhost:8019/src/oauthCallback.rst
  5. Enable Use digital signatures.
  6. Upload your certificate.
  7. Select the scope of permissions that your app should request from the user.
  8. Click your app name to open a page with information about your app. The OAuth consumer key is displayed.

After creating your OAuth Application, set the following connection properties:

  • AuthScheme: OAuthJWT.
  • InitiateOAuth: GETANDREFRESH.
  • OAuthJWTCert: The JWT Certificate store.
  • OAuthJWTPassword: The password of the JWT Certificate store.
  • OAuthJWTIssuer: The OAuth Client ID.
  • OAuthJWTCertType: The type of the certificate store specified by OAuthJWTCert.

Note: This flow never issues a refresh token.

Authenticating to Tableau CRM

The following subsections describe how to authenticate to Tableau CRM from three common authentication flows:
  • Desktop: a connection to a server on the user's local machine, frequently used for testing and prototyping.
  • Web: access to data via a shared website.
  • Headless Server: a dedicated computer that provides services to other computers and their users, which is configured to operate without a monitor and keyboard.

For information about how to create a custom OAuth application, see Creating a Custom OAuth Application. For a complete list of connection string properties available in Tableau CRM, see Connection.

Note: To configure the session timeout in Salesforce, navigate to Setup > Administration Setup > Security Controls > Session Settings.

Automatic refresh of the OAuth access token:

To have the Cloud automatically refresh the OAuth access token, do the following:

  1. Before connecting to data for the first time, set the following connection parameters:
    • InitiateOAuth: REFRESH.
    • OAuthClientId: The client Id in your application settings.
    • OAuthClientSecret: The client secret in your application settings.
    • OAuthAccessToken: The access token returned by GetOAuthAccessToken.
    • OAuthSettingsLocation: The path where you want the Cloud to save the OAuth values, which persist across connections.
  2. On subsequent data connections, set the following:
    • InitiateOAuth
    • OAuthSettingsLocation

Manual refresh of the OAuth access token:

The only value needed to manually refresh the OAuth access token is the OAuth refresh token.

  1. To manually refresh the OAuthAccessToken after the ExpiresIn period (returned by GetOAuthAccessToken) has elapsed, call the RefreshOAuthAccessToken stored procedure.
  2. Set the following connection properties:

    • OAuthClientId: The Client Id in your application settings.
    • OAuthClientSecret: The Client Secret in your application settings.

  3. Call RefreshOAuthAccessToken with OAuthRefreshToken set to the OAuth refresh token returned by GetOAuthAccessToken.
  4. After the new tokens have been retrieved, set the OAuthAccessToken property to the value returned by RefreshOAuthAccessToken. This opens a new connection.

Store the OAuth refresh token so that you can use it to manually refresh the OAuth access token after it has expired.

CData Cloud

Creating a Custom OAuth Application

Creating a Custom OAuth Application

The following procedure registers a custom OAuth application in the admin console and obtains the OAuth client credentials, the consumer key and consumer secret:

  1. Access Setup.
    (If you are connecting from a Desktop application, you can access Setup by logging into Salesforce.com and clicking your user name.)
  2. Open a new application.
    • If your organization uses the Salesforce Lightning Experience UI:
      1. Search for "App" in the Quick Find box.
      2. Select App ManagerA (not Manage Connected Apps).
      3. Click New Connected App.
    • If your organization uses the Salesforce Classic UI:
      1. Search for "Apps" in the Quick Find box.
      2. Under Build or Create, select Apps.
      3. Under Connected Apps, click New.
  3. Enter a name to be displayed to users when they log in to grant permissions to your application. Also supply a contact email address.
  4. Select Enable OAuth Settings.
  5. Enter a value in the Callback URL box.
    • If this is a desktop application, set the Callback URL to http://localhost:33333 or a different port number of your choice.
    • If this is a Web application, set the Callback URL to a Website page where you want the user to be returned to, after they have authorized your application.
  6. Assign the following OAuth scopes:
    • Access and manage your wave data (wave_api)
    • Access and manage your data (api)
    • Perform requests on your behalf at any time (refresh_token, offline_token)

After your application is created, click the new application name. The admin console displays the OAuth client credentials, the consumer key, and consumer secret. Record this information for later use.

CData Cloud

Selecting Datasets

The following sections show how to execute SELECT statements to your Tableau CRM datasets or lenses. See Data Model for information on how the Cloud models datasets as tables and lenses as views.

Selecting Datasets

Reference the table name of a dataset by adding "Dataset_" as a prefix to the dataset name, as in the following query: 

SELECT Id, Name, Item, Quantity, Amount FROM DataSet_Test WHERE Amount = 50
The following query assumes that the dataset has the column names Id, Name, Quantity, and Amount. The dataset may have more columns than what were selected and they can be in any order.

Selecting Lenses

*Note: The Lenses that generate a Compact-Form query, are not supported at this time due to some API restrictions and will not be included in table listing. In order to make them work, currently we have this workaround as solution.

  1. From your dashboard choose LENSES
  2. Open the LENS which is not working and go to "SAQL Mode"
  3. Make a minor update (i.e: a white space in the end of the query)
  4. Save the LENS and wait some seconds for the changes to by applied
  5. After that you should be able to query that LENS

Reference the table name of a lens by adding "Lens_" as a prefix to the lens name, as in the following query. 

SELECT Id, Name, Item, Quantity, Amount FROM Lens_Test WHERE Amount = 50
The query above assumes that the lens has the column names Id, Name, Quantity, and Amount. The lens may have more columns than what were selected and they can be in any order.

CData Cloud

Inserting Datasets

The Cloud offers the possibility to insert data into your Tableau CRM datasets.

Getting the metadata file

To insert data into an exisiting dataset, first you need to download the metadata file. You can download the metadata file during the process of creating a new dataset by performing the following steps:
  1. In Tableau CRM, go to the home page, click Create, and then choose Dataset.
  2. Select CSV file to upload and click Next.
  3. From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
  4. For more info on Metadata format refer to this guide: https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_ext_data_format.pdf

or for an existing dataset, if you have a csv file with the dataset's data go through the same process as when creating a new dataset to get the metadata json file for it, but don't actually create the dataset.

Inserting data

To insert new data, the MetadataFilesLocation connection property is required. You must set its value to the location of the file where your metadata files are stored. 
INSERT INTO Dataset_Example (Col1, Col2, Col3) VALUES ('val1', 'val2', 'val3')

INSERT INTO SELECT (Bulk inserting)

First you need to insert data into a temporary table. Temporary tables are denoted by a # appearing in their name. When using a temporary table to insert, the temporary table must be named in the format [TableName]#TEMP, where TableName is the name of the table you will be inserting to. For instance: 
INSERT INTO Dataset_Example#TEMP (Col1, Col2, Col3) VALUES ('val1', 'val2', 'val3')
INSERT INTO Dataset_Example#TEMP (Col1, Col2, Col3) VALUES ('val4', 'val5', 'val6')
INSERT INTO Dataset_Example#TEMP (Col1, Col2, Col3) VALUES ('val7', 'val8', 'val9')
Then you need to insert to the actual table. 
INSERT INTO Dataset_Example (Col1, Col2, Col3) SELECT Col1, Col2, Col3 FROM Dataset_Example#TEMP
If the AsyncBulkOperation connection property is set to 'true' the provider will allow Tableau CRM to process the data while your application continues executing. The downside of using asynchronous services is that you will need to check the status of the upload manually to see if Salesforce has finished processing the request and see if there were any issues. You can do this by calling the GetJobStatus stored procedure. You can get the value of the JobId required for the GetJobStatus stored procedure from the LastResultInfo#TEMP table. 
SELECT JobId FROM LastResultInfo#TEMP

CData Cloud

Upserting Datasets

The Cloud offers the possibility to upsert data into your Tableau CRM datasets.

Getting the metadata file

To upsert data into an exisiting dataset, first you need to download the metadata file. You can download the metadata file during the process of creating a new dataset by performing the following steps:
  1. In Tableau CRM, go to the home page, click Create, and then choose Dataset.
  2. Select CSV file to upload and click Next.
  3. From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
  4. For more info on Metadata format refer to this guide: https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_ext_data_format.pdf

or for an existing dataset, if you have a csv file with the dataset's data go through the same process as when creating a new dataset to get the metadata json file for it, but don't actually create the dataset.

Upserting data

To upsert new data, the MetadataFilesLocation connection property is required. You must set its value to the location of the file where your metadata files are stored.
Note: The metadata file must contain one (and only one) field with a unique identifier. 
UPSERT INTO Dataset_Example (Col1, Col2, Col3) Values ('val1', 'val2', 'val3')

UPSERT INTO SELECT (Bulk upserting)

First you need to insert data into a temporary table. Temporary tables are denoted by a # appearing in their name. When using a temporary table to upsert, the temporary table must be named in the format [TableName]#TEMP, where TableName is the name of the table you will be upserting to. For instance: 
INSERT INTO Dataset_Example#TEMP (Col1, Col2, Col3) VALUES ('val1', 'val2', 'val3')
INSERT INTO Dataset_Example#TEMP (Col1, Col2, Col3) VALUES ('val4', 'val5', 'val6')
INSERT INTO Dataset_Example#TEMP (Col1, Col2, Col3) VALUES ('val7', 'val8', 'val9')
Then you need to upsert to the actual table. 
UPSERT INTO Dataset_Example (Col1, Col2, Col3) SELECT Col1, Col2, Col3 FROM Dataset_Example#TEMP
If the AsyncBulkOperation connection property is set to 'true' the provider will allow Tableau CRM to process the data while your application continues executing. The downside of using asynchronous services is that you will need to check the status of the upload manually to see if Salesforce has finished processing the request and see if there were any issues. You can do this by calling the GetJobStatus stored procedure. You can get the value of the JobId required for the GetJobStatus stored procedure from the LastResultInfo#TEMP table. 
SELECT JobId FROM LastResultInfo#TEMP

CData Cloud

Deleting Datasets

The Cloud offers the possibility to delete data from your Tableau CRM datasets.

Getting the metadata file

To delete data from an exisiting dataset, first you need to download the metadata file. You can download the metadata file during the process of creating a new dataset by performing the following steps:
  1. In Tableau CRM, go to the home page, click Create, and then choose Dataset.
  2. Select CSV file to upload and click Next.
  3. From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
  4. For more info on Metadata format refer to this guide: https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_ext_data_format.pdf

or for an existing dataset, if you have a csv file with the dataset's data go through the same process as when creating a new dataset to get the metadata json file for it, but don't actually create the dataset.

Deleting data

To delete existing data, the MetadataFilesLocation connection property is required. You must set its value to the location of the file where your metadata files are stored.
Note: The metadata file must contain one (and only one) field with a unique identifier. 
DELETE FROM Dataset_Example WHERE Col1='uniqueValue'

DELETE FROM EXISTS SELECT (Bulk deleting)

First you need to insert data into a temporary table. Temporary tables are denoted by a # appearing in their name. When using a temporary table to delete, the temporary table must be named in the format [TableName]#TEMP, where TableName is the name of the table you will be deleting from. For instance: 
INSERT INTO Dataset_Example#TEMP (Col1) VALUES ('uniqueValue')
INSERT INTO Dataset_Example#TEMP (Col1) VALUES ('uniqueValue')
INSERT INTO Dataset_Example#TEMP (Col1) VALUES ('uniqueValue')
Then you need to delete from the actual table. 
DELETE FROM Dataset_Example WHERE EXISTS SELECT Col1 FROM FROM Dataset_Example#TEMP
If the AsyncBulkOperation connection property is set to 'true' the provider will allow Tableau CRM to process the data while your application continues executing. The downside of using asynchronous services is that you will need to check the status of the upload manually to see if Salesforce has finished processing the request and see if there were any issues. You can do this by calling the GetJobStatus stored procedure. You can get the value of the JobId required for the GetJobStatus stored procedure from the LastResultInfo#TEMP table. 
SELECT JobId FROM LastResultInfo#TEMP

CData Cloud

Uploading Datasets

The Cloud offers the possibility to to create datasets or insert data into your Tableau CRM datasets by using CSV files.

Uploading CSV files

You can upload CSV files to datasets by using the UploadCSVToDataset stored procedure. To upload a CSV file to a dataset the following parameters are required: DatasetName, CSVFileLocation. If the AsyncBulkInsert connection property is set to 'true' the provider will allow Tableau CRM to process the data while your application continues executing. The downside of using asynchronous services is that you will need to check the status of the upload manually to see if Salesforce has finished processing the request and see if there were any issues. You can do this by calling the GetJobStatus stored procedure.
  • DatasetName: The name of dataset you want to create or append data to.
  • CSVFileLocation: The location of the CSV file containing the data that will be uploaded.
  • Operation: The operation you want to use when you're loading data into the dataset. It is set to 'Append' by default. If set to 'Overwrite', a dataset with the given data will be created, and replaced if it exists.If set to 'Append', the given data will be added to an exisiting dataset or a new dataset will be created if it does not exist. A metadata file is required for 'Append' operations. The data and metadata for the 'Append' operations must exactly match the dataset on which the operation is happening.
  • MetadataFileLocation: This parameter is required when Operation is set to 'Append'.
  • AppName: The name of the app that contains the dataset. If the name is ommitted for when you're creating a dataset, the name of the user's private app is used. If the name is omitted for an existing dataset, the system resolves the app name. If the name is specified for an existing dataset, the name is required to match the name of the current app that contains the dataset.
  • CSVFileCharset: Set this property to the actual charset of the CSV file you want to upload. You do not need to set this parameter if the file's encoding is UTF-8.

CData Cloud

SSL Configuration

Customizing the SSL Configuration

By default, the Cloud attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

CData Cloud

Firewall and Proxy

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

  • To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
  • To tunnel the connection, set FirewallType to TUNNEL.
  • To authenticate, specify FirewallUser and FirewallPassword.
  • To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

CData Cloud

Data Model

The Cloud models Tableau CRM datasets and lenses as database views, or read-only tables, using the Tableau CRM REST API. Datasets additionally support bidirectional access.

The following sections provide information on the functionality available through the views and stored procedures.

Views

You can use the Cloud to work with all the datasets and lenses in your account. View schemas are discovered dynamically at run time.

Dataset tables start with "Dataset_", so if you want to get the data of a dataset called "Test", the table name would be "Dataset_Test". Lens tables start with "Lens_", so if you want to get the data of a lens called "Test", then the table name would be "Lens_Test".

See System Tables to obtain schema information and other Cloud metadata at run time. The Views section shows an example database modeled on datasets and lenses available in the Tableau CRM development environment.

Dynamic Schemas

When you connect, the Cloud gets the list of tables and the metadata for the tables by calling the appropriate Web services. Any changes you make to your datasets or lenses, such as adding new columns or changing the data type of a column, will immediately be reflected when you connect using the Cloud.

Query Processing

The Cloud offloads as much of the SELECT statement processing as possible to Tableau CRM and then processes the rest of the query within the Cloud.

Executing SQL to Datasets and Lenses

Datasets support INSERT statements, while lenses support only SELECT; you can also call the UploadCSVToDataSet stored procedure to insert to an existing dataset or to create a new dataset.

See the following sections for examples of executing SQL to datasets and lenses:

  • Selecting Datasets
  • Inserting Datasets
  • Uploading Datasets

Customizing Schemas

You can customize table schemas to do the following:

  • Change the columns and data types reported.
  • Change the operations that can be executed against a dataset or lense.
To customize a schema, call the CreateSchema stored procedure. The stored procedure saves the dynamic schema to a static configuration file. Schema files have a simple format that makes them easy to customize.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to access other API functionality not surfaced through the views.

CData Cloud

Tables

The Cloud models the data in Tableau CRM as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cloud - 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.

CData Cloud

Dataset_Account

The Tableau CRM dataset Dataset_Account.

Columns

Name Type ReadOnly Description
AccountName String False

This field is generated dynamically and corresponds to the AccountName field in the dataset.

AccountSource String False

This field is generated dynamically and corresponds to the AccountSource field in the dataset.

AnnualRevenue Double False

This field is generated dynamically and corresponds to the AnnualRevenue field in the dataset.

BillingCountry String False

This field is generated dynamically and corresponds to the BillingCountry field in the dataset.

BillingState String False

This field is generated dynamically and corresponds to the BillingState field in the dataset.

CreatedDate Datetime False

This field is generated dynamically and corresponds to the CreatedDate field in the dataset.

CreatedDate_Day Double False

This field is generated dynamically and corresponds to the CreatedDate_Day field in the dataset.

CreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_day_epoch field in the dataset.

CreatedDate_Hour Double False

This field is generated dynamically and corresponds to the CreatedDate_Hour field in the dataset.

CreatedDate_Minute Double False

This field is generated dynamically and corresponds to the CreatedDate_Minute field in the dataset.

CreatedDate_Month Double False

This field is generated dynamically and corresponds to the CreatedDate_Month field in the dataset.

CreatedDate_Quarter Double False

This field is generated dynamically and corresponds to the CreatedDate_Quarter field in the dataset.

CreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_sec_epoch field in the dataset.

CreatedDate_Second Double False

This field is generated dynamically and corresponds to the CreatedDate_Second field in the dataset.

CreatedDate_Week Double False

This field is generated dynamically and corresponds to the CreatedDate_Week field in the dataset.

CreatedDate_Year Double False

This field is generated dynamically and corresponds to the CreatedDate_Year field in the dataset.

CustomFilter Boolean False

This field is generated dynamically and corresponds to the CustomFilter field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

Industry String False

This field is generated dynamically and corresponds to the Industry field in the dataset.

LastModifiedDate Datetime False

This field is generated dynamically and corresponds to the LastModifiedDate field in the dataset.

LastModifiedDate_Day Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Day field in the dataset.

LastModifiedDate_day_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_day_epoch field in the dataset.

LastModifiedDate_Hour Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Hour field in the dataset.

LastModifiedDate_Minute Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Minute field in the dataset.

LastModifiedDate_Month Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Month field in the dataset.

LastModifiedDate_Quarter Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Quarter field in the dataset.

LastModifiedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_sec_epoch field in the dataset.

LastModifiedDate_Second Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Second field in the dataset.

LastModifiedDate_Week Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Week field in the dataset.

LastModifiedDate_Year Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Year field in the dataset.

Name String False

This field is generated dynamically and corresponds to the Name field in the dataset.

NumberOfEmployees Double False

This field is generated dynamically and corresponds to the NumberOfEmployees field in the dataset.

OwnerFullPhotoUrl String False

This field is generated dynamically and corresponds to the OwnerFullPhotoUrl field in the dataset.

OwnerName String False

This field is generated dynamically and corresponds to the OwnerName field in the dataset.

OwnerRoleDeveloperName String False

This field is generated dynamically and corresponds to the OwnerRoleDeveloperName field in the dataset.

OwnerRoleHierarchy_RoleNames String False

This field is generated dynamically and corresponds to the OwnerRoleHierarchy_RoleNames field in the dataset.

OwnerRoleName String False

This field is generated dynamically and corresponds to the OwnerRoleName field in the dataset.

OwnerRoleParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleDeveloperName field in the dataset.

OwnerRoleParentRoleName String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleName field in the dataset.

OwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleId field in the dataset.

OwnerRoleRoleNames String False

This field is generated dynamically and corresponds to the OwnerRoleRoleNames field in the dataset.

OwnerRoleRoleNamesPath String False

This field is generated dynamically and corresponds to the OwnerRoleRoleNamesPath field in the dataset.

OwnerRoleRolePath String False

This field is generated dynamically and corresponds to the OwnerRoleRolePath field in the dataset.

OwnerRoleRoles String False

This field is generated dynamically and corresponds to the OwnerRoleRoles field in the dataset.

OwnerSmallPhotoUrl String False

This field is generated dynamically and corresponds to the OwnerSmallPhotoUrl field in the dataset.

OwnerUniqueUserName String False

This field is generated dynamically and corresponds to the OwnerUniqueUserName field in the dataset.

OwnerUsername String False

This field is generated dynamically and corresponds to the OwnerUsername field in the dataset.

OwnerUserRoleId String False

This field is generated dynamically and corresponds to the OwnerUserRoleId field in the dataset.

OwnerId String False

This field is generated dynamically and corresponds to the OwnerId field in the dataset.

Type String False

This field is generated dynamically and corresponds to the Type field in the dataset.

CData Cloud

Dataset_Activity

The Tableau CRM dataset Dataset_Activity.

Columns

Name Type ReadOnly Description
AccountAccountSource String False

This field is generated dynamically and corresponds to the AccountAccountSource field in the dataset.

AccountAnnualRevenue Double False

This field is generated dynamically and corresponds to the AccountAnnualRevenue field in the dataset.

AccountBillingCountry String False

This field is generated dynamically and corresponds to the AccountBillingCountry field in the dataset.

AccountBillingState String False

This field is generated dynamically and corresponds to the AccountBillingState field in the dataset.

AccountIndustry String False

This field is generated dynamically and corresponds to the AccountIndustry field in the dataset.

AccountName String False

This field is generated dynamically and corresponds to the AccountName field in the dataset.

AccountNumberOfEmployees Double False

This field is generated dynamically and corresponds to the AccountNumberOfEmployees field in the dataset.

AccountOwnerName String False

This field is generated dynamically and corresponds to the AccountOwnerName field in the dataset.

AccountOwnerRoleName String False

This field is generated dynamically and corresponds to the AccountOwnerRoleName field in the dataset.

AccountOwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the AccountOwnerRoleParentRoleId field in the dataset.

AccountOwnerRoleRolePath String False

This field is generated dynamically and corresponds to the AccountOwnerRoleRolePath field in the dataset.

AccountOwnerRoleRoles String False

This field is generated dynamically and corresponds to the AccountOwnerRoleRoles field in the dataset.

AccountOwnerUniqueUserName String False

This field is generated dynamically and corresponds to the AccountOwnerUniqueUserName field in the dataset.

AccountOwnerId String False

This field is generated dynamically and corresponds to the AccountOwnerId field in the dataset.

AccountType String False

This field is generated dynamically and corresponds to the AccountType field in the dataset.

AccountId String False

This field is generated dynamically and corresponds to the AccountId field in the dataset.

ActivityDate Datetime False

This field is generated dynamically and corresponds to the ActivityDate field in the dataset.

ActivityDate_Day Double False

This field is generated dynamically and corresponds to the ActivityDate_Day field in the dataset.

ActivityDate_day_epoch Double False

This field is generated dynamically and corresponds to the ActivityDate_day_epoch field in the dataset.

ActivityDate_Hour Double False

This field is generated dynamically and corresponds to the ActivityDate_Hour field in the dataset.

ActivityDate_Minute Double False

This field is generated dynamically and corresponds to the ActivityDate_Minute field in the dataset.

ActivityDate_Month Double False

This field is generated dynamically and corresponds to the ActivityDate_Month field in the dataset.

ActivityDate_Quarter Double False

This field is generated dynamically and corresponds to the ActivityDate_Quarter field in the dataset.

ActivityDate_sec_epoch Double False

This field is generated dynamically and corresponds to the ActivityDate_sec_epoch field in the dataset.

ActivityDate_Second Double False

This field is generated dynamically and corresponds to the ActivityDate_Second field in the dataset.

ActivityDate_Week Double False

This field is generated dynamically and corresponds to the ActivityDate_Week field in the dataset.

ActivityDate_Year Double False

This field is generated dynamically and corresponds to the ActivityDate_Year field in the dataset.

AssignedToName String False

This field is generated dynamically and corresponds to the AssignedToName field in the dataset.

AssignedToUniqueUserName String False

This field is generated dynamically and corresponds to the AssignedToUniqueUserName field in the dataset.

CallDisposition String False

This field is generated dynamically and corresponds to the CallDisposition field in the dataset.

CallDurationInSeconds Double False

This field is generated dynamically and corresponds to the CallDurationInSeconds field in the dataset.

CallType String False

This field is generated dynamically and corresponds to the CallType field in the dataset.

CreatedDate Datetime False

This field is generated dynamically and corresponds to the CreatedDate field in the dataset.

CreatedDate_Day Double False

This field is generated dynamically and corresponds to the CreatedDate_Day field in the dataset.

CreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_day_epoch field in the dataset.

CreatedDate_Hour Double False

This field is generated dynamically and corresponds to the CreatedDate_Hour field in the dataset.

CreatedDate_Minute Double False

This field is generated dynamically and corresponds to the CreatedDate_Minute field in the dataset.

CreatedDate_Month Double False

This field is generated dynamically and corresponds to the CreatedDate_Month field in the dataset.

CreatedDate_Quarter Double False

This field is generated dynamically and corresponds to the CreatedDate_Quarter field in the dataset.

CreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_sec_epoch field in the dataset.

CreatedDate_Second Double False

This field is generated dynamically and corresponds to the CreatedDate_Second field in the dataset.

CreatedDate_Week Double False

This field is generated dynamically and corresponds to the CreatedDate_Week field in the dataset.

CreatedDate_Year Double False

This field is generated dynamically and corresponds to the CreatedDate_Year field in the dataset.

CustomFilter Boolean False

This field is generated dynamically and corresponds to the CustomFilter field in the dataset.

DaysOverdue Double False

This field is generated dynamically and corresponds to the DaysOverdue field in the dataset.

DurationInMinutes Double False

This field is generated dynamically and corresponds to the DurationInMinutes field in the dataset.

EventSubtype String False

This field is generated dynamically and corresponds to the EventSubtype field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

IsClosed Boolean False

This field is generated dynamically and corresponds to the IsClosed field in the dataset.

IsOverdue Boolean False

This field is generated dynamically and corresponds to the IsOverdue field in the dataset.

LastModifiedDate Datetime False

This field is generated dynamically and corresponds to the LastModifiedDate field in the dataset.

LastModifiedDate_Day Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Day field in the dataset.

LastModifiedDate_day_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_day_epoch field in the dataset.

LastModifiedDate_Hour Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Hour field in the dataset.

LastModifiedDate_Minute Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Minute field in the dataset.

LastModifiedDate_Month Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Month field in the dataset.

LastModifiedDate_Quarter Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Quarter field in the dataset.

LastModifiedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_sec_epoch field in the dataset.

LastModifiedDate_Second Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Second field in the dataset.

LastModifiedDate_Week Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Week field in the dataset.

LastModifiedDate_Year Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Year field in the dataset.

OpportunityAccountAccountSource String False

This field is generated dynamically and corresponds to the OpportunityAccountAccountSource field in the dataset.

OpportunityAccountBillingCountry String False

This field is generated dynamically and corresponds to the OpportunityAccountBillingCountry field in the dataset.

OpportunityAccountBillingState String False

This field is generated dynamically and corresponds to the OpportunityAccountBillingState field in the dataset.

OpportunityAccountIndustry String False

This field is generated dynamically and corresponds to the OpportunityAccountIndustry field in the dataset.

OpportunityAccountName String False

This field is generated dynamically and corresponds to the OpportunityAccountName field in the dataset.

OpportunityAccountOwnerId String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerId field in the dataset.

OpportunityAccountType String False

This field is generated dynamically and corresponds to the OpportunityAccountType field in the dataset.

OpportunityAccountId String False

This field is generated dynamically and corresponds to the OpportunityAccountId field in the dataset.

OpportunityCloseDate String False

This field is generated dynamically and corresponds to the OpportunityCloseDate field in the dataset.

OpportunityCloseDate_Day String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Day field in the dataset.

OpportunityCloseDate_day_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_day_epoch field in the dataset.

OpportunityCloseDate_Hour String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Hour field in the dataset.

OpportunityCloseDate_Minute String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Minute field in the dataset.

OpportunityCloseDate_Month String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Month field in the dataset.

OpportunityCloseDate_Quarter String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Quarter field in the dataset.

OpportunityCloseDate_sec_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_sec_epoch field in the dataset.

OpportunityCloseDate_Second String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Second field in the dataset.

OpportunityCloseDate_Week String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Week field in the dataset.

OpportunityCloseDate_Year String False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Year field in the dataset.

OpportunityCreatedDate String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate field in the dataset.

OpportunityCreatedDate_Day String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Day field in the dataset.

OpportunityCreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_day_epoch field in the dataset.

OpportunityCreatedDate_Hour String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Hour field in the dataset.

OpportunityCreatedDate_Minute String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Minute field in the dataset.

OpportunityCreatedDate_Month String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Month field in the dataset.

OpportunityCreatedDate_Quarter String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Quarter field in the dataset.

OpportunityCreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_sec_epoch field in the dataset.

OpportunityCreatedDate_Second String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Second field in the dataset.

OpportunityCreatedDate_Week String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Week field in the dataset.

OpportunityCreatedDate_Year String False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Year field in the dataset.

OpportunityDaysPastDue Double False

This field is generated dynamically and corresponds to the OpportunityDaysPastDue field in the dataset.

OpportunityDaysSinceLastActivity Double False

This field is generated dynamically and corresponds to the OpportunityDaysSinceLastActivity field in the dataset.

OpportunityForecastCategoryName String False

This field is generated dynamically and corresponds to the OpportunityForecastCategoryName field in the dataset.

OpportunityId String False

This field is generated dynamically and corresponds to the OpportunityId field in the dataset.

OpportunityIsClosed String False

This field is generated dynamically and corresponds to the OpportunityIsClosed field in the dataset.

OpportunityIsLost String False

This field is generated dynamically and corresponds to the OpportunityIsLost field in the dataset.

OpportunityIsPastDue String False

This field is generated dynamically and corresponds to the OpportunityIsPastDue field in the dataset.

OpportunityIsWon String False

This field is generated dynamically and corresponds to the OpportunityIsWon field in the dataset.

OpportunityLeadSource String False

This field is generated dynamically and corresponds to the OpportunityLeadSource field in the dataset.

OpportunityName String False

This field is generated dynamically and corresponds to the OpportunityName field in the dataset.

OpportunityNeglected String False

This field is generated dynamically and corresponds to the OpportunityNeglected field in the dataset.

OpportunityOpportunityAge Double False

This field is generated dynamically and corresponds to the OpportunityOpportunityAge field in the dataset.

OpportunityOwnerId String False

This field is generated dynamically and corresponds to the OpportunityOwnerId field in the dataset.

OpportunityProductFamily String False

This field is generated dynamically and corresponds to the OpportunityProductFamily field in the dataset.

OpportunityProductName String False

This field is generated dynamically and corresponds to the OpportunityProductName field in the dataset.

OpportunityRecordTypeName String False

This field is generated dynamically and corresponds to the OpportunityRecordTypeName field in the dataset.

OpportunityRecordTypeId String False

This field is generated dynamically and corresponds to the OpportunityRecordTypeId field in the dataset.

OpportunityStageName String False

This field is generated dynamically and corresponds to the OpportunityStageName field in the dataset.

OpportunityType String False

This field is generated dynamically and corresponds to the OpportunityType field in the dataset.

OwnerFullPhotoUrl String False

This field is generated dynamically and corresponds to the OwnerFullPhotoUrl field in the dataset.

OwnerName String False

This field is generated dynamically and corresponds to the OwnerName field in the dataset.

OwnerRoleDeveloperName String False

This field is generated dynamically and corresponds to the OwnerRoleDeveloperName field in the dataset.

OwnerRoleHierarchy_RoleNames String False

This field is generated dynamically and corresponds to the OwnerRoleHierarchy_RoleNames field in the dataset.

OwnerRoleName String False

This field is generated dynamically and corresponds to the OwnerRoleName field in the dataset.

OwnerRoleParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleDeveloperName field in the dataset.

OwnerRoleParentRoleName String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleName field in the dataset.

OwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleId field in the dataset.

OwnerRoleRoleNames String False

This field is generated dynamically and corresponds to the OwnerRoleRoleNames field in the dataset.

OwnerRoleRoleNamesPath String False

This field is generated dynamically and corresponds to the OwnerRoleRoleNamesPath field in the dataset.

OwnerRoleRolePath String False

This field is generated dynamically and corresponds to the OwnerRoleRolePath field in the dataset.

OwnerRoleRoles String False

This field is generated dynamically and corresponds to the OwnerRoleRoles field in the dataset.

OwnerSmallPhotoUrl String False

This field is generated dynamically and corresponds to the OwnerSmallPhotoUrl field in the dataset.

OwnerUniqueUserName String False

This field is generated dynamically and corresponds to the OwnerUniqueUserName field in the dataset.

OwnerUsername String False

This field is generated dynamically and corresponds to the OwnerUsername field in the dataset.

OwnerUserRoleId String False

This field is generated dynamically and corresponds to the OwnerUserRoleId field in the dataset.

OwnerId String False

This field is generated dynamically and corresponds to the OwnerId field in the dataset.

Priority String False

This field is generated dynamically and corresponds to the Priority field in the dataset.

Status String False

This field is generated dynamically and corresponds to the Status field in the dataset.

Subject String False

This field is generated dynamically and corresponds to the Subject field in the dataset.

TaskSubtype String False

This field is generated dynamically and corresponds to the TaskSubtype field in the dataset.

WhatId String False

This field is generated dynamically and corresponds to the WhatId field in the dataset.

CData Cloud

Dataset_Analytics

The Tableau CRM dataset Dataset_Analytics.

Columns

Name Type ReadOnly Description
Date Datetime False

This field is generated dynamically and corresponds to the Date field in the dataset.

Date_Day Double False

This field is generated dynamically and corresponds to the Date_Day field in the dataset.

Date_day_epoch Double False

This field is generated dynamically and corresponds to the Date_day_epoch field in the dataset.

Date_Hour Double False

This field is generated dynamically and corresponds to the Date_Hour field in the dataset.

Date_Minute Double False

This field is generated dynamically and corresponds to the Date_Minute field in the dataset.

Date_Month Double False

This field is generated dynamically and corresponds to the Date_Month field in the dataset.

Date_Quarter Double False

This field is generated dynamically and corresponds to the Date_Quarter field in the dataset.

Date_sec_epoch Double False

This field is generated dynamically and corresponds to the Date_sec_epoch field in the dataset.

Date_Second Double False

This field is generated dynamically and corresponds to the Date_Second field in the dataset.

Date_Week Double False

This field is generated dynamically and corresponds to the Date_Week field in the dataset.

Date_Year Double False

This field is generated dynamically and corresponds to the Date_Year field in the dataset.

Name String False

This field is generated dynamically and corresponds to the Name field in the dataset.

CData Cloud

Dataset_Case

The Tableau CRM dataset Dataset_Case.

Columns

Name Type ReadOnly Description
AccountAccountSource String False

This field is generated dynamically and corresponds to the AccountAccountSource field in the dataset.

AccountAnnualRevenue Double False

This field is generated dynamically and corresponds to the AccountAnnualRevenue field in the dataset.

AccountBillingCountry String False

This field is generated dynamically and corresponds to the AccountBillingCountry field in the dataset.

AccountBillingState String False

This field is generated dynamically and corresponds to the AccountBillingState field in the dataset.

AccountIndustry String False

This field is generated dynamically and corresponds to the AccountIndustry field in the dataset.

AccountName String False

This field is generated dynamically and corresponds to the AccountName field in the dataset.

AccountNumberOfEmployees Double False

This field is generated dynamically and corresponds to the AccountNumberOfEmployees field in the dataset.

AccountOwnerName String False

This field is generated dynamically and corresponds to the AccountOwnerName field in the dataset.

AccountOwnerRoleName String False

This field is generated dynamically and corresponds to the AccountOwnerRoleName field in the dataset.

AccountOwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the AccountOwnerRoleParentRoleId field in the dataset.

AccountOwnerRoleRolePath String False

This field is generated dynamically and corresponds to the AccountOwnerRoleRolePath field in the dataset.

AccountOwnerRoleRoles String False

This field is generated dynamically and corresponds to the AccountOwnerRoleRoles field in the dataset.

AccountOwnerUniqueUserName String False

This field is generated dynamically and corresponds to the AccountOwnerUniqueUserName field in the dataset.

AccountOwnerId String False

This field is generated dynamically and corresponds to the AccountOwnerId field in the dataset.

AccountType String False

This field is generated dynamically and corresponds to the AccountType field in the dataset.

AccountId String False

This field is generated dynamically and corresponds to the AccountId field in the dataset.

CaseNumber Double False

This field is generated dynamically and corresponds to the CaseNumber field in the dataset.

ClosedDate Datetime False

This field is generated dynamically and corresponds to the ClosedDate field in the dataset.

ClosedDate_Day Double False

This field is generated dynamically and corresponds to the ClosedDate_Day field in the dataset.

ClosedDate_day_epoch Double False

This field is generated dynamically and corresponds to the ClosedDate_day_epoch field in the dataset.

ClosedDate_Hour Double False

This field is generated dynamically and corresponds to the ClosedDate_Hour field in the dataset.

ClosedDate_Minute Double False

This field is generated dynamically and corresponds to the ClosedDate_Minute field in the dataset.

ClosedDate_Month Double False

This field is generated dynamically and corresponds to the ClosedDate_Month field in the dataset.

ClosedDate_Quarter Double False

This field is generated dynamically and corresponds to the ClosedDate_Quarter field in the dataset.

ClosedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the ClosedDate_sec_epoch field in the dataset.

ClosedDate_Second Double False

This field is generated dynamically and corresponds to the ClosedDate_Second field in the dataset.

ClosedDate_Week Double False

This field is generated dynamically and corresponds to the ClosedDate_Week field in the dataset.

ClosedDate_Year Double False

This field is generated dynamically and corresponds to the ClosedDate_Year field in the dataset.

ContactId String False

This field is generated dynamically and corresponds to the ContactId field in the dataset.

CreatedDate Datetime False

This field is generated dynamically and corresponds to the CreatedDate field in the dataset.

CreatedDate_Day Double False

This field is generated dynamically and corresponds to the CreatedDate_Day field in the dataset.

CreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_day_epoch field in the dataset.

CreatedDate_Hour Double False

This field is generated dynamically and corresponds to the CreatedDate_Hour field in the dataset.

CreatedDate_Minute Double False

This field is generated dynamically and corresponds to the CreatedDate_Minute field in the dataset.

CreatedDate_Month Double False

This field is generated dynamically and corresponds to the CreatedDate_Month field in the dataset.

CreatedDate_Quarter Double False

This field is generated dynamically and corresponds to the CreatedDate_Quarter field in the dataset.

CreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_sec_epoch field in the dataset.

CreatedDate_Second Double False

This field is generated dynamically and corresponds to the CreatedDate_Second field in the dataset.

CreatedDate_Week Double False

This field is generated dynamically and corresponds to the CreatedDate_Week field in the dataset.

CreatedDate_Year Double False

This field is generated dynamically and corresponds to the CreatedDate_Year field in the dataset.

CurrentDate Datetime False

This field is generated dynamically and corresponds to the CurrentDate field in the dataset.

CurrentDate_Day Double False

This field is generated dynamically and corresponds to the CurrentDate_Day field in the dataset.

CurrentDate_day_epoch Double False

This field is generated dynamically and corresponds to the CurrentDate_day_epoch field in the dataset.

CurrentDate_Hour Double False

This field is generated dynamically and corresponds to the CurrentDate_Hour field in the dataset.

CurrentDate_Minute Double False

This field is generated dynamically and corresponds to the CurrentDate_Minute field in the dataset.

CurrentDate_Month Double False

This field is generated dynamically and corresponds to the CurrentDate_Month field in the dataset.

CurrentDate_Quarter Double False

This field is generated dynamically and corresponds to the CurrentDate_Quarter field in the dataset.

CurrentDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CurrentDate_sec_epoch field in the dataset.

CurrentDate_Second Double False

This field is generated dynamically and corresponds to the CurrentDate_Second field in the dataset.

CurrentDate_Week Double False

This field is generated dynamically and corresponds to the CurrentDate_Week field in the dataset.

CurrentDate_Year Double False

This field is generated dynamically and corresponds to the CurrentDate_Year field in the dataset.

DurationCalculatedField Double False

This field is generated dynamically and corresponds to the DurationCalculatedField field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

IsClosed Boolean False

This field is generated dynamically and corresponds to the IsClosed field in the dataset.

IsEscalated Boolean False

This field is generated dynamically and corresponds to the IsEscalated field in the dataset.

LastModifiedDate Datetime False

This field is generated dynamically and corresponds to the LastModifiedDate field in the dataset.

LastModifiedDate_Day Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Day field in the dataset.

LastModifiedDate_day_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_day_epoch field in the dataset.

LastModifiedDate_Hour Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Hour field in the dataset.

LastModifiedDate_Minute Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Minute field in the dataset.

LastModifiedDate_Month Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Month field in the dataset.

LastModifiedDate_Quarter Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Quarter field in the dataset.

LastModifiedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_sec_epoch field in the dataset.

LastModifiedDate_Second Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Second field in the dataset.

LastModifiedDate_Week Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Week field in the dataset.

LastModifiedDate_Year Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Year field in the dataset.

OpportunityAmount Double False

This field is generated dynamically and corresponds to the OpportunityAmount field in the dataset.

Origin String False

This field is generated dynamically and corresponds to the Origin field in the dataset.

OwnerId String False

This field is generated dynamically and corresponds to the OwnerId field in the dataset.

Status String False

This field is generated dynamically and corresponds to the Status field in the dataset.

Subject String False

This field is generated dynamically and corresponds to the Subject field in the dataset.

Type String False

This field is generated dynamically and corresponds to the Type field in the dataset.

CData Cloud

Dataset_DTC_Opportunity_SAMPLE

The Tableau CRM dataset Dataset_DTC_Opportunity_SAMPLE.

Columns

Name Type ReadOnly Description
Account_Name String False

This field is generated dynamically and corresponds to the Account_Name field in the dataset.

Account_Owner String False

This field is generated dynamically and corresponds to the Account_Owner field in the dataset.

Account_Type String False

This field is generated dynamically and corresponds to the Account_Type field in the dataset.

Amount Double False

This field is generated dynamically and corresponds to the Amount field in the dataset.

Billing_Country String False

This field is generated dynamically and corresponds to the Billing_Country field in the dataset.

Billing_State_Province String False

This field is generated dynamically and corresponds to the Billing_State_Province field in the dataset.

Close_Date Datetime False

This field is generated dynamically and corresponds to the Close_Date field in the dataset.

Close_Date_Day Double False

This field is generated dynamically and corresponds to the Close_Date_Day field in the dataset.

Close_Date_day_epoch Double False

This field is generated dynamically and corresponds to the Close_Date_day_epoch field in the dataset.

Close_Date_Hour Double False

This field is generated dynamically and corresponds to the Close_Date_Hour field in the dataset.

Close_Date_Minute Double False

This field is generated dynamically and corresponds to the Close_Date_Minute field in the dataset.

Close_Date_Month Double False

This field is generated dynamically and corresponds to the Close_Date_Month field in the dataset.

Close_Date_Quarter Double False

This field is generated dynamically and corresponds to the Close_Date_Quarter field in the dataset.

Close_Date_sec_epoch Double False

This field is generated dynamically and corresponds to the Close_Date_sec_epoch field in the dataset.

Close_Date_Second Double False

This field is generated dynamically and corresponds to the Close_Date_Second field in the dataset.

Close_Date_Week Double False

This field is generated dynamically and corresponds to the Close_Date_Week field in the dataset.

Close_Date_Year Double False

This field is generated dynamically and corresponds to the Close_Date_Year field in the dataset.

Closed Boolean False

This field is generated dynamically and corresponds to the Closed field in the dataset.

Column1 Double False

This field is generated dynamically and corresponds to the Column1 field in the dataset.

Created_Date Datetime False

This field is generated dynamically and corresponds to the Created_Date field in the dataset.

Created_Date_Day Double False

This field is generated dynamically and corresponds to the Created_Date_Day field in the dataset.

Created_Date_day_epoch Double False

This field is generated dynamically and corresponds to the Created_Date_day_epoch field in the dataset.

Created_Date_Hour Double False

This field is generated dynamically and corresponds to the Created_Date_Hour field in the dataset.

Created_Date_Minute Double False

This field is generated dynamically and corresponds to the Created_Date_Minute field in the dataset.

Created_Date_Month Double False

This field is generated dynamically and corresponds to the Created_Date_Month field in the dataset.

Created_Date_Quarter Double False

This field is generated dynamically and corresponds to the Created_Date_Quarter field in the dataset.

Created_Date_sec_epoch Double False

This field is generated dynamically and corresponds to the Created_Date_sec_epoch field in the dataset.

Created_Date_Second Double False

This field is generated dynamically and corresponds to the Created_Date_Second field in the dataset.

Created_Date_Week Double False

This field is generated dynamically and corresponds to the Created_Date_Week field in the dataset.

Created_Date_Year Double False

This field is generated dynamically and corresponds to the Created_Date_Year field in the dataset.

Forecast_Category String False

This field is generated dynamically and corresponds to the Forecast_Category field in the dataset.

Industry String False

This field is generated dynamically and corresponds to the Industry field in the dataset.

Opportunity_Name String False

This field is generated dynamically and corresponds to the Opportunity_Name field in the dataset.

Opportunity_Owner String False

This field is generated dynamically and corresponds to the Opportunity_Owner field in the dataset.

Opportunity_Source String False

This field is generated dynamically and corresponds to the Opportunity_Source field in the dataset.

Opportunity_Type String False

This field is generated dynamically and corresponds to the Opportunity_Type field in the dataset.

Owner_Role String False

This field is generated dynamically and corresponds to the Owner_Role field in the dataset.

Product_Family String False

This field is generated dynamically and corresponds to the Product_Family field in the dataset.

Product_Name String False

This field is generated dynamically and corresponds to the Product_Name field in the dataset.

Segment String False

This field is generated dynamically and corresponds to the Segment field in the dataset.

Stage String False

This field is generated dynamically and corresponds to the Stage field in the dataset.

Won Boolean False

This field is generated dynamically and corresponds to the Won field in the dataset.

CData Cloud

Dataset_Fashion

The Tableau CRM dataset Dataset_Fashion.

Columns

Name Type ReadOnly Description
Body_HTML String False

This field is generated dynamically and corresponds to the Body_HTML field in the dataset.

Gift_Card Boolean False

This field is generated dynamically and corresponds to the Gift_Card field in the dataset.

Google_Shopping_AdWords_Grouping String False

This field is generated dynamically and corresponds to the Google_Shopping_AdWords_Grouping field in the dataset.

Google_Shopping_AdWords_Labels String False

This field is generated dynamically and corresponds to the Google_Shopping_AdWords_Labels field in the dataset.

Google_Shopping_Age_Group String False

This field is generated dynamically and corresponds to the Google_Shopping_Age_Group field in the dataset.

Google_Shopping_Condition String False

This field is generated dynamically and corresponds to the Google_Shopping_Condition field in the dataset.

Google_Shopping_Custom_Label_0 String False

This field is generated dynamically and corresponds to the Google_Shopping_Custom_Label_0 field in the dataset.

Google_Shopping_Custom_Label_1 String False

This field is generated dynamically and corresponds to the Google_Shopping_Custom_Label_1 field in the dataset.

Google_Shopping_Custom_Label_2 String False

This field is generated dynamically and corresponds to the Google_Shopping_Custom_Label_2 field in the dataset.

Google_Shopping_Custom_Label_3 String False

This field is generated dynamically and corresponds to the Google_Shopping_Custom_Label_3 field in the dataset.

Google_Shopping_Custom_Label_4 String False

This field is generated dynamically and corresponds to the Google_Shopping_Custom_Label_4 field in the dataset.

Google_Shopping_Custom_Product Boolean False

This field is generated dynamically and corresponds to the Google_Shopping_Custom_Product field in the dataset.

Google_Shopping_Gender String False

This field is generated dynamically and corresponds to the Google_Shopping_Gender field in the dataset.

Google_Shopping_Google_Product_Category String False

This field is generated dynamically and corresponds to the Google_Shopping_Google_Product_Category field in the dataset.

Google_Shopping_MPN String False

This field is generated dynamically and corresponds to the Google_Shopping_MPN field in the dataset.

Handle String False

This field is generated dynamically and corresponds to the Handle field in the dataset.

Image_Alt_Text String False

This field is generated dynamically and corresponds to the Image_Alt_Text field in the dataset.

Image_Src String False

This field is generated dynamically and corresponds to the Image_Src field in the dataset.

Option1_Name String False

This field is generated dynamically and corresponds to the Option1_Name field in the dataset.

Option1_Value String False

This field is generated dynamically and corresponds to the Option1_Value field in the dataset.

Option2_Name String False

This field is generated dynamically and corresponds to the Option2_Name field in the dataset.

Option2_Value String False

This field is generated dynamically and corresponds to the Option2_Value field in the dataset.

Option3_Name String False

This field is generated dynamically and corresponds to the Option3_Name field in the dataset.

Option3_Value String False

This field is generated dynamically and corresponds to the Option3_Value field in the dataset.

Published Boolean False

This field is generated dynamically and corresponds to the Published field in the dataset.

SEO_Description String False

This field is generated dynamically and corresponds to the SEO_Description field in the dataset.

SEO_Title String False

This field is generated dynamically and corresponds to the SEO_Title field in the dataset.

Tags String False

This field is generated dynamically and corresponds to the Tags field in the dataset.

Title String False

This field is generated dynamically and corresponds to the Title field in the dataset.

Type String False

This field is generated dynamically and corresponds to the Type field in the dataset.

Variant_Barcode String False

This field is generated dynamically and corresponds to the Variant_Barcode field in the dataset.

Variant_Compare_At_Price String False

This field is generated dynamically and corresponds to the Variant_Compare_At_Price field in the dataset.

Variant_Fulfillment_Service String False

This field is generated dynamically and corresponds to the Variant_Fulfillment_Service field in the dataset.

Variant_Grams Double False

This field is generated dynamically and corresponds to the Variant_Grams field in the dataset.

Variant_Image String False

This field is generated dynamically and corresponds to the Variant_Image field in the dataset.

Variant_Inventory_Policy String False

This field is generated dynamically and corresponds to the Variant_Inventory_Policy field in the dataset.

Variant_Inventory_Qty Double False

This field is generated dynamically and corresponds to the Variant_Inventory_Qty field in the dataset.

Variant_Inventory_Tracker String False

This field is generated dynamically and corresponds to the Variant_Inventory_Tracker field in the dataset.

Variant_Price Double False

This field is generated dynamically and corresponds to the Variant_Price field in the dataset.

Variant_Requires_Shipping Boolean False

This field is generated dynamically and corresponds to the Variant_Requires_Shipping field in the dataset.

Variant_SKU String False

This field is generated dynamically and corresponds to the Variant_SKU field in the dataset.

Variant_Taxable Boolean False

This field is generated dynamically and corresponds to the Variant_Taxable field in the dataset.

Variant_Weight_Unit String False

This field is generated dynamically and corresponds to the Variant_Weight_Unit field in the dataset.

Vendor String False

This field is generated dynamically and corresponds to the Vendor field in the dataset.

CData Cloud

Dataset_OneMillion

The Tableau CRM dataset Dataset_OneMillion.

Columns

Name Type ReadOnly Description
Col_1 String False

This field is generated dynamically and corresponds to the Col_1 field in the dataset.

Col_10 String False

This field is generated dynamically and corresponds to the Col_10 field in the dataset.

Col_2 String False

This field is generated dynamically and corresponds to the Col_2 field in the dataset.

Col_3 String False

This field is generated dynamically and corresponds to the Col_3 field in the dataset.

Col_4 String False

This field is generated dynamically and corresponds to the Col_4 field in the dataset.

Col_5 String False

This field is generated dynamically and corresponds to the Col_5 field in the dataset.

Col_6 String False

This field is generated dynamically and corresponds to the Col_6 field in the dataset.

Col_7 String False

This field is generated dynamically and corresponds to the Col_7 field in the dataset.

Col_8 String False

This field is generated dynamically and corresponds to the Col_8 field in the dataset.

Col_9 String False

This field is generated dynamically and corresponds to the Col_9 field in the dataset.

CData Cloud

Dataset_Opportunity

The Tableau CRM dataset Dataset_Opportunity.

Columns

Name Type ReadOnly Description
AccountAccountSource String False

This field is generated dynamically and corresponds to the AccountAccountSource field in the dataset.

AccountAnnualRevenue Double False

This field is generated dynamically and corresponds to the AccountAnnualRevenue field in the dataset.

AccountBillingCountry String False

This field is generated dynamically and corresponds to the AccountBillingCountry field in the dataset.

AccountBillingState String False

This field is generated dynamically and corresponds to the AccountBillingState field in the dataset.

AccountIndustry String False

This field is generated dynamically and corresponds to the AccountIndustry field in the dataset.

AccountName String False

This field is generated dynamically and corresponds to the AccountName field in the dataset.

AccountNumberOfEmployees Double False

This field is generated dynamically and corresponds to the AccountNumberOfEmployees field in the dataset.

AccountOwnerName String False

This field is generated dynamically and corresponds to the AccountOwnerName field in the dataset.

AccountOwnerRoleName String False

This field is generated dynamically and corresponds to the AccountOwnerRoleName field in the dataset.

AccountOwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the AccountOwnerRoleParentRoleId field in the dataset.

AccountOwnerRoleRolePath String False

This field is generated dynamically and corresponds to the AccountOwnerRoleRolePath field in the dataset.

AccountOwnerRoleRoles String False

This field is generated dynamically and corresponds to the AccountOwnerRoleRoles field in the dataset.

AccountOwnerUniqueUserName String False

This field is generated dynamically and corresponds to the AccountOwnerUniqueUserName field in the dataset.

AccountOwnerId String False

This field is generated dynamically and corresponds to the AccountOwnerId field in the dataset.

AccountType String False

This field is generated dynamically and corresponds to the AccountType field in the dataset.

AccountId String False

This field is generated dynamically and corresponds to the AccountId field in the dataset.

Amount Double False

This field is generated dynamically and corresponds to the Amount field in the dataset.

CloseDate Datetime False

This field is generated dynamically and corresponds to the CloseDate field in the dataset.

CloseDate_Day Double False

This field is generated dynamically and corresponds to the CloseDate_Day field in the dataset.

CloseDate_day_epoch Double False

This field is generated dynamically and corresponds to the CloseDate_day_epoch field in the dataset.

CloseDate_Hour Double False

This field is generated dynamically and corresponds to the CloseDate_Hour field in the dataset.

CloseDate_Minute Double False

This field is generated dynamically and corresponds to the CloseDate_Minute field in the dataset.

CloseDate_Month Double False

This field is generated dynamically and corresponds to the CloseDate_Month field in the dataset.

CloseDate_Quarter Double False

This field is generated dynamically and corresponds to the CloseDate_Quarter field in the dataset.

CloseDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CloseDate_sec_epoch field in the dataset.

CloseDate_Second Double False

This field is generated dynamically and corresponds to the CloseDate_Second field in the dataset.

CloseDate_Week Double False

This field is generated dynamically and corresponds to the CloseDate_Week field in the dataset.

CloseDate_Year Double False

This field is generated dynamically and corresponds to the CloseDate_Year field in the dataset.

CreatedById String False

This field is generated dynamically and corresponds to the CreatedById field in the dataset.

CreatedDate Datetime False

This field is generated dynamically and corresponds to the CreatedDate field in the dataset.

CreatedDate_Day Double False

This field is generated dynamically and corresponds to the CreatedDate_Day field in the dataset.

CreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_day_epoch field in the dataset.

CreatedDate_Hour Double False

This field is generated dynamically and corresponds to the CreatedDate_Hour field in the dataset.

CreatedDate_Minute Double False

This field is generated dynamically and corresponds to the CreatedDate_Minute field in the dataset.

CreatedDate_Month Double False

This field is generated dynamically and corresponds to the CreatedDate_Month field in the dataset.

CreatedDate_Quarter Double False

This field is generated dynamically and corresponds to the CreatedDate_Quarter field in the dataset.

CreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_sec_epoch field in the dataset.

CreatedDate_Second Double False

This field is generated dynamically and corresponds to the CreatedDate_Second field in the dataset.

CreatedDate_Week Double False

This field is generated dynamically and corresponds to the CreatedDate_Week field in the dataset.

CreatedDate_Year Double False

This field is generated dynamically and corresponds to the CreatedDate_Year field in the dataset.

CustomFilter Boolean False

This field is generated dynamically and corresponds to the CustomFilter field in the dataset.

DaysPastDue Double False

This field is generated dynamically and corresponds to the DaysPastDue field in the dataset.

DaysSinceLastActivity Double False

This field is generated dynamically and corresponds to the DaysSinceLastActivity field in the dataset.

ForecastCategory String False

This field is generated dynamically and corresponds to the ForecastCategory field in the dataset.

ForecastCategoryName String False

This field is generated dynamically and corresponds to the ForecastCategoryName field in the dataset.

HasOpportunityLineItem Boolean False

This field is generated dynamically and corresponds to the HasOpportunityLineItem field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

IsClosed Boolean False

This field is generated dynamically and corresponds to the IsClosed field in the dataset.

IsLost String False

This field is generated dynamically and corresponds to the IsLost field in the dataset.

IsPastDue Boolean False

This field is generated dynamically and corresponds to the IsPastDue field in the dataset.

IsWon Boolean False

This field is generated dynamically and corresponds to the IsWon field in the dataset.

LastActivityDate Datetime False

This field is generated dynamically and corresponds to the LastActivityDate field in the dataset.

LastActivityDate_Day Double False

This field is generated dynamically and corresponds to the LastActivityDate_Day field in the dataset.

LastActivityDate_day_epoch Double False

This field is generated dynamically and corresponds to the LastActivityDate_day_epoch field in the dataset.

LastActivityDate_Hour Double False

This field is generated dynamically and corresponds to the LastActivityDate_Hour field in the dataset.

LastActivityDate_Minute Double False

This field is generated dynamically and corresponds to the LastActivityDate_Minute field in the dataset.

LastActivityDate_Month Double False

This field is generated dynamically and corresponds to the LastActivityDate_Month field in the dataset.

LastActivityDate_Quarter Double False

This field is generated dynamically and corresponds to the LastActivityDate_Quarter field in the dataset.

LastActivityDate_sec_epoch Double False

This field is generated dynamically and corresponds to the LastActivityDate_sec_epoch field in the dataset.

LastActivityDate_Second Double False

This field is generated dynamically and corresponds to the LastActivityDate_Second field in the dataset.

LastActivityDate_Week Double False

This field is generated dynamically and corresponds to the LastActivityDate_Week field in the dataset.

LastActivityDate_Year Double False

This field is generated dynamically and corresponds to the LastActivityDate_Year field in the dataset.

LastModifiedDate Datetime False

This field is generated dynamically and corresponds to the LastModifiedDate field in the dataset.

LastModifiedDate_Day Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Day field in the dataset.

LastModifiedDate_day_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_day_epoch field in the dataset.

LastModifiedDate_Hour Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Hour field in the dataset.

LastModifiedDate_Minute Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Minute field in the dataset.

LastModifiedDate_Month Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Month field in the dataset.

LastModifiedDate_Quarter Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Quarter field in the dataset.

LastModifiedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_sec_epoch field in the dataset.

LastModifiedDate_Second Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Second field in the dataset.

LastModifiedDate_Week Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Week field in the dataset.

LastModifiedDate_Year Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Year field in the dataset.

LeadSource String False

This field is generated dynamically and corresponds to the LeadSource field in the dataset.

Name String False

This field is generated dynamically and corresponds to the Name field in the dataset.

Neglected Boolean False

This field is generated dynamically and corresponds to the Neglected field in the dataset.

OpportunityAge Double False

This field is generated dynamically and corresponds to the OpportunityAge field in the dataset.

OwnerFullPhotoUrl String False

This field is generated dynamically and corresponds to the OwnerFullPhotoUrl field in the dataset.

OwnerName String False

This field is generated dynamically and corresponds to the OwnerName field in the dataset.

OwnerRoleDeveloperName String False

This field is generated dynamically and corresponds to the OwnerRoleDeveloperName field in the dataset.

OwnerRoleHierarchy_RoleNames String False

This field is generated dynamically and corresponds to the OwnerRoleHierarchy_RoleNames field in the dataset.

OwnerRoleName String False

This field is generated dynamically and corresponds to the OwnerRoleName field in the dataset.

OwnerRoleParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleDeveloperName field in the dataset.

OwnerRoleParentRoleName String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleName field in the dataset.

OwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the OwnerRoleParentRoleId field in the dataset.

OwnerRoleRoleNames String False

This field is generated dynamically and corresponds to the OwnerRoleRoleNames field in the dataset.

OwnerRoleRoleNamesPath String False

This field is generated dynamically and corresponds to the OwnerRoleRoleNamesPath field in the dataset.

OwnerRoleRolePath String False

This field is generated dynamically and corresponds to the OwnerRoleRolePath field in the dataset.

OwnerRoleRoles String False

This field is generated dynamically and corresponds to the OwnerRoleRoles field in the dataset.

OwnerSmallPhotoUrl String False

This field is generated dynamically and corresponds to the OwnerSmallPhotoUrl field in the dataset.

OwnerUniqueUserName String False

This field is generated dynamically and corresponds to the OwnerUniqueUserName field in the dataset.

OwnerUsername String False

This field is generated dynamically and corresponds to the OwnerUsername field in the dataset.

OwnerUserRoleId String False

This field is generated dynamically and corresponds to the OwnerUserRoleId field in the dataset.

OwnerId String False

This field is generated dynamically and corresponds to the OwnerId field in the dataset.

ProductProductFamily String False

This field is generated dynamically and corresponds to the ProductProductFamily field in the dataset.

ProductProductName String False

This field is generated dynamically and corresponds to the ProductProductName field in the dataset.

RecordTypeName String False

This field is generated dynamically and corresponds to the RecordTypeName field in the dataset.

RecordTypeId String False

This field is generated dynamically and corresponds to the RecordTypeId field in the dataset.

StageDefaultProbability Double False

This field is generated dynamically and corresponds to the StageDefaultProbability field in the dataset.

StageIsPulled Double False

This field is generated dynamically and corresponds to the StageIsPulled field in the dataset.

StageIsPushed Double False

This field is generated dynamically and corresponds to the StageIsPushed field in the dataset.

StageSortOrder Double False

This field is generated dynamically and corresponds to the StageSortOrder field in the dataset.

StageStageName String False

This field is generated dynamically and corresponds to the StageStageName field in the dataset.

StageName String False

This field is generated dynamically and corresponds to the StageName field in the dataset.

Time_In_Current_StageDuration_Seconds Double False

This field is generated dynamically and corresponds to the Time_In_Current_StageDuration_Seconds field in the dataset.

Type String False

This field is generated dynamically and corresponds to the Type field in the dataset.

CData Cloud

Dataset_Opportunity_products

The Tableau CRM dataset Dataset_Opportunity_products.

Columns

Name Type ReadOnly Description
AccountName String False

This field is generated dynamically and corresponds to the AccountName field in the dataset.

CustomFilter Boolean False

This field is generated dynamically and corresponds to the CustomFilter field in the dataset.

Discount_Percent Double False

This field is generated dynamically and corresponds to the Discount_Percent field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

ListPrice Double False

This field is generated dynamically and corresponds to the ListPrice field in the dataset.

OpportunityAccountAccountSource String False

This field is generated dynamically and corresponds to the OpportunityAccountAccountSource field in the dataset.

OpportunityAccountAnnualRevenue Double False

This field is generated dynamically and corresponds to the OpportunityAccountAnnualRevenue field in the dataset.

OpportunityAccountBillingCountry String False

This field is generated dynamically and corresponds to the OpportunityAccountBillingCountry field in the dataset.

OpportunityAccountBillingState String False

This field is generated dynamically and corresponds to the OpportunityAccountBillingState field in the dataset.

OpportunityAccountIndustry String False

This field is generated dynamically and corresponds to the OpportunityAccountIndustry field in the dataset.

OpportunityAccountName String False

This field is generated dynamically and corresponds to the OpportunityAccountName field in the dataset.

OpportunityAccountNumberOfEmployees Double False

This field is generated dynamically and corresponds to the OpportunityAccountNumberOfEmployees field in the dataset.

OpportunityAccountOwnerName String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerName field in the dataset.

OpportunityAccountOwnerRoleName String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerRoleName field in the dataset.

OpportunityAccountOwnerRoleRolePath String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerRoleRolePath field in the dataset.

OpportunityAccountOwnerRoleRoles String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerRoleRoles field in the dataset.

OpportunityAccountOwnerUniqueUserName String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerUniqueUserName field in the dataset.

OpportunityAccountOwnerId String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerId field in the dataset.

OpportunityAccountType String False

This field is generated dynamically and corresponds to the OpportunityAccountType field in the dataset.

OpportunityAccountId String False

This field is generated dynamically and corresponds to the OpportunityAccountId field in the dataset.

OpportunityCloseDate Datetime False

This field is generated dynamically and corresponds to the OpportunityCloseDate field in the dataset.

OpportunityCloseDate_Day Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Day field in the dataset.

OpportunityCloseDate_day_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_day_epoch field in the dataset.

OpportunityCloseDate_Hour Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Hour field in the dataset.

OpportunityCloseDate_Minute Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Minute field in the dataset.

OpportunityCloseDate_Month Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Month field in the dataset.

OpportunityCloseDate_Quarter Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Quarter field in the dataset.

OpportunityCloseDate_sec_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_sec_epoch field in the dataset.

OpportunityCloseDate_Second Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Second field in the dataset.

OpportunityCloseDate_Week Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Week field in the dataset.

OpportunityCloseDate_Year Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Year field in the dataset.

OpportunityCreatedDate Datetime False

This field is generated dynamically and corresponds to the OpportunityCreatedDate field in the dataset.

OpportunityCreatedDate_Day Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Day field in the dataset.

OpportunityCreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_day_epoch field in the dataset.

OpportunityCreatedDate_Hour Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Hour field in the dataset.

OpportunityCreatedDate_Minute Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Minute field in the dataset.

OpportunityCreatedDate_Month Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Month field in the dataset.

OpportunityCreatedDate_Quarter Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Quarter field in the dataset.

OpportunityCreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_sec_epoch field in the dataset.

OpportunityCreatedDate_Second Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Second field in the dataset.

OpportunityCreatedDate_Week Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Week field in the dataset.

OpportunityCreatedDate_Year Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Year field in the dataset.

OpportunityDaysPastDue Double False

This field is generated dynamically and corresponds to the OpportunityDaysPastDue field in the dataset.

OpportunityDaysSinceLastActivity Double False

This field is generated dynamically and corresponds to the OpportunityDaysSinceLastActivity field in the dataset.

OpportunityForecastCategory String False

This field is generated dynamically and corresponds to the OpportunityForecastCategory field in the dataset.

OpportunityForecastCategoryName String False

This field is generated dynamically and corresponds to the OpportunityForecastCategoryName field in the dataset.

OpportunityIsClosed Boolean False

This field is generated dynamically and corresponds to the OpportunityIsClosed field in the dataset.

OpportunityIsLost String False

This field is generated dynamically and corresponds to the OpportunityIsLost field in the dataset.

OpportunityIsPastDue Boolean False

This field is generated dynamically and corresponds to the OpportunityIsPastDue field in the dataset.

OpportunityIsWon Boolean False

This field is generated dynamically and corresponds to the OpportunityIsWon field in the dataset.

OpportunityLeadSource String False

This field is generated dynamically and corresponds to the OpportunityLeadSource field in the dataset.

OpportunityName String False

This field is generated dynamically and corresponds to the OpportunityName field in the dataset.

OpportunityNeglected Boolean False

This field is generated dynamically and corresponds to the OpportunityNeglected field in the dataset.

OpportunityOpportunityAge Double False

This field is generated dynamically and corresponds to the OpportunityOpportunityAge field in the dataset.

OpportunityOwnerFullPhotoUrl String False

This field is generated dynamically and corresponds to the OpportunityOwnerFullPhotoUrl field in the dataset.

OpportunityOwnerName String False

This field is generated dynamically and corresponds to the OpportunityOwnerName field in the dataset.

OpportunityOwnerRoleDeveloperName String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleDeveloperName field in the dataset.

OpportunityOwnerRoleHierarchy_RoleNames String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleHierarchy_RoleNames field in the dataset.

OpportunityOwnerRoleName String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleName field in the dataset.

OpportunityOwnerRoleParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleParentRoleDeveloperName field in the dataset.

OpportunityOwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleParentRoleId field in the dataset.

OpportunityOwnerRoleRoleNames String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleRoleNames field in the dataset.

OpportunityOwnerRoleRolePath String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleRolePath field in the dataset.

OpportunityOwnerRoleRoles String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleRoles field in the dataset.

OpportunityOwnerSmallPhotoUrl String False

This field is generated dynamically and corresponds to the OpportunityOwnerSmallPhotoUrl field in the dataset.

OpportunityOwnerUniqueUserName String False

This field is generated dynamically and corresponds to the OpportunityOwnerUniqueUserName field in the dataset.

OpportunityOwnerId String False

This field is generated dynamically and corresponds to the OpportunityOwnerId field in the dataset.

OpportunityRecordTypeName String False

This field is generated dynamically and corresponds to the OpportunityRecordTypeName field in the dataset.

OpportunityRecordTypeId String False

This field is generated dynamically and corresponds to the OpportunityRecordTypeId field in the dataset.

OpportunityStageIsPulled Double False

This field is generated dynamically and corresponds to the OpportunityStageIsPulled field in the dataset.

OpportunityStageIsPushed Double False

This field is generated dynamically and corresponds to the OpportunityStageIsPushed field in the dataset.

OpportunityStageName String False

This field is generated dynamically and corresponds to the OpportunityStageName field in the dataset.

OpportunityType String False

This field is generated dynamically and corresponds to the OpportunityType field in the dataset.

OpportunityId String False

This field is generated dynamically and corresponds to the OpportunityId field in the dataset.

PricebookProduct2Id String False

This field is generated dynamically and corresponds to the PricebookProduct2Id field in the dataset.

PricebookEntryId String False

This field is generated dynamically and corresponds to the PricebookEntryId field in the dataset.

ProductFamily String False

This field is generated dynamically and corresponds to the ProductFamily field in the dataset.

ProductName String False

This field is generated dynamically and corresponds to the ProductName field in the dataset.

ProductProductCode String False

This field is generated dynamically and corresponds to the ProductProductCode field in the dataset.

ProductCode String False

This field is generated dynamically and corresponds to the ProductCode field in the dataset.

Quantity Double False

This field is generated dynamically and corresponds to the Quantity field in the dataset.

Total_ListPrice Double False

This field is generated dynamically and corresponds to the Total_ListPrice field in the dataset.

TotalPrice Double False

This field is generated dynamically and corresponds to the TotalPrice field in the dataset.

CData Cloud

Dataset_Pipeline_trending

The Tableau CRM dataset Dataset_Pipeline_trending.

Columns

Name Type ReadOnly Description
Amount Double False

This field is generated dynamically and corresponds to the Amount field in the dataset.

Amount_isUpdated Double False

This field is generated dynamically and corresponds to the Amount_isUpdated field in the dataset.

AmountPrev Double False

This field is generated dynamically and corresponds to the AmountPrev field in the dataset.

CloseDate Datetime False

This field is generated dynamically and corresponds to the CloseDate field in the dataset.

CloseDate_Day Double False

This field is generated dynamically and corresponds to the CloseDate_Day field in the dataset.

CloseDate_day_epoch Double False

This field is generated dynamically and corresponds to the CloseDate_day_epoch field in the dataset.

CloseDate_Hour Double False

This field is generated dynamically and corresponds to the CloseDate_Hour field in the dataset.

CloseDate_isUpdated Double False

This field is generated dynamically and corresponds to the CloseDate_isUpdated field in the dataset.

CloseDate_Minute Double False

This field is generated dynamically and corresponds to the CloseDate_Minute field in the dataset.

CloseDate_Month Double False

This field is generated dynamically and corresponds to the CloseDate_Month field in the dataset.

CloseDate_Quarter Double False

This field is generated dynamically and corresponds to the CloseDate_Quarter field in the dataset.

CloseDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CloseDate_sec_epoch field in the dataset.

CloseDate_Second Double False

This field is generated dynamically and corresponds to the CloseDate_Second field in the dataset.

CloseDate_Week Double False

This field is generated dynamically and corresponds to the CloseDate_Week field in the dataset.

CloseDate_Year Double False

This field is generated dynamically and corresponds to the CloseDate_Year field in the dataset.

CloseDatePrev Datetime False

This field is generated dynamically and corresponds to the CloseDatePrev field in the dataset.

CloseDatePrev_Day Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Day field in the dataset.

CloseDatePrev_day_epoch Double False

This field is generated dynamically and corresponds to the CloseDatePrev_day_epoch field in the dataset.

CloseDatePrev_Hour Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Hour field in the dataset.

CloseDatePrev_Minute Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Minute field in the dataset.

CloseDatePrev_Month Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Month field in the dataset.

CloseDatePrev_Quarter Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Quarter field in the dataset.

CloseDatePrev_sec_epoch Double False

This field is generated dynamically and corresponds to the CloseDatePrev_sec_epoch field in the dataset.

CloseDatePrev_Second Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Second field in the dataset.

CloseDatePrev_Week Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Week field in the dataset.

CloseDatePrev_Year Double False

This field is generated dynamically and corresponds to the CloseDatePrev_Year field in the dataset.

CreatedById String False

This field is generated dynamically and corresponds to the CreatedById field in the dataset.

CreatedDate Datetime False

This field is generated dynamically and corresponds to the CreatedDate field in the dataset.

CreatedDate_Day Double False

This field is generated dynamically and corresponds to the CreatedDate_Day field in the dataset.

CreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_day_epoch field in the dataset.

CreatedDate_Hour Double False

This field is generated dynamically and corresponds to the CreatedDate_Hour field in the dataset.

CreatedDate_Minute Double False

This field is generated dynamically and corresponds to the CreatedDate_Minute field in the dataset.

CreatedDate_Month Double False

This field is generated dynamically and corresponds to the CreatedDate_Month field in the dataset.

CreatedDate_Quarter Double False

This field is generated dynamically and corresponds to the CreatedDate_Quarter field in the dataset.

CreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the CreatedDate_sec_epoch field in the dataset.

CreatedDate_Second Double False

This field is generated dynamically and corresponds to the CreatedDate_Second field in the dataset.

CreatedDate_Week Double False

This field is generated dynamically and corresponds to the CreatedDate_Week field in the dataset.

CreatedDate_Year Double False

This field is generated dynamically and corresponds to the CreatedDate_Year field in the dataset.

CreatedDatePrev String False

This field is generated dynamically and corresponds to the CreatedDatePrev field in the dataset.

CreatedDatePrev_Day String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Day field in the dataset.

CreatedDatePrev_day_epoch Double False

This field is generated dynamically and corresponds to the CreatedDatePrev_day_epoch field in the dataset.

CreatedDatePrev_Hour String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Hour field in the dataset.

CreatedDatePrev_Minute String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Minute field in the dataset.

CreatedDatePrev_Month String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Month field in the dataset.

CreatedDatePrev_Quarter String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Quarter field in the dataset.

CreatedDatePrev_sec_epoch Double False

This field is generated dynamically and corresponds to the CreatedDatePrev_sec_epoch field in the dataset.

CreatedDatePrev_Second String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Second field in the dataset.

CreatedDatePrev_Week String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Week field in the dataset.

CreatedDatePrev_Year String False

This field is generated dynamically and corresponds to the CreatedDatePrev_Year field in the dataset.

CustomFilter Boolean False

This field is generated dynamically and corresponds to the CustomFilter field in the dataset.

Duration Double False

This field is generated dynamically and corresponds to the Duration field in the dataset.

ForecastCategory String False

This field is generated dynamically and corresponds to the ForecastCategory field in the dataset.

ForecastCategoryForecastCategoryName String False

This field is generated dynamically and corresponds to the ForecastCategoryForecastCategoryName field in the dataset.

ForecastCategoryPrev String False

This field is generated dynamically and corresponds to the ForecastCategoryPrev field in the dataset.

ForecastCategoryPrevForecastCategoryName String False

This field is generated dynamically and corresponds to the ForecastCategoryPrevForecastCategoryName field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

IsDeleted Boolean False

This field is generated dynamically and corresponds to the IsDeleted field in the dataset.

IsLastUpdate Double False

This field is generated dynamically and corresponds to the IsLastUpdate field in the dataset.

IsPulled Double False

This field is generated dynamically and corresponds to the IsPulled field in the dataset.

IsPushed Double False

This field is generated dynamically and corresponds to the IsPushed field in the dataset.

OpportunityAccountAccountSource String False

This field is generated dynamically and corresponds to the OpportunityAccountAccountSource field in the dataset.

OpportunityAccountBillingCountry String False

This field is generated dynamically and corresponds to the OpportunityAccountBillingCountry field in the dataset.

OpportunityAccountBillingState String False

This field is generated dynamically and corresponds to the OpportunityAccountBillingState field in the dataset.

OpportunityAccountIndustry String False

This field is generated dynamically and corresponds to the OpportunityAccountIndustry field in the dataset.

OpportunityAccountName String False

This field is generated dynamically and corresponds to the OpportunityAccountName field in the dataset.

OpportunityAccountOwnerName String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerName field in the dataset.

OpportunityAccountOwnerId String False

This field is generated dynamically and corresponds to the OpportunityAccountOwnerId field in the dataset.

OpportunityAccountType String False

This field is generated dynamically and corresponds to the OpportunityAccountType field in the dataset.

OpportunityAccountId String False

This field is generated dynamically and corresponds to the OpportunityAccountId field in the dataset.

OpportunityAmount Double False

This field is generated dynamically and corresponds to the OpportunityAmount field in the dataset.

OpportunityCloseDate Datetime False

This field is generated dynamically and corresponds to the OpportunityCloseDate field in the dataset.

OpportunityCloseDate_Day Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Day field in the dataset.

OpportunityCloseDate_day_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_day_epoch field in the dataset.

OpportunityCloseDate_Hour Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Hour field in the dataset.

OpportunityCloseDate_Minute Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Minute field in the dataset.

OpportunityCloseDate_Month Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Month field in the dataset.

OpportunityCloseDate_Quarter Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Quarter field in the dataset.

OpportunityCloseDate_sec_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_sec_epoch field in the dataset.

OpportunityCloseDate_Second Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Second field in the dataset.

OpportunityCloseDate_Week Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Week field in the dataset.

OpportunityCloseDate_Year Double False

This field is generated dynamically and corresponds to the OpportunityCloseDate_Year field in the dataset.

OpportunityForecastCategoryName String False

This field is generated dynamically and corresponds to the OpportunityForecastCategoryName field in the dataset.

OpportunityIsClosed Boolean False

This field is generated dynamically and corresponds to the OpportunityIsClosed field in the dataset.

OpportunityIsLost String False

This field is generated dynamically and corresponds to the OpportunityIsLost field in the dataset.

OpportunityIsWon Boolean False

This field is generated dynamically and corresponds to the OpportunityIsWon field in the dataset.

OpportunityLeadSource String False

This field is generated dynamically and corresponds to the OpportunityLeadSource field in the dataset.

OpportunityName String False

This field is generated dynamically and corresponds to the OpportunityName field in the dataset.

OpportunityOwnerFullPhotoUrl String False

This field is generated dynamically and corresponds to the OpportunityOwnerFullPhotoUrl field in the dataset.

OpportunityOwnerName String False

This field is generated dynamically and corresponds to the OpportunityOwnerName field in the dataset.

OpportunityOwnerRoleDeveloperName String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleDeveloperName field in the dataset.

OpportunityOwnerRoleHierarchy_RoleNames String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleHierarchy_RoleNames field in the dataset.

OpportunityOwnerRoleName String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleName field in the dataset.

OpportunityOwnerRoleParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleParentRoleDeveloperName field in the dataset.

OpportunityOwnerRoleParentRoleName String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleParentRoleName field in the dataset.

OpportunityOwnerRoleParentRoleId String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleParentRoleId field in the dataset.

OpportunityOwnerRoleRoleNames String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleRoleNames field in the dataset.

OpportunityOwnerRoleRolePath String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleRolePath field in the dataset.

OpportunityOwnerRoleRoles String False

This field is generated dynamically and corresponds to the OpportunityOwnerRoleRoles field in the dataset.

OpportunityOwnerSmallPhotoUrl String False

This field is generated dynamically and corresponds to the OpportunityOwnerSmallPhotoUrl field in the dataset.

OpportunityOwnerUniqueUserName String False

This field is generated dynamically and corresponds to the OpportunityOwnerUniqueUserName field in the dataset.

OpportunityOwnerId String False

This field is generated dynamically and corresponds to the OpportunityOwnerId field in the dataset.

OpportunityProductFamily String False

This field is generated dynamically and corresponds to the OpportunityProductFamily field in the dataset.

OpportunityProductName String False

This field is generated dynamically and corresponds to the OpportunityProductName field in the dataset.

OpportunityRecordTypeName String False

This field is generated dynamically and corresponds to the OpportunityRecordTypeName field in the dataset.

OpportunityRecordTypeId String False

This field is generated dynamically and corresponds to the OpportunityRecordTypeId field in the dataset.

OpportunityStageSortOrder Double False

This field is generated dynamically and corresponds to the OpportunityStageSortOrder field in the dataset.

OpportunityStageName String False

This field is generated dynamically and corresponds to the OpportunityStageName field in the dataset.

OpportunityType String False

This field is generated dynamically and corresponds to the OpportunityType field in the dataset.

OpportunityCreatedDate Datetime False

This field is generated dynamically and corresponds to the OpportunityCreatedDate field in the dataset.

OpportunityCreatedDate_Day Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Day field in the dataset.

OpportunityCreatedDate_day_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_day_epoch field in the dataset.

OpportunityCreatedDate_Hour Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Hour field in the dataset.

OpportunityCreatedDate_Minute Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Minute field in the dataset.

OpportunityCreatedDate_Month Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Month field in the dataset.

OpportunityCreatedDate_Quarter Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Quarter field in the dataset.

OpportunityCreatedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_sec_epoch field in the dataset.

OpportunityCreatedDate_Second Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Second field in the dataset.

OpportunityCreatedDate_Week Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Week field in the dataset.

OpportunityCreatedDate_Year Double False

This field is generated dynamically and corresponds to the OpportunityCreatedDate_Year field in the dataset.

OpportunityId String False

This field is generated dynamically and corresponds to the OpportunityId field in the dataset.

StageIsClosed Boolean False

This field is generated dynamically and corresponds to the StageIsClosed field in the dataset.

StageIsWon Boolean False

This field is generated dynamically and corresponds to the StageIsWon field in the dataset.

StageSortOrder Double False

This field is generated dynamically and corresponds to the StageSortOrder field in the dataset.

Stage_IsAdvanced Boolean False

This field is generated dynamically and corresponds to the Stage_IsAdvanced field in the dataset.

Stage_isUpdated Double False

This field is generated dynamically and corresponds to the Stage_isUpdated field in the dataset.

StageName String False

This field is generated dynamically and corresponds to the StageName field in the dataset.

StageNamePrev String False

This field is generated dynamically and corresponds to the StageNamePrev field in the dataset.

StagePrevIsClosed String False

This field is generated dynamically and corresponds to the StagePrevIsClosed field in the dataset.

StagePrevIsWon String False

This field is generated dynamically and corresponds to the StagePrevIsWon field in the dataset.

StagePrevSortOrder Double False

This field is generated dynamically and corresponds to the StagePrevSortOrder field in the dataset.

Time_In_Current_StageDuration_Seconds Double False

This field is generated dynamically and corresponds to the Time_In_Current_StageDuration_Seconds field in the dataset.

Unique_Sort_Key String False

This field is generated dynamically and corresponds to the Unique_Sort_Key field in the dataset.

ValidFromDate Datetime False

This field is generated dynamically and corresponds to the ValidFromDate field in the dataset.

ValidFromDate_Day Double False

This field is generated dynamically and corresponds to the ValidFromDate_Day field in the dataset.

ValidFromDate_day_epoch Double False

This field is generated dynamically and corresponds to the ValidFromDate_day_epoch field in the dataset.

ValidFromDate_Hour Double False

This field is generated dynamically and corresponds to the ValidFromDate_Hour field in the dataset.

ValidFromDate_Minute Double False

This field is generated dynamically and corresponds to the ValidFromDate_Minute field in the dataset.

ValidFromDate_Month Double False

This field is generated dynamically and corresponds to the ValidFromDate_Month field in the dataset.

ValidFromDate_Quarter Double False

This field is generated dynamically and corresponds to the ValidFromDate_Quarter field in the dataset.

ValidFromDate_sec_epoch Double False

This field is generated dynamically and corresponds to the ValidFromDate_sec_epoch field in the dataset.

ValidFromDate_Second Double False

This field is generated dynamically and corresponds to the ValidFromDate_Second field in the dataset.

ValidFromDate_Week Double False

This field is generated dynamically and corresponds to the ValidFromDate_Week field in the dataset.

ValidFromDate_Year Double False

This field is generated dynamically and corresponds to the ValidFromDate_Year field in the dataset.

ValidToDate Datetime False

This field is generated dynamically and corresponds to the ValidToDate field in the dataset.

ValidToDate_Day Double False

This field is generated dynamically and corresponds to the ValidToDate_Day field in the dataset.

ValidToDate_day_epoch Double False

This field is generated dynamically and corresponds to the ValidToDate_day_epoch field in the dataset.

ValidToDate_Hour Double False

This field is generated dynamically and corresponds to the ValidToDate_Hour field in the dataset.

ValidToDate_Minute Double False

This field is generated dynamically and corresponds to the ValidToDate_Minute field in the dataset.

ValidToDate_Month Double False

This field is generated dynamically and corresponds to the ValidToDate_Month field in the dataset.

ValidToDate_Quarter Double False

This field is generated dynamically and corresponds to the ValidToDate_Quarter field in the dataset.

ValidToDate_sec_epoch Int64 False

This field is generated dynamically and corresponds to the ValidToDate_sec_epoch field in the dataset.

ValidToDate_Second Double False

This field is generated dynamically and corresponds to the ValidToDate_Second field in the dataset.

ValidToDate_Week Double False

This field is generated dynamically and corresponds to the ValidToDate_Week field in the dataset.

ValidToDate_Year Double False

This field is generated dynamically and corresponds to the ValidToDate_Year field in the dataset.

CData Cloud

Dataset_Plain_quota

The Tableau CRM dataset Dataset_Plain_quota.

Columns

Name Type ReadOnly Description
OwnerName String False

This field is generated dynamically and corresponds to the OwnerName field in the dataset.

QuotaAmount Double False

This field is generated dynamically and corresponds to the QuotaAmount field in the dataset.

StartDate Datetime False

This field is generated dynamically and corresponds to the StartDate field in the dataset.

StartDate_Day Double False

This field is generated dynamically and corresponds to the StartDate_Day field in the dataset.

StartDate_day_epoch Double False

This field is generated dynamically and corresponds to the StartDate_day_epoch field in the dataset.

StartDate_Hour Double False

This field is generated dynamically and corresponds to the StartDate_Hour field in the dataset.

StartDate_Minute Double False

This field is generated dynamically and corresponds to the StartDate_Minute field in the dataset.

StartDate_Month Double False

This field is generated dynamically and corresponds to the StartDate_Month field in the dataset.

StartDate_Quarter Double False

This field is generated dynamically and corresponds to the StartDate_Quarter field in the dataset.

StartDate_sec_epoch Double False

This field is generated dynamically and corresponds to the StartDate_sec_epoch field in the dataset.

StartDate_Second Double False

This field is generated dynamically and corresponds to the StartDate_Second field in the dataset.

StartDate_Week Double False

This field is generated dynamically and corresponds to the StartDate_Week field in the dataset.

StartDate_Year Double False

This field is generated dynamically and corresponds to the StartDate_Year field in the dataset.

Username String False

This field is generated dynamically and corresponds to the Username field in the dataset.

CData Cloud

Dataset_Product

The Tableau CRM dataset Dataset_Product.

Columns

Name Type ReadOnly Description
Family String False

This field is generated dynamically and corresponds to the Family field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

Name String False

This field is generated dynamically and corresponds to the Name field in the dataset.

ProductCode String False

This field is generated dynamically and corresponds to the ProductCode field in the dataset.

CData Cloud

Dataset_Quota

The Tableau CRM dataset Dataset_Quota.

Columns

Name Type ReadOnly Description
OwnerName String False

This field is generated dynamically and corresponds to the OwnerName field in the dataset.

QuotaAmount String False

This field is generated dynamically and corresponds to the QuotaAmount field in the dataset.

StartDate String False

This field is generated dynamically and corresponds to the StartDate field in the dataset.

StartDate_Day String False

This field is generated dynamically and corresponds to the StartDate_Day field in the dataset.

StartDate_day_epoch String False

This field is generated dynamically and corresponds to the StartDate_day_epoch field in the dataset.

StartDate_Hour String False

This field is generated dynamically and corresponds to the StartDate_Hour field in the dataset.

StartDate_Minute String False

This field is generated dynamically and corresponds to the StartDate_Minute field in the dataset.

StartDate_Month String False

This field is generated dynamically and corresponds to the StartDate_Month field in the dataset.

StartDate_Quarter String False

This field is generated dynamically and corresponds to the StartDate_Quarter field in the dataset.

StartDate_sec_epoch String False

This field is generated dynamically and corresponds to the StartDate_sec_epoch field in the dataset.

StartDate_Second String False

This field is generated dynamically and corresponds to the StartDate_Second field in the dataset.

StartDate_Week String False

This field is generated dynamically and corresponds to the StartDate_Week field in the dataset.

StartDate_Year String False

This field is generated dynamically and corresponds to the StartDate_Year field in the dataset.

UserFullPhotoUrl String False

This field is generated dynamically and corresponds to the UserFullPhotoUrl field in the dataset.

UserId String False

This field is generated dynamically and corresponds to the UserId field in the dataset.

UserName String False

This field is generated dynamically and corresponds to the UserName field in the dataset.

UserRoleDeveloperName String False

This field is generated dynamically and corresponds to the UserRoleDeveloperName field in the dataset.

UserRoleHierarchy_RoleNames String False

This field is generated dynamically and corresponds to the UserRoleHierarchy_RoleNames field in the dataset.

UserRoleName String False

This field is generated dynamically and corresponds to the UserRoleName field in the dataset.

UserRoleParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the UserRoleParentRoleDeveloperName field in the dataset.

UserRoleParentRoleName String False

This field is generated dynamically and corresponds to the UserRoleParentRoleName field in the dataset.

UserRoleParentRoleId String False

This field is generated dynamically and corresponds to the UserRoleParentRoleId field in the dataset.

UserRoleRoleNames String False

This field is generated dynamically and corresponds to the UserRoleRoleNames field in the dataset.

UserRoleRoleNamesPath String False

This field is generated dynamically and corresponds to the UserRoleRoleNamesPath field in the dataset.

UserRoleRolePath String False

This field is generated dynamically and corresponds to the UserRoleRolePath field in the dataset.

UserRoleRoles String False

This field is generated dynamically and corresponds to the UserRoleRoles field in the dataset.

UserSmallPhotoUrl String False

This field is generated dynamically and corresponds to the UserSmallPhotoUrl field in the dataset.

UserUniqueUserName String False

This field is generated dynamically and corresponds to the UserUniqueUserName field in the dataset.

UserUsername String False

This field is generated dynamically and corresponds to the UserUsername field in the dataset.

UserUserRoleId String False

This field is generated dynamically and corresponds to the UserUserRoleId field in the dataset.

Username String False

This field is generated dynamically and corresponds to the Username field in the dataset.

CData Cloud

Dataset_User

The Tableau CRM dataset Dataset_User.

Columns

Name Type ReadOnly Description
CustomFilter Boolean False

This field is generated dynamically and corresponds to the CustomFilter field in the dataset.

FirstName String False

This field is generated dynamically and corresponds to the FirstName field in the dataset.

FullPhotoUrl String False

This field is generated dynamically and corresponds to the FullPhotoUrl field in the dataset.

hasOpportunity Boolean False

This field is generated dynamically and corresponds to the hasOpportunity field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

IsActive Boolean False

This field is generated dynamically and corresponds to the IsActive field in the dataset.

isDuplicate String False

This field is generated dynamically and corresponds to the isDuplicate field in the dataset.

LastName String False

This field is generated dynamically and corresponds to the LastName field in the dataset.

ManagerId String False

This field is generated dynamically and corresponds to the ManagerId field in the dataset.

Name String False

This field is generated dynamically and corresponds to the Name field in the dataset.

OpportunityName String False

This field is generated dynamically and corresponds to the OpportunityName field in the dataset.

RoleDeveloperName String False

This field is generated dynamically and corresponds to the RoleDeveloperName field in the dataset.

RoleHierarchy_RoleNames String False

This field is generated dynamically and corresponds to the RoleHierarchy_RoleNames field in the dataset.

RoleName String False

This field is generated dynamically and corresponds to the RoleName field in the dataset.

RoleParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the RoleParentRoleDeveloperName field in the dataset.

RoleParentRoleName String False

This field is generated dynamically and corresponds to the RoleParentRoleName field in the dataset.

RoleParentRoleId String False

This field is generated dynamically and corresponds to the RoleParentRoleId field in the dataset.

RoleRoleNames String False

This field is generated dynamically and corresponds to the RoleRoleNames field in the dataset.

RoleRoleNamesPath String False

This field is generated dynamically and corresponds to the RoleRoleNamesPath field in the dataset.

RoleRolePath String False

This field is generated dynamically and corresponds to the RoleRolePath field in the dataset.

RoleRoles String False

This field is generated dynamically and corresponds to the RoleRoles field in the dataset.

SmallPhotoUrl String False

This field is generated dynamically and corresponds to the SmallPhotoUrl field in the dataset.

UniqueUserName String False

This field is generated dynamically and corresponds to the UniqueUserName field in the dataset.

Username String False

This field is generated dynamically and corresponds to the Username field in the dataset.

UserRoleId String False

This field is generated dynamically and corresponds to the UserRoleId field in the dataset.

UserType String False

This field is generated dynamically and corresponds to the UserType field in the dataset.

CData Cloud

Dataset_User_role

The Tableau CRM dataset Dataset_User_role.

Columns

Name Type ReadOnly Description
DeveloperName String False

This field is generated dynamically and corresponds to the DeveloperName field in the dataset.

Hierarchy_RoleNames String False

This field is generated dynamically and corresponds to the Hierarchy_RoleNames field in the dataset.

Hierarchy_RoleNamesPath String False

This field is generated dynamically and corresponds to the Hierarchy_RoleNamesPath field in the dataset.

Id String False

This field is generated dynamically and corresponds to the Id field in the dataset.

LastModifiedById String False

This field is generated dynamically and corresponds to the LastModifiedById field in the dataset.

LastModifiedDate Datetime False

This field is generated dynamically and corresponds to the LastModifiedDate field in the dataset.

LastModifiedDate_Day Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Day field in the dataset.

LastModifiedDate_day_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_day_epoch field in the dataset.

LastModifiedDate_Hour Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Hour field in the dataset.

LastModifiedDate_Minute Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Minute field in the dataset.

LastModifiedDate_Month Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Month field in the dataset.

LastModifiedDate_Quarter Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Quarter field in the dataset.

LastModifiedDate_sec_epoch Double False

This field is generated dynamically and corresponds to the LastModifiedDate_sec_epoch field in the dataset.

LastModifiedDate_Second Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Second field in the dataset.

LastModifiedDate_Week Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Week field in the dataset.

LastModifiedDate_Year Double False

This field is generated dynamically and corresponds to the LastModifiedDate_Year field in the dataset.

Name String False

This field is generated dynamically and corresponds to the Name field in the dataset.

ParentRoleDeveloperName String False

This field is generated dynamically and corresponds to the ParentRoleDeveloperName field in the dataset.

ParentRoleName String False

This field is generated dynamically and corresponds to the ParentRoleName field in the dataset.

ParentRoleParentRoleId String False

This field is generated dynamically and corresponds to the ParentRoleParentRoleId field in the dataset.

ParentRoleId String False

This field is generated dynamically and corresponds to the ParentRoleId field in the dataset.

RoleNames String False

This field is generated dynamically and corresponds to the RoleNames field in the dataset.

RoleNamesPath String False

This field is generated dynamically and corresponds to the RoleNamesPath field in the dataset.

RolePath String False

This field is generated dynamically and corresponds to the RolePath field in the dataset.

Roles String False

This field is generated dynamically and corresponds to the Roles field in the dataset.

SystemModstamp Datetime False

This field is generated dynamically and corresponds to the SystemModstamp field in the dataset.

SystemModstamp_Day Double False

This field is generated dynamically and corresponds to the SystemModstamp_Day field in the dataset.

SystemModstamp_day_epoch Double False

This field is generated dynamically and corresponds to the SystemModstamp_day_epoch field in the dataset.

SystemModstamp_Hour Double False

This field is generated dynamically and corresponds to the SystemModstamp_Hour field in the dataset.

SystemModstamp_Minute Double False

This field is generated dynamically and corresponds to the SystemModstamp_Minute field in the dataset.

SystemModstamp_Month Double False

This field is generated dynamically and corresponds to the SystemModstamp_Month field in the dataset.

SystemModstamp_Quarter Double False

This field is generated dynamically and corresponds to the SystemModstamp_Quarter field in the dataset.

SystemModstamp_sec_epoch Double False

This field is generated dynamically and corresponds to the SystemModstamp_sec_epoch field in the dataset.

SystemModstamp_Second Double False

This field is generated dynamically and corresponds to the SystemModstamp_Second field in the dataset.

SystemModstamp_Week Double False

This field is generated dynamically and corresponds to the SystemModstamp_Week field in the dataset.

SystemModstamp_Year Double False

This field is generated dynamically and corresponds to the SystemModstamp_Year field in the dataset.

CData Cloud

Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - Tableau CRM Analytics Views

Name Description
Lens_Explore_Opportunities The Tableau CRM lens Lens_Explore_Opportunities.
Lens_Historical_Pipeline_By_Forecast The Tableau CRM lens Lens_Historical_Pipeline_By_Forecast.
Lens_Historical_Pipeline_By_Stage The Tableau CRM lens Lens_Historical_Pipeline_By_Stage.
Lens_Historical_Pipeline_Forecast_By_Quarter The Tableau CRM lens Lens_Historical_Pipeline_Forecast_By_Quarter.
Lens_Historical_Pipeline_Stage_By_Quarter The Tableau CRM lens Lens_Historical_Pipeline_Stage_By_Quarter.
Lens_Sales_Stage_Details The Tableau CRM lens Lens_Sales_Stage_Details.
Lens_X100KLens The Tableau CRM lens Lens_X100KLens.

CData Cloud

Lens_Explore_Opportunities

The Tableau CRM lens Lens_Explore_Opportunities.

Columns

Name Type Description
AccountAccountSource String This field is generated dynamically and corresponds to the AccountAccountSource field in the lens.
AccountAnnualRevenue Double This field is generated dynamically and corresponds to the AccountAnnualRevenue field in the lens.
AccountBillingCountry String This field is generated dynamically and corresponds to the AccountBillingCountry field in the lens.
AccountBillingState String This field is generated dynamically and corresponds to the AccountBillingState field in the lens.
AccountIndustry String This field is generated dynamically and corresponds to the AccountIndustry field in the lens.
AccountName String This field is generated dynamically and corresponds to the AccountName field in the lens.
AccountNumberOfEmployees Double This field is generated dynamically and corresponds to the AccountNumberOfEmployees field in the lens.
AccountOwnerName String This field is generated dynamically and corresponds to the AccountOwnerName field in the lens.
AccountOwnerRoleName String This field is generated dynamically and corresponds to the AccountOwnerRoleName field in the lens.
AccountOwnerRoleParentRoleId String This field is generated dynamically and corresponds to the AccountOwnerRoleParentRoleId field in the lens.
AccountOwnerRoleRolePath String This field is generated dynamically and corresponds to the AccountOwnerRoleRolePath field in the lens.
AccountOwnerRoleRoles String This field is generated dynamically and corresponds to the AccountOwnerRoleRoles field in the lens.
AccountOwnerUniqueUserName String This field is generated dynamically and corresponds to the AccountOwnerUniqueUserName field in the lens.
AccountOwnerId String This field is generated dynamically and corresponds to the AccountOwnerId field in the lens.
AccountType String This field is generated dynamically and corresponds to the AccountType field in the lens.
AccountId String This field is generated dynamically and corresponds to the AccountId field in the lens.
Amount Double This field is generated dynamically and corresponds to the Amount field in the lens.
CloseDate Datetime This field is generated dynamically and corresponds to the CloseDate field in the lens.
CloseDate_Day Double This field is generated dynamically and corresponds to the CloseDate_Day field in the lens.
CloseDate_day_epoch Double This field is generated dynamically and corresponds to the CloseDate_day_epoch field in the lens.
CloseDate_Hour Double This field is generated dynamically and corresponds to the CloseDate_Hour field in the lens.
CloseDate_Minute Double This field is generated dynamically and corresponds to the CloseDate_Minute field in the lens.
CloseDate_Month Double This field is generated dynamically and corresponds to the CloseDate_Month field in the lens.
CloseDate_Quarter Double This field is generated dynamically and corresponds to the CloseDate_Quarter field in the lens.
CloseDate_sec_epoch Double This field is generated dynamically and corresponds to the CloseDate_sec_epoch field in the lens.
CloseDate_Second Double This field is generated dynamically and corresponds to the CloseDate_Second field in the lens.
CloseDate_Week Double This field is generated dynamically and corresponds to the CloseDate_Week field in the lens.
CloseDate_Year Double This field is generated dynamically and corresponds to the CloseDate_Year field in the lens.
CreatedById String This field is generated dynamically and corresponds to the CreatedById field in the lens.
CreatedDate Datetime This field is generated dynamically and corresponds to the CreatedDate field in the lens.
CreatedDate_Day Double This field is generated dynamically and corresponds to the CreatedDate_Day field in the lens.
CreatedDate_day_epoch Double This field is generated dynamically and corresponds to the CreatedDate_day_epoch field in the lens.
CreatedDate_Hour Double This field is generated dynamically and corresponds to the CreatedDate_Hour field in the lens.
CreatedDate_Minute Double This field is generated dynamically and corresponds to the CreatedDate_Minute field in the lens.
CreatedDate_Month Double This field is generated dynamically and corresponds to the CreatedDate_Month field in the lens.
CreatedDate_Quarter Double This field is generated dynamically and corresponds to the CreatedDate_Quarter field in the lens.
CreatedDate_sec_epoch Double This field is generated dynamically and corresponds to the CreatedDate_sec_epoch field in the lens.
CreatedDate_Second Double This field is generated dynamically and corresponds to the CreatedDate_Second field in the lens.
CreatedDate_Week Double This field is generated dynamically and corresponds to the CreatedDate_Week field in the lens.
CreatedDate_Year Double This field is generated dynamically and corresponds to the CreatedDate_Year field in the lens.
CustomFilter Boolean This field is generated dynamically and corresponds to the CustomFilter field in the lens.
DaysPastDue Double This field is generated dynamically and corresponds to the DaysPastDue field in the lens.
DaysSinceLastActivity Double This field is generated dynamically and corresponds to the DaysSinceLastActivity field in the lens.
ForecastCategory String This field is generated dynamically and corresponds to the ForecastCategory field in the lens.
ForecastCategoryName String This field is generated dynamically and corresponds to the ForecastCategoryName field in the lens.
HasOpportunityLineItem Boolean This field is generated dynamically and corresponds to the HasOpportunityLineItem field in the lens.
Id String This field is generated dynamically and corresponds to the Id field in the lens.
IsClosed Boolean This field is generated dynamically and corresponds to the IsClosed field in the lens.
IsLost String This field is generated dynamically and corresponds to the IsLost field in the lens.
IsPastDue Boolean This field is generated dynamically and corresponds to the IsPastDue field in the lens.
IsWon Boolean This field is generated dynamically and corresponds to the IsWon field in the lens.
LastActivityDate Datetime This field is generated dynamically and corresponds to the LastActivityDate field in the lens.
LastActivityDate_Day Double This field is generated dynamically and corresponds to the LastActivityDate_Day field in the lens.
LastActivityDate_day_epoch Double This field is generated dynamically and corresponds to the LastActivityDate_day_epoch field in the lens.
LastActivityDate_Hour Double This field is generated dynamically and corresponds to the LastActivityDate_Hour field in the lens.
LastActivityDate_Minute Double This field is generated dynamically and corresponds to the LastActivityDate_Minute field in the lens.
LastActivityDate_Month Double This field is generated dynamically and corresponds to the LastActivityDate_Month field in the lens.
LastActivityDate_Quarter Double This field is generated dynamically and corresponds to the LastActivityDate_Quarter field in the lens.
LastActivityDate_sec_epoch Double This field is generated dynamically and corresponds to the LastActivityDate_sec_epoch field in the lens.
LastActivityDate_Second Double This field is generated dynamically and corresponds to the LastActivityDate_Second field in the lens.
LastActivityDate_Week Double This field is generated dynamically and corresponds to the LastActivityDate_Week field in the lens.
LastActivityDate_Year Double This field is generated dynamically and corresponds to the LastActivityDate_Year field in the lens.
LastModifiedDate Datetime This field is generated dynamically and corresponds to the LastModifiedDate field in the lens.
LastModifiedDate_Day Double This field is generated dynamically and corresponds to the LastModifiedDate_Day field in the lens.
LastModifiedDate_day_epoch Double This field is generated dynamically and corresponds to the LastModifiedDate_day_epoch field in the lens.
LastModifiedDate_Hour Double This field is generated dynamically and corresponds to the LastModifiedDate_Hour field in the lens.
LastModifiedDate_Minute Double This field is generated dynamically and corresponds to the LastModifiedDate_Minute field in the lens.
LastModifiedDate_Month Double This field is generated dynamically and corresponds to the LastModifiedDate_Month field in the lens.
LastModifiedDate_Quarter Double This field is generated dynamically and corresponds to the LastModifiedDate_Quarter field in the lens.
LastModifiedDate_sec_epoch Double This field is generated dynamically and corresponds to the LastModifiedDate_sec_epoch field in the lens.
LastModifiedDate_Second Double This field is generated dynamically and corresponds to the LastModifiedDate_Second field in the lens.
LastModifiedDate_Week Double This field is generated dynamically and corresponds to the LastModifiedDate_Week field in the lens.
LastModifiedDate_Year Double This field is generated dynamically and corresponds to the LastModifiedDate_Year field in the lens.
LeadSource String This field is generated dynamically and corresponds to the LeadSource field in the lens.
Name String This field is generated dynamically and corresponds to the Name field in the lens.
Neglected Boolean This field is generated dynamically and corresponds to the Neglected field in the lens.
OpportunityAge Double This field is generated dynamically and corresponds to the OpportunityAge field in the lens.
OwnerFullPhotoUrl String This field is generated dynamically and corresponds to the OwnerFullPhotoUrl field in the lens.
OwnerName String This field is generated dynamically and corresponds to the OwnerName field in the lens.
OwnerRoleDeveloperName String This field is generated dynamically and corresponds to the OwnerRoleDeveloperName field in the lens.
OwnerRoleHierarchy_RoleNames String This field is generated dynamically and corresponds to the OwnerRoleHierarchy_RoleNames field in the lens.
OwnerRoleName String This field is generated dynamically and corresponds to the OwnerRoleName field in the lens.
OwnerRoleParentRoleDeveloperName String This field is generated dynamically and corresponds to the OwnerRoleParentRoleDeveloperName field in the lens.
OwnerRoleParentRoleName String This field is generated dynamically and corresponds to the OwnerRoleParentRoleName field in the lens.
OwnerRoleParentRoleId String This field is generated dynamically and corresponds to the OwnerRoleParentRoleId field in the lens.
OwnerRoleRoleNames String This field is generated dynamically and corresponds to the OwnerRoleRoleNames field in the lens.
OwnerRoleRoleNamesPath String This field is generated dynamically and corresponds to the OwnerRoleRoleNamesPath field in the lens.
OwnerRoleRolePath String This field is generated dynamically and corresponds to the OwnerRoleRolePath field in the lens.
OwnerRoleRoles String This field is generated dynamically and corresponds to the OwnerRoleRoles field in the lens.
OwnerSmallPhotoUrl String This field is generated dynamically and corresponds to the OwnerSmallPhotoUrl field in the lens.
OwnerUniqueUserName String This field is generated dynamically and corresponds to the OwnerUniqueUserName field in the lens.
OwnerUsername String This field is generated dynamically and corresponds to the OwnerUsername field in the lens.
OwnerUserRoleId String This field is generated dynamically and corresponds to the OwnerUserRoleId field in the lens.
OwnerId String This field is generated dynamically and corresponds to the OwnerId field in the lens.
ProductProductFamily String This field is generated dynamically and corresponds to the ProductProductFamily field in the lens.
ProductProductName String This field is generated dynamically and corresponds to the ProductProductName field in the lens.
RecordTypeName String This field is generated dynamically and corresponds to the RecordTypeName field in the lens.
RecordTypeId String This field is generated dynamically and corresponds to the RecordTypeId field in the lens.
StageDefaultProbability Double This field is generated dynamically and corresponds to the StageDefaultProbability field in the lens.
StageIsPulled Double This field is generated dynamically and corresponds to the StageIsPulled field in the lens.
StageIsPushed Double This field is generated dynamically and corresponds to the StageIsPushed field in the lens.
StageSortOrder Double This field is generated dynamically and corresponds to the StageSortOrder field in the lens.
StageStageName String This field is generated dynamically and corresponds to the StageStageName field in the lens.
StageName String This field is generated dynamically and corresponds to the StageName field in the lens.
Time_In_Current_StageDuration_Seconds Double This field is generated dynamically and corresponds to the Time_In_Current_StageDuration_Seconds field in the lens.
Type String This field is generated dynamically and corresponds to the Type field in the lens.

CData Cloud

Lens_Historical_Pipeline_By_Forecast

The Tableau CRM lens Lens_Historical_Pipeline_By_Forecast.

Columns

Name Type Description
ForecastCategoryForecastCategoryName String This field is generated dynamically and corresponds to the ForecastCategoryForecastCategoryName field in the lens.
Month String This field is generated dynamically and corresponds to the Month field in the lens.
stage_sort Double This field is generated dynamically and corresponds to the stage_sort field in the lens.
sum_Amount Double This field is generated dynamically and corresponds to the sum_Amount field in the lens.
time_sort Double This field is generated dynamically and corresponds to the time_sort field in the lens.

CData Cloud

Lens_Historical_Pipeline_By_Stage

The Tableau CRM lens Lens_Historical_Pipeline_By_Stage.

Columns

Name Type Description
Month String This field is generated dynamically and corresponds to the Month field in the lens.
stage_sort Double This field is generated dynamically and corresponds to the stage_sort field in the lens.
StageNameTest String This field is generated dynamically and corresponds to the StageNameTest field in the lens.
sum_Amount Double This field is generated dynamically and corresponds to the sum_Amount field in the lens.
time_sort Double This field is generated dynamically and corresponds to the time_sort field in the lens.

CData Cloud

Lens_Historical_Pipeline_Forecast_By_Quarter

The Tableau CRM lens Lens_Historical_Pipeline_Forecast_By_Quarter.

Columns

Name Type Description
ForecastCategoryForecastCategoryName String This field is generated dynamically and corresponds to the ForecastCategoryForecastCategoryName field in the lens.
Quarter String This field is generated dynamically and corresponds to the Quarter field in the lens.
stage_sort Double This field is generated dynamically and corresponds to the stage_sort field in the lens.
sum_Amount Double This field is generated dynamically and corresponds to the sum_Amount field in the lens.
time_sort Double This field is generated dynamically and corresponds to the time_sort field in the lens.

CData Cloud

Lens_Historical_Pipeline_Stage_By_Quarter

The Tableau CRM lens Lens_Historical_Pipeline_Stage_By_Quarter.

Columns

Name Type Description
Quarter String This field is generated dynamically and corresponds to the Quarter field in the lens.
stage_sort Double This field is generated dynamically and corresponds to the stage_sort field in the lens.
StageName String This field is generated dynamically and corresponds to the StageName field in the lens.
sum_Amount Double This field is generated dynamically and corresponds to the sum_Amount field in the lens.
time_sort Double This field is generated dynamically and corresponds to the time_sort field in the lens.

CData Cloud

Lens_Sales_Stage_Details

The Tableau CRM lens Lens_Sales_Stage_Details.

Columns

Name Type Description
Amount Double This field is generated dynamically and corresponds to the Amount field in the lens.
CloseDate Datetime This field is generated dynamically and corresponds to the CloseDate field in the lens.
CreatedDate Datetime This field is generated dynamically and corresponds to the CreatedDate field in the lens.
OpportunityAccountName String This field is generated dynamically and corresponds to the OpportunityAccountName field in the lens.
OpportunityName String This field is generated dynamically and corresponds to the OpportunityName field in the lens.
StageName String This field is generated dynamically and corresponds to the StageName field in the lens.

CData Cloud

Lens_X100KLens

The Tableau CRM lens Lens_X100KLens.

Columns

Name Type Description
Col_3 String This field is generated dynamically and corresponds to the Col_3 field in the lens.
Col_4 String This field is generated dynamically and corresponds to the Col_4 field in the lens.
Col_5 String This field is generated dynamically and corresponds to the Col_5 field in the lens.
Col_6 String This field is generated dynamically and corresponds to the Col_6 field in the lens.
limit String This field is generated dynamically and corresponds to the limit field in the lens.

CData Cloud

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the Cloud beyond simple SELECT/INSERT/UPDATE/DELETE operations with Tableau CRM.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Tableau CRM, along with an indication of whether the procedure succeeded or failed.

CData Cloud - Tableau CRM Analytics Stored Procedures

Name Description
CreateMetadataFile Creates a metadata file for the specified dataset.
GetJobStatus Create a dataset from a CSV file.

CData Cloud

CreateMetadataFile

Creates a metadata file for the specified dataset.

Input

Name Type Description
Charset String The charset of the table.

The default value is UTF-8.

FieldsDelimitedBy String The delimiter of the table columns.

The default value is ,.

LinesTerminatedBy String The delimiter of the table lines.

The default value is \r\n.

TableName String The name of the table or view. Ex : 'Dataset_Title
FileName String The full file path and name of the metadata file to generate. Ex : 'C:\\Users\\User\\Desktop\\SFTableauCRM\\DataSetTest.json'

Result Set Columns

Name Type Description
Result String Returns Success or Failure.
FileData String File data that will be outputted encoded in Base64 if the FileName and FileStream inputs are not set.

CData Cloud

GetJobStatus

Create a dataset from a CSV file.

Input

Name Type Description
JobId String The id of the job.

Result Set Columns

Name Type Description
Status String Indicates the status of the job.
StatusMessage String The message of the status. Empty unless something went wrong with the upload.

CData Cloud

System Tables

You can query the system tables described in this section to access schema information, information on data source functionality, and batch operation statistics.

Schema Tables

The following tables return database metadata for Tableau CRM:

  • sys_catalogs: Lists the available databases.
  • sys_schemas: Lists the available schemas.
  • sys_tables: Lists the available tables and views.
  • sys_tablecolumns: Describes the columns of the available tables and views.
  • sys_procedures: Describes the available stored procedures.
  • sys_procedureparameters: Describes stored procedure parameters.
  • sys_keycolumns: Describes the primary and foreign keys.
  • sys_indexes: Describes the available indexes.

Data Source Tables

The following tables return information about how to connect to and query the data source:

  • sys_connection_props: Returns information on the available connection properties.
  • sys_sqlinfo: Describes the SELECT queries that the Cloud can offload to the data source.

Query Information Tables

The following table returns query statistics for data modification queries:

  • sys_identity: Returns information about batch operations or single updates.

CData Cloud

sys_catalogs

Lists the available databases.

The following query retrieves all databases determined by the connection string: 

SELECT * FROM sys_catalogs

Columns

Name Type Description
CatalogName String The database name.

CData Cloud

sys_schemas

Lists the available schemas.

The following query retrieves all available schemas: 

          SELECT * FROM sys_schemas

Columns

Name Type Description
CatalogName String The database name.
SchemaName String The schema name.

CData Cloud

sys_tables

Lists the available tables.

The following query retrieves the available tables and views: 

          SELECT * FROM sys_tables

Columns

Name Type Description
CatalogName String The database containing the table or view.
SchemaName String The schema containing the table or view.
TableName String The name of the table or view.
TableType String The table type (table or view).
Description String A description of the table or view.
IsUpdateable Boolean Whether the table can be updated.

CData Cloud

sys_tablecolumns

Describes the columns of the available tables and views.

The following query returns the columns and data types for the Dataset_Opportunity table: 

SELECT ColumnName, DataTypeName FROM sys_tablecolumns WHERE TableName='Dataset_Opportunity'

Columns

Name Type Description
CatalogName String The name of the database containing the table or view.
SchemaName String The schema containing the table or view.
TableName String The name of the table or view containing the column.
ColumnName String The column name.
DataTypeName String The data type name.
DataType Int32 An integer indicating the data type. This value is determined at run time based on the environment.
Length Int32 The storage size of the column.
DisplaySize Int32 The designated column's normal maximum width in characters.
NumericPrecision Int32 The maximum number of digits in numeric data. The column length in characters for character and date-time data.
NumericScale Int32 The column scale or number of digits to the right of the decimal point.
IsNullable Boolean Whether the column can contain null.
Description String A brief description of the column.
Ordinal Int32 The sequence number of the column.
IsAutoIncrement String Whether the column value is assigned in fixed increments.
IsGeneratedColumn String Whether the column is generated.
IsHidden Boolean Whether the column is hidden.
IsArray Boolean Whether the column is an array.
IsReadOnly Boolean Whether the column is read-only.
IsKey Boolean Indicates whether a field returned from sys_tablecolumns is the primary key of the table.

CData Cloud

sys_procedures

Lists the available stored procedures.

The following query retrieves the available stored procedures: 

          SELECT * FROM sys_procedures

Columns

Name Type Description
CatalogName String The database containing the stored procedure.
SchemaName String The schema containing the stored procedure.
ProcedureName String The name of the stored procedure.
Description String A description of the stored procedure.
ProcedureType String The type of the procedure, such as PROCEDURE or FUNCTION.

CData Cloud

sys_procedureparameters

Describes stored procedure parameters.

The following query returns information about all of the input parameters for the SelectEntries stored procedure: 

SELECT * FROM sys_procedureparameters WHERE ProcedureName='SelectEntries' AND Direction=1 OR Direction=2

Columns

Name Type Description
CatalogName String The name of the database containing the stored procedure.
SchemaName String The name of the schema containing the stored procedure.
ProcedureName String The name of the stored procedure containing the parameter.
ColumnName String The name of the stored procedure parameter.
Direction Int32 An integer corresponding to the type of the parameter: input (1), input/output (2), or output(4). input/output type parameters can be both input and output parameters.
DataTypeName String The name of the data type.
DataType Int32 An integer indicating the data type. This value is determined at run time based on the environment.
Length Int32 The number of characters allowed for character data. The number of digits allowed for numeric data.
NumericPrecision Int32 The maximum precision for numeric data. The column length in characters for character and date-time data.
NumericScale Int32 The number of digits to the right of the decimal point in numeric data.
IsNullable Boolean Whether the parameter can contain null.
IsRequired Boolean Whether the parameter is required for execution of the procedure.
IsArray Boolean Whether the parameter is an array.
Description String The description of the parameter.
Ordinal Int32 The index of the parameter.

CData Cloud

sys_keycolumns

Describes the primary and foreign keys.

The following query retrieves the primary key for the Dataset_Opportunity table: 

         SELECT * FROM sys_keycolumns WHERE IsKey='True' AND TableName='Dataset_Opportunity'

Columns

Name Type Description
CatalogName String The name of the database containing the key.
SchemaName String The name of the schema containing the key.
TableName String The name of the table containing the key.
ColumnName String The name of the key column.
IsKey Boolean Whether the column is a primary key in the table referenced in the TableName field.
IsForeignKey Boolean Whether the column is a foreign key referenced in the TableName field.
PrimaryKeyName String The name of the primary key.
ForeignKeyName String The name of the foreign key.
ReferencedCatalogName String The database containing the primary key.
ReferencedSchemaName String The schema containing the primary key.
ReferencedTableName String The table containing the primary key.
ReferencedColumnName String The column name of the primary key.

CData Cloud

sys_foreignkeys

Describes the foreign keys.

The following query retrieves all foreign keys which refer to other tables: 

         SELECT * FROM sys_foreignkeys WHERE ForeignKeyType = 'FOREIGNKEY_TYPE_IMPORT'

Columns

Name Type Description
CatalogName String The name of the database containing the key.
SchemaName String The name of the schema containing the key.
TableName String The name of the table containing the key.
ColumnName String The name of the key column.
PrimaryKeyName String The name of the primary key.
ForeignKeyName String The name of the foreign key.
ReferencedCatalogName String The database containing the primary key.
ReferencedSchemaName String The schema containing the primary key.
ReferencedTableName String The table containing the primary key.
ReferencedColumnName String The column name of the primary key.
ForeignKeyType String Designates whether the foreign key is an import (points to other tables) or export (referenced from other tables) key.

CData Cloud

sys_primarykeys

Describes the primary keys.

The following query retrieves the primary keys from all tables and views: 

         SELECT * FROM sys_primarykeys

Columns

Name Type Description
CatalogName String The name of the database containing the key.
SchemaName String The name of the schema containing the key.
TableName String The name of the table containing the key.
ColumnName String The name of the key column.
KeySeq String The sequence number of the primary key.
KeyName String The name of the primary key.

CData Cloud

sys_indexes

Describes the available indexes. By filtering on indexes, you can write more selective queries with faster query response times.

The following query retrieves all indexes that are not primary keys: 

          SELECT * FROM sys_indexes WHERE IsPrimary='false'

Columns

Name Type Description
CatalogName String The name of the database containing the index.
SchemaName String The name of the schema containing the index.
TableName String The name of the table containing the index.
IndexName String The index name.
ColumnName String The name of the column associated with the index.
IsUnique Boolean True if the index is unique. False otherwise.
IsPrimary Boolean True if the index is a primary key. False otherwise.
Type Int16 An integer value corresponding to the index type: statistic (0), clustered (1), hashed (2), or other (3).
SortOrder String The sort order: A for ascending or D for descending.
OrdinalPosition Int16 The sequence number of the column in the index.

CData Cloud

sys_connection_props

Returns information on the available connection properties and those set in the connection string.

When querying this table, the config connection string should be used: 

jdbc:cdata:tableaucrm:config:

This connection string enables you to query this table without a valid connection.

The following query retrieves all connection properties that have been set in the connection string or set through a default value: 

SELECT * FROM sys_connection_props WHERE Value <> ''

Columns

Name Type Description
Name String The name of the connection property.
ShortDescription String A brief description.
Type String The data type of the connection property.
Default String The default value if one is not explicitly set.
Values String A comma-separated list of possible values. A validation error is thrown if another value is specified.
Value String The value you set or a preconfigured default.
Required Boolean Whether the property is required to connect.
Category String The category of the connection property.
IsSessionProperty String Whether the property is a session property, used to save information about the current connection.
Sensitivity String The sensitivity level of the property. This informs whether the property is obfuscated in logging and authentication forms.
PropertyName String A camel-cased truncated form of the connection property name.
Ordinal Int32 The index of the parameter.
CatOrdinal Int32 The index of the parameter category.
Hierarchy String Shows dependent properties associated that need to be set alongside this one.
Visible Boolean Informs whether the property is visible in the connection UI.
ETC String Various miscellaneous information about the property.

CData Cloud

sys_sqlinfo

Describes the SELECT query processing that the Cloud can offload to the data source.

See SQL Compliance for SQL syntax details.

Discovering the Data Source's SELECT Capabilities

Below is an example data set of SQL capabilities. Some aspects of SELECT functionality are returned in a comma-separated list if supported; otherwise, the column contains NO.

NameDescriptionPossible Values
AGGREGATE_FUNCTIONSSupported aggregation functions.AVG, COUNT, MAX, MIN, SUM, DISTINCT
COUNTWhether COUNT function is supported.YES, NO
IDENTIFIER_QUOTE_OPEN_CHARThe opening character used to escape an identifier.[
IDENTIFIER_QUOTE_CLOSE_CHARThe closing character used to escape an identifier.]
SUPPORTED_OPERATORSA list of supported SQL operators.=, >, <, >=, <=, <>, !=, LIKE, NOT LIKE, IN, NOT IN, IS NULL, IS NOT NULL, AND, OR
GROUP_BYWhether GROUP BY is supported, and, if so, the degree of support.NO, NO_RELATION, EQUALS_SELECT, SQL_GB_COLLATE
OJ_CAPABILITIESThe supported varieties of outer joins supported.NO, LEFT, RIGHT, FULL, INNER, NOT_ORDERED, ALL_COMPARISON_OPS
OUTER_JOINSWhether outer joins are supported.YES, NO
SUBQUERIESWhether subqueries are supported, and, if so, the degree of support.NO, COMPARISON, EXISTS, IN, CORRELATED_SUBQUERIES, QUANTIFIED
STRING_FUNCTIONSSupported string functions.LENGTH, CHAR, LOCATE, REPLACE, SUBSTRING, RTRIM, LTRIM, RIGHT, LEFT, UCASE, SPACE, SOUNDEX, LCASE, CONCAT, ASCII, REPEAT, OCTET, BIT, POSITION, INSERT, TRIM, UPPER, REGEXP, LOWER, DIFFERENCE, CHARACTER, SUBSTR, STR, REVERSE, PLAN, UUIDTOSTR, TRANSLATE, TRAILING, TO, STUFF, STRTOUUID, STRING, SPLIT, SORTKEY, SIMILAR, REPLICATE, PATINDEX, LPAD, LEN, LEADING, KEY, INSTR, INSERTSTR, HTML, GRAPHICAL, CONVERT, COLLATION, CHARINDEX, BYTE
NUMERIC_FUNCTIONSSupported numeric functions.ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT, EXP, FLOOR, LOG, MOD, SIGN, SIN, SQRT, TAN, PI, RAND, DEGREES, LOG10, POWER, RADIANS, ROUND, TRUNCATE
TIMEDATE_FUNCTIONSSupported date/time functions.NOW, CURDATE, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, MONTH, QUARTER, WEEK, YEAR, CURTIME, HOUR, MINUTE, SECOND, TIMESTAMPADD, TIMESTAMPDIFF, DAYNAME, MONTHNAME, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, EXTRACT
REPLICATION_SKIP_TABLESIndicates tables skipped during replication.
REPLICATION_TIMECHECK_COLUMNSA string array containing a list of columns which will be used to check for (in the given order) to use as a modified column during replication.
IDENTIFIER_PATTERNString value indicating what string is valid for an identifier.
SUPPORT_TRANSACTIONIndicates if the provider supports transactions such as commit and rollback.YES, NO
DIALECTIndicates the SQL dialect to use.
KEY_PROPERTIESIndicates the properties which identify the uniform database.
SUPPORTS_MULTIPLE_SCHEMASIndicates if multiple schemas may exist for the provider.YES, NO
SUPPORTS_MULTIPLE_CATALOGSIndicates if multiple catalogs may exist for the provider.YES, NO
DATASYNCVERSIONThe CData Data Sync version needed to access this driver.Standard, Starter, Professional, Enterprise
DATASYNCCATEGORYThe CData Data Sync category of this driver.Source, Destination, Cloud Destination
SUPPORTSENHANCEDSQLWhether enhanced SQL functionality beyond what is offered by the API is supported.TRUE, FALSE
SUPPORTS_BATCH_OPERATIONSWhether batch operations are supported.YES, NO
SQL_CAPAll supported SQL capabilities for this driver.SELECT, INSERT, DELETE, UPDATE, TRANSACTIONS, ORDERBY, OAUTH, ASSIGNEDID, LIMIT, LIKE, BULKINSERT, COUNT, BULKDELETE, BULKUPDATE, GROUPBY, HAVING, AGGS, OFFSET, REPLICATE, COUNTDISTINCT, JOINS, DROP, CREATE, DISTINCT, INNERJOINS, SUBQUERIES, ALTER, MULTIPLESCHEMAS, GROUPBYNORELATION, OUTERJOINS, UNIONALL, UNION, UPSERT, GETDELETED, CROSSJOINS, GROUPBYCOLLATE, MULTIPLECATS, FULLOUTERJOIN, MERGE, JSONEXTRACT, BULKUPSERT, SUM, SUBQUERIESFULL, MIN, MAX, JOINSFULL, XMLEXTRACT, AVG, MULTISTATEMENTS, FOREIGNKEYS, CASE, LEFTJOINS, COMMAJOINS, WITH, LITERALS, RENAME, NESTEDTABLES, EXECUTE, BATCH, BASIC, INDEX
PREFERRED_CACHE_OPTIONSA string value specifies the preferred cacheOptions.
ENABLE_EF_ADVANCED_QUERYIndicates if the driver directly supports advanced queries coming from Entity Framework. If not, queries will be handled client side.YES, NO
PSEUDO_COLUMNSA string array indicating the available pseudo columns.
MERGE_ALWAYSIf the value is true, The Merge Mode is forcibly executed in Data Sync.TRUE, FALSE
REPLICATION_MIN_DATE_QUERYA select query to return the replicate start datetime.
REPLICATION_MIN_FUNCTIONAllows a provider to specify the formula name to use for executing a server side min.
REPLICATION_START_DATEAllows a provider to specify a replicate startdate.
REPLICATION_MAX_DATE_QUERYA select query to return the replicate end datetime.
REPLICATION_MAX_FUNCTIONAllows a provider to specify the formula name to use for executing a server side max.
IGNORE_INTERVALS_ON_INITIAL_REPLICATEA list of tables which will skip dividing the replicate into chunks on the initial replicate.
CHECKCACHE_USE_PARENTIDIndicates whether the CheckCache statement should be done against the parent key column.TRUE, FALSE
CREATE_SCHEMA_PROCEDURESIndicates stored procedures that can be used for generating schema files.

The following query retrieves the operators that can be used in the WHERE clause: 

SELECT * FROM sys_sqlinfo WHERE Name = 'SUPPORTED_OPERATORS'
Note that individual tables may have different limitations or requirements on the WHERE clause; refer to the Data Model section for more information.

Columns

Name Type Description
NAME String A component of SQL syntax, or a capability that can be processed on the server.
VALUE String Detail on the supported SQL or SQL syntax.

CData Cloud

sys_identity

Returns information about attempted modifications.

The following query retrieves the Ids of the modified rows in a batch operation: 

         SELECT * FROM sys_identity

Columns

Name Type Description
Id String The database-generated Id returned from a data modification operation.
Batch String An identifier for the batch. 1 for a single operation.
Operation String The result of the operation in the batch: INSERTED, UPDATED, or DELETED.
Message String SUCCESS or an error message if the update in the batch failed.

CData Cloud

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Establishing a Connection.

Authentication

PropertyDescription
AuthSchemeThe type of authentication to use when connecting to Tableau CRM.
InstanceURLThe URL of the Salesforce instance you want to use.
SubdomainThe instance of the Tableau CRM API used.
UseSandboxA boolean determining if the connection should be made to a Tableau CRM sandbox account.

Connection

PropertyDescription
ApiVersionThe API version being used. This can be specified to access a new version of the API once it is released.

JWT OAuth

PropertyDescription
OAuthJWTCertThe JWT Certificate store.
OAuthJWTCertTypeThe type of key store containing the JWT Certificate.
OAuthJWTCertPasswordThe password for the OAuth JWT certificate.
OAuthJWTCertSubjectThe subject of the OAuth JWT certificate.
OAuthJWTIssuerThe issuer of the Java Web Token.
OAuthJWTSubjectThe user subject for which the application is requesting delegated access.

SSL

PropertyDescription
SSLServerCertThe certificate to be accepted from the server when connecting using TLS/SSL.

Logging

PropertyDescription
VerbosityThe verbosity level that determines the amount of detail included in the log file.

Schema

PropertyDescription
BrowsableSchemasThis property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
MetadataFilesLocationThe location of the metadata files. Set this to the path of the folder where your metadata files are stored, or the specific path of your file.
TypeDetectionSchemeDetermines how to determine the data types of columns.
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
PrimaryKeyIdentifierSet this property to control the name of the primary key.

Miscellaneous

PropertyDescription
AsyncBulkOperationA boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.
HandleAPINullIssuesA boolean indicating if the provider should handle known issues with Tableau CRM nulls.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
PagesizeThe maximum number of results to return per page from Tableau CRM.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseDisplayNamesBoolean determining if the display names for the columns should be used instead of the API names.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.
CData Cloud

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.

PropertyDescription
AuthSchemeThe type of authentication to use when connecting to Tableau CRM.
InstanceURLThe URL of the Salesforce instance you want to use.
SubdomainThe instance of the Tableau CRM API used.
UseSandboxA boolean determining if the connection should be made to a Tableau CRM sandbox account.
CData Cloud

AuthScheme

The type of authentication to use when connecting to Tableau CRM.

Possible Values

Auto, OAuth, OAuthPKCE, OAuthJWT

Data Type

string

Default Value

"Auto"

Remarks

  • Auto: Lets the driver decide automatically based on the other connection properties you have set.
  • OAuth: Set this to perform OAuth authentication.
  • OAuthPKCE: Uses OAuth2 with the authorization code grant type and PKCE extension. OAuthClientId is the credential.
  • OAuthJWT: Set this to perform OAuth authentication with a certificate.

CData Cloud

InstanceURL

The URL of the Salesforce instance you want to use.

Data Type

string

Default Value

""

Remarks

The URL of the Salesforce instance you want to use. This connection property must be set when InitiateOAuth is set to OFF; the value is returned by GetOAuthAccessToken.

CData Cloud

Subdomain

The instance of the Tableau CRM API used.

Data Type

string

Default Value

""

Remarks

The instance of the Tableau CRM API used. Used to connect via a branded login page. Applicable only in authentication.

CData Cloud

UseSandbox

A boolean determining if the connection should be made to a Tableau CRM sandbox account.

Data Type

bool

Default Value

false

Remarks

In order to connect to a Tableau CRM sandbox account, set UseSandbox to TRUE and append the sandbox name to the end of the username when asked in the UI. For instance, if your username is "user", and sandbox name in Tableau CRM is "sandbox", the username you should be entering should be "user.sandbox".

CData Cloud

Connection

This section provides a complete list of the Connection properties you can configure in the connection string for this provider.

PropertyDescription
ApiVersionThe API version being used. This can be specified to access a new version of the API once it is released.
CData Cloud

ApiVersion

The API version being used. This can be specified to access a new version of the API once it is released.

Data Type

string

Default Value

"59.0"

Remarks

The API version being used. This can be specified to access a new version of the API once it is released. Otherwise, you can use the default.

CData Cloud

JWT OAuth

This section provides a complete list of the JWT OAuth properties you can configure in the connection string for this provider.

PropertyDescription
OAuthJWTCertThe JWT Certificate store.
OAuthJWTCertTypeThe type of key store containing the JWT Certificate.
OAuthJWTCertPasswordThe password for the OAuth JWT certificate.
OAuthJWTCertSubjectThe subject of the OAuth JWT certificate.
OAuthJWTIssuerThe issuer of the Java Web Token.
OAuthJWTSubjectThe user subject for which the application is requesting delegated access.
CData Cloud

OAuthJWTCert

The JWT Certificate store.

Data Type

string

Default Value

""

Remarks

The name of the certificate store for the client certificate.

The OAuthJWTCertType field specifies the type of the certificate store specified by OAuthJWTCert. If the store is password protected, specify the password in OAuthJWTCertPassword.

OAuthJWTCert is used in conjunction with the OAuthJWTCertSubject field in order to specify client certificates. If OAuthJWTCert has a value, and OAuthJWTCertSubject is set, a search for a certificate is initiated. Please refer to the OAuthJWTCertSubject field for details.

Designations of certificate stores are platform-dependent.

The following are designations of the most common User and Machine certificate stores in Windows:

MYA certificate store holding personal certificates with their associated private keys.
CACertifying authority certificates.
ROOTRoot certificates.
SPCSoftware publisher certificates.

In Java, the certificate store normally is a file containing certificates and optional private keys.

When the certificate store type is PFXFile, this property must be set to the name of the file. When the type is PFXBlob, the property must be set to the binary contents of a PFX file (i.e. PKCS12 certificate store).

CData Cloud

OAuthJWTCertType

The type of key store containing the JWT Certificate.

Data Type

string

Default Value

"PEMKEY_BLOB"

Remarks

This property can take one of the following values:

USERFor Windows, this specifies that the certificate store is a certificate store owned by the current user. Note: This store type is not available in Java.
MACHINEFor Windows, this specifies that the certificate store is a machine store. Note: this store type is not available in Java.
PFXFILEThe certificate store is the name of a PFX (PKCS12) file containing certificates.
PFXBLOBThe certificate store is a string (base-64-encoded) representing a certificate store in PFX (PKCS12) format.
JKSFILEThe certificate store is the name of a Java key store (JKS) file containing certificates. Note: this store type is only available in Java.
JKSBLOBThe certificate store is a string (base-64-encoded) representing a certificate store in Java key store (JKS) format. Note: this store type is only available in Java.
PEMKEY_FILEThe certificate store is the name of a PEM-encoded file that contains a private key and an optional certificate.
PEMKEY_BLOBThe certificate store is a string (base64-encoded) that contains a private key and an optional certificate.
PUBLIC_KEY_FILEThe certificate store is the name of a file that contains a PEM- or DER-encoded public key certificate.
PUBLIC_KEY_BLOBThe certificate store is a string (base-64-encoded) that contains a PEM- or DER-encoded public key certificate.
SSHPUBLIC_KEY_FILEThe certificate store is the name of a file that contains an SSH-style public key.
SSHPUBLIC_KEY_BLOBThe certificate store is a string (base-64-encoded) that contains an SSH-style public key.
P7BFILEThe certificate store is the name of a PKCS7 file containing certificates.
PPKFILEThe certificate store is the name of a file that contains a PPK (PuTTY Private Key).
XMLFILEThe certificate store is the name of a file that contains a certificate in XML format.
XMLBLOBThe certificate store is a string that contains a certificate in XML format.

CData Cloud

OAuthJWTCertPassword

The password for the OAuth JWT certificate.

Data Type

string

Default Value

""

Remarks

If the certificate store is of a type that requires a password, this property is used to specify that password in order to open the certificate store.

CData Cloud

OAuthJWTCertSubject

The subject of the OAuth JWT certificate.

Data Type

string

Default Value

"*"

Remarks

When loading a certificate the subject is used to locate the certificate in the store.

If an exact match is not found, the store is searched for subjects containing the value of the property.

If a match is still not found, the property is set to an empty string, and no certificate is selected.

The special value "*" picks the first certificate in the certificate store.

The certificate subject is a comma separated list of distinguished name fields and values. For instance "CN=www.server.com, OU=test, C=US, [email protected]". Common fields and their meanings are displayed below.

FieldMeaning
CNCommon Name. This is commonly a host name like www.server.com.
OOrganization
OUOrganizational Unit
LLocality
SState
CCountry
EEmail Address

If a field value contains a comma it must be quoted.

CData Cloud

OAuthJWTIssuer

The issuer of the Java Web Token.

Data Type

string

Default Value

""

Remarks

The issuer of the Java Web Token. This is typically either the Client Id or Email Address of the OAuth Application.

CData Cloud

OAuthJWTSubject

The user subject for which the application is requesting delegated access.

Data Type

string

Default Value

""

Remarks

The user subject for which the application is requesting delegated access. Typically, the user account name or email address.

CData Cloud

SSL

This section provides a complete list of the SSL properties you can configure in the connection string for this provider.

PropertyDescription
SSLServerCertThe certificate to be accepted from the server when connecting using TLS/SSL.
CData Cloud

SSLServerCert

The certificate to be accepted from the server when connecting using TLS/SSL.

Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.

This property can take the following forms:

Description Example
A full PEM Certificate (example shortened for brevity) -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate C:\cert.cer
The public key (example shortened for brevity) -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated) ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated) 34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine is accepted.

Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.

CData Cloud

Logging

This section provides a complete list of the Logging properties you can configure in the connection string for this provider.

PropertyDescription
VerbosityThe verbosity level that determines the amount of detail included in the log file.
CData Cloud

Verbosity

The verbosity level that determines the amount of detail included in the log file.

Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the Cloud reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are detailed in the Logging page.

CData Cloud

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.

PropertyDescription
BrowsableSchemasThis property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
MetadataFilesLocationThe location of the metadata files. Set this to the path of the folder where your metadata files are stored, or the specific path of your file.
TypeDetectionSchemeDetermines how to determine the data types of columns.
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
PrimaryKeyIdentifierSet this property to control the name of the primary key.
CData Cloud

BrowsableSchemas

This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.

Data Type

string

Default Value

""

Remarks

Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.

CData Cloud

MetadataFilesLocation

The location of the metadata files. Set this to the path of the folder where your metadata files are stored, or the specific path of your file.

Data Type

string

Default Value

""

Remarks

Set this to the path of the folder where your metadata files are stored, or the specific path of your file. If you specify only the folder, than your metadata files should have specific names. For example: datasetName.json.

CData Cloud

TypeDetectionScheme

Determines how to determine the data types of columns.

Possible Values

None, RowScan

Data Type

string

Default Value

"RowScan"

Remarks

NoneSetting TypeDetectionScheme to None will return all columns as the string type. Note: Even when set to None, the column names will still be scanned when Header is set to True.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.

CData Cloud

RowScanDepth

The maximum number of rows to scan to look for the columns available in a table.

Data Type

string

Default Value

"50"

Remarks

Since Tableau CRM is schemaless, the columns in a table must be determined by scanning table rows. This value determines the maximum number of documents that will be scanned.

Setting a high value may decrease performance. Setting a low value may prevent the data type from being determined properly, especially when there is null data.

CData Cloud

PrimaryKeyIdentifier

Set this property to control the name of the primary key.

Data Type

string

Default Value

""

Remarks

Determines the name of the primary key column. Set this to the primary key column of the table you are querying.

CData Cloud

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.

PropertyDescription
AsyncBulkOperationA boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.
HandleAPINullIssuesA boolean indicating if the provider should handle known issues with Tableau CRM nulls.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
PagesizeThe maximum number of results to return per page from Tableau CRM.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseDisplayNamesBoolean determining if the display names for the columns should be used instead of the API names.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.
CData Cloud

AsyncBulkOperation

A boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.

Data Type

bool

Default Value

false

Remarks

Tableau CRM responses can be fairly slow when inserting data. In these situations it is best to use asynchronous services to submit the data. Asynchronous services allow Tableau CRM to process the data while your application continues executing. The downside of using asynchronous services is that you will need to check the status of the insert manually to see if Salesforce has finished processing the request and see if there were any issues.

CData Cloud

HandleAPINullIssues

A boolean indicating if the provider should handle known issues with Tableau CRM nulls.

Data Type

bool

Default Value

true

Remarks

Tableau CRM has documented some known issues with nulls. This includes rows being excluded from results when there would be nulls on a columns used in both Order By and Group By. For instance: 

SELECT Product_Name FROM Dataset_DTC_Opportunity_SAMPLE GROUP BY Product_Name

Will normally not return the entries that are null. This causes issues for aggregations especially. To handle this, CData Cloud will instead handle operations that would normally cause a problem with nulls internally instead of having the Tableau CRM execute them. This will cause worse performance, but results will be accurate. Set HandleAPINullIssues to false if null entries are not a problem for you, or if in cases where performance is more important.

CData Cloud

MaxRows

Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.

Data Type

int

Default Value

-1

Remarks

Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.

CData Cloud

Pagesize

The maximum number of results to return per page from Tableau CRM.

Data Type

int

Default Value

10000

Remarks

The Pagesize property affects the maximum number of results to return per page from Tableau CRM. Setting a higher value may result in better performance at the cost of additional memory allocated per page consumed.

CData Cloud

PseudoColumns

This property indicates whether or not to include pseudo columns as columns to the table.

Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".

CData Cloud

Timeout

The value in seconds until the timeout error is thrown, canceling the operation.

Data Type

int

Default Value

60

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the Cloud throws an exception.

CData Cloud

UseDisplayNames

Boolean determining if the display names for the columns should be used instead of the API names.

Data Type

bool

Default Value

false

Remarks

Boolean determining if the display names for the columns should be used instead of the API names.

CData Cloud

UseSimpleNames

Boolean determining if simple names should be used for tables and columns.

Data Type

bool

Default Value

false

Remarks

Tableau CRM tables and columns can use special characters in names that are normally not allowed in standard databases. UseSimpleNames makes the Cloud easier to use with traditional database tools.

Setting UseSimpleNames to true will simplify the names of tables and columns returned. It will enforce a naming scheme such that only alphanumeric characters and the underscore are valid for the displayed table and column names. Any nonalphanumeric characters will be converted to an underscore.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839