Add a PostgreSQL source
Connect an external PostgreSQL database as a data source for O'Dashboard.
Navigate to Sources
In the left sidebar, click on Sources. This is where all your connected data sources live — and where you'll add new ones.
Create a new source
Once you're on the Sources page, click "New Source" in the top right corner.
You'll be prompted to choose your source type. O'Dashboard supports two options — your Odoo database directly, or an external PostgreSQL database. In this example, we're going to connect an external PostgreSQL database.
Configure the connection
Give your source a name — something simple and recognizable, like "My Postgres Database". Then paste in your connection string. This is the standard PostgreSQL connection format, so if you have it handy, it takes just a few seconds.
Test the connection
Once that's in, click "Test Connection". O'Dashboard will reach out to your database and verify everything is in order. Just a couple of seconds — and there it is. Connection successful.
Connection successful
If the test passes, your database is reachable and the credentials are valid.
Create and sync
Click "Create". One last step — hit the "Sync" button to synchronize your database with O'Dashboard. This is what allows O'Dashboard to discover your tables and make them available for querying.
Why sync?
The sync step lets O'Dashboard discover all the tables and columns in your database. This is required for the Builder mode to work. You can re-sync at any time if your database schema changes.
And that's it. Your source is connected, synced, and ready to use.