Tableau CRM Analytics Connector for CData Sync

Build 25.0.9540
  • Tableau CRM Analytics
    • 接続の確立
      • カスタムOAuth アプリケーションの作成
      • データセットの選択
      • データセットの挿入
      • データセットのアップサート
      • データセットの削除
      • データセットのアップロード
    • 高度な機能
      • SSL の設定
      • ファイアウォールとプロキシ
    • データモデル
      • テーブル
        • Dataset_Account
        • Dataset_Activity
        • Dataset_Analytics
        • Dataset_Case
        • Dataset_DTC_Opportunity_SAMPLE
        • Dataset_Fashion
        • Dataset_OneMillion
        • Dataset_Opportunity
        • Dataset_Opportunity_products
        • Dataset_Pipeline_trending
        • Dataset_Plain_quota
        • Dataset_Product
        • Dataset_Quota
        • Dataset_User
        • Dataset_User_role
      • ビュー
        • Lens_Explore_Opportunities
        • Lens_Historical_Pipeline_By_Forecast
        • Lens_Historical_Pipeline_By_Stage
        • Lens_Historical_Pipeline_Forecast_By_Quarter
        • Lens_Historical_Pipeline_Stage_By_Quarter
        • Lens_Sales_Stage_Details
        • Lens_X100KLens
      • ストアドプロシージャ
        • CreateMetadataFile
        • CreateSchema
        • GetJobStatus
        • GetOAuthAccessToken
        • GetOAuthAuthorizationURL
        • RefreshOAuthAccessToken
        • UploadCSVToDataSet
    • 接続文字列オプション
      • Authentication
        • AuthScheme
        • InstanceURL
        • Subdomain
        • UseSandbox
      • Connection
        • ApiVersion
      • OAuth
        • OAuthClientId
        • OAuthClientSecret
      • JWT OAuth
        • OAuthJWTCert
        • OAuthJWTCertType
        • OAuthJWTCertPassword
        • OAuthJWTCertSubject
        • OAuthJWTIssuer
        • OAuthJWTSubject
      • SSL
        • SSLServerCert
      • Firewall
        • FirewallType
        • FirewallServer
        • FirewallPort
        • FirewallUser
        • FirewallPassword
      • Proxy
        • ProxyAutoDetect
        • ProxyServer
        • ProxyPort
        • ProxyAuthScheme
        • ProxyUser
        • ProxyPassword
        • ProxySSLType
        • ProxyExceptions
      • Logging
        • LogModules
      • Schema
        • Location
        • BrowsableSchemas
        • Tables
        • Views
        • MetadataFilesLocation
        • TypeDetectionScheme
        • RowScanDepth
        • PrimaryKeyIdentifier
      • Miscellaneous
        • AsyncBulkOperation
        • HandleAPINullIssues
        • MaxRows
        • Other
        • Pagesize
        • PseudoColumns
        • QueryLanguage
        • QueryPassthrough
        • Timeout
        • UseDisplayNames
        • UserDefinedViews
        • UseSimpleNames
        • ValidationMode
    • Third Party Copyrights

Tableau CRM Analytics Connector for CData Sync

概要

CData Sync App は、Tableau CRM Analytics データをデータベース、データレイク、またはデータウェアハウスに継続的にパイプライン化する簡単な方法を提供し、分析、レポート、AI、および機械学習で簡単に利用できるようにします。

Tableau CRM コネクタはCData Sync アプリケーションから使用可能で、Tableau CRM からデータを取得して、サポートされている任意の同期先に移動できます。

Tableau CRM バージョンサポート

Sync App は、Tableau CRM REST API を使用してTableau CRM データセットとレンズをリレーショナルデータベースのテーブルとしてモデル化します。

Tableau CRM Analytics Connector for CData Sync

接続の確立

Tableau CRM への接続を追加

Tableau CRM への接続を追加するには：

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

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Tableau CRM への接続

OAuthJWT

Tableau CRM はOAuth 2 認証標準を利用しています。Tableau CRM にアプリケーションを登録し、OAuthClientId およびOAuthClientSecret を取得する必要があります。詳しくは、カスタムOAuth アプリケーションの作成 を参照してください。

AuthScheme をOAuthJWT に設定します。

OAuthJWT コンシューマーキーの取得

OAuthJWT コンシューマーキーを取得するには：
  1. Salesforce.com にログインします。
  2. ［設定］で［クイック検索］ボックスにApps を入力し、リンクをクリックしてアプリを作成します。表示されたページの接続アプリケーションセクションで、新規をクリックします。
  3. ユーザーがアプリケーションにログイン認証をする際に表示されるアプリケーション名を入力します。連絡先E メールアドレスも入力します。
  4. OAuth 設定の有効化をクリックし、コールバックURL ボックスに値を入力します。この値は必要に応じて接続アプリケーションを作成する場合にのみ設定します。この種類の認証には、実際には必要ありません。 Callback URL は次の形式になります： 
    http://localhost:8019/src/oauthCallback.rst
  5. デジタル署名を使用を有効にします。
  6. 証明書をアップロードします。
  7. アプリがユーザーに要求するアクセス許可の範囲を選択します。
  8. アプリケーション名をクリックしてアプリケーションの情報ページを開きます。OAuth コンシューマーキーが表示されます。

OAuth アプリケーション作成後、次の接続プロパティを設定します。

  • AuthScheme： OAuthJWT。
  • InitiateOAuth： GETANDREFRESH。
  • OAuthJWTCert：JWT 証明書のストア。
  • OAuthJWTPassword：JWT 証明書ストアのパスワード。
  • OAuthJWTIssuer：OAuth クライアントID。
  • OAuthJWTCertType：OAuthJWTCert で指定された証明書ストアの種類。

Note： このフローではリフレッシュトークンは発行されません。

OAuth

AuthScheme をOAuth に設定します。

以下のサブセクションでは、3つの認証フローでのTableau CRM への認証について詳しく説明します。

  • デスクトップ：ユーザーのローカルマシン上でのサーバーへの接続で、テストやプロトタイピングによく使用されます。
  • Web：共有ウェブサイト経由でデータにアクセスします。
  • ヘッドレスサーバー：他のコンピュータやそのユーザーにサービスを提供する専用コンピュータで、モニタやキーボードなしで動作するように構成されています。

カスタムOAuth アプリケーションの作成については、カスタムOAuth アプリケーションの作成 を参照してください。 Tableau CRM で利用可能な接続文字列プロパティの全リストは、Connection を参照してください。

Note： Salesforce でセッションタイムアウトを設定するには、設定 -> 管理 -> セキュリティのコントロール -> セッション設定に移動します。

OAuth アクセストークンの自動リフレッシュ：

Sync App がOAuth アクセストークンを自動的にリフレッシュするようにするには、次のように設定します。

  1. はじめてデータに接続する前に、次の接続プロパティを設定します。
    • InitiateOAuth： REFRESH。
    • OAuthClientId：アプリケーション設定のクライアントId。
    • OAuthClientSecret：アプリケーション設定のクライアントシークレット。
    • OAuthAccessToken：GetOAuthAccessToken によって返されたアクセストークン。
    • OAuthSettingsLocation：Sync App がOAuth 値を保存する場所のパス。これは接続間で維持されます。
  2. その後のデータ接続では、以下を設定します。
    • InitiateOAuth
    • OAuthSettingsLocation

OAuth アクセストークンの手動リフレッシュ：

OAuth アクセストークンを手動でリフレッシュするために必要な唯一の値は、OAuth リフレッシュトークンです。

  1. ExpiresIn 期間（GetOAuthAccessToken が返す）が経過した後にOAuthAccessToken を手動でリフレッシュするには、RefreshOAuthAccessToken ストアドプロシージャを呼び出します。
  2. 次の接続プロパティを設定します。

    • OAuthClientId：アプリケーション設定のクライアントId。
    • OAuthClientSecret：アプリケーション設定のクライアントシークレット。

  3. RefreshOAuthAccessToken を呼び出し、OAuthRefreshToken にGetOAuthAccessToken によって返されたOAuth リフレッシュトークンを設定します。
  4. 新しいトークンが取得できたら、OAuthAccessToken プロパティにRefreshOAuthAccessToken によって返された値を設定します。これで新規接続が開かれます。

