Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-6748

Clarify the relationship between user and database for BI Connector

    XMLWordPrintableJSON

Details

    • 1

    Description

      Documentation Changes

      Applies only to the 1.x branch of the BI connector.

      Description

      Even though this section says that username and database are the same, I think the documentation needs to say more about the relationship within the BI Connector between:

      • MongoDB database
      • Postgres database
      • Postgres user

      A reasonable user might think that the mongobiuser tool simply creates a user in the Connector and somehow associated that with a MongoDB connection string.

      Furthermore, they might think that when importing a schema via the mongobischama tool a database will be created in Postgres with the same name as the MongoDB database indicated in the DRDL file.

      But that's not the case. What actually happens is that mongobiuser creates a BI Connector user AND a database of the same name as the user. When importing schemas into the Connector via mongobischema, all tables in the DRDL file are imported into that database. The MongoDB database is NOT represented as a BI Connector database.

      Essentially, each BI Connector user has its own separate schema in the Connector. It's not shared with any other BI Connector users. This is implied by the fact that mongobischema requires a BI Connector username, but it should be more explicit.

      Attachments

        Activity

          People

            bryan.reinero Bryan Reinero
            jeff.yemin@mongodb.com Jeffrey Yemin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              6 years, 22 weeks, 1 day ago