Edit on GitHub
PowerReviews Enterprise Lite link
Updated November 10, 2023
PowerReviews Enterprise is a software platform for product reviews and ratings.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | MODERATION_OBSERVATION, ORDERS, and SPECIFIC_MODERATION_OBSERVATION tables |
| Custom data | check | REVIEW table |
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step PowerReviews Enterprise setup guide to connect PowerReviews Enterprise with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables and their child tables:
ORDERSPRODUCTQUESTIONREVIEW
We re-import the ORDERS table once a week to capture deletes.
We also re-import the MODERATION_OBSERVATION and SPECIFIC_MODERATION_OBSERVATION tables to capture updates and deletes.
Schema informationlink
This schema applies to all PowerReviews Enterprise connectors.
To zoom, open the ERD in a new window.