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 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:
To create a project, click plus button in the upper-right corner on the BizDataX Portal home page, enter the Name and save.
Open created project's dashboard and on Data sources panel click gear button.
To create a data source, click the plus button in the upper-right corner.
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 MSSQL database, select
SQL Server as analyzer type and save.
To create an environment, click the plus button in the upper-right corner above the Environments grid that opens the 4-step wizard.
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.
Select schemas for import, and to proceed to the next step that is a table selection for the data model, click the Next button.
Select tables for import, and to proceed to the next step that is a columns import to the data model, click the Next button.
All columns from the selected tables are automatically imported. The environment is imported and ready for use.