Optim Development Studio

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

Overview

Learn more

Downloads

Trial

Use and maintain

Previously known as IBM Data Studio Developer, Optim Development Studio provides an integrated database development environment for Oracle, DB2, and Informix.

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 with 2.2 in addition to IBM DB2 and Informix Dynamic Server on any platform.

View features and benefits