Pipeline Cloud is EveryAction/NGP VAN’s data replication solution that gives you direct access to your raw data.
Read an overview of Pipeline Cloud
If you are just getting started with Pipeline Cloud, we suggest that you begin by reading our setup instructions and our quick-start User Guide. Both of these documents will get you going quickly and provide help with some of the more common queries using SQL.
This Developer Documentation provides a more detailed look at the tables and database schema available for Pipeline Cloud. Intended for more advanced users, these additional resources will help you build more complex queries and custom integrations for your data.
Data Dictionary
Our downloadable data dictionary gives you every available data point broken down by table and field. Data tiers are matched to our sales packages so you will be able to quickly identify the kind of data that is available for your particular database setup.
Attached in this article below is the downloadable data dictionary or you can click this link > Download the Data Dictionary (last updated November 25, 2025).
All databases include these Core tables, regardless of sales packages and add-on purchases:
- Contacts, including Organizations
- Addresses
- Phones and Phone Opt-ins
- Salutations
- Notes
- Committees
- Campaigns
- Activist Codes
- Survey Questions
- Users assigned to database
If you have Digital package, you will also get these additional Core tables, regardless of other packages or add-ons:
- Targeted Email
- Events including tickets
- Online forms
- Contributions
- Add-On’s:
- Advocacy Targets (includes local and custom if applicable)
- Click-to-Call
Other available tables will depend on your package, as outlined in our Data Dictionary.
Entity Relationship Diagram (ERD)
The Entity Relationship Diagram (ERD) will help you understand how our tables interact.
We have a downloadable ERD for our Core tables that will help you understand these relationships.
Attached in this article below is a downloadable ERD for our Core tables or you can click this link > Download the Core ERD (last updated November 16, 2020)
The ERD is color-coded to help you visualize the relationships:
- Blue is for Contacts
- Green is for Events
- Yellow represents all other tables
The first page of the ERD contains all of the Core tables.
The second page is a less cluttered view of the Core tables that excludes Users and Committees.
- The Users table is a foreign key to many tables on CreatedBy.
- The Committees table is a foreign key to many tables on CommitteeID.
We have a downloadable ERD for our Digital tables that will help you understand these relationships.
Attached in this article below is a downloadable ERD for our Digital tables or you can click this link > Download the Digital ERD (last updated November 18, 2020)
The ERD is color-coded to help you visualize the relationships:
- Blue is for Contacts
- Green is for Events
- Purple is for Contributions
- Orange is for Emails
- Pink is for Online Actions
- Yellow represents all other tables