HubSpot データモデル
CData ODBC Driver for HubSpot はHubSpot データを使いやすいSQL データベースとしてモデル化します。データモデルには3つのパートがあります。テーブル、ビュー、およびストアドプロシージャです。
テーブル
テーブル セクションには標準SQL テーブルの詳細が、ビュー セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、HubSpot アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| Contacts | Handles HubSpot contact records, enabling full create, read, update, delete (CRUD) operations on contact data. |
| Companies | Manages company records in HubSpot, allowing creation, updating, and deletion of company data similar to contact management. |
| Deals | Manages HubSpot deals used for recording sales opportunities, with capabilities for retrieval and modification. |
| Tickets | Retrieves all ticket records from a HubSpot portal, used for customer support and issue tracking. |
| Engagements | Represents various types of interactions in HubSpot, including calls, emails, and tasks, useful for tracking customer engagement activities. |
| ContactProperties | Accesses both standard and custom properties assigned to contacts, critical for personalized marketing and sales strategies. |
| CompanyProperties | Provides access to standard and custom fields associated with companies in HubSpot, aiding in data enrichment. |
| DealProperties | Provides access to deal property fields, both standard and custom, supporting deal tracking and analysis. |
| TicketProperties | Lists all properties related to tickets, both default and custom, used for managing customer support cases. |
| LineItems | Retrieves all line items in HubSpot, commonly used in association with deals and transactions. |
| Products | Retrieves product records configured in HubSpot, useful for inventory, pricing, and catalog management. |
| Workflows | Manages and retrieves workflows configured in HubSpot to automate marketing, sales, and service processes. |
| CrmAssociations | Queries customer relationship management (CRM) object associations within HubSpot, essential for understanding relationships between CRM entities. |
| ContactFormSubmissions | Lists form submissions made by contacts, useful for analyzing contact engagement through forms. |
| Forms | Enables creation, management, and retrieval of HubSpot forms used for lead capture and contact data collection. |
| MarketingEmails | Enables creation, management, and retrieval of marketing emails in HubSpot for email campaign management. |
| EmailSubscriptions | Lists subscription types linked to a specific email address, allowing management of subscription preferences. |
| AnalyticsSessions | Breaks down analytics data by user sessions, providing visibility into visitor behavior across sessions. |
| AnalyticsViews | Lists configured analytics views within the HubSpot portal, providing information on available analytics perspectives. |
本製品 は、HubSpot API を使用してサポートされているフィルタを処理します。その他のフィルタは、本製品 内でクライアント側で処理されます。
ストアドプロシージャ
ストアドプロシージャ は、SQL クエリを介して呼び出されるアクションです。標準的なCRUD 操作だけでなく、スキーマの作成やOAuth トークンの管理など、より高度なタスクも実行します。