Information protection is one of the common entry points for organizations getting started with information governance. Protecting sensitive data serves a clear business need, and protecting data is the goal of many current regulations. In this 2 part series we will start looking at the protection of data in this article by looking at the security of IBM Data Servers on z/OS. This will be followed by part 2 looking at audit and compliance.

Feeding a data warehouse with changes from the source database can be very expensive. If the extraction is only done with SQL, there is no way to easily identify the rows that have been changed. IBM InfoSphere Replication Server can detect changed data by reading only the database log. This article series illustrates how you can use InfoSphere Replication Server to efficiently extract just the changed data, and then pass the changes to IBM InfoSphere DataStage to feed the data warehouse. This is a two-part article series. In Part 1, get an overview of the products and how they can work together. In Part 2, explore two different integration options: with staging tables or with MQ messages.

Learn how to develop service components by combining pureXML, data Web services, and data objects and using a sample module project with WebSphere Integration Developer V7.

A short document to explain the main concepts of IBM Cognos 8 Dispatchers when routing requests.

This document describes how one can implement SSO to his Custom Java Authentication Provider by explaining the required concepts. This documents supplements SDK documentation.

This document provides an example of installing and upgrading TM1 9.5 including TM1 9.5 Server, TM1 9.5 Web, and TM1 9.5 Contributor. This example is performed on a Single Server running MS Windows XP 32-bit and using IIS and Apache Tomcat.

The IBM Data Server .NET Provider supports application development for IBM Informix. It is available for download as part of the Informix Client Software Development Kit (SDK). This article describes the two .NET providers that support .NET application development for Informix, and highlights the benefits of using the Data Server .NET Provider. The article also provides examples to help you quickly get started using the IBM Data Server .NET Provider.

The concept of shell sharing between Eclipse-based products means that you can share the core Eclipse components so that they are not duplicated between each Eclipse-based product. Shell sharing can save disk space, eliminate duplication of components, and enable products to interact with each other, making each product stronger than if it were run stand-alone. This article explains the process of sharing Eclipse shells between many different IBM products by showing an example of this using InfoSphere Data Architect (IDA), Optim Development Studio (ODS) and Optim Database Administrator (ODA).

Get an introduction to the various editions of IBM Informix, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease-of-use, reliability, stability, and access to extensibility features.

This document is intended as a guideline on how to use IBM Cognos 8 as a data source to build IBM Cognos 8 BI Transformer PowerCubes.

IBM Informix 4GL is a comprehensive development and production environment for creating sophisticated database applications. The 7.50.xC4 release of Informix 4GL includes direct support for file I/O without requiring function calls in another language such as C. This article describes the advantages of using the direct I/O support and provides you with an introduction to how you can use it with operations such as OPEN FILE, CLOSE FILE, READ, WRITE, and SEEK. The article includes code samples that can help you get started with implementing the file I/O feature in your own applications.

The IBM Enterprise Content Management Widgets (ECM Widgets) product is gaining traction in banking, insurance, health care, and many other fields. The ease of use and programming-free nature of the widgets enable business application developers to quickly produce content management applications. For industry solutions that require customized widgets, developers can build new widgets to meet their own business requirements. These customized widgets can be easily integrated into the ECM widgets environment by events wiring. In this article series, learn how to develop custom widgets to integrate them with four ECM widgets to build powerful solutions. Part 1 details how to use events of the In-basket widget and how to develop a role selector widget to work with the In-basket widget.

This article gives an end-to-end example of how an Open SQL query that handles arbitrary JOINS between SAP tables that are not known during coding time can be executed dynamically. You will learn how joins are done in Open SQL, how to specify the needed clauses of this statement during runtime, and how to dynamically create the target structure that is needed with the help of the RTTS (Run Time Type Services) API of ABAP. Specifying Open SQL conditions with joins during execution time has many applications, including when the queries are only known during runtime. Data extraction and data browsing of the SAP system are examples. In another example, specifying queries dynamically helps if the main application logic is not implemented in ABAP code but in a remote program. In this case, this article describes how only a small generic ABAP program is needed, and the SQL queries can be maintained externally.

pureQuery improves application throughput on DB2(R) for z/OS(R) by making it easy to deploy static SQL for Java(TM) for any new or existing application. For new applications, this can be accomplished by using the pureQuery DAO interfaces and annotated methods. The client optimization feature enables capture and bind of SQL in any Java application, including those using a framework. This article has been updated with the latest performance numbers from the Version 2.2 release of the Optim(TM) pureQuery Runtime.

Predictive analytics software helps you to find non-obvious, hidden patterns in large data sets. Current tools for predictive analytics, such as SPSS (an IBM company) and IBM InfoSphere Warehouse, expect data to be represented in an appropriate way before the actual analysis can take place. However, you may have cases where the data you want to analyze is not readily available in a format these tools can recognize. For example, SAP systems are widely used by many companies across a variety of industries, but data in SAP systems is not directly accessible to these tools. This article shows you how to use IBM InfoSphere Information Server to extract data from SAP systems for analysis within InfoSphere Warehouse and SPSS PASW Modeler.

A IBM Cognos 8 SDK application that provides enhanced auditing for IBM Cognos 8 BI. The version of the application is 1.5.05 and it will work with IBM Cognos 8 BI versions 8.3 and up.

The Rapid Deployment Package (RDP) for IBM InfoSphere Master Data Management Server solution addresses the needs of clients in the first phase of implementing initial load solutions. Using MDM, clients need to perform initial and delta loads, typically as a batch. This article focuses on the RDP Direct Load approach using Information Server 8.0.1 to perform the initial data load for an MDM server solution running InfoSphere MDM Server Version 8.0.1. In addition to the introduction, installation, and setup for this approach, the article also provides performance tuning tips and best practices. You can use the recommendations provided in this article as guidance while developing your own MDM Server initial load solutions using the RDP Direct Load approach.

In this article, learn how you can use a user exit to extend Optim Performance Manager to integrate DB2 for Linux, UNIX, and Windows database monitoring with enterprise monitoring systems, using the Simple Network Management Protocol (SNMP) for system and network monitoring. The user exit is a simple general purpose mechanism that can be configured to call any executable program making it possible for you to use DB2 database performance alerts in a wide variety of ways.

This document describes an approach that can be used to dynamically sort on a Numerical Column.

Before you can implement any information-centric project like archiving, data privacy, master data management (MDM), data warehousing, data lineage, or application data consolidation, you have to know what data you have, where it is located, and how it is related between systems. For most organizations, the data discovery and analysis process is very manual, requiring months of human involvement to discover business objects, sensitive data, cross-source data relationships, and transformation logic. In this article, learn how IBM InfoSphere Discovery provides sophisticated analysis to automate the analysis process and generate actionable results.