Dataset Extractor tool

The extractor tool extracts the data set metadata from the installed technology packs.

The metadata that is extracted consists of dataset information that is exposed on XML files. These XML files are metadata repositories.

In addition to the XML files, the metadata consists of resource bundles or properties files that hold simple text values for dataset columns or parameters that are visible on Dashboard Application Services Hub UI. Internal processing is done by using column IDs or Parameter IDs but you can see simple text that is mapped in the properties files for the corresponding column or parameter ID.

Additionally, the metadata also contains binding or mapping of a dataset definition to a query definition. A query definition represents an implementation that interacts with any arbitrary database to fetch data. Currently, Tivoli® Netcool® Performance Manager Data Provider supports a subset of DataAccess API as the underlying query layer.

The Dataset Extractor tool is bundled with Tivoli Netcool Performance Manager distribution.

The Dataset Extractor tool is available at <DIST_DIR>/proviso/RHEL/DataView/RHEL<version_num>/misc/Dataset_Extractor folder.

Before you run the Dataset Extractor tool, you need to do the following steps:
  1. Copy the Dataset_Extractor/ folder from the Tivoli Netcool Performance Manager distribution path to a temporary folder.
    Note:
    • Any further references to this directory are made by using the token <TEMP_DIR>.
    • Do not place this <TEMP_DIR> folder within the JazzSM home directory.
  2. Extract the tnpmDatasetExtractor.tar file.
    For example: 
    
cd <TEMP_DIR>/Dataset_Extractor
tar -xvf tnpmDatasetExtractor.tar

    The dataset extractor tool is available after extracting the tar file.

  3. The following directories are created under <TEMP_DIR>/Dataset_Extractor folder
    
# ls <TEMP_DIR>/Dataset_Extractor
bin     
lib 
resources
    • bin/ folder contains the tnpmDatasetExtrator.sh that is used to run the Dataset Extractor tool.
    • lib/ folder contains the dataset extractor dependencies libraries.
    • resources/ folder contains the sample properties file required for Dataset Extractor tool.