 |
|
|
|
Use Optim software to manage privatized test data from design to
deployment
With Optim(TM) Development Studio 2.2, built-in integration with Optim
Test Data Management enables developers and database administrators to use
copy-and-paste function to generate an Optim Test Data Management request. The
request can then be used for the efficient creation of a consistent,
right-sized, referentially intact subset of data for testing. This methodology
also enables you to enforce data privacy standards that were originally
defined in the data model that used InfoSphere(TM) Data Architect. Developers
can see which columns are private to ensure that the generated script enforces
the requirement to include the Optim Data Privacy option for de-identifying
private data. This article offers an end-to-end example scenario depicting a
data architect, a database administrator, and a developer completing the steps
needed for the solution.
|
|
15 Oct 2009 |
|
| |
Developing with PL/SQL in IBM Data Studio 2.2 and Optim Development Studio 2.2
This article describes how you can use
IBM Data Studio 2.2 and
Optim Development Studio 2.2
to develop routines that use Oracle PL/SQL.
It shows you how to create, edit, deploy, and debug PL/SQL packages,
procedures, and functions for the following databases:
DB2 for Linux, UNIX, and Windows Version 9.7,
Oracle 10g, and Oracle 11g.
|
|
20 Aug 2009 |
|
| |
Using common connections with Optim solutions
Creating database connections requires users to provide specific
information, including the database vendor, version, and URL information. In
version 2.1, Data Studio Developer and Administrator introduced a simple and
efficient way to manage database connections, allowing users to easily store
and retrieve connection parameters for multiple databases. With the 2.2
release (in which these products have been renamed to Optim(TM)), there have
been additional usability improvements. Support for common connections has
also been added to InfoSphere(TM) Data Architect 7.5.2. This article describes
how to use common connections for greater efficiency in managing database
connection information.
|
|
16 Jul 2009 |
|
| |
Data Web Services on DB2 for z/OS, Part 2: Integrate z/OS data sets using user-defined functions
Learn by example how to create an external user-defined function (UDF) on DB2 for z/OS
that can read z/OS Unix System Services (USS) files and z/OS data sets.
You can then use existing SQL built-in functions and your own UDFs to
perform data manipulation on the information stored in the data sets and files.
You can also expose these "file-reading" SQL statements as IBM Data Web Services,
which results in the data sets and files being available to Web service operations.
|
|
09 Jul 2009 |
|
| |
What's new and cool in Optim Development Studio 2.2
Optim(TM) Development Studio, previously known as Data Studio Developer,
takes new strides towards realizing IBM's Integrated Data Management vision.
This article explains how developers, architects, and database administrators
(DBAs) can collaborate in new and productive ways in heterogeneous database
environments with Oracle and IBM databases. Learn how you can fast track the
performance of your applications even more using Optim Development Studio and
pureQuery.
|
|
18 Jun 2009 |
|
| |
Integrated Data Management: Managing data across its lifecycle
IBM is consolidating many of its
Data Studio offerings under the Optim name.
The Optim portfolio will focus on realizing integrated data management with innovative delivery of
application-aware solutions for managing data and data-driven applications across the lifecycle,
from requirements to retirement.
This overview article explains both the vision and reality of Integrated Data Management
and how you -- whether a data architect, developer or tester, DBA, or data steward -- can use
IBM solutions today to respond quickly to emerging opportunities, improve quality of service,
mitigate risk, and reduce costs.
|
|
02 Jun 2009 |
|
| |
Optimize Enterprise Generation Language (EGL) applications using pureQuery and Data Studio Developer
This article describes how pureQuery and Data Studio Developer can be used to optimize data access for DB2 LUW and z/OS with EGL Java applications. The article shows how EGL and Data Studio Developer can be installed in a shell-sharing mode, and then how pureQuery can be used with the EGL Java generated code to convert dynamic statements to static statements for the DB2 versions, change captured SQL statements with better performing SQL statements,reduce SQL Injection risk, and look at execution times for the different SQL statements in special views provided in DataStudio.
|
|
08 May 2009 |
|
| |
Data Web Services on DB2 for z/OS, Part 1: Unlock business functions using DB2 for z/OS stored procedures and Data Web Services
Is your organization using or planning to use DB2 for z/OS stored procedures to
provide business functions? Have you ever wondered how to reuse stored procedures without programming effort in Web services? If so, this article will be of interest to you.
|
|
07 May 2009 |
|
| |
Build an intelligent eForms solution based on DB2 pureXML, Lotus Forms, and Web services
Form processing is one of the major daily tasks in many public and private
businesses. Processes based on paper forms are resource intensive, time consuming,
and often result in inaccurate or incomplete data. This article describes how you
can build an efficient electronic solution for form data capture, submission, and
management. The article guides you through three steps to build an efficient XML
electronic forms data collection solution with Lotus Forms for data capture, DB2
pureXML for data storage and query, and a connection between the two via a simple Web service that you can
create with Data Studio Developer. In three steps you can have an operational electronic forms application that can be the basis for efficient, quick, and accurate data collection and management.
|
|
30 Apr 2009 |
|
| |
Integrating Rational Software Architect with Rational Data Architect
Model-driven software development generally starts with either application
modeling or data modeling. Application modeling and data modeling, however, are closely
related to, and complement, one another. IBM has recognized the importance of
integrating application modeling with data modeling in model-driven software
development, and has developed the Unified Modeling Language (UML)-to-Logical Data
Model (LDM) and the LDM-to-UML transformations. These transformations integrate
application modeling using Rational Software Architect (RSA) and data modeling using
Rational Data Architect (RDA). This article provides a quick overview of RSA and RDA,
outlines the high-level steps in three RSA-RDA integration scenarios, and discusses the
UML-to-LDM and the LDM-to-UML transformations and the UML Logical Data Model Profile. [2009 Apr 17: Added note about Rational Data Architect changing product
name to InfoSphere Data Architect. --Ed.]
|
|
17 Apr 2009 |
|
| |
Use IBM Rational Data Architect to model your Oracle databases
Find out why IBM Rational Data Architect is gaining momentum as a database
modeling tool that is optimized for IBM databases, yet also provides functionality
to model other major database vendors such as Oracle. Look at alternatives to Oracle
Designer, and see how keeping up with Oracle's major enhancements is setting RDA
apart from the rest of the data modeling tools. [2009 Apr 17: Added note about Rational Data Architect changing product
name to InfoSphere Data Architect. --Ed.]
|
|
17 Apr 2009 |
|
| |
Integrate WebSphere Business Modeler and Rational Data Architect
Get an overview of IBM Rational Data Architect and IBM WebSphere Business
Modeler. Step through three scenarios for integrating business process and data
modeling using Rational Data Architect and WebSphere Business Modeler, and find
recommendations and best practices along the way. [2009 Apr 17: Added note about Rational Data Architect changing product
name to InfoSphere Data Architect. --Ed.]
|
|
17 Apr 2009 |
|
| |
More pureQuery Performance: Now with .NET applications accessing DB2 for
z/OS
|
|
26 Mar 2009 |
|
| |
Debugging stored procedures on DB2 z/OS with Data Studio
Developer, Part 2: Configure the stored procedure debug session manager on z/OS
Learn step-by-step how to configure the Unified Debugger
session manager for use on a z/OS(R) system, and learn how to use routines to
manage the session manager. Proper setup of the session manager on z/OS can
facilitate using IBM Data Studio Developer to debug stored procedures on
DB2(R) for z/OS servers.
|
|
19 Mar 2009 |
|
| |
Exploring what's new in Data Studio Developer, Version 2.1
IBM Data Studio Developer V2.1 introduces new application developer
functions and features, some of which are a direct result of the changes
in the underlying Eclipse framework that Data Studio Developer uses. Data
Studio V1.2 was developed using Eclipse 3.2.2, and it uses the frameworks in the Web
Tools Platform (WTP) project. Data Studio Developer V2.1 was developed using
Eclipse 3.4.1, and the frameworks were developed in the Data Tools Platform (DTP) project.
This article highlights the UI changes that you will see as a result of this
move, and you will learn how to navigate within Data Studio V2.1 using the new
features.
|
|
19 Feb 2009 |
|
| |
Understand IBM Data Studio Version 2 software packaging
This article provides a brief overview of the functionality and packaging
of some of the key Data Studio products from the IBM integrated data management
portfolio. The portfolio includes
Data Studio Developer and Data Studio pureQuery Runtime, Data Studio Administrator, DB2 High Performance Unload, InfoSphere; Data Architect, DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature, and
DB2 Optimization Expert for z/OS.
|
|
05 Feb 2009 |
|
| |
Integration between XML Forms Generator and Data Studio, Part 2: DB2 pureXML support in XFG
The pureXML feature of IBM DB2 9 has revolutionized support for
XML data -- handling XML as a new data type that is stored in a natural hierarchy -- different
from relational data. IBM Data Studio can create Data Web Services with multiple pureXML
parameters to manipulate pureXML instances in the database. With the pureXML support in XML
Forms Generator (XFG), you can visualize pureXML into XHTML/XForm for user to interact. Also
XFG can retrieve the registered related XML Schemas of pureXML instances and generate type
information, validation constraints into the target pureXML XHTML/XForm. So pureXML support
in XFG makes it easy to build forms interfaces for XML instances stored in pureXML.
|
|
20 Jan 2009 |
|
| |
Integration between XML Forms Generator and Data Studio, Part 1: Get started with the integration by creating an application
The XML Forms Generator (XFG) provides a jump-start for form development. It can
quickly and automatically produce valid and functional forms containing XForms markup
embedded within an XHTML document. The input to form generation can be an XML data
instance with or without a backing XML Schema, or a WSDL document. Data Web Services,
which is based on SQL scripts and Store Procedures, is a database related application
of traditional Web Services. IBM Data Studio is a client tool for generating Data Web Services visually with the help of direct connection to database.
The integration between XFG and Data Studio can enable to generate XForms/XHTMLs from Data
Web Services generated by Data Studio. This integration provides advantages such as joining the development of UI pages and Data access seamlessly, reducing the workload of UI development from Data Web Services, visualizing the pureXML UI development with full-support of validation, etc.
|
|
19 Dec 2008 |
|
| |
What’s new and exciting in IBM Data Studio Developer 2.1
Discover how IBM Data Studio Developer 2.1 will give you a better
understanding of your database application. See how the new implementation of
Data Studio Developer can improve your productivity and enable better
collaboration between developers and DBAs. Follow along with the scenarios in
this article and experience how you can get more done, with greater ease and
with greater insights, using Data Studio Developer 2.1.
|
|
03 Dec 2008 |
|
| |
Understand IBM Data Studio software packaging
Get a brief overview of the
functionality and packaging of some of the key Data Studio products from the IBM
integrated data management portfolio, including Data Studio, Rational Data Architect,
Data Studio Administrator, Data Studio Developer, and Data Studio pureQuery Runtime.
|
|
20 Nov 2008 |
|
| |
Shell sharing between Data Studio, Rational Data Architect, Rational Software Architect, and Rational Application Developer
Share the same Eclipse installation between different IBM software development
products, such as Data Studio, RDA, RSA, and RAD.
|
|
13 Nov 2008 |
|
| |
Debugging stored procedures on DB2 z/OS with Data Studio
Developer, Part 1: Debugging DB2 for z/OS SQL stored procedures with IBM Data Studio Developer v1.2
The Unified Debugger in DB2 combined with Data Studio Developer together provide a great toolset for anyone creating SQL native or external stored procedures
as well as Java stored procedures. This article provides important background information on the Unified Debugger and
shows you step-by-step how to use Data Studio Developer to create and debug a sample native SQL stored procedure. Typical problems are also addressed.
The focus in this article is on
DB2 for z/OS stored procedures, but many of the concepts and steps are similar on other DB2 servers.
l
|
|
06 Nov 2008 |
|
| |
The information perspective of SOA design, Part 5: The value and use of Rational Data Architect in SOA
Discover how you can use the IBM Rational Data Architect, IBM Industry Models and the unified metadata management of IBM Information Server to align process, service, and data models. Use these tools to accelerate your SOA project. The fifth part of "The information perspective of SOA design" series describes the key features of the products that support the data modeling pattern in SOA.
|
|
01 Oct 2008 |
|
| |
Data preservation and data migration in Data Studio Administrator V1.2
Follow a scenario where a DBA uses Data Studio Administrator to create a new
table and then populate it with data from an existing table.
|
|
25 Sep 2008 |
|
| |
Universal Services for pureXML using Data Web Services
Get started with configuring, testing, and modifying the Universal Services.
|
|
19 Aug 2008 |
|
| |
Write high performance Java data access applications, Part 3: Data Studio pureQuery API best practices
pureQuery is a high-performance Java data access platform focused
on simplifying the tasks of developing, managing and optimizing applications
and services that access data. It consists of tools, APIs and a runtime engine.
The previous articles in this series introduced the two programming styles
to help users access the database through simple but powerful APIs.
This article summarizes some best practices for development using the
pureQuery API and gives you real-world scenarios to see how to implement these
practices.
|
|
14 Aug 2008 |
|
| |
What’s new and exciting in IBM Data Studio Developer 1.2
Data Studio Developer 1.2 speeds development and enhances control for a
wide variety of experiences. Whether you are a developer or an
application-centric DBA, Data Studio Developer has many new features that can
get your job done faster and easier, including unique problem isolation and
impact analysis capabilities, ability to leverage static SQL for existing JDBC
applications, enhancements to static SQL development and administration, Web
services, and much more. This article highlights the features in this release
that will help you simplify your complex tasks.
|
|
07 Aug 2008 |
|
| |
Migrate from EJB 2 container-managed persistence to pureQuery for IBM Master Data Management Server, Part 2: Proving the pureQuery technology
If you've been curious about the new release of WebSphere Customer Center (now
named IBM InfoSphere Master Data Management Server), then this series is for you!
This series describes how and why pureQuery technology was used in the new release,
the implementation and migration to pureQuery, and the results of performance and
capability testing to validate this critical decision. Part 2 focuses on our
productivity and performance measurements in making the decision to user pureQuery
and also provides some hints and tips for working with pureQuery.
|
|
10 Jul 2008 |
|
| |
IBM Data Studio pureQuery Runtime for z/OS Performance
In this article, get a brief overview of pureQuery technology, the enhancements announced with Version 1.2, and the results of a performance study comparing pureQuery access methods with a variety of popular Java data access alternatives.
|
|
08 Jul 2008 |
|
| |
Migrate from EJB 2 container-managed persistence to pureQuery for IBM Master Data Management Server, Part 1: Evaluating pureQuery technology
If you've been curious or confused about the new release of WebSphere Customer
Center (now named IBM InfoSphere Master Data Management Server), then this series is
for you! This series describes how and why pureQuery technology was used in the new
release, the implementation and migration to pureQuery, and the results of
performance and capability testing to validate this critical decision. Part 1 focuses on the evaluation of persistence mechanisms and our plan to validate the technology.
|
|
03 Jul 2008 |
|
| |
IBM Data Studio pureQuery Runtime for z/OS Performance
pureQuery improves application throughput on DB2 for z/OS by making it
easy to code and deploy static SQL for Java. The new client optimization
feature in Version 1.2 extends the benefits of static SQL to any existing Java
application without changing or recompiling Java applications.
|
|
01 Jul 2008 |
|
| |
Write high performance, Java data access applications, Part 2: Introducing pureQuery inline method style
IBM pureQuery is a high-performance Java data access platform focused on simplifying the tasks of developing and managing applications that access data. It consists of tools, APIs and a runtime engine. pureQuery introduces two programming styles to help users access the database through simple but powerful APIs. This article introduces one such style, the inline method programming style, and discusses how users can use it to efficiently query and update databases. This article also explores the benefits as well as some of the key features of using the inline method programming style.
|
|
01 May 2008 |
|
| |
Write high performance, Java data access applications, Part 1: Introducing pureQuery annotated method style
pureQuery is a high-performance Java data access platform focused on simplifying
the tasks of developing and managing applications that access data. It consists of tools, APIs and a runtime. This article introduces the pureQuery annotated method coding style -- a simple, flexible style falling under the named-query paradigm, capable of executing SQL statically or dynamically. This article explains why a developer might choose to write a pureQuery application in the annotated method style, explains some of the differences between the annotated method style and the pureQuery inline coding style, and gives a brief overview of the most powerful features of pureQuery annotated methods.
|
|
10 Apr 2008 |
|
| |
Use WebSphere Service Registry and Repository as the master registry for DB2 pureXML schemas
In this article, learn how you can integrate WebSphere Service Registry and
Repository (WSRR) with DB2 pureXML. The WSRR product helps you establish governance
around your use of XML schema, while the DB2 pureXML XML schema Repository ensures
integrity of your XML data. Schemas can automatically be inserted into the schema
repository from within WSRR.
|
|
03 Apr 2008 |
|
| |
Web service development and deployment with Informix Dynamic Server and IBM Data Studio
IBM Data Studio brings Informix Dynamic Server developers the latest in Web services technology. Learn how this new set of tools makes it easy to design, develop, deploy, and manage your IDS applications. Get started with Web services development using the latest methodology, and also learn how you can simulate a Web service response by converting it to presentable HTML format.
|
|
21 Feb 2008 |
|
| |
"No Excuses" Database Programming for Java
Make your programs fly with static SQL and pureQuery.
|
|
08 Jan 2008 |
|
| |
Building the DB2 Health Monitor Sample Application for PHP, Part 2: DB2 pureXML or DOM? You decide
DB2 9 pureXML technology allows businesses to improve data
integrity and avoid legacy data lock-in. It enables application developers
to utilize the best storage medium for the task and eliminate the middle-tier
application logic previously required to take advantage of Web services. It
enables DBAs to centralize logic at the database server
and to help to optimize performance. More importantly, pureXML technology helps to reduce
the complexity of application development back to what it always has been by utilizing
the database for what it does best: to describe, retrieve, and store data. This
article uses the DB2 Health Monitor Sample Application as an example to show you how this
is possible.
|
|
03 Jan 2008 |
|
| |
Data Web Services: Build Web services the new way to access IBM database
servers
IBM Data Studio is a unified tooling platform that contains a comprehensive
set of features to develop, administer, and manage your database servers. The development IDE of Data Studio packs in a number of features to assist in all your data related development needs. An integral component of this product is
the capability to generate Web services-based access to your database. In this
article, get an overview of this exciting new technology called Data Web Services,
and step through some of its features and capabilities.
|
|
06 Dec 2007 |
|
| |
Migrate ERwin data models to Rational Data Architect
IBM Rational Data Architect delivers unique features not available in many of
today's data modeling tools in the market, including CA ERwin. Migrate
existing data models created in CA ERwin Data Modeler to Rational Data Architect,
and explore some of Rational Data Architect's features data modelers and data
architects use on a daily basis.
|
|
13 Sep 2007 |
|
| |
The power of Rational Data Architect
Learn about the salient features of Rational Data Architect (RDA) and its place and use within the software development lifecycle using the Rational Software Development Platform. In today's world of Service-Oriented Architecture (SOA), data is a vital component. This article explains how RDA addresses the issue of data's importance in SOA, and how RDA is used in a business environment.
|
|
02 Aug 2007 |
|
| |
Use Rational Data Architect to define and enforce data object naming
standards
Examine the features of Rational Data Architect that enable users to define and
implement object naming standards, and then see a real-world example.
|
|
11 Jan 2007 |
|
| |
Use Rational Data Architect to integrate data sources
No doubt about it -- information integration is challenging. Many business decisions must be documented and many transformations must be performed. IBM Rational Data Architect can document your decisions and automate part of this process. Read this article to explore a tool-supported process for federation design in just five steps.
|
|
21 Mar 2006 |
|
| |
