Archive for the ‘IBM: DB2 Tutorials’ Category

Automate small footprint, embedded Informix Dynamic Server deployments

Thursday, March 11th, 2010

Source

This tutorial shows you how to automate IBM Informix Dynamic Server (IDS) small footprint deployments by using
the IDS deployment utility and the IDS embeddability toolkit.
An important requirement of an embedded database system is that it be invisible to end users and administrators.
IDS is a perfect database system for application
environments that require an embedded database
because you can install, deploy, and administer the database silently.
It is transparent to users that there is a robust and
reliable database system catering to the database requirements of the application.

Scoping the IBM Industry Model for banking using Enterprise Model Extender and InfoSphere Data Architect

Friday, March 5th, 2010

Source

Learn how the process of scoping can yield business objects that will
guide you to developing a meaningful logical data model. This tutorial uses
IBM Enterprise Model Extender with IBM InfoSphere Data Architect to illustrate
the scoping process.

Using Cognos 8 BI with Rational Portfolio Manager

Thursday, February 4th, 2010

Source

This tutorial provides a sample scenario that shows how to create reports by using IBM Cognos 8 Business Intelligence software suite with the Open Data Access tool in Rational Portfolio Manager. Open Data Access is a new feature that provides an easier to understand database model to help you create reports.

Deploy your database applications and projects on the cloud

Friday, January 29th, 2010

Source

Cloud computing is an increasingly popular paradigm that can significantly accelerate development and prototyping cycles.
In this tutorial, you will learn how you can easily deploy your database applications and projects on the cloud in just minutes using IBM DB2 data
server and Amazon Elastic Compute Cloud (EC2). No prior cloud computing or DB2 experience
is necessary.

Introducing entity subtypes in IBM InfoSphere Master Information Hub

Friday, January 29th, 2010

Source

In this tutorial, learn how to implement entity subtypes and supporting
services for IBM InfoSphere Master Data Management Server and InfoSphere
Master Information Hub. Using an entity subtyping framework allows you to
introduce new entities that may be processed by the services of their parent
entities, which helps achieve service interoperability and extensibility for a
new domain created using Master Information Hub.

Text Analysis Perspective for IBM InfoSphere eDiscovery Analyzer V2.1.1

Friday, January 15th, 2010

Source

Gain an understanding of Text Analysis Perspective and its integration
with IBM InfoSphere eDiscovery Analyzer, Version 2.1.1. With this feature, you
can quickly and easily configure simple text analysis engines and deploy them
to IBM InfoSphere eDiscovery Analyzer. This tutorial discusses the
installation steps and procedures required to deploy the text analysis engine
as a new facet in IBM InfoSphere eDiscovery Analyzer using a sample
scenario.

Manipulate CSV data with Python and pureXML

Tuesday, December 22nd, 2009

Source

IBM DB2 pureXML allows you to store XML data natively in a relational database management system, giving you the power and flexibility to report on this data without disturbing the advantages that its XML format offers. In this tutorial, you will learn how to connect to a DB2 database from the Python programming language, importing data about population from the United States Census Bureau. You will use Python to convert this CSV file into XML, before inserting this XML data natively into DB2. Finally, you will use Python to create a command-line application that produces some informative tables that you can access through a menu system.

Develop a store locator application using IBM DB2 pureXML and ASP.NET

Tuesday, December 8th, 2009

Source

In this connected and open world, where data flows freely, you can find a
vast amount of useful information on the Web. In the past, if you wanted to find
the location of the nearest store for your favorite retailer, you probably looked
it up in the telephone directory, found the company's phone number, called them,
and asked for directions to their nearest outlet. This method is a recipe for getting lost, wasting time, and a general frustration for the customer. Today, however, this has all changed. Now you simply open your Web browser and visit the company's Web site, where you can usually find a "Store Locator" feature that will help you find the store nearest to you, and conveniently plot it on a map to make it easier to find. In this tutorial, you will learn to develop such a feature using C# ASP.NET and an IBM DB2 database.

Use REALbasic to develop Informix Dynamic Server database applications on Mac OS

Wednesday, November 25th, 2009

Source

In this tutorial, see how to develop IBM Informix Dynamic Server (IDS)
database applications for Apple Mac OS using REALbasic. REALbasic is a
cross-platform programming language and development platform that you can use
to write a single application code base and deploy it on Mac as well as Linux
and Windows platforms. This tutorial shows you how to develop REALbasic
database applications on Mac OS that leverage the functionality of IDS on the
Mac OS platform.

Create an alerts system using XMPP, SMS, pureXML, and PHP

Tuesday, November 24th, 2009

Source

Thanks to the native XML support that pureXML offers IBM DB2 database developers, you can load XML data directly into your database, freeing up development time to add functionality to your application. Follow along in this tutorial to import an XML file with Euro foreign exchange rates into an IBM DB2 database and use special XQuery and SQL/XML functions to split this XML into separate database rows. You will also create a PHP script that pulls down new rates from the European Central Bank (ECB) Web site each day. Then you will extend the script to send update alerts to a Google Talk user using the XMPP protocol, and to a cell phone by SMS text message using the Clickatell SMS gateway service. Finally, you will create a PHP script that generates a PNG (Portable Network Graphics) graph of this data.