Biuwer Docs
Biuwer.comBlogLog InTry for free
English
English
  • Welcome
  • Getting Started
    • What is Biuwer?
    • Glossary
    • How to use Biuwer?
      • Sign Up process
      • Accessing Biuwer
      • Home page and navigation
      • My user Profile
      • Managing content
      • Exploring data
      • Filtering data
      • Collaborating with data
      • The Film Rentals space
    • How Biuwer works
    • Next steps
  • Managing Data
    • Introduction
    • Data Connections
    • Datasets
    • Data Models
  • Content Management
    • Introduction
    • Personal space
    • Shared spaces
    • Favourite content
    • Pages
    • Cards
      • Data Card Editor
      • Data queries
      • KPI card
      • Vertical Table Card
      • Cross Table Card
      • Chart Card
      • Map Card
      • Custom Card
      • Calculated fields
    • Filters
    • Multilanguage
  • Creating a Dashboard
    • What questions I want to answer
    • What data sources are there
    • Setting up data connections
    • Setting up datasets
    • Setting up data models
    • Create cards
    • Create the page
    • Setting up access security
  • Security Management
    • Introduction
    • Platform permissions
    • Roles
    • Object permissions
    • Permission inheritance
    • Property of objects
    • User access logs
  • Administration
    • Organization
      • 🎨Themes
      • 🎨Color palettes
    • Users
    • Groups
    • Roles
    • Authentication tokens
  • INTEGRATION GUIDE
    • Introduction
    • Concepts to take into account
      • Contents to integrate
      • Shared resources
      • Users
      • Groups of users
      • Authentication Tokens
      • Data Policies
    • How do I integrate Biuwer into my application?
      • Items to prepare
      • Content access security
      • Data access security
      • Embedding a resource in my application
    • Integration Types
      • Manual integration
      • Automated integration
Powered by GitBook
On this page

Was this helpful?

  1. Creating a Dashboard

Setting up datasets

PreviousSetting up data connectionsNextSetting up data models

Last updated 4 years ago

Was this helpful?

Up to this point, Biuwer can already connect to the database in this case, but to know about which tables, views or in general "data entities", we must obtain Datasets.

To do this, you have a very versatile tool called "Reverse Engineering", on the left side menu of the Data Center, which consists of Biuwer connecting to the data source, scanning all available data entities and displaying them on screen for you to choose the ones you need.

Continuing with the previous example, if we need data from the "film" table (where the details of all films are stored), we will configure the reverse engineering on the "Film rental DB" connection and the container in which the "film" table is located is "public". After pressing the "Read Datasets" button, available data entities are displayed.

Some tips to facilitate the use of reverse engineering:

  • You can use the "Select all" or "Deselect all" buttons to make the selection of required datasets and fields.

  • We recommend selecting only entities and data fields to be used, for cleanliness and order in the Data Center. You can always quickly add a field or an entire dataset at any time.

  • It is not possible to select data entities that are already imported into Biuwer and do not have additional fields not present in Biuwer.

Depending on the data source, there may be data types that are not supported by Biuwer. In this case it is not possible to select these fields and the message "Not Supported" will be displayed.

Creating a dataset from the reverse engineering functionality