Propertyware (RealPage)
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Propertyware (RealPage) to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Propertyware API credentials to sync property, lease, and accounting data into the PostHog Data warehouse.
Find your client ID, client secret, and organization ID in Propertyware under Administration Setup > API Keys (you'll need an administrator role to access this page). The client secret is shown only once when the key is created, so store it somewhere safe before closing the dialog.
Configuration
| Option | Type | Required |
|---|---|---|
Client ID | text | Yes |
Client secret | password | Yes |
Organization ID | text | Yes |
Linking Propertyware (RealPage) to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Propertyware (RealPage)
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
Portfolios | A group of properties (buildings) managed together, typically for one owner. | Incremental, Full refresh | lastModifiedDateTime | id |
Buildings | A physical property (single-family home or multi-unit building) within a portfolio. | Incremental, Full refresh | lastModifiedDateTime | id |
Units | An individually leasable unit within a building. | Incremental, Full refresh | lastModifiedDateTime | id |
Leases | A lease agreement between one or more tenants and a portfolio owner for a unit or building. | Incremental, Full refresh | lastModifiedDateTime | id |
LeaseCharges | A charge posted to a lease (rent, fees, or other billed amounts). | Incremental, Full refresh | lastModifiedDateTime | id |
LeasePayments | A payment applied against lease charges. | Incremental, Full refresh | lastModifiedDateTime | id |
LeaseAdjustments | A manual adjustment posted to a lease's balance. | Incremental, Full refresh | lastModifiedDateTime | id |
LeaseRefunds | A refund issued from a lease's balance back to a tenant. | Incremental, Full refresh | lastModifiedDateTime | id |
Contacts | A person record — tenant, owner, or other contact — in the account. | Incremental, Full refresh | lastModifiedDateTime | id |
Prospects | A prospective tenant who has expressed interest in leasing a property. | Incremental, Full refresh | lastModifiedDateTime | id |
Vendors | A vendor or service provider paid for work performed on managed properties. | Incremental, Full refresh | lastModifiedDateTime | id |
Bills | A bill owed to a vendor, optionally tied to a work order. | Incremental, Full refresh | lastModifiedDateTime | id |
BillPayments | A payment made to a vendor against one or more bills. | Incremental, Full refresh | lastModifiedDateTime | id |
WorkOrders | A maintenance work order for a building or unit. | Incremental, Full refresh | lastModifiedDateTime | id |
Inspections | A property inspection scheduled or completed for a lease or building. | Incremental, Full refresh | lastModifiedDateTime | id |
GLAccounts | A general ledger account used for accounting entries across the account. | Incremental, Full refresh | lastModifiedDateTime | id |