OAuth リフレッシュトークンを保存し、OAuth アクセストークンの有効期限が切れた後に手動でリフレッシュできるようにします。

Tableau CRM Analytics Connector for CData Sync

カスタムOAuth アプリケーションの作成

カスタムOAuth アプリケーションの作成

以下の手順では、管理コンソールにカスタムOAuth アプリケーションを登録し、OAuth クライアントクレデンシャルであるコンシューマーキーとコンシューマーシークレットを取得します。

  1. 設定にアクセスします。
    （デスクトップアプリケーションから接続する場合は、Salesforce.com にログインしてユーザー名をクリックすると、設定にアクセスできます。）
  2. 新しいアプリケーションを開きます。
    • 組織がSalesforce Lightning Experience UI を使用している場合：
      1. ［クイック検索］ボックスに"App" を入力します。
      2. ［アプリケーションマネージャ］（接続アプリケーションの管理では ありません）を選択します。
      3. ［新規接続アプリケーション］をクリックします。
    • 組織がSalesforce Classic UI を使用している場合：
      1. ［クイック検索］ボックスに"Apps" を入力します。
      2. ［ビルド］または［作成］でアプリ を選択します。
      3. ［接続アプリケーション］で［新規］をクリックします。
  3. ユーザーがアプリケーションにログイン認証をする際に表示されるアプリケーション名を入力します。また、連絡先のE メールアドレスも入力します。
  4. ［OAuth 設定の有効化］を選択します。
  5. コールバックURL ボックスに値を入力します。
    • デスクトップアプリケーションの場合は、Callback URL をhttp://localhost:33333 か 任意の別のポート番号に設定してください。
    • Web アプリケーションの場合は、Callback URL をユーザーがアプリケーションを認可した後に表示したいWeb サイトページに設定します。
  6. 次のOAuth スコープを割り当てます。
    • Wave データへのアクセスと管理（wave_api）
    • データへのアクセスと管理（api）
    • ユーザーに代わっていつでも要求を実行（refresh_token, offline_token）

アプリケーションが作成されたら、新しいアプリケーションの名前をクリックします。管理コンソールは、OAuth クライアントクレデンシャル、コンシューマーキーおよびコンシューマーシークレットを表示します。 後で使うために、この情報を記録しておきます。

Tableau CRM Analytics Connector for CData Sync

データセットの選択

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.

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

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

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

Tableau CRM Analytics Connector for CData Sync

データセットの挿入

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:
  1. In Tableau CRM, go to the home page, click Create, and then choose Dataset.
  2. Select CSV file to upload and click Next.
  3. From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
  4. For more info on Metadata format refer to this guide: https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_ext_data_format.pdf

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

Inserting data

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

INSERT INTO SELECT (Bulk inserting)

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

Tableau CRM Analytics Connector for CData Sync

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

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:
  1. In Tableau CRM, go to the home page, click Create, and then choose Dataset.
  2. Select CSV file to upload and click Next.
  3. From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
  4. For more info on Metadata format refer to this guide: https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_ext_data_format.pdf

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

Upserting data

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

UPSERT INTO SELECT (Bulk upserting)

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

Tableau CRM Analytics Connector for CData Sync

データセットの削除

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:
  1. In Tableau CRM, go to the home page, click Create, and then choose Dataset.
  2. Select CSV file to upload and click Next.
  3. From new opened window download the JSON metadata schema file by clicking Download File in dropdown list at Data Schema File section.
  4. For more info on Metadata format refer to this guide: https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_ext_data_format.pdf

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

Deleting data

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

DELETE FROM EXISTS SELECT (Bulk deleting)

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

Tableau CRM Analytics Connector for CData Sync

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

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 Analytics Connector for CData Sync

高度な機能

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

ユーザー定義ビュー

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

SSL の設定

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

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

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

クエリ処理

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

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

ログ

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

Tableau CRM Analytics Connector for CData Sync

SSL の設定

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

Tableau CRM Analytics Connector for CData Sync

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

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

  • ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
  • ProxyPort：プロキシサーバーが起動しているTCP ポート。
  • ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
  • ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
  • ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

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

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

Tableau CRM Analytics Connector for CData Sync

データモデル

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 内で処理します。

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

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

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

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

スキーマのカスタマイズ

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

  • レポートされたカラムとデータ型を変更。
  • データセットまたはレンズに対して実行される操作を変更。
スキーマをカスタマイズするには、CreateSchema ストアドプロシージャを呼び出します。ストアドプロシージャは、動的なスキーマを静的なコンフィギュレーションファイルに保存します。スキーマファイルはシンプルな形式となっており、カスタマイズは簡単です。

ストアドプロシージャ

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

Tableau CRM Analytics Connector for CData Sync

テーブル

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

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Tableau CRM の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらずSync App の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにTableau CRM から関連するレスポンスデータを返します。

Tableau CRM Analytics Connector for CData Sync ストアドプロシージャ

Name Description
CreateMetadataFile Creates a metadata file for the specified dataset.
GetJobStatus Create a dataset from a CSV file.

Tableau CRM Analytics Connector for CData Sync

CreateMetadataFile

Creates a metadata file for the specified dataset.

Input

Name Type Description
Charset String The charset of the table.

デフォルト値はUTF-8です。

FieldsDelimitedBy String The delimiter of the table columns.

デフォルト値は,です。

LinesTerminatedBy String The delimiter of the table lines.

デフォルト値は\r\nです。

TableName String The name of the table or view. Ex : 'Dataset_Title
FileName String The full file path and name of the metadata file to generate. Ex : 'C:\\Users\\User\\Desktop\\SFTableauCRM\\DataSetTest.json'

Result Set Columns

Name Type Description
Result String Returns Success or Failure.
FileData String File data that will be outputted encoded in Base64 if the FileName and FileStream inputs are not set.

Tableau CRM Analytics Connector for CData Sync

CreateSchema

Creates a schema file for the specified table or view.

CreateSchema

データモデル内の既存のテーブルまたはビューからローカルスキーマファイル（.rsd）を作成します。

スキーマファイルは、このプロシージャが実行されると、Location 接続プロパティで設定されたディレクトリに作成されます。ファイルを編集してカラムを含めたり除外したり、カラム名を変更したり、カラムのデータ型を変更したりできます。

Sync App はLocation を確認し、.rsd ファイルの名前がデータモデルのテーブルまたはビューに一致するかどうかを判断します。重複がある場合、スキーマファイルはデータモデル内のこのテーブルのデフォルトインスタンスよりも優先されます。既存のテーブルまたはビューに一致しないスキーマファイルがLocation に存在する場合、新しいテーブルまたはビューのエントリがSync App のデータモデルに追加されます。

Input

Name Type Description
TableName String The name of the table or view.
FileName String The full file path and name of the schema to generate. Ex : 'C:\\Users\\User\\Desktop\\SFTableauCRM\\DataSetTest.rsd'

Result Set Columns

Name Type Description
Result String Returns Success or Failure.
FileData String File data that will be outputted encoded in Base64 if the FileName and FileStream inputs are not set.

Tableau CRM Analytics Connector for CData Sync

GetJobStatus

Create a dataset from a CSV file.

Input

Name Type Description
JobId String The id of the job.

Result Set Columns

Name Type Description
Status String Indicates the status of the job.
StatusMessage String The message of the status. Empty unless something went wrong with the upload.

Tableau CRM Analytics Connector for CData Sync

GetOAuthAccessToken

Gets the OAuth access token from Tableau CRM.

Input

Name Type Description
AuthMode String The type of authentication mode to use. The allowed values are APP, WEB.
Verifier String The verifier token returned by Tableau CRM after using the URL obtained with GetOAuthAuthorizationURL. Required for only the Web AuthMode.
CallbackUrl String The URL the user will be redirected to after authorizing your application.
State String Indicates any state which may be useful to your application upon receipt of the response. Your application receives the same value it sent, as this parameter makes a round-trip to the TableauCRM authorization server and back. Uses include redirecting the user to the correct resource in your site, using nonces, and mitigating cross-site request forgery.
PKCEVerifier String The PKCEVerifier returned by GetOAuthAuthorizationURL. Only required when AuthScheme=OAuthPKCE.

