PowerReviews Enterprise Lite

PowerReviews Enterprise is a software platform for product reviews and ratings.

Features

Feature Name	Supported	Notes
Capture deletes		`MODERATION_OBSERVATION` and `ORDERS` tables
History mode
Custom data		`REVIEW` table
Data blocking		Column level
Column hashing
Re-sync		Connection level and table level. A parent table re-sync includes all associated child tables.
API configurable		API configuration
Priority-first sync
Fivetran data models
Private networking
Authorization via API

We support the SaaS and Hybrid deployment models for the connector.

NOTE: You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.

Follow our step-by-step PowerReviews Enterprise setup guide to connect PowerReviews Enterprise with your destination using Fivetran connectors.

To capture new records, we incrementally sync the following tables and their child tables:

To capture updates and deleted records, we also periodically re-import certain tables:

We re-import the ORDERS table once a week to capture deletes.
We re-import the SPECIFIC_MODERATION_REVIEW_OBSERVATION and SPECIFIC_MODERATION_QUESTION_OBSERVATION tables to capture updates.
We re-import the MODERATION_OBSERVATION table to capture both updates and deletes.

This schema applies to all PowerReviews Enterprise connectors.

Explore PowerReviews Enterprise schema ERD