接続の確立

Sync App アプリケーションの接続ページに移動し、接続の追加 パネルで対応するアイコンを選択して、Tableau CRM への接続を作成します。Tableau CRM アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからTableau CRM コネクタをダウンロードおよびインストールします。

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

Tableau CRM はOAuth 2 認証標準を利用しています。Tableau CRM にアプリケーションを登録し、OAuthClientId およびOAuthClientSecret を取得する必要があります。 Tableau CRM への接続の認証ガイドを参照してください。

OAuthJWT Certificates

Set the AuthScheme to OAuthJWT.

OAuthJWT

To obtain the OAuthJWT consumer key:

Log in to Salesforce.com.
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.
Enter a name to be displayed to users when they log in to grant permissions to your app, along with a contact Email address.
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
```
Enable Use digital signatures.
Upload your certificate.
Select the scope of permissions that your app should request from the user.
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: Set to OAuthJWT.
InitiateOAuth: Set to GETANDREFRESH.
OAuthJWTCert: Set this to the JWT Certificate store.
OAuthJWTPassword: Set this to the Password of the JWT Certificate store.
OAuthJWTIssuer: Set this to the OAuth Client ID.
OAuthJWTCertType: Set this to the type of the certificate store specified by OAuthJWTCert.

Note: This flow never issues a refresh token.

Tableau CRM への接続

OAuth では認証するユーザーにブラウザでTableau CRM との通信を要求します。次のセクションで説明するとおり、Sync App はさまざまな方法でこれをサポートします。

接続アプリケーションの作成

次の手順に従って、OAuth クライアントクレデンシャル、コンシューマーキーおよびコンシューマーシークレットを取得できます。

Salesforce.com にログインし、ユーザー名をクリックして［設定］にアクセスします。
組織がSalesforce Lightning Experience UI を使用している場合は、［設定］の［クイック検索］ボックスにApp を入力して［アプリケーションマネージャ］（［接続アプリケーションを管理する］ではありません）を選択し、［新規接続アプリケーション］をクリックします。

組織がSalesforce Classic UI を使用している場合は、［設定］の［クイック検索］ボックスにApps を入力し、［ビルド］または［作成］でアプリを選択します。［接続アプリケーション］で［新規］をクリックします。
ユーザーがアプリケーションにログイン認証をする際に表示されるアプリケーション名を入力します。連絡先E メールアドレスも入力します。
［OAuth 設定の有効化］をクリックし、コールバックURL ボックスに値を入力します。

コールバックURL を http://localhost:33333 か任意の別のポート番号に設定してください。
次のOAuth 範囲を選択します：

Wave データへのアクセスと管理（wave_api）

データへのアクセスと管理（api）

ユーザーに代わっていつでも要求を実行（refresh_token, offline_token）
アプリケーションを作成したら、アプリケーション名をクリックしてアプリケーションの情報ページを開きます。OAuth クライアントクレデンシャル、コンシューマーキーおよびコンシューマーシークレットが表示されます。

Tableau CRM への認証

次の接続プロパティを設定して、接続してください。

OAuthClientId：アプリ設定のコンシューマーキーに設定。
OAuthClientSecret：アプリケーション設定のコンシューマーシークレットに設定。
CallbackURL：アプリケーション設定のコールバックURL に設定。

接続すると、Sync App はデフォルトブラウザでOAuth エンドポイントを開きます。ログインして、アプリケーションにアクセス許可を与えます。Sync App がOAuth プロセスを完了します。

コールバックURL でアクセストークンを設定し、認証リクエストを行います。
返されたリフレッシュトークンと有効なアクセストークンとを交換します。

データセットの選択

The following sections show how to execute SELECT statements to your Tableau CRM datasets or lenses. See データモデル for information on how the Sync App 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.

From your dashboard choose LENSES
Open the LENS which is not working and go to "SAQL Mode"
Make a minor update (i.e: a white space in the end of the query)
Save the LENS and wait some seconds for the changes to by applied
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.

データセットの挿入

The Sync App 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:

In Tableau CRM, go to the home page, click Create, and then choose Dataset.
Select CSV file to upload and click Next.
From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
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

データセットのアップサート

The Sync App 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:

In Tableau CRM, go to the home page, click Create, and then choose Dataset.
Select CSV file to upload and click Next.
From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
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

データセットの削除

The Sync App 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:

In Tableau CRM, go to the home page, click Create, and then choose Dataset.
Select CSV file to upload and click Next.
From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
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

データセットのアップロード

The Sync App 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.

高度な機能

このセクションでは、Tableau CRM Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App を使用すると、事前設定されたクエリによって内容が決定されるユーザー定義ビューと呼ばれる仮想テーブルを定義できます。このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。カスタムビューの作成と設定の概要については、ユーザー定義ビューを参照してください。

SSL の設定

SSL の設定を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、接続文字列オプションにあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシに合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Tableau CRM にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくはクエリ処理を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログを参照してください。基本的なロギングでは、次の2つの接続プロパティを設定するだけです。LogModules 接続プロパティを使用してログに記録する情報のサブセットを選択できる、より洗練されたロギングをサポートする多数の機能があります。

SSL の設定

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL / TLS のネゴシエーションを試みます。

別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows のシステムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらにHTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

次のプロパティを設定します。

プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
接続をトンネルするには、FirewallType をTUNNEL に設定します。
認証するには、FirewallUser とFirewallPassword を設定します。
SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

データモデル

Sync App はTableau CRM REST API を使用して、Tableau CRM データセットおよびレンズをデータベースビュー、またはread only のテーブルとしてモデル化します。データセットは、双方向アクセスを追加サポートします。

次のセクションでは、ビューおよびストアドプロシージャを使って利用できる機能について説明します。

ビュー

Sync App を使用すると、アカウント内のすべてのデータセットとレンズを操作できます。ビュースキーマは、実行時に動的に検出されます。

データセットテーブルは"Dataset_" で始まります。"Test" という名前のデータセットのデータを取得したい場合は、テーブル名は"Dataset_Test" となります。レンズテーブルは"Lens_" で始まります。"Test" という名前のレンズのデータを取得したい場合は、テーブル名は"Lens_Test" となります。

実行時にスキーマ情報およびその他のSync App メタデータを取得するには、システムテーブルを参照してください。ビューセクションは、Tableau CRM 開発環境で使用可能なデータセットおよびレンズをモデルにしたデータベースの例を示します。

動的スキーマ

接続時にSync App は、適切なWeb サービスを呼び出してテーブルのリストとテーブルのメタデータを取得します。Sync App を使用して接続すると、新しいカラムの追加やカラムのデータ型の変更など、データセットまたはレンズに対して行う変更は即座に反映されます。

クエリ処理

Sync App は、Tableau CRM にできるだけ多くのSELECT 構文処理をオフロードし、残りのクエリをSync App 内で処理します。 Sync App がクライアントサイドのインメモリ処理でAPI 制限を回避する方法の詳細については、SupportEnhancedSQL を参照してください。

データセットおよびレンズへのSQL の実行

データセットはINSERT ステートメントをサポートしていますが、レンズはSELECT のみをサポートします。UploadCSVToDataSet ストアドプロシージャを呼び出して、既存のデータセットに挿入したり新しいデータセットを作成したりすることもできます。

データセットおよびレンズへのSQL の実行例については、次のセクションを参照してください。

データセットの選択
データセットの挿入
データセットのアップロード

スキーマのカスタマイズ

テーブルスキーマをカスタマイズして、次のことを行うことができます。

レポートされたカラムとデータ型を変更。
データセットまたはレンズに対して実行される操作を変更。

スキーマをカスタマイズするには、CreateSchema ストアドプロシージャを呼び出します。ストアドプロシージャは、動的なスキーマを静的なコンフィギュレーションファイルに保存します。スキーマファイルはシンプルな形式となっており、カスタマイズは簡単です。

ストアドプロシージャ

ストアドプロシージャは、データソースのファンクションライクなインターフェースです。これらは、ビューに表示されない他のAPI 機能にアクセスするために使用できます。

テーブル

Sync App はTableau CRM のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、Tableau CRM テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

Tableau CRM Analytics Connector for CData Sync テーブル


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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Tableau CRM Analytics Connector for CData Sync ビュー


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.

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.

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.

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.

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.

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.

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.

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.

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

接続を確立する方法について詳しくは、接続の確立を参照してください。

Authentication

プロパティ	説明
AuthScheme	The type of authentication to use when connecting to Tableau CRM.
InstanceURL	The URL of the Salesforce instance you want to use.
Subdomain	The instance of the Tableau CRM API used.
UseSandbox	A boolean determining if the connection should be made to a Tableau CRM sandbox account.

Connection

プロパティ	説明
ApiVersion	The API version being used. This can be specified to access a new version of the API once it is released.

OAuth

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

JWT OAuth

プロパティ	説明
OAuthJWTCert	JWT 証明書のストア。
OAuthJWTCertType	JWT 証明書を格納するキーストアの種類。
OAuthJWTCertPassword	OAuth JWT 証明書のパスワード。
OAuthJWTCertSubject	OAuth JWT 証明書のサブジェクト。
OAuthJWTIssuer	Java Web Token の発行者。
OAuthJWTSubject	アプリケーションからデリゲートアクセスの要求対象となるユーザーサブジェクト。

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

Firewall

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

Proxy

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

Logging

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

Schema

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。
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.
TypeDetectionScheme	Determines how to determine the data types of columns.
RowScanDepth	The maximum number of rows to scan to look for the columns available in a table.
PrimaryKeyIdentifier	Set this property to control the name of the primary key.

Miscellaneous

プロパティ	説明
AsyncBulkOperation	A boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.
HandleAPINullIssues	A boolean indicating if the provider should handle known issues with Tableau CRM nulls.
MaxRows	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
Pagesize	Tableau CRM から返されるページあたりの結果の最大数。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UseDisplayNames	Boolean determining if the display names for the columns should be used instead of the API names.
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。
UseSimpleNames	テーブルとカラムに簡略名を使用するかどうかを決定するboolean。

Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

プロパティ	説明
AuthScheme	The type of authentication to use when connecting to Tableau CRM.
InstanceURL	The URL of the Salesforce instance you want to use.
Subdomain	The instance of the Tableau CRM API used.
UseSandbox	A boolean determining if the connection should be made to a Tableau CRM sandbox account.

AuthScheme

The type of authentication to use when connecting to Tableau CRM.

解説

Auto: Lets the driver decide automatically based on the other connection properties you have set.
OAuth: Set this to perform OAuth authentication.
OAuthJWT: Set this to perform OAuth authentication with a certificate.

InstanceURL

The URL of the Salesforce instance you want to use.

解説

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.

Subdomain

The instance of the Tableau CRM API used.

解説

The instance of the Tableau CRM API used. Used to connect via a branded login page. Applicable only in authentication.

UseSandbox

A boolean determining if the connection should be made to a Tableau CRM sandbox account.

解説

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

Connection

このセクションでは、本プロバイダーの接続文字列で設定可能なConnection プロパティの全リストを提供します。

プロパティ	説明
ApiVersion	The API version being used. This can be specified to access a new version of the API once it is released.

ApiVersion

The API version being used. This can be specified to access a new version of the API once it is released.

解説

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.

OAuth

このセクションでは、本プロバイダーの接続文字列で設定可能なOAuth プロパティの全リストを提供します。

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

OAuthClientId

OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId 値、およびクライアントシークレットOAuthClientSecret が提供されます。

OAuthClientSecret

OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId が提供されます。また、コンシューマーシークレットと呼ばれるクライアントシークレットも提供されます。クライアントシークレットをOAuthClientSecret プロパティに設定します。

JWT OAuth

このセクションでは、本プロバイダーの接続文字列で設定可能なJWT OAuth プロパティの全リストを提供します。

プロパティ	説明
OAuthJWTCert	JWT 証明書のストア。
OAuthJWTCertType	JWT 証明書を格納するキーストアの種類。
OAuthJWTCertPassword	OAuth JWT 証明書のパスワード。
OAuthJWTCertSubject	OAuth JWT 証明書のサブジェクト。
OAuthJWTIssuer	Java Web Token の発行者。
OAuthJWTSubject	アプリケーションからデリゲートアクセスの要求対象となるユーザーサブジェクト。

OAuthJWTCert

JWT 証明書のストア。

解説

クライアント証明書のための証明書ストア名。

OAuthJWTCertType フィールドは、OAuthJWTCert により指定された証明書ストアの種類を指定します。ストアがパスワードで保護されている場合は、OAuthJWTCertPassword でパスワードを指定します。

OAuthJWTCert は、OAuthJWTCertSubject フィールドとともにクライアント証明書を指定するために使われます。 OAuthJWTCert に値がある場合で、OAuthJWTCertSubject が設定されている場合は、証明書の検索が始まります。詳しくは、OAuthJWTCertSubject フィールドを参照してください。

証明書ストアの指定はプラットフォームに依存します。

Windows の共通のユーザとシステム証明書ストアの指定は以下のとおりです。


MY	個人証明書と関連付けられた秘密キーを格納している証明書ストア。
CA	証明機関の証明書。
ROOT	ルート証明書。
SPC	ソフトウェア発行元証明書。

Javaでは、証明書ストアは通常、証明書および任意の秘密キーを含むファイルです。

証明書ストアの種類がPFXFile の場合は、このプロパティにファイル名を設定します。 PFXBlob の場合は、このプロパティをPFX ファイルのバイナリコンテンツ（例えば、PKCS12証明書ストア）に設定する必要があります。

OAuthJWTCertType

JWT 証明書を格納するキーストアの種類。

解説

このプロパティには次の値の一つを設定できます。


USER	Windows の場合、現在のユーザーにより所有された証明書ストアであることを指定します。 Note：この種類はJava では利用できません。
MACHINE	Windows の場合、この証明書ストアがシステムストアであることを指定します。 Note：この種類はJava では利用できません。
PFXFILE	この証明書ストアは、証明書を含むPFX（PKCS12）ファイルの名前です。
PFXBLOB	この証明書ストアは、PFX（PKCS12）形式の証明書ストアを表すBase-64でエンコードされた文字列です。
JKSFILE	この証明書ストアは、証明書を含むJava key store（JKS）ファイルの名前です。 Note：この種類はJava のみで利用できます。
JKSBLOB	この証明書ストアは、Java key store（JKS）形式の証明書ストアを表すBase-64でエンコードされた文字列です。 Note：この種類はJava のみで利用できます。
PEMKEY_FILE	この証明書ストアは、秘密キーと任意の証明書を含むPEM でエンコードされたファイルの名前です。
PEMKEY_BLOB	この証明書ストアは、秘密キーと任意の証明書を含むBase-64でエンコードされた文字列です。
PUBLIC_KEY_FILE	この証明書ストアは、PEM またはDER でエンコードされた公開キーの証明書を含むファイルの名前です。
PUBLIC_KEY_BLOB	この証明書ストアは、PEM またはDER でエンコードされた公開キーの証明書を含むBase-64でエンコードされた文字列です。
SSHPUBLIC_KEY_FILE	この証明書ストアは、SSH 公開キーを含むファイルの名前です。
SSHPUBLIC_KEY_BLOB	この証明書ストアは、SSH 公開キーを含むBase-64でエンコードされた文字列です。
P7BFILE	この証明書ストアは、証明書を含むPKCS7 ファイルの名前です。
PPKFILE	この証明書ストアは、PuTTY 秘密キー（PPK）を含むファイルの名前です。
XMLFILE	この証明書ストアは、XML 形式の証明書を含むファイルの名前です。
XMLBLOB	この証明書ストアは、XML 形式の証明書を含む文字列の名前です。

OAuthJWTCertPassword

OAuth JWT 証明書のパスワード。

解説

証明書ストアでパスワードが必要である場合、このプロパティを使用してパスワードを指定し、証明書ストアにアクセスできます。

OAuthJWTCertSubject

OAuth JWT 証明書のサブジェクト。

解説

証明書のサブジェクトは、証明書をロードするときにストア内の証明書を検索するために使用されます。

完全に一致するものが見つからない場合、ストアはプロパティの値を含むサブジェクトを検索します。

それでも一致するものが見つからない場合、プロパティは空白で設定され、証明書は選択されません。

"*" に設定すると、証明書ストアの1番目の証明書が選択されます。

証明書のサブジェクトは識別の名前フィールドおよび値のカンマ区切りのリストです。例えば、"CN=www.server.com, OU=test, C=US, [email protected]"。共通のフィールドとその説明は以下のとおりです。


フィールド	説明
CN	共通名。一般的には、www.server.com のようなホスト名です。
O	法人名
OU	法人の部署名
L	法人の住所（市町村名）
S	法人の住所（都道府県）
C	国名
E	Eメールアドレス

フィールド値にカンマが含まれている場合は、それを引用符で囲む必要があります。

OAuthJWTIssuer

Java Web Token の発行者。

解説

Java Web Token の発行者。通常は、OAuth アプリケーションのクライアントId またはE メールアドレスとなります。

OAuthJWTSubject

アプリケーションからデリゲートアクセスの要求対象となるユーザーサブジェクト。

解説

アプリケーションからデリゲートアクセスの要求対象となるユーザーサブジェクトです。通常は、ユーザーのアカウント名またはE メールアドレスとなります。

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

SSLServerCert

TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

Firewall

このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

FirewallType

プロキシベースのファイアウォールで使われるプロトコル。

解説

このプロパティは、Sync App がFirewallServer プロキシ経由でトンネルトラフィックを使うためのプロトコルを指定します。デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し次のプロキシタイプのどれかで接続するには、ProxyAutoDetect をfalse に設定します。


タイプ	デフォルトポート	説明
TUNNEL	80	これが設定されている場合、Sync App はTableau CRM への接続を開き、プロキシを経由して通信が行われます。
SOCKS4	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 4 プロキシ経由で送信し、接続リクエストが許容されるかどうかを決定します。
SOCKS5	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 5 プロキシ経由で送信します。プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。

FirewallServer

プロキシベースのファイアウォールの名前もしくはIP アドレス。

解説

ファイアウォールトラバーサルを許容するために設定するIP アドレス、DNS 名、もしくはプロキシホスト名を指定するプロパティです。プロトコルはFirewallType で指定されます。このプロパティとFirewallServer を使って、SOCKS 経由での接続、もしくはトンネリングが可能です。HTTP プロキシへの接続には、ProxyServer を使用します。

Sync App はデフォルトでシステムプロキシを使うので注意してください。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定してください。

FirewallPort

プロキシベースのファイアウォールのTCP ポート。

解説

ファイアウォールトラバーサルを許容するために設定するプロキシベースのファイアウォールのTCP ポート。名前もしくはIP アドレスを指定するには、FirewallServer を使います。FirewallType でプロトコルを指定します。

FirewallUser

プロキシベースのファイアウォールに認証するために使うユーザー名。

解説

FirewallUser およびFirewallPassword プロパティは、FirewallType により指定された認証方式に則り、FirewallServer、およびFirewallPort で指定されたプロキシに対しての認証に使われます。

FirewallPassword

プロキシベースのファイアウォールへの認証に使われるパスワード。

解説

このプロパティは、FirewallType により指定された認証メソッドに則り、FirewallServer およびFirewallPort で指定されたプロキシに渡されます。

Proxy

このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

ProxyAutoDetect

これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

解説

これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。

ProxyServer

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。

解説

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。HTTP プロキシへの認証には、Sync App はHTTP、Windows(NTLM)、もしくはKerberos 認証タイプを使用することができます。

SOCKS プロキシを経由して接続する、もしくは接続をトンネルするには、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定します。

ProxyPort

ProxyServer プロキシが起動しているTCP ポート。

解説

HTTP トラフィックをリダイレクトするHTTP プロキシが実行されているポート。ProxyServer でHTTP プロキシを指定します。その他のプロキシタイプについては、FirewallType を参照してください。

ProxyAuthScheme

ProxyServer プロキシへの認証で使われる認証タイプ。

解説

この値は、ProxyServer およびProxyPort で指定されるHTTP プロキシに認証するために使われる認証タイプを指定します。

Sync App は、デフォルトでsystem proxy settings を使い、追加での設定が不要です。他のプロキシへの接続をする場合には、ProxyServer およびProxyPort に加え、ProxyAutoDetect をfalse に設定します。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

認証タイプは、次のどれかになります。

BASIC： Sync App はHTTP BASIC 認証を行います。
DIGEST： Sync App はHTTP DIGEST 認証を行います。
NEGOTIATE： Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKereros トークンを取得します。
PROPRIETARY： Sync App はNTLM もしくはKerberos トークンを発行しません。このトークンを、HTTP リクエストのAuthorization ヘッダーに含める必要があります。

SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。

ProxyUser

ProxyServer プロキシへの認証に使われるユーザー名。

解説

ProxyUser および ProxyPassword オプションは、ProxyServer で指定されたHTTP プロキシに対して接続および認証するために使用されます。

ProxyAuthScheme で使用可能な認証タイプを選択することができます。HTTP 認証を使う場合、これをHTTP プロキシで識別可能なユーザーのユーザー名に設定します。Windows もしくはKerberos 認証を使用する場合、このプロパティを次の形式のどれかでユーザー名に設定します。

user@domain
domain\user

ProxyPassword

ProxyServer プロキシへの認証に使われるパスワード。

解説

このプロパティは、NTLM(Windows)、Kerberos、もしくはHTTP 認証をサポートするHTTP プロキシサーバーに認証するために使われます。HTTP プロキシを指定するためには、ProxyServer およびProxyPort を設定します。認証タイプを指定するためにはProxyAuthScheme を設定します。

HTTP 認証を使う場合、さらにHTTP プロキシにProxyUser およびProxyPassword を設定します。

NTLM 認証を使う場合、Windows パスワードにProxyUser およびProxyPassword を設定します。Kerberos 認証には、これらを入力する必要があります。

SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシに接続する場合には、これをfalse に設定します。

ProxySSLType

ProxyServer プロキシへの接続時に使用するSSL タイプ。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この値は、AUTO、ALWAYS、NEVER、TUNNEL のいずれかです。有効な値は次のとおりです。


AUTO	デフォルト設定。URL がHTTPS URL の場合、Sync App は、TUNNEL オプションを使います。URL がHTTP URL の場合、コンポーネントはNEVER オプションを使います。
ALWAYS	接続は、常にSSL 有効となります。
NEVER	接続は、SSL 有効になりません。
TUNNEL	接続は、トンネリングプロキシを経由します。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。

ProxyExceptions

ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

解説

ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。

Sync App は、追加設定なしにデフォルトでシステムのプロキシ設定を使います。この接続のプロキシ例外を明示的に構成するには、ProxyAutoDetect をfalse に設定して、ProxyServer およびProxyPort を設定する必要があります。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

LogModules

ログファイルに含めるコアモジュール。

解説

指定された（';' で区切られた）モジュールのみがログファイルに含まれます。デフォルトではすべてのモジュールが含まれます。

概要はログページを参照してください。

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。
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.
TypeDetectionScheme	Determines how to determine the data types of columns.
RowScanDepth	The maximum number of rows to scan to look for the columns available in a table.
PrimaryKeyIdentifier	Set this property to control the name of the primary key.

Location

テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。

解説

Sync App のスキーマファイル（テーブルとビューの場合は.rsd ファイル、ストアドプロシージャの場合は.rsb ファイル）を含むディレクトリへのパス。このフォルダの場所は、実行ファイルの場所からの相対パスにすることができます。Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。

指定しない場合、デフォルトの場所は"%APPDATA%\\CData\\TableauCRM Data Provider\\Schema" となり、%APPDATA% はユーザーのコンフィギュレーションディレクトリに設定されます：

BrowsableSchemas

このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

解説

スキーマをデータベースからリストすると、負荷がかかる可能性があります。接続文字列でスキーマのリストを提供すると、パフォーマンスが向上します。

Tables

このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。

解説

テーブルを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でテーブルのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

Views

使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

解説

ビューを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でビューのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

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.

解説

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.

TypeDetectionScheme

Determines how to determine the data types of columns.

解説


None	Setting 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.
RowScan	Setting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.

RowScanDepth

The maximum number of rows to scan to look for the columns available in a table.

解説

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.

PrimaryKeyIdentifier

Set this property to control the name of the primary key.

解説

Determines the name of the primary key column. Set this to the primary key column of the table you are querying.

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
AsyncBulkOperation	A boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.
HandleAPINullIssues	A boolean indicating if the provider should handle known issues with Tableau CRM nulls.
MaxRows	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
Pagesize	Tableau CRM から返されるページあたりの結果の最大数。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UseDisplayNames	Boolean determining if the display names for the columns should be used instead of the API names.
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。
UseSimpleNames	テーブルとカラムに簡略名を使用するかどうかを決定するboolean。

AsyncBulkOperation

A boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.

解説

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.

HandleAPINullIssues

A boolean indicating if the provider should handle known issues with Tableau CRM nulls.

解説

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 Sync App 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.

MaxRows

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

解説

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

Other

これらの隠しプロパティは特定のユースケースでのみ使用されます。

解説

以下にリストされているプロパティは、特定のユースケースで使用可能です。通常のドライバーのユースケースおよび機能では、これらのプロパティは必要ありません。

複数のプロパティをセミコロン区切りリストで指定します。

統合およびフォーマット


DefaultColumnSize	データソースがメタデータにカラムの長さを提供しない場合に、文字列フィールドのデフォルトの長さを設定します。デフォルト値は2000です。
ConvertDateTimeToGMT	日時の値を、マシンのローカルタイムではなくGMT グリニッジ標準時に変換するかどうかを決定します。
RecordToFile=filename	基底のソケットデータ転送を指定のファイルに記録します。

Pagesize

Tableau CRM から返されるページあたりの結果の最大数。

解説

Pagesize プロパティは、Tableau CRM から返されるページあたりの結果の最大数に影響を与えます。より大きい値を設定すると、1ページあたりの消費メモリが増える代わりに、パフォーマンスが向上する場合があります。

PseudoColumns

このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。

解説

Entity Framework ではテーブルカラムでない疑似カラムに値を設定できないため、この設定はEntity Framework で特に便利です。この接続設定の値は、"Table1=Column1, Table1=Column2, Table2=Column3" の形式です。"*=*" のように"*" 文字を使用して、すべてのテーブルとすべてのカラムを含めることができます。

Timeout

タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。

解説

Timeout が0に設定されている場合は、操作がタイムアウトしません。処理が正常に完了するか、エラー状態になるまで実行されます。

Timeout の有効期限が切れても処理が完了していない場合は、Sync App は例外をスローします。

UseDisplayNames

Boolean determining if the display names for the columns should be used instead of the API names.

解説

Boolean determining if the display names for the columns should be used instead of the API names.

UserDefinedViews

カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

解説

ユーザー定義ビューは、UserDefinedViews.json というJSON 形式のコンフィギュレーションファイルで定義されています。Sync App は、このファイルで指定されたビューを自動的に検出します。

また、複数のビュー定義を持ち、UserDefinedViews 接続プロパティを使用して制御することも可能です。このプロパティを使用すると、指定されたビューのみがSync App によって検知されます。

このユーザー定義ビューのコンフィギュレーションファイルは、次のようにフォーマットされています。

各ルートエレメントはビューの名前を定義します。
各ルートエレメントには、query と呼ばれる子エレメントが含まれており、この子エレメントにはビューのカスタムSQL クエリが含まれています。

次に例を示します。

{
	"MyView": {
		"query": "SELECT * FROM Dataset_Opportunity WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

UserDefinedViews 接続プロパティを使用して、JSON コンフィギュレーションファイルの場所を指定します。次に例を示します。

"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"

UseSimpleNames

テーブルとカラムに簡略名を使用するかどうかを決定するboolean。

解説

Tableau CRM テーブルおよびカラムでは、通常のデータベースでは使うことが認められていない特殊記号・文字を名前に使うことができます。UseSimpleNames を使用すると、Sync App を従来のデータベースツールでより簡単に使用できるようになります。

UseSimpleNames をtrue に設定し、返されるテーブル名およびカラム名をシンプルにします。表示されるテーブル名およびカラム名においてアルファベット文字およびアンダースコアのみを有効とするネーミングスキームを強制します。英数字以外の文字はすべて、アンダースコアに変換されます。