Result Set Columns

Name Type Description
OAuthAccessToken String The authentication token returned from Tableau CRM.
OAuthRefreshToken String A token that may be used to obtain a new access token.
ExpiresIn String The remaining lifetime for the access token in seconds.
InstanceUrl String The URL of the Salesforce instance.

Tableau CRM Analytics Connector for CData Sync

GetOAuthAuthorizationURL

Gets the Tableau CRM authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to Tableau CRM.

Input

Name Type Description
CallbackUrl String The URL that the data provider will return to after the user has authorized your app.
State String Indicates any state which may be useful to your application upon receipt of the response. Your application receives the same value it sent, as this parameter makes a round-trip to the TableauCRM authorization server and back. Uses include redirecting the user to the correct resource in your site, using nonces, and mitigating cross-site request forgery.

Result Set Columns

Name Type Description
URL String The URL to be entered into a Web browser to obtain the verifier token and authorize the data provider with.
PKCEVerifier String A random value used as input for GetOAuthAccessToken. Only provided when AuthScheme=OAuthPKCE.

Tableau CRM Analytics Connector for CData Sync

RefreshOAuthAccessToken

Refreshes the OAuth access token used for authentication with Tableau CRM.

Input

Name Type Description
OAuthRefreshToken String The old token to be refreshed.

Result Set Columns

Name Type Description
OAuthAccessToken String The authentication token returned from Tableau CRM.
ExpiresIn String The remaining lifetime on the access token.
SalesforceInstanceUrl String The instance URL being used by the app.

Tableau CRM Analytics Connector for CData Sync

UploadCSVToDataSet

Create a dataset from a CSV file.

Input

Name Type Description
DataSetName String The name of the dataset you want to create or update.
CSVFileLocation String The location of the CSV file you want to upload.
CSVContent String The Base64 encoded content of the CSV file you want to upload. If CSVFileLocation is specified you should not use this input.
Operation String The operation you want to use when you're loading data into the dataset. 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.

使用できる値は次のとおりです。Overwrite, Append, Delete, Upsert

デフォルト値はAppendです。

MetadataFilesLocation String The location of the metadata 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.
AppName String 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 String Set this to the actual charset of the CSV file you want to upload. You do not need to set this parameter if the charset is UTF-8.

Result Set Columns

Name Type Description
Id String The Id of the upload job.
Success Boolean Indicates if the data was upload to Salesforce.

Tableau CRM Analytics Connector for CData Sync

接続文字列オプション

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

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

Authentication

プロパティ説明
AuthSchemeThe type of authentication to use when connecting to Tableau CRM.
InstanceURLThe URL of the Salesforce instance you want to use.
SubdomainThe instance of the Tableau CRM API used.
UseSandboxA boolean determining if the connection should be made to a Tableau CRM sandbox account.

Connection

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

OAuth

プロパティ説明
OAuthClientIdカスタムOAuth アプリケーションに割り当てられたクライアントID（コンシューマーキーとも呼ばれます）を指定します。このID は、認証時にOAuth 認可サーバーにアプリケーションを識別させるために必要です。
OAuthClientSecretカスタムOAuth アプリケーションに割り当てられたクライアントシークレットを指定します。この機密情報は、OAuth 認可サーバーに対してアプリケーションを認証するために使用されます。（カスタムOAuth アプリケーションのみ）

JWT OAuth

プロパティ説明
OAuthJWTCertクライアント証明書のJWT 証明書ストアの名前を指定します。
OAuthJWTCertTypeJWT 証明書を格納しているキーストアの種類を指定します。
OAuthJWTCertPasswordパスワードで保護された証明書ストアにアクセスするために使用されるOAuth JWT 証明書のパスワードを指定します。証明書ストアがパスワードを必要としない場合は、このプロパティを空白のままにします。
OAuthJWTCertSubjectストアで一致する証明書を検索するために使用される、OAuth JWT 証明書のサブジェクトを指定します。部分一致と、先頭の証明書を選択するためのワイルドカード '*' をサポートします。
OAuthJWTIssuerJava Web Token の発行者。
OAuthJWTSubjectアプリケーションからデリゲートアクセスの要求対象となるユーザーサブジェクト。

SSL

プロパティ説明
SSLServerCertTLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

Firewall

プロパティ説明
FirewallTypeprovider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。
FirewallServerファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。
FirewallPortプロキシベースのファイアウォールで使用するTCP ポートを指定します。
FirewallUserプロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。
FirewallPasswordプロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

Proxy

プロパティ説明
ProxyAutoDetectprovider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。
ProxyServerHTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレスを指定します。
ProxyPortクライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバーのTCP ポートを指定します。
ProxyAuthSchemeProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。
ProxyUserProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名を提供します。
ProxyPasswordProxyUser 接続プロパティで指定されたユーザーのパスワードを指定します。
ProxySSLTypeProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプを指定します。
ProxyExceptionsProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリストを指定します。

Logging

プロパティ説明
LogModulesログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

Schema

プロパティ説明
Locationテーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。
BrowsableSchemasレポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tablesレポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。
Viewsレポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。
MetadataFilesLocationThe location of the metadata files. Set this to the path of the folder where your metadata files are stored, or the specific path of your file.
TypeDetectionSchemeDetermines how to determine the data types of columns.
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
PrimaryKeyIdentifierSet this property to control the name of the primary key.

Miscellaneous

プロパティ説明
AsyncBulkOperationA boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.
HandleAPINullIssuesA boolean indicating if the provider should handle known issues with Tableau CRM nulls.
MaxRows集計やGROUP BY を含まないクエリで返される最大行数を指定します。
Other特定の問題に対処するため、特殊なシナリオ向けの高度な接続プロパティを指定します。このプロパティは、サポートチームの指示がある場合にのみ使用してください。
Pagesizeprovider がTableau CRM にデータをリクエストするときに返す、ページあたりの最大レコード数を指定します。
PseudoColumnsテーブルカラムとして公開する擬似カラムを、'TableName=ColumnName;TableName=ColumnName' の形式の文字列で指定します。
QueryLanguageSpecifies the query language to use with Tableau CRM.
QueryPassthroughこのオプションは、クエリをTableau CRM サーバーにas-is で渡します。
Timeoutprovider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。
UseDisplayNamesBoolean determining if the display names for the columns should be used instead of the API names.
UserDefinedViewsカスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。
UseSimpleNamesテーブルとカラムに簡略名を使用するかどうかを指定します。
ValidationModeThe validation mode to use during schema discovery. Options are None, Basic, and Enhanced (default: Basic).
Tableau CRM Analytics Connector for CData Sync

Authentication

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

プロパティ説明
AuthSchemeThe type of authentication to use when connecting to Tableau CRM.
InstanceURLThe URL of the Salesforce instance you want to use.
SubdomainThe instance of the Tableau CRM API used.
UseSandboxA boolean determining if the connection should be made to a Tableau CRM sandbox account.
Tableau CRM Analytics Connector for CData Sync

AuthScheme

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

解説

  • OAuth: Set this to perform OAuth authentication.
  • OAuthPKCE: Uses OAuth2 with the authorization code grant type and PKCE extension. OAuthClientId is the credential.
  • OAuthJWT: Set this to perform OAuth authentication with a certificate.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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

Tableau CRM Analytics Connector for CData Sync

Connection

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

プロパティ説明
ApiVersionThe API version being used. This can be specified to access a new version of the API once it is released.
Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

OAuth

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

プロパティ説明
OAuthClientIdカスタムOAuth アプリケーションに割り当てられたクライアントID（コンシューマーキーとも呼ばれます）を指定します。このID は、認証時にOAuth 認可サーバーにアプリケーションを識別させるために必要です。
OAuthClientSecretカスタムOAuth アプリケーションに割り当てられたクライアントシークレットを指定します。この機密情報は、OAuth 認可サーバーに対してアプリケーションを認証するために使用されます。（カスタムOAuth アプリケーションのみ）
Tableau CRM Analytics Connector for CData Sync

OAuthClientId

