Creating a data model (BizDataX Portal)

Creating a data model on BizDataX Portal includes the import of schemas, tables, and columns to BizDataX Portal.

The data model is created in the BizDataX Portal database after retrieved via the connection string, and it is used when searching for sensitive data, creating a masking flow, and executing packages.

Table of contents
Import to BizDataX Portal

Import to BizDataX Portal

Import to BizDataX Portal is a prerequisite for import into the BizDataX Designer. To import schemas, tables, and columns to BizDataX Portal, open the BizDataX Portal and do the following:

  • Create project
  • Create data source
  • Create environment

To create a project, click plus button in the upper-right corner on the BizDataX Portal home page, enter the Name and save.

New project

Open created project's dashboard and on Data sources panel click gear button.

Manage data sources

To create a data source, click the plus button in the upper-right corner.

New data source

Enter the Name and select the Analyzer type.
Analyzer types versions selected during the installation of the BizDataX Portal are now offered. Since this guide uses an Microsoft SQL Server database, select SQL Server as analyzer type and save.

Create data source

To create an environment, click the plus button in the upper-right corner above the Environments grid that opens the 4-step wizard.

New environment

Enter the Name and Connection string.
An example is Data Source=.;Initial Catalog=BizDataXDemo;Integrated Security=True.
To proceed to the next step that is a schema selection for the data model, save changes.

Create environment

Select schemas for import, and to proceed to the next step that is a table selection for the data model, click the Next button.

Import schemas

Select tables for import, and to proceed to the next step that is a columns import to the data model, click the Next button.

Import tables

All columns from the selected tables are automatically imported. The environment is imported and ready for use.

Import columns