Data relationship and field mapping
Build a mapping plan for Dynamo DB and HubSpot
These candidates compare the meaning of records in each inventory. Field names below are business concepts for your worksheet, not verified API field names or ready-to-import mappings. Confirm the actual schema, object operations, and account permissions before implementation.
Download this pair’s planning worksheet (.csv) ↓ No email required. Includes candidate relationships, identity rules, ownership, validation, and recovery checks.
Proposed reporting projection Proposed customer or company table in Dynamo DB (choose its name) / Company
Plan a customer or company dataset while preserving its source meaning.
- Dynamo DB
- Proposed table: design required · User-designed table; confirm schema and connector eligibility
- HubSpot
- Documented inventory entry · ✅ Supported
Identity rule to define
Retain the source company ID and the destination customer/company ID. Separate legal entities, subsidiaries, and business units; a shared name or web domain is insufficient.
Field concepts to specify
- Source record ID
- Legal or display name
- Business-unit reference
- Lifecycle status
Ownership decision
Assign ownership separately for relationship details and finance-controlled billing details.
Inventory references: HubSpot: Company inventory
Proposed reporting projection Proposed contact or customer person table in Dynamo DB (choose its name) / Contact
Plan a contact or customer person dataset while preserving its source meaning.
- Dynamo DB
- Proposed table: design required · User-designed table; confirm schema and connector eligibility
- HubSpot
- Documented inventory entry · ✅ Supported
Identity rule to define
Use a stable person/contact ID and an explicit cross-system lookup. Email can change and can be shared, so treat it as a matching clue rather than a universal key.
Field concepts to specify
- Source person ID
- Display name
- Email address
- Organization reference
- Consent state
Ownership decision
Keep consent and communication preferences under an agreed authority; a general contact update must not silently resubscribe someone.
Inventory references: HubSpot: Contact inventory
Proposed reporting projection Proposed deal or opportunity table in Dynamo DB (choose its name) / Deal
Plan a deal or opportunity dataset while preserving its source meaning.
- Dynamo DB
- Proposed table: design required · User-designed table; confirm schema and connector eligibility
- HubSpot
- Documented inventory entry · ✅ Supported
Identity rule to define
Keep the opportunity/deal ID separate from any later order or invoice ID.
Field concepts to specify
- Source deal ID
- Stage
- Amount and currency
- Expected close date
- Company reference
Ownership decision
The sales process owns qualification and stage changes; downstream financial records have their own state and approval rules.
Inventory references: HubSpot: Deal inventory
Proposed reporting projection Proposed support case or ticket table in Dynamo DB (choose its name) / Ticket
Plan a support case or ticket dataset while preserving its source meaning.
- Dynamo DB
- Proposed table: design required · User-designed table; confirm schema and connector eligibility
- HubSpot
- Documented inventory entry · ✅ Supported
Identity rule to define
Retain the ticket ID and distinguish parent tickets, follow-ups, and merged cases.
Field concepts to specify
- Source ticket ID
- Requester reference
- Status
- Priority
- Assigned team
Ownership decision
Agree which queue controls status and assignee; keep private comments distinct from public replies.
Inventory references: HubSpot: Ticket inventory
Potential shared entity Items / Product
Compare whether Dynamo DB Items and HubSpot Product describe the same product or catalog item in your business.
- Dynamo DB
- Catalog entry: support to confirm · Object named in catalog; Stacksync coverage requires confirmation
- HubSpot
- Documented inventory entry · ✅ Supported
Identity rule to define
Distinguish the product ID, variant ID, SKU, and price-list entry; they are not interchangeable keys.
Field concepts to specify
- Source product ID
- SKU or variant reference
- Description
- Unit of measure
- Price-list reference
Ownership decision
Assign ownership for catalog content, price, and stock separately.
Inventory references: HubSpot: Product inventory
Proposed reporting projection Proposed product or catalog item table in Dynamo DB (choose its name) / Product
Plan a product or catalog item dataset while preserving its source meaning.
- Dynamo DB
- Proposed table: design required · User-designed table; confirm schema and connector eligibility
- HubSpot
- Documented inventory entry · ✅ Supported
Identity rule to define
Distinguish the product ID, variant ID, SKU, and price-list entry; they are not interchangeable keys.
Field concepts to specify
- Source product ID
- SKU or variant reference
- Description
- Unit of measure
- Price-list reference
Ownership decision
Assign ownership for catalog content, price, and stock separately.
Inventory references: HubSpot: Product inventory