カスタムOAuth アプリケーションに割り当てられたクライアントID（コンシューマーキーとも呼ばれます）を指定します。このID は、認証時にOAuth 認可サーバーにアプリケーションを識別させるために必要です。

解説

このプロパティは2つのケースで必要となります：

  • カスタムOAuth アプリケーションを使用する場合。たとえば、Web ベースの認証フロー、サービスベースの認証、またはアプリケーションの登録が必要な証明書ベースのフローなどが該当します。
  • ドライバーが埋め込みOAuth 資格情報を提供しない場合。

（ドライバーが埋め込みOAuth 資格情報を提供する場合、この値はすでにSync App によって設定されており、手動で入力する必要がないことがあります。）

OAuthClientId は、認証付きの接続を構成する際に、OAuthClientSecret やOAuthSettingsLocation などの他のOAuth 関連プロパティと一緒に使用されるのが一般的です。

OAuthClientId は、ユーザーがOAuth 経由で認証を行う前に設定する必要がある、主要な接続パラメータの1つです。 この値は、通常、ID プロバイダーのアプリケーション登録設定で確認できます。 Client ID、Application ID、Consumer Key などとラベル付けされた項目を探してください。

クライアントID は、クライアントシークレットのような機密情報とは見なされませんが、アプリケーションの識別情報の一部であるため、慎重に取り扱う必要があります。公開リポジトリや共有設定ファイルでこの値を露出させないようにしてください。

接続設定時にこのプロパティを使用する方法の詳細については、接続の確立 を参照してください。

Tableau CRM Analytics Connector for CData Sync

OAuthClientSecret

カスタムOAuth アプリケーションに割り当てられたクライアントシークレットを指定します。この機密情報は、OAuth 認可サーバーに対してアプリケーションを認証するために使用されます。（カスタムOAuth アプリケーションのみ）

解説

このプロパティ（アプリケーションシークレットまたはコンシューマシークレットとも呼ばれます）は、安全なクライアント認証を必要とするすべてのフローでカスタムOAuth アプリケーションを使用する場合に必要です。たとえば、Web ベースのOAuth、サービスベースの接続、証明書ベースの認可フローなどが該当します。 組み込みOAuth アプリケーションを使用する場合は必要ありません。

クライアントシークレットは、OAuth フローのトークン交換ステップで使用されます。このステップでは、ドライバーが認可サーバーにアクセストークンを要求します。 この値が欠落しているか正しくない場合、認証はinvalid_client またはunauthorized_client エラーで失敗します。

OAuthClientSecret は、ユーザーがOAuth 経由で認証を行う前に設定する必要がある、主要な接続パラメータの1つです。この値は、OAuth アプリケーションを登録する際にID プロバイダーから取得できます。

Notes：

  • この値は安全に保管し、公開リポジトリやスクリプト、安全でない環境では決して公開しないようにしてください。
  • クライアントシークレットは、一定期間が経過すると有効期限が切れる場合もあります。 アクセスを中断させないために、有効期限を常に監視し、必要に応じてシークレットをローテーションするようにしてください。

接続設定時にこのプロパティを使用する方法の詳細については、接続の確立 を参照してください。

Tableau CRM Analytics Connector for CData Sync

JWT OAuth

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

プロパティ説明
OAuthJWTCertクライアント証明書のJWT 証明書ストアの名前を指定します。
OAuthJWTCertTypeJWT 証明書を格納しているキーストアの種類を指定します。
OAuthJWTCertPasswordパスワードで保護された証明書ストアにアクセスするために使用されるOAuth JWT 証明書のパスワードを指定します。証明書ストアがパスワードを必要としない場合は、このプロパティを空白のままにします。
OAuthJWTCertSubjectストアで一致する証明書を検索するために使用される、OAuth JWT 証明書のサブジェクトを指定します。部分一致と、先頭の証明書を選択するためのワイルドカード '*' をサポートします。
OAuthJWTIssuerJava Web Token の発行者。
OAuthJWTSubjectアプリケーションからデリゲートアクセスの要求対象となるユーザーサブジェクト。
Tableau CRM Analytics Connector for CData Sync

OAuthJWTCert

クライアント証明書のJWT 証明書ストアの名前を指定します。

解説

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

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

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

注記

  • Windows の共通のユーザーとシステム証明書ストアは以下のとおりです。
    • MY：個人証明書と関連付けられた秘密キーを 格納している証明書ストア。
    • CA：証明機関の証明書。
    • ROOT：ルート証明書。
    • SPC：ソフトウェア発行元証明書。
  • Javaでは、証明書ストアは通常、証明書および 任意の秘密キーを含むファイルです。
  • 証明書ストアの種類がPFXFile の場合は、 このプロパティにファイル名を設定します。
  • PFXBlob の場合は、このプロパティをPFX ファイルのバイナリコンテンツ（例えば、PKCS12証明書ストア）に設定する必要があります。

Tableau CRM Analytics Connector for CData Sync

OAuthJWTCertType

JWT 証明書を格納しているキーストアの種類を指定します。

解説

値説明注記
USER現在のユーザーが所有する証明書ストア。 Windows のみ使用可能です。
MACHINEマシンストア。Java やその他の非Windows 環境では使用できません。
PFXFILE証明書を含むPFX（PKCS12）ファイル。
PFXBLOBPFX（PKCS12）形式の証明書ストアをbase-64 でエンコードした文字列。
JKSFILE証明書を含むJava キーストア（JKS）ファイル。Java 専用。
JKSBLOBJava キーストア（JKS）形式の証明書ストアをbase-64 でエンコードした文字列。 Java 専用。
PEMKEY_FILE秘密鍵とオプションの証明書を含むPEM でエンコードされたファイル。
PEMKEY_BLOB秘密鍵とオプションの証明書をbase-64 でエンコードした文字列。
PUBLIC_KEY_FILEPEM またはDER でエンコードされた公開鍵証明書を含むファイル。
PUBLIC_KEY_BLOBPEM またはDER でエンコードされた公開鍵証明書をbase-64 でエンコードした文字列。
SSHPUBLIC_KEY_FILESSH 形式の公開鍵を含むファイル。
SSHPUBLIC_KEY_BLOBSSH 形式の公開鍵ををbase-64 でエンコードした文字列。
P7BFILE証明書を含むPKCS7 ファイル。
PPKFILEPuTTY 秘密キー（PPK）を含むファイル。
XMLFILEXML 形式の証明書を含むファイル。
XMLBLOBXML 形式の証明書を含む文字列。
BCFKSFILEBouncy Castle キーストアを含むファイル。
BCFKSBLOBBouncy Castle キーストアを含む文字列（base-64エンコード）。

Tableau CRM Analytics Connector for CData Sync

OAuthJWTCertPassword

パスワードで保護された証明書ストアにアクセスするために使用されるOAuth JWT 証明書のパスワードを指定します。証明書ストアがパスワードを必要としない場合は、このプロパティを空白のままにします。

解説

このプロパティは、パスワードで保護された証明書ストアを開くために必要なパスワードを指定します。 パスワードが必要かどうかを判断するには、ご利用の証明書ストアのドキュメントまたは設定を参照してください。

Tableau CRM Analytics Connector for CData Sync

OAuthJWTCertSubject

ストアで一致する証明書を検索するために使用される、OAuth JWT 証明書のサブジェクトを指定します。部分一致と、先頭の証明書を選択するためのワイルドカード '*' をサポートします。

解説

このプロパティの値は、ストアで一致する証明書を検索するために使用されます。検索プロセスは以下のように動作します。

  • サブジェクトに完全に一致する証明書が見つかれば、該当する証明書が選択されます。
  • 完全に一致するものがない場合、ストアは、サブジェクトがプロパティ値を含む証明書を検索します。
  • 一致する証明書がない場合、証明書は選択されません。

値を '*' に設定すると、ストアの先頭の証明書が自動的に選択されます。 証明書のサブジェクトは識別名フィールドおよび値のカンマ区切りのリストです。 例：CN=www.server.com, OU=test, C=US, [email protected]。

一般的なフィールドには以下のものが含まれます。

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

フィールド値にカンマが含まれる場合は、引用符で囲んでください。例："O=ACME, Inc."。

