Skip to content

developerWorks : Information Management : Technical library : Articles
Syndicate content developerWorks
The latest content from IBM developerWorks
Updated: 4 hours 17 min ago

IBM Cognos Proven Practices: IBM Cognos TM1 9.5 Quick Install and Upgrade Guide

Fri, 07/23/2010 - 05:00
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.
Categories: Companies, DB2

Get started with the IBM Data Server .NET Provider for Informix

Thu, 07/22/2010 - 05:00
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.
Categories: Companies, DB2

Shell sharing with InfoSphere Data Architect, Optim Development Studio, and Optim Database Administrator

Thu, 07/22/2010 - 05:00
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).
Categories: Companies, DB2

Compare the Informix Version 11 editions

Thu, 07/22/2010 - 05:00
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.
Categories: Companies, DB2

IBM Cognos Proven Practices: IBM Cognos 8 as a Data Source for Transformer

Tue, 07/20/2010 - 05:00
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.
Categories: Companies, DB2

Using dynamic Open SQL to perform joins on SAP transparent tables

Thu, 07/15/2010 - 05:00
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.
Categories: Companies, DB2

Get started with direct file I/O support in IBM Informix 4GL

Thu, 07/15/2010 - 05:00
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.
Categories: Companies, DB2

Integrate third-party widgets with IBM ECM Widgets, Part 1: Integration with the In-basket widget

Thu, 07/15/2010 - 05:00
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.
Categories: Companies, DB2

IBM Optim pureQuery Runtime for z/OS performance

Thu, 07/15/2010 - 05:00
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.
Categories: Companies, DB2

Predictive analytics on SAP with SPSS and InfoSphere Warehouse

Thu, 07/08/2010 - 05:00
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.
Categories: Companies, DB2

IBM Cognos Proven Practices: IBM Cognos 8 Audit Extension

Mon, 07/05/2010 - 05:00
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.
Categories: Companies, DB2

Loading a large volume of Master Data Management data quickly, Part 2: Using Rapid Deployment Package direct load with InfoSphere MDM Server

Thu, 07/01/2010 - 05:00
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.
Categories: Companies, DB2

Use Optim Performance Manager with Simple Network Management Protocol

Thu, 07/01/2010 - 05:00
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.
Categories: Companies, DB2

IBM Cognos Proven Practices: Dynamic Sort on a Numerical Column in IBM Cognos 8

Tue, 06/29/2010 - 05:00
This document describes an approach that can be used to dynamically sort on a Numerical Column.
Categories: Companies, DB2

IBM InfoSphere Discovery: The next generation of data analysis

Tue, 06/29/2010 - 05:00
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.
Categories: Companies, DB2

Tune IBM InfoSphere Streams 1.2 with InfiniBand for high performance

Thu, 06/24/2010 - 05:00
The new IBM InfoSphere Streams transport that uses IBM WebSphere MQ Low Latency Messaging provides access to InfiniBand communication links. These offer much higher throughput than, for example, 1Gb ethernet, but this higher throughput is not always achieved in practice, for a variety of reasons. I set out to explore what performance was actually available on InfiniBand when using InfoSphere Streams, and what improvements in performance could be achieved through tuning of the application, WebSphere MQ Low Latency Messaging, and the system. In the process of performing numerous experiments with different configurations and other tuning adjustments, I found that throughput could be increased more than 10 fold under some circumstances.
Categories: Companies, DB2

What's new and cool in Optim Development Studio, Part 2: Exploring Optim Development Studio and pureQuery Runtime Version 2.2 Fix Pack 3

Thu, 06/24/2010 - 05:00
New capabilities in Fix Pack 3 of IBM Optim(TM) Development Studio and pureQuery Runtime 2.2 provide significant enhancements in security, control, and maintenance for database administrators who use pureQuery client optimization to improve security, stability, and performance of Java database applications. The enhancements are based on a new central repository for storing pureQuery metadata and properties. This article uses a scenario to illustrate some of the new capabilities made possible with Fix Pack 3.
Categories: Companies, DB2

Developing Java components for the FileNet P8 Component Integrator

Tue, 06/22/2010 - 05:00
This article shows you how to develop Java components for the FileNet Component Integrator. The Component Integrator is part of the IBM FileNet Process Engine. It enables you to call functions of a custom Java class from a component step within a workflow. The article describes how to obtain sessions, debug your Java code, and build and configure a custom JAAS login module for database connectivity.
Categories: Companies, DB2

IBM Cognos Proven Practices: How to Install the IBM Cognos Controller 8.5 Client on a User's PC

Mon, 06/21/2010 - 05:00
This document demonstrates how to install the Controller 8.5 client on an end-user's PC, inside a typical environment. By following these "best practices" the intention is to make client deployment as easy as possible, with the minimum of errors or issues. Later, this document gives best practices for Citrix server client installation.
Categories: Companies, DB2

IBM Cognos 8 SDK Application To Merge Reports

Mon, 06/21/2010 - 05:00
A IBM Cognos 8 SDK application that merges reports created against the same package.
Categories: Companies, DB2