Setting up datasets
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.
Creating a dataset from the reverse engineering functionality
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.