Tableau CRM Analytics Connector for CData Sync

OAuthJWTIssuer

Java Web Token の発行者。

解説

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

Tableau CRM Analytics Connector for CData Sync

OAuthJWTSubject

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

解説

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

Tableau CRM Analytics Connector for CData Sync

SSL

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

プロパティ説明
SSLServerCertTLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。
Tableau CRM Analytics Connector for CData Sync

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

Note：'*' を使用してすべての証明書を受け入れるように指定することも可能ですが、セキュリティ上の懸念があるため推奨されません。

Tableau CRM Analytics Connector for CData Sync

Firewall

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

プロパティ説明
FirewallTypeprovider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。
FirewallServerファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。
FirewallPortプロキシベースのファイアウォールで使用するTCP ポートを指定します。
FirewallUserプロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。
FirewallPasswordプロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。
Tableau CRM Analytics Connector for CData Sync

FirewallType

provider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。 プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Note：デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し、次のプロキシタイプのいずれかに接続するには、ProxyAutoDetect をfalse に設定します。

次の表は、サポートされている各プロトコルのポート番号情報です。

プロトコル デフォルトポート 説明
TUNNEL 80 Sync App がTableau CRM への接続を開くポート。トラフィックはこの場所のプロキシを経由して行き来します。
SOCKS4 1080 Sync App がTableau CRM への接続を開くポート。SOCKS 4 は次にFirewallUser 値をプロキシに渡し、接続リクエストが許容されるかどうかを決定します。
SOCKS5 1080 Sync App がTableau CRM にデータを送信するポート。SOCKS 5 プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

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

Tableau CRM Analytics Connector for CData Sync

FirewallServer

ファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。 プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Tableau CRM Analytics Connector for CData Sync

FirewallPort

プロキシベースのファイアウォールで使用するTCP ポートを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。 プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Tableau CRM Analytics Connector for CData Sync

FirewallUser

プロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。 プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Tableau CRM Analytics Connector for CData Sync

FirewallPassword

プロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。 プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Tableau CRM Analytics Connector for CData Sync

Proxy

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

プロパティ説明
ProxyAutoDetectprovider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。
ProxyServerHTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレスを指定します。
ProxyPortクライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバーのTCP ポートを指定します。
ProxyAuthSchemeProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。
ProxyUserProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名を提供します。
ProxyPasswordProxyUser 接続プロパティで指定されたユーザーのパスワードを指定します。
ProxySSLTypeProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプを指定します。
ProxyExceptionsProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリストを指定します。
Tableau CRM Analytics Connector for CData Sync

ProxyAutoDetect

provider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。

解説

この接続プロパティをTrue に設定すると、Sync App は既存のプロキシサーバー構成についてシステムプロキシ設定をチェックします（プロキシサーバーの詳細を手動で入力する必要はありません）。

この接続プロパティは他のプロキシ設定より優先されます。特定のプロキシサーバーに接続するためにSync App を構成する場合は、ProxyAutoDetect をFalse に設定します。

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

Tableau CRM Analytics Connector for CData Sync

ProxyServer

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

解説

ProxyAutoDetect がFalse に設定されている場合、Sync App はこの接続プロパティで指定されたプロキシサーバーを通じてのみHTTP トラフィックをルーティングします。

ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムプロキシ設定で指定されたプロキシサーバーを介してHTTP トラフィックをルーティングします。

Tableau CRM Analytics Connector for CData Sync

ProxyPort

クライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバーのTCP ポートを指定します。

解説

ProxyAutoDetect がFalse に設定されている場合、Sync App はこの接続プロパティで指定されたProxyServer ポートを通じてのみHTTP トラフィックをルーティングします。

ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムプロキシ設定で指定されたプロキシサーバーポートを介してHTTP トラフィックをルーティングします。

その他のプロキシタイプについては、FirewallType を参照してください。

Tableau CRM Analytics Connector for CData Sync

ProxyAuthScheme

ProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。

解説

サポートされる認証の種類：

  • BASIC：Sync App はHTTP Basic 認証を行います。
  • DIGEST：Sync App はHTTP ダイジェスト認証を行います。
  • NTLM：Sync App はNTLM トークンを取得します。
  • NEGOTIATE： Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKerberos トークンを取得します。
  • NONE：ProxyServer が認証を必要としないことを示します。

NONE 以外のすべての値については、ProxyUser およびProxyPassword 接続プロパティも設定する必要があります。

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

Tableau CRM Analytics Connector for CData Sync

ProxyUser

ProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名を提供します。

解説

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

ProxyAuthScheme で利用可能な認証タイプを1つ選択した後、このプロパティを以下のように設定します。

ProxyAuthScheme の値 ProxyUser に設定する値
BASIC プロキシサーバーに登録されているユーザーのユーザー名。
DIGEST プロキシサーバーに登録されているユーザーのユーザー名。
NEGOTIATE プロキシサーバーが属するドメインまたは信頼されたドメイン内の有効なユーザーであるWindows ユーザーのユーザー名。user@domain またはdomain\user の形式で指定。
NTLM プロキシサーバーが属するドメインまたは信頼されたドメイン内の有効なユーザーであるWindows ユーザーのユーザー名。user@domain またはdomain\user の形式で指定。
NONE ProxyPassword 接続プロパティは設定しないでください。

Note：Sync App は、ProxyAutoDetect がFalse に設定されている場合にのみ、このユーザー名を使用します。 ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムのプロキシ設定で指定されているユーザー名を使用します。

Tableau CRM Analytics Connector for CData Sync

ProxyPassword

ProxyUser 接続プロパティで指定されたユーザーのパスワードを指定します。

解説

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

ProxyAuthScheme で利用可能な認証タイプを1つ選択した後、このプロパティを以下のように設定します。

ProxyAuthScheme の値 ProxyPassword に設定する値
BASIC ProxyUser で指定したプロキシサーバーユーザーに紐付けられたパスワード。
DIGEST ProxyUser で指定したプロキシサーバーユーザーに紐付けられたパスワード。
NEGOTIATE ProxyUser で指定したWindows ユーザーアカウントに紐付けられたパスワード。
NTLM ProxyUser で指定したWindows ユーザーアカウントに紐付けられたパスワード。
NONE ProxyPassword 接続プロパティは設定しないでください。

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

Note：Sync App は、ProxyAutoDetect がFalse に設定されている場合にのみ、このパスワードを使用します。 ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムのプロキシ設定で指定されているパスワードを使用します。

Tableau CRM Analytics Connector for CData Sync

ProxySSLType

ProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプを指定します。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この接続プロパティには、以下の値を設定できます。

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

Tableau CRM Analytics Connector for CData Sync

ProxyExceptions

ProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリストを指定します。

解説

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

Note：Sync App はデフォルトでシステムプロキシ設定を使用するため、それ以上の設定は必要ありません。 この接続にプロキシ例外を明示的に設定する場合は、ProxyAutoDetect をFalse に設定します。

Tableau CRM Analytics Connector for CData Sync

Logging

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

プロパティ説明
LogModulesログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。
Tableau CRM Analytics Connector for CData Sync

LogModules

ログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

解説

Sync App は、実行する各操作の詳細を Logfile 接続プロパティで指定されたログファイルに書き込みます。

ログに記録される各操作は、モジュールと呼ばれるカテゴリに分類されます。各モジュールには対応する短いコードがあり、個々の Sync App の操作がどのモジュールに属するかを示すラベルとして使用されます。

この接続プロパティにモジュールコードをセミコロン区切りのリストで設定すると、指定したモジュールに属する操作のみがログファイルに書き込まれます。この設定は今後のログ記録にのみ適用され、既存のログファイルの内容には影響しません。例: INFO;EXEC;SSL;META;

デフォルトでは、すべてのモジュールの操作がログに含まれます。

モジュールを明示的に除外するには、先頭に「-」を付けます。例: -HTTP

サブモジュールにフィルターを適用するには、<モジュール名>.<サブモジュール名> の構文で指定します。たとえば、次の値を設定すると、Sync App は HTTP モジュールに属するアクションのみをログに記録し、さらに HTTP モジュールの Res サブモジュールに属するアクションを除外します: HTTP;-HTTP.Res

