Portal Corporativo de Input Ouput Soluciones Informáticas, SL

Noticias del sector
IBM developerWorks : Information Mgmt : Articles
The latest content from IBM developerWorks

IBM Cognos Proven Practices: PowerPlay Transformer Model Check List Guidelines on what to check when preparing and reviewing a Transformer model pre-production. IBM Cognos Proven Practices: Guidelines to Special Consolidation Structures in IBM Cognos Controller How to setup and configure Z Consolidation Method. Cognos cloud best practices: Choosing the settings to enable high availability The goal of high availability is to provide a backup mechanism to transfer requests and data processing to a standby system in the event of primary system failure, but user and system requirements vary, meaning there is no one ideal configuration. This article provides a number of recommendations for setting up and maintaining the Cognos solution for high availability and for disaster recovery. Monitoring in DB2 9.7, Part 1: Emulating data reset with the new DB2 9.7 monitoring table functions This article describes a simple method for performing a per-session reset of monitoring data returned from various monitor table functions in IBM DB2 for Linux, UNIX, and Windows. The behavior is functionally equivalent to the reset capability available in the DB2 system monitor snapshot APIs. The article includes a download with two scripts that you can use to implement this method for a number of the new monitoring table functions introduced in DB2 Version 9.7. The focus of the article is the new monitor table functions introduced in DB2 Version 9.7, but you can easily apply the same method to other table functions in DB2 that report monitoring data. IBM Cognos Proven Practices: Benchmarking your IBM Cognos 8 Environment using IBM Cognos Upgrade Manager During the lifecycle of your IBM Cognos 8 application you may need to update IBM Cognos 8 with a Service Pack, Fix Pack, hotsite or other IBM Cognos updater. This document can be used to provide a guided approach. IBM Cognos Proven Practices: Dynamic Sorting of a List within IBM Cognos 8 Report Studio A technique which applies dynamic column sorting on a list using custom IBM Cognos 8 Report Studio toolbox items. Running a successful project with the InfoSphere Master Data Management Workbench This article teaches you how to run a project using the IBM InfoSphere Master Data Management (MDM) Workbench. It explains each of the components of the workbench and defines the recommended approach for using the MDM workbench on a development project. This recommended approach is based on best practices that have been created by the MDM Workbench architects and draws on experiences from successful projects that have used the MDM workbench. The article also includes useful tips that your development team can use to configure the MDM Workbench for maximum performance. Selected common SQL features for developers of portable DB2 applications This summary of the common SQL application features is a quick reference for application developers who need to understand the frequently used features and functions across platforms. Integrate third-party widgets with IBM ECM Widgets, Part 2: Using the Content List widget to display documents and to change search events There are numerous enhancements in the IBM ECM Widgets 4.5.2 release, including the Content List widget event enhancements. The new events enable displaying documents, changing the search, requesting selected rows, sending selected rows, and creating custom actions. This article, the second in the series about integrating third-party widgets, describes how you can use the new events in the Content List widget to add value to your business. Intelligent solutions get even smarter with IBM Real-Time Asset Locator IBM recently introduced software to help organizations optimize their use of critical physical assets by integrating asset location tracking technologies with powerful IBM Tivoli asset management software. IBM Real-Time Asset Locator is one of those new products. Coupled with IBM Maximo Asset Management, IBM Real-Time Asset Locator can help you leverage location tracking sensor data and bring intelligence and visibility to aspects of your business that were previously not directly monitored in near real time. This article looks at the IBM Real-Time Asset Locator and its integration with Maximo Asset Mangement to see how the products interoperate and how they establish the foundation on which business solutions can be built. Cognos cloud best practices: Moving from a single- to a multiple-image topology Just like in a traditional data center, the deployment of Cognos into the cloud may require multiple machines, so your cloud solution may require multiple images. Criteria such as performance, scalability and high availability typically lead to a multi-image topology. The authors demonstrate the best practices for managing this type of multi-image topology. SAP Cookbook For IBM Cognos 8 BI This document is intended to provide a single point of reference for techniques and product behaviours when dealing with SAP BW as a data source in IBM Cognos 8 BI. DB2 for z/OS best practices: Partitioning DB2 for z/OS tablespaces DB2 for z/OS partitioning has a primary motivation of increasing data availability and throughput. Release changes to DB2 have made manageability even easier, but a DB2 DBA still needs to initially size for space and size for managability. The focus of this article is about right-sizing DB2 partitions to allow not only for throughput and parallelism, but also for maintenance and object manageability. Mashups, beyond reporting Developers of all kinds may occasionally find a need to build an application that makes simple updates to a database table. This article describes how to build an IBM Mashup Center widget that can display an HTML form that lets users update relational database tables. Optionally, you can quickly create your own mashup page by simply using the downloadable sample widget as is and supplying your own HTML form. IBM Cognos Proven Practices: Installing & Configuring IBM Cognos Controller 8.5 Server Guidelines to installing and configuring IBM Cognos Controller 8.5. Process your DB2 for i indexes in parallel With DB2 for i, parallel processing is useful for more than just queries. Batch processing, data loads, and index builds can all occur much faster if you use multiple processors to do that work. [2010 Aug 19: The author updated this article with content based on enhancements in DB2 for i Version 7.1. --Ed.] Generating XML from the Informix server This article describes how to use the extensibility features of IBM Informix to generate XML-formatted data. Sample code is included. IBM Cognos Proven Practices: Authenticate to IBM Cognos 8 Based on Flat Files This package contains a simple Custom Java Authentication Provider based on flat files. It's very handy for off-line setups or test installs, doesn't require any other 3rd software. User Pass-through Authentication with IBM Cognos 8 This document provides backgrounds and concepts required to understand the user pass-through (SSO to databases) possibilities of IBM Cognos 8. Its purpose is to supplement product documentation and explain the possibilities and limitations. Logging Console and Monitoring This document describes how to use the Cognos Logging Console. IBM Cognos Proven Practices: Access Reporter for Series 7 Version 4 (cer5) Access Reporter is a utility that will audit the access permissions on all objects within the Upfront datastore as well as provide all user memberships within the Series 7 namespace. Get started with advanced query statistics in OmniFind Enterprise Edition Learn about advanced query statistics, a new feature introduced in IBM OmniFind Enterprise Edition V9.1, based on query log index technology. This new feature offers access to three critical types of statistical information about searches executed using OmniFind: changes in query activity over time, popular queries issued by users, and query history. By monitoring and analyzing these statistics, you can gain insights that enable you to enhance search performance and improve the quality of search results. Accelerate Hibernate and iBATIS applications using pureQuery, Part 1: Using the IBM Integration Module for Hibernate and pureQuery When extended with the downloadable IBM Integration Module, the IBM Optim pureQuery Runtime simplifies the process of generating DB2 static SQL for Hibernate and iBATIS applications. It does this without requiring you to make changes to your application code or to gather SQL from production workloads. The Optim pureQuery Runtime also enables Hibernate and iBATIS applications that access DB2 or Informix to benefit from the heterogeneous batching feature in pureQuery. With the heterogeneous batching feature, you can batch multiple INSERT, UPDATE, and DELETE requests before sending them across the network, even when the requests reference multiple tables. This article is part one of a two part series. It describes using the IBM Integration Module with Hibernate applications. Part two will focus on iBATIS applications. This article includes a downloadable sample application that illustrates how you can easily enable both these capabilities. The article also provides informal elapsed time performance measurements. Querying and reporting on XML data sources in IBM Cognos 8 using IBM Cognos Virtual View Manager XML is increasingly becoming common as a means for information exchange. A web service application is an example of the type of application that uses XML to exchange information. Any business intelligence product or solution must have sufficient capability to query information that could be in the form of XML. Learn how IBM Cognos 8 delivers a comprehensive, flexible, secure, and scalable solution to query and report on XML data sources, including web services, by leveraging the IBM Cognos Virtual View Manager. IBM Cognos Proven Practices: Using JavaScript to Pass Multiple Values to a Textbox Prompt within IBM Cognos 8 Report Studio This technique uses JavaScript to allow a user to pass multiple values provided to an IBM Cognos 8 Report Studio textbox prompt. IBM Cognos Proven Practices: Customising the IBM Cognos 8.4.x UI This document provides some tips and techniques when creating a custom style (or "skin") in IBM Cognos 8.4.x. Integrate IBM FileNet Business Process Manager and IBM Content Manager using IBM WEBi as a widget Many companies need an out-of-the-box solution for integrating IBM FileNet Business Process Manager (BPM) and IBM Content Manager V8 (CM8). Today, using new capabilities provided by IBM Enterprise Content Management Widgets (ECM Widgets) 4.5.2 and IBM WEB Interface (WEBi) 1.0.4, IBM's Enterprise Content Management products bring you an easy way to integrate BPM and CM8 at the runtime tier. Using these new features, enterprise business analysts can manage their business processes using CM8 content without having to invest any additional development effort. This article describes the business background, the architecture, and the procedures for integrating BPM and CM8 repositories at runtime. IBM technology in the financial markets front office, Part 2: Invoke conditional business rules based on analyzing data streams This second article in the series focuses on the integration of InfoSphere(TM) Streams and WebSphere(R) ILOG(R) JRules. InfoSphere Streams is a high-performance stream processing engine that is capable of performing calculations and analysis of data streams in real time. ILOG JRules is a business rules management system that enables the creation of rule-based applications. This article presents a simple, algorithmic trading scenario in which InfoSphere Streams operate on a stream of market data and, under certain circumstances, a business rule is invoked using ILOG JRules. In order to perform this task, you will learn how to integrate the two products together in an efficient manner. Information protection, Part 2: Audit and compliance 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 2008, the average cost of a data breach to an organization was $6.5M - and these only represent the ones that were found. Most of these breaches were internal. Feature: Industry Focus: Energy and Utilities The story of a team of IBM data architects tasked with creating data models for the Model City Mannheim smart grid project. The team built on the existing International Electrotechnical Commission (IEC) Common Information Model (CIM), finding ways to match new smart energy grid concepts and needs with existing model definitions, and in some cases proposing ways to expand the model. Smarter is: Delivering social services where they're needed most Alameda County Social Services Agency uses IBM DB2, InfoSphere Identity Insight Solutions, and Cognos to implement a Social Services Integrated Reporting System that helps generate the information that the agency needs to continue to qualify for state and federal funding. The solution also helps reduce waste and direct resources where they are most needed. Programmers Only: Reducing Conversations with DB2 for z/OS: Part 3 Are you following best practices in your programming methods? Bonnie Baker offers up more examples of bad SQL habits that need to be broken to help eliminate or reduce conversations with DB2 for z/OS, including removing unnecessary re-reads Cover Story: Maintenance Makes Money Here are five ways to reduce costs and improve performance by paying attention to database detail. Database maintenance means more than just cleaning up--it's about understanding the specific platform that your database runs on, and taking advantage of new technologies. News Bytes: IBM Data Management magazine, Issue 3 2010 Get the latest data management news, including the new IBM pureScale Application System, Smart Analytics System, DB2 SQL Skin for Sybase ASE, new Informix Editions, SPSS Decision Management software, InfoSphere BigInsights, and a new look for IDUG. Informix DBA: Building Fast Data Warehouse Schemas: Part 2 Lester Knutsen shows how to design dimension tables in part two of a three-part series on data model and schema design for data warehouses. IIUG User View: Big News for Informix Stuart Litel explains how the new editions of Informix relate to each other, reports on the success of the spring 2010 IIUG Informix Conference, and gives a preview of coming events at the IBM Information on Demand 2010 Global Conference. Feature: InfoSphere Guardium This article describes the technical details of IBM InfoSphere Guardium, a solution for real-time database activity monitoring and protection. Existing information security solutions often leave databases vulnerable to advanced hacking techniques and insider attacks. InfoSphere Guardium automatically monitors database transactions and can respond in real-time to access policy violations. Embedded Informix: Think Inside the Box A discussion of the reliability and performance characteristics of Informix that make it an excellent candidate for use as an embedded database server, and a walkthrough of creating an embedded deployment. Informix provides features--such as the Deployment Wizard and Deployment Utility--that simplify the creation of a deployment optimized for an embedded environment. Distributed DBA: Creating and Using Partitioned Tables Why, where, when, and how to partition tables in DB2 for Linux, UNIX, and Windows. IDUG User View: Real-Life DB2 Superheroes Dave Beulke reports on the IDUG 2010 North America conference, including new features for DB2 10 for zOS, migration stories from users moving from Oracle to DB2, and improved XML functions in DB2 9.7 for Linux, UNIX, and Windows Data Architect: You Want to Govern What? Robert Catterall is a database guy, and he needs to be convinced of the need for data governance. With help from Steven Adler, director of Information Governance Solutions at IBM, he explores the tenets of data governance and discusses how it can help database teams. Information protection, Part 1: Information security 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. High-performance solution to feeding a data warehouse with real-time data, Part 1: Integrate InfoSphere Replication Server and InfoSphere DataStage 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. IBM Cognos Proven Practices: IBM Cognos 8 BI Dispatcher Routing Explained A short document to explain the main concepts of IBM Cognos 8 Dispatchers when routing requests. IBM Cognos Proven Practices: Adding Single Sign-On to your IBM Cognos 8 Custom Java Authentication Provider This document describes how one can implement SSO to his Custom Java Authentication Provider by explaining the required concepts. This documents supplements SDK documentation. Using pureXML in SCA component development with WebSphere Integration Developer V7 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. IBM Cognos Proven Practices: IBM Cognos TM1 9.5 Quick Install and Upgrade Guide 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. Compare the Informix Version 11 editions 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. Get started with the IBM Data Server .NET Provider for Informix 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. Shell sharing with InfoSphere Data Architect, Optim Development Studio, and Optim Database Administrator 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).