The PEARS data mart can be used in combination with Power BI as follows. Prerequisites Setup Power BI can connect directly to the data mart using the PostgreSQL provider, npgsql. This provider and its necessary drivers are installed with Power BI Desktop and Power BI Gateway. However, before a trusted connection can be established with … Read more
A preview is provided below. A full-screen view of this resource is available here: 2025-07-11 – PEARS Decision Tree Unable to display PDF file. Download instead.
A preview is provided below. A full-screen view of this resource is available here: 2025-07-11 – PEARS Reporting Modules Unable to display PDF file. Download instead.
The public list of events can be accessed using the following endpoint: https://test.pears.io/events/<org_slug>/events-api/ To use the endpoint replace org_slug with your organization’s public slug (contact PEARS support if you don’t know what it is). Pagination Results will be paginated with a default page size of 20. The following query parameters can be used to navigate the paginated … Read more
The PEARS data mart can be used in combination with R and RStudio as follows. Prerequisites Setup Certificates Before a trusted connection can be established with the data mart, Amazon’s RDS certificates must be downloaded to a local folder on the device. Package Installation R can connect directly to the data mart using the RPostgres … Read more
The PEARS data mart is a read-only nightly copy of the entire set of PEARS data for your organization(s), transformed into a more readable and usable database schema. You can connect directly to your data mart database using tools like TablePlus (TablePlus | Modern, Native Tool for Database Management.) or Power BI. Or, you can … Read more
In order to assist with the transfer of data from PEARS to National PEARS (N-PEARS), the PEARS Team has built an N-PEARS Annual Report Export from PEARS for importation into N-PEARS. The current version of the N-PEARS export is 2.0. Known Issues: None at this time. Record Types Included This documentation serves to detail out … Read more
Program activities in PEARS generally feed into the Direct Education section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked … Read more
Success stories in PEARS feed into the Success Stories section in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Only records with a … Read more
Indirect activities in PEARS feed into the Indirect Education Channels section in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Records Excluded: Any … Read more