balm_bulk_insert_2

1. Description

Balm_bulk_insert is used to clean data for given asondate and load balm aggregators aggregated output data to required 13 BALM tables(inflow/outflow/producttotals) present in ORACLE/MSSQL DB depending on data-type parameter type. Note: The data-type can be DIM(uploads to DimMasterInflowN,DimMasterOutflowN and DimMasterProductTotals), WODIM(uploads to MasterInflowN, MasterOutflowN and tblProductTotals), CONV_WODIM(uploads to MasterInflowConvertedN, MasterOutflowConvertedN and tblProductTotalsConverted) and CONV_DIM(uploads to DimMasterInflowConvertedN,DimMasterOutflowConvertedN and DimMasterProductTotalsConverted).

2. Program location

<installation_path>/balm_bulk_insert

3.Screen Configuration

3.1 Select Stream dependancy

Select all the stream dependancies for which you need to load the data.

3.2 Select the loader type

Select the type of loader you want to use. For ex,select Balm loader for loading output of balm_aggr. Similarly select any other loader depending on the type of data you want to load.

3.3 Process Config Fields

Here select the source lists for which the aggregated outputs has to be loaded.

3.4 Process Arguments

Here enter the process arguments to be passed to the program. The mandatory and non-mandatory fields are given below.

3.4.1 Mandatory Parameters

#	Parameters	Description	Example
1	connection_string	Balm database connection string	Click-Here

3.4.1.1 Connection String

Connection strings for different Databases are given below:

3.4.1.2 MSSQL

      "{
        "db": "MSSQL",
        "schema": "dbo",
        "username": "sa",
        "password": "Surya@123",
        "server": "localhost",
        "dbname": "TestDB",
        "options": {
          "t": "1"
        }
      }"

3.4.1.3 Oracle

    {
    "db": "ORACLE",
    "schema": "BALM_BOC",
    "username": "BALM_BOC",
    "password": "Surya123",
    "server": "192.168.66.193:1521/orcl"
    }

3.4.1.4 Postgres

    "{
      "db": "POSTGRES",
      "schema": "public",
      "username": "postgres",
      "password": "surya123",
      "server": "localhost",
      "dbname": "postgres",
      "options": {
        "t": "1"
      }
    }"

3.4.1.5 Description

#	Parameters	Desc
1	db	Specifies the database type
2	schema	Defines the database schema
3	username	The username for authenticating the database connection
4	password	The password associated with the username for database authentication.
5	server	The server address or hostname where the database is hosted
6	dbname	The name of the database to connect
7	options	Additional connection options

3.4.2 Non Mandatory Parameters

#	Parameters	Description	Default value	Example
1	log_level	Level of diagnostics written to the log file.	info	error/warn/info/debug/trace/none
2	per_diagnostics_flag	The flag that decides whether performance diagnostics will be written to the diagnostics log file.	false	true or false
3	terminator	Separator used in between columns.	|
4	rowterminator	Terminator used in between rows.	0x0a

4. Output

4.1 Healthcheck report-1 to 13

13 healthcheck report will be generated at the data_file path for each of the 13 tables (inflow/outflow/producttotals).