# IntegrateDB - Database sharing toolkit for Postgres

**URL:** <https://forum.elixirforum.com/t/integratedb-database-sharing-toolkit-for-postgres/37148>\
**Category:** Discussions\
**Tags:** phoenix, postgres, integration, liveview, broadway\
**Created:** [January 28, 2021, 2:11pm UTC](https://forum.elixirforum.com/t/integratedb-database-sharing-toolkit-for-postgres/37148 "2021-01-28T14:11:58Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Exadra37](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/exadra37/32/9183_2.png) [@Exadra37](https://forum.elixirforum.com/u/Exadra37)\
**Post date:** [January 28, 2021, 8:05pm UTC](https://forum.elixirforum.com/t/integratedb-database-sharing-toolkit-for-postgres/37148/4 "2021-01-28T20:05:00Z")

</div>

> ### Example - integrate a reporting application
> 
> Imagine that you have a primary web application with a Postgres database and that you want to integrate a reporting system. Assume you’ve [installed IntegrateDB](https://hexdocs.pm/integratedb/installation.html) and [bootstrapped a root user](https://hexdocs.pm/integratedb/usage.html). You then start by creating a `Stakeholder` representing your secondary reporting application:
> 
> ```elixir
> curl -X POST -H "..." -d '{"name": "reporter"}' /api/v1/stakeholders
> 
> ```
> 
> This creates a Postgres database user (`reporter`) with access scoped to its own private DDL schema (`reporter.*`) and returns the database user credentials in the response data:
> 
> ```elixir
> {
> "data": {
> "credentials": {
> "username": "reporter", 
> "password": "... randomly generated ...",
> }
> }
> }
> 
> ```
> 
> Save the credentials (somewhere safe!) and provide them to your reporting application as the database user and password it should use to connect directly to the Postgres database.

Unless I misunderstood you want to give the user and password to a client in the web to access the database directly?

Also, the cURL request can be done from a client in the internet?

---

_[View the full topic](https://forum.elixirforum.com/t/integratedb-database-sharing-toolkit-for-postgres/37148)._