Exporting analysis results

Use IBM® InfoSphere® Information Analyzer to export analysis information into InfoSphere Optim™ and InfoSphere Guardium®.

Before you begin

You must have InfoSphere Information Analyzer Business Analyst or InfoSphere Information Analyzer Data Steward privileges.

You can export IBM InfoSphere Information Analyzer analysis results by using command line interface of the InfoSphere Information Analyzer client. These results are used by InfoSphere Optim and InfoSphere Guardium.

Procedure

Export the analysis results into Optim using the following script, <InformationServer-Home>/ASBNode/bin/IAAdmin
- getExportForOptimResults -projectName <ProjectName> [-output <output zip file name>] [-dataClassConfidenceThreshold <dataClassConfidenceThreshold>
  You can export the analysis results like data classification, primary key and foreign key relationships of all the columns and tables of a project into a format that can be used by the InfoSphere Optim.
  
  The specified output file must be a zip file if you specify the output option. If the output option is not specified, the export result is output to the <ProjectName> .zip file in your current working directory.
  The Zip file contains the following three files:
  1. <Project Name>.ddm file that contains the data classification information of all the columns in a project.
  2. <Project Name>.dbm file that conatins column analysis, data classification and primary key, and foreign key relationships of all the tables and columns in a project.
  3. <Project Name>.txt file that contains the relationship among the tables in a project.
Export the analysis results into Guardium using the following script, <InformationServer-Home>/ASBNode/bin/IAAdmin
- getExportForGuardiumResults -projectName <ProjectName> [-output <output csv file name>] [-dataClassConfidenceThreshold <dataClassConfidenceThreshold>
  getExportForGuardiumResults command generates a csv file that contains data classification information of all the columns in a project.
  
  The percentage of data that must match the properties of the data class. The percentage is an integer value. For example, suppose that the threshold of a data class that is assigned to a database column is set at 0.75. In this case, 75 per cent of the data in the database column must match the data class for InfoSphere Information Analyzer to analyze data in the database column.
  
  You can export the data classification information of all the columns in to a format that can be used by InfoSphere Guardium.
  
  If the output option is specified, the specified output file must be a csv file. If the output option is not specified, the export result is output to the <ProjectName> .csv file in your current working directory.
  
  Note: A default value of 0.75 is used for dataClassConfidenceThreshold, if not specified in the command.