# eTapestry

> Connect to eTapestry to sync donor accounts, journal entries (gifts, pledges, payments, recurring giving), and your fundraising configuration into your warehouse.

Filament turns your eTapestry data into board reports, appeal reports and dashboards that stay current. Gifts, pledges, payments and recurring gift schedules sync through the eTapestry API every 6 hours with their fund, campaign and approach, so nobody has to run a query and export a report to Excel each time the numbers are needed.

Pledged and received amounts can sit side by side, this year next to last year, and each figure shows its working. Ask follow-up questions in plain English, export the dashboard to PDF for the board pack, and connect your email and marketing tools if you want to see what happened before the gift.

## Moving off eTapestry? Keep your giving history

If you're switching donor databases, connect eTapestry to Filament before you go. Every account, gift, pledge, payment and recurring gift schedule syncs into your own warehouse with its fund, campaign and approach, and it stays there for as long as the eTapestry connection stays in Filament. Disconnecting an app deletes its copy, so keep the connection after you switch.

Connect your new donor database as well, and next year's appeal results can sit beside the years you kept in eTapestry on the same dashboard. Filament connects to Salesforce, Little Green Light, NationBuilder and other fundraising tools.

## Data we sync

- **Accounts**: Donor records with contact information, account number, account role type, personas, and custom defined field values for segmentation. (`ref`, `account_number`, `name`, `email`, `account_role_type`, `account_defined_values`, `persona_defined_values`)
- **Gifts**: Outright donations with amount, date, fund, campaign, approach, payment method, and any custom defined field values for fundraising performance analysis. (`ref`, `amount`, `date`, `fund`, `campaign`, `approach`, `valuable_type`)
- **Pledges**: Pledged commitments with the original amount, outstanding balance, arrears amount, and next payment date, joined to payments for fulfilment tracking. (`ref`, `amount`, `outstanding_balance`, `arrears_amount`, `next_payment_date`)
- **Payments**: Payments applied against pledges, inheriting the parent pledge's fund and campaign assignment for revenue reconciliation. (`ref`, `amount`, `date`, `pledge_ref`, `fund`, `campaign`)
- **Recurring Gift Schedules**: Active recurring giving schedules with frequency, next gift date, next amount, and installment value for retention and forecast analysis. (`ref`, `frequency`, `next_gift_date`, `next_gift_amount`, `installment_amount`)
- **Funds, Campaigns and Approaches**: The fundraising dimensions every transaction is tagged with. Reference tables joined to gifts, pledges and payments by name (not foreign key). (`name`, `type`)
- **Relationships**: Explicit links between accounts (household members, employer or employee, matching gift donors). Flags head-of-household and matching gift relationships. (`account1_ref`, `account2_ref`, `type`, `hoh_account`, `matching_gift_account`)
- **Defined Fields**: Custom field definitions used across accounts, personas, and journal entries. Values are embedded inside each parent record's defined_values JSON. (`ref`, `name`, `type`, `category`)

## How do I connect eTapestry?

An eTapestry database administrator must enable API access.

1. Open [Apps](https://filamentanalytics.com/apps) in Filament and add **eTapestry**.
2. In eTapestry, go to **Management → My Organization → Subscriptions** and enable the API Subscription.
3. Copy the API Key and Database ID into Filament.
4. Add any useful context about your funds, campaigns and custom fields, then complete setup.

If the API Subscription is unavailable, contact your eTapestry account manager.
