DB2 Database Support
Improved Performance and Reduced Complexity
For enterprise organizations that value efficient, high-performance access to DB2-resident data, the Progress DataDirect ODBC, JDBC, and ADO.NET database drivers simplify the development and deployment associated with DB2 connectivity to disparate data sources and applications.
Simultaneously, DataDirect Data Integration Suite dramatically improves the querying, publishing, reporting -- and even updating – of DB2 relational data, as well as integration with disparate data sources. In effect, DB2 enterprises enjoy more efficient data processing, less application downtime, more productive end-users, and a healthier bottom line.
Improved Runtime Application Performance, Scalability and Reliability
DataDirect dynamically interoperates with DB2 databases. When used in DB2 applications, DataDirect components optimize application performance, scale to meet real-time demand, minimize system downtime, and ensure reliable interactions with disparate data sources, applications, and end-users.
- Employs a clientless architecture that dramatically improves application throughput
- Optimizes performance for both single-threaded and multi-threaded connections
- Maximizes hardware resource efficiency with the most efficient memory, CPU, and network usage
- Leverages a robust Performance Tuning Wizard to fine-tune DB2 connectivity and decrease network traffic
- Supports Windows authentication for more secure connections, and other industry-standard security features to protect access to and transmission of DB2 data
- Converts XQuery to SQL, meaning highly-efficient query execution by generating and executing SQL on the server to retrieve only the DB2 data needed for the query
- Speeds execution time for DB2 XQueries via special optimization and mediation features that ensure better performance over other tools or hand-coded applications
- Converts DB2 query results to XML for streamed, maintenance-friendly, middle-tier integration processing that reduces memory requirements
Reduced Development Complexity of Data Connectivity and Integration
With DataDirect, developers spend less time on managing DB2 data connectivity and integration issues and more time on the application’s business logic and user requirements.
For organizations that employ multiple DB2 versions, or even a variety of vendor databases, DataDirect streamlines the interfacing between these data sources, future-proofs applications against database changes, and enables a more flexible, more robust data management infrastructure.
- Supports multiple versions of DB2, whether running on Windows, UNIX, or Linux (V9.5, V9.1, V8.x); iSeries (UBD V5R2, V5R3, V5R4); or z/OS (V9.1, V8.1), from a single component with full backwards compatibility
- Communicates directly with the database, providing better scalability and eliminating the overhead involved with client libraries. For z/OS and iSeries, this includes DB2 Connect
- Delivers DB2 connectivity to all major application platforms and server environments
- Adheres to open standards and eliminates the need for proprietary extensions
- Enables more code reuse by abstracting the differences between various corporate databases and between different DB2 versions
- Offers SQL leveling, the ability to write and execute a SQL statement across multiple databases or database versions
- Supports the full range of DB2 features
- Supports database-independent features such as stored procedure escape syntax, distributed transaction support, connection pooling and failover, and database load balancing
- Offers an intuitive graphical-mapping development environment that automatically generates integration-ready XQuery code once DB2 connectivity is established
- Adheres completely to the W3C XQuery Standard, whereas other XQuery tools use proprietary extensions, requiring additional coding and re-coding for every release version
