Last updated
Databases and warehouses · data connector
Automated PostgreSQL reports, delivered on schedule
Rahoto connects to PostgreSQL as a database user with a password. It discovers the tables and views in the schema it is pointed at (public unless you say otherwise), and runs queries with pushdown in a session the database itself holds read-only.
What Rahoto reads
Your tables and views
Rahoto reads the structure from PostgreSQL itself: every table and view in the schema it is pointed at, with its columns and types. Nothing is fixed in advance, so the report sees the same tables your team does.
How you connect
What you need before connecting
- Sign-in
- A database user and password
- You provide
-
- Host
- Database
- User name
- Password
- Port (optional)
- Defaults
-
- Port: 5432
- Schema: public
- Read-only: on
- Read-only session
- Queries run in a session the database itself holds read-only.
Connectors read from your sources and are read-only by default. See the connection guidance for the steps.
How it refreshes
Refreshed on your schedule
Refresh mode: Snapshot, incremental.
- On each scheduled run Rahoto takes a fresh snapshot of the data and rebuilds the report from it.
- You can preview the data before you bind it to the page.
- Charts and tables can also query PostgreSQL directly, with the query work pushed down to it.
- Before an issue goes out, Rahoto checks the pages and notices when a source changed shape.
Where the report goes
Delivered where your readers already work
- Slack
- thread or channel
- Teams
- channel post
- inline or attached
- Web
- viewer or embed
- Webhook
- your endpoint
- S3
- bucket drop
- Drive
- shared folder
- SFTP
- your server
Web publishing is on every plan; the other seven channels come with every paid plan. PDF, PowerPoint and PNG travel on any of them.
An example report
Monthly management report
The first working day of each month, built from PostgreSQL.
- A cover with the month and the business unit
- A headline page of the figures your team defines, each bound to a table, view or query
- Charts and tables bound to the same governed tables
- Commentary pages written in the editor beside the numbers
- An appendix of definitions, so readers know where each figure comes from
The structure of a report, with no figures shown. You design the pages; Rahoto binds them to the data and sends them on schedule. See finished examples in the sample gallery.
Connect PostgreSQL and set the schedule
Bind it into the document, check a run, and choose where it goes.