Integration of IBM InfoSphere Guardium reports with Business Intelligence tools
AlexanderIrrgang 270002HYVX Visits (3004)
This article describes the facilities IBM InfoSphere Guardium provides for integration with Business Intelligence products. Specifically the availability of reports on mobile devices is limited and direct access via mobile devices to the Guardium appliances weakens the overall security concept. Hence, a logical step is to export the data, analyze it with existing Business Intelligence solutions, e.g. IBM's Cognos Business Intelligence, and provide custom reports to mobile end devices. This approach guarantees the integrity of the database activity monitoring environment as well as the accessibility of essential reports.
Todays society relies greatly on mobile devices and the availability of data. One can increasingly observe this trend beginning to enter management levels. Being able to make decisions based on mission critical reports anywhere and anytime enables organizations to quickly adapt to their opportunities.
IBM's InfoSphere Guardium protects the information infrastructure of a company and gathers data to report on. Leveraging Business Intelligence suite's advanced analytics features and mobile provisioning, IBM InfoSphere Guardium data becomes part of an all-encompassing reporting in the organization.
InfoSphere Guardium integration with Business Intelligence suites
The big picture covers four layers of software and hardware in the organization describing how these products integrate.The figure shows this architecture. InfoSphere Guardium monitors and audits the existing information architecture consisting of database servers and enterprise applications. The data gathered is exported to a Business Intelligence suite's data source and can be reported on. These reports can then be provisioned to desktops and mobile devices.
InfoSphere Guardium's data can be exported as a CSV file per report. These files must then be loaded into a data source compatible with the Business Intelligence suite.
Exporting data with InfoSphere Guardium and loading it into a data source
InfoSphere Guardium conveniently offers facilities to export gathered data as CSV files. The basic steps are:
Steps one to four can be read up in the InfoSphere Guardium documentation and are basic configuration work. However step five requires some software to discover exported files, to analyze the schema of the files and to finally import them into a data source.
The InfoSphere Guardium team for software services can offer such a solution involving only a remote host running Linux with Perl and a set of modules installed. Linux monitors the file system for incoming reports by means of dnotify or inotify and executes a Perl script upon arrival. The script then analyzes the report's structure, extracts the relevant columns and loads the data into any supported relational database system. By using Perl's DBI modules, common databases such as DB2, Oracle, Microsoft SQL and many more are supported as data sources.
IBM's software services team has a ready-to-deploy solution for easy integration of InfoSphere Guardium and Cognos Business Intelligence at hand. With minimal efforts you will be able to incorporate security reports into your existing reporting structure and leverage mobile access to these reports.