Optim Development Studio

Speed data access design, development, and deployment while increasing data access efficiency and performance

Overview

Learn more

Technical article

Downloads

Trial

Use and maintain

To provide more value to our customers, we have consolidated Optim Development Studio, Optim Database Administrator and Data Studio. Visit IBM Data Studio to learn more.

Optim Development Studio improves development productivity up to 50% for developing and testing SQL and XQuery queries, stored procedures, Web services, and Java data access layers.

Generates a data access layer and test applications using Java objects, JSON, or, XML.
Facilitates the use of JDBC and SQL data access best practices for enhanced performance.
Enhances problem isolation, correlating problem SQL with issuing code even when using frameworks that generate the SQL.
Simplifies impact analysis, visualizing the impacted SQL and source code for proposed schema changes.
Leverages unique pureQuery software to deliver better performance, security, and manageability.
Enhances cross-lifecycle collaboration to improve productivity, alignment, and application quality providing integration with additional Optim and Rational offerings.
Extends heterogeneous data server support to Oracle in addition to IBM DB2 and Informix Dynamic Server on any platform.

View features and benefits