Verbosity 接続プロパティによるログファイルのフィルタリングは、この接続プロパティによるフィルタリングよりも優先されます。そのため、Verbosity 接続プロパティで指定したレベルよりも高い詳細レベルの操作は、この接続プロパティで指定したモジュールに属していても、ログファイルには出力されません。

使用可能なモジュールとサブモジュールは次のとおりです。

モジュール名 モジュールの説明 サブモジュール
INFO 一般情報。接続文字列、製品バージョン（ビルド番号）、および初期接続メッセージが含まれます。
  • Connec — 接続の作成または破棄に関連する情報。
  • Messag — 接続、接続文字列、製品バージョンに関するメッセージの汎用ラベル。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。
EXEC クエリ実行。ユーザーが記述した SQL クエリ、解析済み SQL クエリ、正規化済み SQL クエリの実行メッセージが含まれます。クエリおよびクエリページの成功/失敗メッセージもここに表示されます。
  • Messag — クエリ実行に関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。
  • Normlz — クエリの正規化ステップ。クエリの正規化とは、ユーザーが送信したクエリを、最適なパフォーマンスで同じ結果を得られるように書き換える処理です。
  • Origin — ユーザーの元のクエリ（ユーザーが実行した正確で未変更の非正規化クエリ）を記録するメッセージに適用されるラベル。
  • Page — クエリのページングに関連するメッセージ。
  • Parsed — クエリの解析ステップ。解析とは、ユーザーが送信したクエリを、処理しやすい標準化された形式に変換するプロセスです。
HTTP HTTP プロトコルメッセージ。HTTP リクエスト/レスポンス（POST メッセージを含む）、および Kerberos 関連のメッセージが含まれます。
  • KERB — Kerberos に関連する HTTP リクエスト。
  • Messag — HTTP プロトコルに関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。
  • Unpack — サービス API から返された圧縮データを製品が解凍する際のメッセージに適用されるラベル。
  • Res — HTTP レスポンスを含むメッセージ。
  • Req — HTTP リクエストを含むメッセージ。
WSDL WSDL/XSD ファイルの生成に関するメッセージ。 —
SSL SSL 証明書メッセージ。
  • Certif — SSL 証明書に関するメッセージ。
AUTH 認証関連の失敗/成功メッセージ。
  • Messag — 認証に関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。
  • OAuth — OAuth 認証に関連するメッセージ。
  • Krbros — Kerberos 関連の認証メッセージ。
SQL SQL トランザクション、SQL 一括転送メッセージ、および SQL 結果セットメッセージが含まれます。
  • Bulk — 一括クエリ実行に関するメッセージ。
  • Cache — パフォーマンス向上のため、製品のキャッシュへの行データの読み書きに関連するメッセージ。
  • Messag — SQL トランザクションに関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。
  • ResSet — クエリの結果セット。
  • Transc — 実行されたジョブ数やバックアップテーブルの処理に関する情報を含む、トランザクション処理に関連するメッセージ。
META メタデータキャッシュとスキーマメッセージ。
  • Cache — パフォーマンス向上のため、製品のキャッシュ内のカラムおよびテーブル定義の読み取りと変更に関連するメッセージ。
  • Schema — サービススキーマからのメタデータの取得またはサービススキーマの変更に関連するメッセージ。
  • MemSto — インメモリメタデータキャッシュへの書き込みまたは読み取りに関連するメッセージ。
  • Storag — メモリ内ではなく、ディスクまたは外部データストアへのメタデータの保存に関連するメッセージ。
FUNC SQL 関数の実行に関連する情報。
  • Errmsg — SQL 関数の実行に関連するエラーメッセージ。
TCP TCP トランスポートレイヤーメッセージでの送受信生バイト。
  • Send — TCP プロトコル経由で送信された生データ。
  • Receiv — TCP プロトコル経由で受信した生データ。
FTP File Transfer Protocol に関するメッセージ。
  • Info — FTP プロトコルでの通信に関連するステータスメッセージ。
  • Client — FTP 通信中に FTP クライアント（製品）が実行したアクションに関連するメッセージ。
  • Server — FTP 通信中に FTP サーバーが実行したアクションに関連するメッセージ。
SFTP Secure File Transfer Protocol に関するメッセージ。
  • Info — SFTP プロトコルでの通信に関連するステータスメッセージ。
  • To_Server — SFTP 通信中に SFTP クライアント（製品）が実行したアクションに関連するメッセージ。
  • From_Server — SFTP 通信中に SFTP サーバーが実行したアクションに関連するメッセージ。
POP Post Office Protocol 経由で転送されるデータに関するメッセージ。
  • Client — POP 通信中に POP クライアント（製品）が実行したアクションに関連するメッセージ。
  • Server — POP 通信中に POP サーバーが実行したアクションに関連するメッセージ。
  • Status — POP プロトコルでの通信に関連するステータスメッセージ。
SMTP Simple Mail Transfer Protocol 経由で転送されるデータに関するメッセージ。
  • Client — SMTP 通信中に SMTP クライアント（製品）が実行したアクションに関連するメッセージ。
  • Server — SMTP 通信中に SMTP サーバーが実行したアクションに関連するメッセージ。
  • Status — SMTP プロトコルでの通信に関連するステータスメッセージ。
CORE 他のモジュールでカバーされていない、さまざまな製品内部操作に関連するメッセージ。 —
DEMN SQL リモーティングに関連するメッセージ。 —
CLJB 一括データアップロード（クラウドジョブ）に関するメッセージ。
  • Commit — 一括データアップロードの送信。
SRCE 他のモジュールに属さない、製品が生成するその他のメッセージ。 —
TRANCE 低レベルの製品操作に関する高度なメッセージ。 —

Tableau CRM Analytics Connector for CData Sync

Schema

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

プロパティ説明
Locationテーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。
BrowsableSchemasレポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tablesレポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。
Viewsレポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。
MetadataFilesLocationThe location of the metadata files. Set this to the path of the folder where your metadata files are stored, or the specific path of your file.
TypeDetectionSchemeDetermines how to determine the data types of columns.
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
PrimaryKeyIdentifierSet this property to control the name of the primary key.
Tableau CRM Analytics Connector for CData Sync

Location

テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。

解説

Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。

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

プラットフォーム %APPDATA%
Windows APPDATA 環境変数の値
Linux ~/.config

Tableau CRM Analytics Connector for CData Sync

BrowsableSchemas

レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

解説

利用可能なデータベーススキーマをすべてリストすると余分な時間がかかり、パフォーマンスが低下します。 接続文字列にスキーマのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

Tableau CRM Analytics Connector for CData Sync

Tables

レポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。

解説

データベースによっては、利用可能なすべてのテーブルをリストするのに時間がかかり、パフォーマンスが低下する場合があります。 接続文字列にテーブルのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

利用可能なテーブルがたくさんあり、すでに作業したいテーブルが決まっている場合、このプロパティを使用して対象のテーブルのみに表示を制限することができます。これを行うには、カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。 例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。

Note：複数のスキーマまたはカタログを持つデータソースに接続する場合は、表示する各テーブルを完全修飾名で指定する必要があります。これにより、複数のカタログやスキーマに存在するテーブルが混同されることを防ぎます。

Tableau CRM Analytics Connector for CData Sync

Views

レポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。

解説

データベースによっては、利用可能なすべてのビューをリストするのに時間がかかり、パフォーマンスが低下する場合があります。 接続文字列にビューのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

利用可能なビューがたくさんあり、すでに作業したいビューが決まっている場合、このプロパティを使用して対象のビューのみに表示を制限することができます。これを行うには、カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。 例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。

Note：複数のスキーマまたはカタログを持つデータソースに接続する場合は、確認する各ビューを完全修飾名で指定する必要があります。これにより、複数のカタログやスキーマに存在するビューが混同されることを防ぎます。

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

TypeDetectionScheme

Determines how to determine the data types of columns.

解説

NoneSetting TypeDetectionScheme to None will return all columns as the string type. Note: Even when set to None, the column names will still be scanned when Header is set to True.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

Miscellaneous

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

