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:
- <Project Name>.ddm file that contains the
data classification information of all the columns in a project.
- <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.
- <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.