Creating a data source

This page explains how to create a data source, which can consist of one or more environments.

Table of contents
Create a data source
      Analysis settings
List of data sources

Create a data source

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

Data sources Figure 1: Data sources

The first step is entering the basic information about the new data source, or updating the existing information if editing the data source. The following information can be entered:

  • Name - data source name, must be unique.
  • Namespace - it will be automatically generated using data source name during creation process and used in BizDataX Designer after Portal data import. Once created, namespace name cannot be changed.
  • Analyzer type - the type of the database analyzer.
    Each database technology is represented by a data source analyzer. Users can select one of the installed data source analyzers that match the desired database technology.
  • Analysis settings - custom settings that refine the analysis process.
    After selecting the analyzer type, the information about supported settings is displayed, which can be used to fill the analysis settings field.
  • Note - note or a comment.

Create data source Figure 2: Creating a new data source

Depending on the type of database whose metadata you want to import, you will have to choose an appropriate BizDataX data source analyzer type. Make sure to use the correct data source analyzer or the import process will fail.

Analysis settings

Different settings are available depending on the type of analyzer selected and explained on the screen displayed in Figure 1. Here are mentioned some additional specifics.

Multiple analysis settings are specified using ;.

countrecords=stat
Before using this setting, it is recommended to update the database statistics. Updating the statistics for databases can be found on the following links:

Oracle
https://docs.oracle.com/database/121/CCAPP/GUID-E4F013A8-E83C-44AF-B9A4-CA1FBF717730.htm#CCAPP9634

Informix
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_14.1.0/com.ibm.sqls.doc/ids_sqs_1278.htm

MSSQL
https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver15

DB2
https://www.ibm.com/support/producthub/db2/docs/content/SSEPGG_11.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001980.html

Sybase
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36272.1550/html/commands/CIHFHDEF.htm

sample
Besides this setting, there is also something called sample size and it is used in discovery rules. Performance and quality of the data can also be affected by the sample size which can be set during the creation of the discovery rules. The default options in both of these settings are the recommended settings which should work well with most database tables.

List of data sources

All data sources currently contained in the project can be viewed on the data sources list, the landing page of the data sources functionality. It contains a table detailing every data source of the project. Only basic information are shown so you can identify a data source at a glance.

Data source list Figure 3: Data sources list

In the menu on the right available options are:

  • View data source details
  • Edit data source
  • Delete data source

Use checkboxes to delete multiple sources at once.

Deleting the data source will permanently delete all related data – environments, rules and findings.