プロパティ説明
AsyncBulkOperationA boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.
HandleAPINullIssuesA boolean indicating if the provider should handle known issues with Tableau CRM nulls.
MaxRows集計やGROUP BY を含まないクエリで返される最大行数を指定します。
Other特定の問題に対処するため、特殊なシナリオ向けの高度な接続プロパティを指定します。このプロパティは、サポートチームの指示がある場合にのみ使用してください。
Pagesizeprovider がTableau CRM にデータをリクエストするときに返す、ページあたりの最大レコード数を指定します。
PseudoColumnsテーブルカラムとして公開する擬似カラムを、'TableName=ColumnName;TableName=ColumnName' の形式の文字列で指定します。
QueryLanguageSpecifies the query language to use with Tableau CRM.
QueryPassthroughこのオプションは、クエリをTableau CRM サーバーにas-is で渡します。
Timeoutprovider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。
UseDisplayNamesBoolean determining if the display names for the columns should be used instead of the API names.
UserDefinedViewsカスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。
UseSimpleNamesテーブルとカラムに簡略名を使用するかどうかを指定します。
ValidationModeThe validation mode to use during schema discovery. Options are None, Basic, and Enhanced (default: Basic).
Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

MaxRows

集計やGROUP BY を含まないクエリで返される最大行数を指定します。

解説

このプロパティのデフォルト値である-1 は、クエリに明示的にLIMIT 句が含まれていない限り、行の制限が適用されないことを意味します。 （クエリにLIMIT 句が含まれている場合、クエリで指定された値がMaxRows 設定よりも優先されます。）

MaxRows を0より大きい整数に設定することで、クエリがデフォルトで過度に大きな結果セットを返さないようにします。

このプロパティは、非常に大きなデータセットを返す可能性のあるクエリを実行する際に、パフォーマンスを最適化し、過剰なリソース消費を防ぐのに役立ちます。

Tableau CRM Analytics Connector for CData Sync

Other

特定の問題に対処するため、特殊なシナリオ向けの高度な接続プロパティを指定します。このプロパティは、サポートチームの指示がある場合にのみ使用してください。

解説

このプロパティにより、シニアユーザーはサポートチームのアドバイスに基づいて、特定の状況に対応する隠しプロパティを設定できます。 これらの設定は通常のユースケースには必要ありませんが、特定の要件に対応したり、追加の機能を提供したりすることができます。 複数のプロパティを定義するには、セミコロンで区切られたリストを使用します。

Note：特定のシナリオや問題に対処するためにサポートチームから助言があった場合にのみ、これらのプロパティを設定することを強く推奨します。

統合およびフォーマット

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

Tableau CRM Analytics Connector for CData Sync

Pagesize

provider がTableau CRM にデータをリクエストするときに返す、ページあたりの最大レコード数を指定します。

解説

クエリを処理する際、Tableau CRM でクエリされたデータすべてを一度にリクエストする代わりに、Sync App はクエリされたデータをページと呼ばれる部分ごとにリクエストすることができます。

この接続プロパティは、Sync App がページごとにリクエストする結果の最大数を決定します。

Note：大きなページサイズを設定すると全体的なクエリ実行時間が短縮される可能性がありますが、その場合、クエリ実行時にSync App がより多くのメモリを使用することになり、タイムアウトが発生するリスクがあります。

Tableau CRM Analytics Connector for CData Sync

PseudoColumns

テーブルカラムとして公開する擬似カラムを、'TableName=ColumnName;TableName=ColumnName' の形式の文字列で指定します。

解説

このプロパティを使用すると、Sync App がテーブルカラムとして公開する擬似カラムを定義できます。

個々の擬似カラムを指定するには、以下の形式を使用します。

Table1=Column1;Table1=Column2;Table2=Column3

すべてのテーブルのすべての擬似カラムを含めるには、次を使用してください： 

*=*

Tableau CRM Analytics Connector for CData Sync

QueryLanguage

Specifies the query language to use with Tableau CRM.

解説

Tableau CRM supports both SAQL and SQL as query languages, each with distinct behaviors.

SQL mode uses standard relational syntax, but some features available in SAQL are not supported. For example, SQL returns a group for null values in grouped queries, while SAQL does not.

If your datasets include date fields, enable the the Index Date Fields in SQL setting in the Tableau CRM UI under Setup > Analytics > Settings > SQL Settings. This setting allows SQL queries to access derived date fields such as year, month, and day components. Datasets must be recreated after enabling the setting for the changes to take effect.

Tableau CRM Analytics Connector for CData Sync

QueryPassthrough

このオプションは、クエリをTableau CRM サーバーにas-is で渡します。

解説

これが設定されていると、クエリはTableau CRM に直接渡されます。

Tableau CRM Analytics Connector for CData Sync

Timeout

provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。

解説

タイムアウトは、クエリや操作全体ではなくサーバーとの個々の通信に適用されます。 例えば、各ページング呼び出しがタイムアウト制限内に完了する場合、クエリは60秒を超えて実行を続けることができます。

タイムアウトはデフォルトで60秒に設定されています。タイムアウトを無効にするには、このプロパティを0に設定します。

タイムアウトを無効にすると、操作が成功するか、サーバー側のタイムアウト、ネットワークの中断、またはサーバーのリソース制限などの他の条件で失敗するまで無期限に実行されます。

Note： このプロパティは慎重に使用してください。長時間実行される操作がパフォーマンスを低下させたり、応答しなくなる可能性があるためです。

Tableau CRM Analytics Connector for CData Sync

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.

Tableau CRM Analytics Connector for CData Sync

UserDefinedViews

カスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。

解説

UserDefinedViews を使用すると、UserDefinedViews.json というJSON 形式の構成ファイルを通じてカスタムビューを定義および管理できます。 これらのビューはSync App によって自動的に認識され、標準のデータベースビューのようにカスタムSQL クエリを実行できるようになります。 JSON ファイルは、各ビューをルート要素として定義し、その子要素として"query" を持ちます。この"query" にはビューのSQL クエリが含まれています。

次に例を示します。 

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

このプロパティを使用して、1つのファイルに複数のビューを定義し、ファイルパスを指定できます。 次に例を示します。 

UserDefinedViews=C:\Path\To\UserDefinedViews.json
UserDefinedViews でビューを指定すると、Sync App はそのビューだけを参照します。

詳しくは、ユーザー定義ビュー を参照してください。

Tableau CRM Analytics Connector for CData Sync

UseSimpleNames

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

解説

Tableau CRM テーブルでは、標準的なデータベースでは通常許可されない特殊文字を名前に含めることができます。このプロパティを使用すると、Sync App を従来のデータベースツールでより簡単に使用できるようになります。

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

Notes：

  • 英数字以外の文字はアンダースコアに置き換えられます。
  • カラム名やテーブル名が128 文字を超える場合は、SQL Server 標準に準拠するために128文字に切り詰められます。

Tableau CRM Analytics Connector for CData Sync

ValidationMode

The validation mode to use during schema discovery. Options are None, Basic, and Enhanced (default: Basic).

解説

  • None: No checks will be performed when pushing tables and views.
  • Basic: Each view will be checked to ensure its query is properly configured.
  • Enhanced: Each pushed view will also be checked for the presence of records.

Tableau CRM Analytics Connector for CData Sync

Third Party Copyrights

LZMA from 7Zip LZMA SDK

LZMA SDK is placed in the public domain.

Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original LZMA SDK code, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.

LZMA2 from XZ SDK

Version 1.9 and older are in the public domain.

Xamarin.Forms

Xamarin SDK

The MIT License (MIT)

Copyright (c) .NET Foundation Contributors

All rights reserved.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

NSIS 3.10

Copyright (C) 1999-2025 Contributors THE ACCOMPANYING PROGRAM IS PROVIDED UNDER THE TERMS OF THIS COMMON PUBLIC LICENSE ("AGREEMENT"). ANY USE, REPRODUCTION OR DISTRIBUTION OF THE PROGRAM CONSTITUTES RECIPIENT'S ACCEPTANCE OF THIS AGREEMENT.

1. DEFINITIONS

"Contribution" means:

