Skip to main content

Create Dataset using View option

What is View?​

  • A view is a database object that has no values. Its contents are based on the base table. It contains rows and columns similar to the real table. You can use views to hide table columns from users by granting them access to the view and not to the table itself.

Prerequisites​

  • To create dataset by creating view in MySQL. User needs to work with MySQL Workbench.
Note:

To know more in detail about how to create View in MySQL Click here

  1. Log in to AIV using your respective credentials.

  2. Go to Hamburger Menu Docusaurus Slash Introduction > MasterData > Dataset.

    Docusaurus Slash Introduction

    Docusaurus Slash Introduction

  • To know more in details about Dataset Section Click here .
  1. User can create dataset using 2 options:-

I. From the Footer Menu

Docusaurus Slash Introduction

II. From the Context Menu

Docusaurus Slash Introduction

  1. Click on Create Dataset option & your screen will look as per below image.

    Docusaurus Slash Introduction

Note

To know more about terminology of General tab Click here

  1. Enter the details in Create Dataset window as per below:-
  • Name: Demo Dataset (user can select name as per their requirement)
  • Source: Select aiv from drop-down (same name as you set it when you are creating database connection)

  1. In Datasource option JDBC is selected by default.

    Docusaurus Slash Introduction

  2. Write Query in Query window as given below:

  3. For this example we used below given query.

Query

SELECT * FROM customersview;

Docusaurus Slash Introduction

  1. Click on Preview button & it will show the output as per the image below:

    Docusaurus Slash Introduction