a) in the case of the initial Contributor, the initial code and documentation distributed under this Agreement, and b) in the case of each subsequent Contributor:

i) changes to the Program, and

ii) additions to the Program;

where such changes and/or additions to the Program originate from and are distributed by that particular Contributor. A Contribution 'originates' from a Contributor if it was added to the Program by such Contributor itself or anyone acting on such Contributor's behalf. Contributions do not include additions to the Program which: (i) are separate modules of software distributed in conjunction with the Program under their own license agreement, and (ii) are not derivative works of the Program.

"Contributor" means any person or entity that distributes the Program.

"Licensed Patents " mean patent claims licensable by a Contributor which are necessarily infringed by the use or sale of its Contribution alone or when combined with the Program.

"Program" means the Contributions distributed in accordance with this Agreement.

"Recipient" means anyone who receives the Program under this Agreement, including all Contributors.

2. GRANT OF RIGHTS

a) Subject to the terms of this Agreement, each Contributor hereby grants Recipient a non-exclusive, worldwide, royalty-free copyright license to reproduce, prepare derivative works of, publicly display, publicly perform, distribute and sublicense the Contribution of such Contributor, if any, and such derivative works, in source code and object code form.

b) Subject to the terms of this Agreement, each Contributor hereby grants Recipient a non-exclusive, worldwide, royalty-free patent license under Licensed Patents to make, use, sell, offer to sell, import and otherwise transfer the Contribution of such Contributor, if any, in source code and object code form. This patent license shall apply to the combination of the Contribution and the Program if, at the time the Contribution is added by the Contributor, such addition of the Contribution causes such combination to be covered by the Licensed Patents. The patent license shall not apply to any other combinations which include the Contribution. No hardware per se is licensed hereunder.

c) Recipient understands that although each Contributor grants the licenses to its Contributions set forth herein, no assurances are provided by any Contributor that the Program does not infringe the patent or other intellectual property rights of any other entity. Each Contributor disclaims any liability to Recipient for claims brought by any other entity based on infringement of intellectual property rights or otherwise. As a condition to exercising the rights and licenses granted hereunder, each Recipient hereby assumes sole responsibility to secure any other intellectual property rights needed, if any. For example, if a third party patent license is required to allow Recipient to distribute the Program, it is Recipient's responsibility to acquire that license before distributing the Program.

d) Each Contributor represents that to its knowledge it has sufficient copyright rights in its Contribution, if any, to grant the copyright license set forth in this Agreement.

3. REQUIREMENTS

A Contributor may choose to distribute the Program in object code form under its own license agreement, provided that:

a) it complies with the terms and conditions of this Agreement; and

b) its license agreement:

i) effectively disclaims on behalf of all Contributors all warranties and conditions, express and implied, including warranties or conditions of title and non-infringement, and implied warranties or conditions of merchantability and fitness for a particular purpose;

ii) effectively excludes on behalf of all Contributors all liability for damages, including direct, indirect, special, incidental and consequential damages, such as lost profits;

iii) states that any provisions which differ from this Agreement are offered by that Contributor alone and not by any other party; and

iv) states that source code for the Program is available from such Contributor, and informs licensees how to obtain it in a reasonable manner on or through a medium customarily used for software exchange.

When the Program is made available in source code form:

a) it must be made available under this Agreement; and

b) a copy of this Agreement must be included with each copy of the Program.

Contributors may not remove or alter any copyright notices contained within the Program.

Each Contributor must identify itself as the originator of its Contribution, if any, in a manner that reasonably allows subsequent Recipients to identify the originator of the Contribution.

4. COMMERCIAL DISTRIBUTION

Commercial distributors of software may accept certain responsibilities with respect to end users, business partners and the like. While this license is intended to facilitate the commercial use of the Program, the Contributor who includes the Program in a commercial product offering should do so in a manner which does not create potential liability for other Contributors. Therefore, if a Contributor includes the Program in a commercial product offering, such Contributor ("Commercial Contributor") hereby agrees to defend and indemnify every other Contributor ("Indemnified Contributor") against any losses, damages and costs (collectively "Losses") arising from claims, lawsuits and other legal actions brought by a third party against the Indemnified Contributor to the extent caused by the acts or omissions of such Commercial Contributor in connection with its distribution of the Program in a commercial product offering. The obligations in this section do not apply to any claims or Losses relating to any actual or alleged intellectual property infringement. In order to qualify, an Indemnified Contributor must: a) promptly notify the Commercial Contributor in writing of such claim, and b) allow the Commercial Contributor to control, and cooperate with the Commercial Contributor in, the defense and any related settlement negotiations. The Indemnified Contributor may participate in any such claim at its own expense.

For example, a Contributor might include the Program in a commercial product offering, Product X. That Contributor is then a Commercial Contributor. If that Commercial Contributor then makes performance claims, or offers warranties related to Product X, those performance claims and warranties are such Commercial Contributor's responsibility alone. Under this section, the Commercial Contributor would have to defend claims against the other Contributors related to those performance claims and warranties, and if a court requires any other Contributor to pay any damages as a result, the Commercial Contributor must pay those damages.

5. NO WARRANTY

EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, THE PROGRAM IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, EITHER EXPRESS OR IMPLIED INCLUDING, WITHOUT LIMITATION, ANY WARRANTIES OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Each Recipient is solely responsible for determining the appropriateness of using and distributing the Program and assumes all risks associated with its exercise of rights under this Agreement, including but not limited to the risks and costs of program errors, compliance with applicable laws, damage to or loss of data, programs or equipment, and unavailability or interruption of operations.

6. DISCLAIMER OF LIABILITY

EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, NEITHER RECIPIENT NOR ANY CONTRIBUTORS SHALL HAVE ANY LIABILITY FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING WITHOUT LIMITATION LOST PROFITS), HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OR DISTRIBUTION OF THE PROGRAM OR THE EXERCISE OF ANY RIGHTS GRANTED HEREUNDER, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

7. GENERAL

If any provision of this Agreement is invalid or unenforceable under applicable law, it shall not affect the validity or enforceability of the remainder of the terms of this Agreement, and without further action by the parties hereto, such provision shall be reformed to the minimum extent necessary to make such provision valid and enforceable.

If Recipient institutes patent litigation against a Contributor with respect to a patent applicable to software (including a cross-claim or counterclaim in a lawsuit), then any patent licenses granted by that Contributor to such Recipient under this Agreement shall terminate as of the date such litigation is filed. In addition, if Recipient institutes patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Program itself (excluding combinations of the Program with other software or hardware) infringes such Recipient's patent(s), then such Recipient's rights granted under Section 2(b) shall terminate as of the date such litigation is filed.

All Recipient's rights under this Agreement shall terminate if it fails to comply with any of the material terms or conditions of this Agreement and does not cure such failure in a reasonable period of time after becoming aware of such noncompliance. If all Recipient's rights under this Agreement terminate, Recipient agrees to cease use and distribution of the Program as soon as reasonably practicable. However, Recipient's obligations under this Agreement and any licenses granted by Recipient relating to the Program shall continue and survive.

Everyone is permitted to copy and distribute copies of this Agreement, but in order to avoid inconsistency the Agreement is copyrighted and may only be modified in the following manner. The Agreement Steward reserves the right to publish new versions (including revisions) of this Agreement from time to time. No one other than the Agreement Steward has the right to modify this Agreement. IBM is the initial Agreement Steward. IBM may assign the responsibility to serve as the Agreement Steward to a suitable separate entity. Each new version of the Agreement will be given a distinguishing version number. The Program (including Contributions) may always be distributed subject to the version of the Agreement under which it was received. In addition, after a new version of the Agreement is published, Contributor may elect to distribute the Program (including its Contributions) under the new version. Except as expressly stated in Sections 2(a) and 2(b) above, Recipient receives no rights or licenses to the intellectual property of any Contributor under this Agreement, whether expressly, by implication, estoppel or otherwise. All rights in the Program not expressly granted under this Agreement are reserved.

This Agreement is governed by the laws of the State of New York and the intellectual property laws of the United States of America. No party to this Agreement will bring a legal action under this Agreement more than one year after the cause of action arose. Each party waives its rights to a jury trial in any resulting litigation.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9540