Data Connectivity Whitepapers on ODBC JDBC ADO.NET and database connections
The Essentials Series: Java Database Connectivity
By Mark Scott

Database connections are the lifeblood of enterprise applications, administrating the secure and steady flow of information between corporate applications and their persistent relational databases. Optimizing these connections can usher in widespread improvements in information management and improvements in server and network resource utilization

This article looks at JDBC drivers from the aspect of their ability to reach the full potential of their promise. It exposes the key factors that help a JDBC driver provide a full range of functionality and optimal performance while still managing on lean requirements of a constrained server environment. It discusses how to measure performance in terms of real world performance found in real production environments.

The Essential Series: Managed .NET Connectivity
By Mark Scott

Database connections are the lifeblood of enterprise applications, administrating the secure and steady flow of information between corporate applications and their persistent relational databases. Optimizing these connections can usher in widespread improvements in information management and improvements in server and network resource utilization.

This article discusses the architectural distinctives of a well-designed .Net connectivity product. It looks at the features required to minimize resource utilization on the host system and provide optimal scalability within an enterprise ecosphere.

The Essentials Series: Open Database Connectivity
By Mark Scott

Database connections are the lifeblood of enterprise applications, administrating the secure and steady flow of information between corporate applications and their persistent relational databases. Optimizing these connections can usher in widespread improvements in information management and improvements in server and network resource utilization.

This article looks at the characteristics of efficient, well designed ODBC driver suites, such as communication strategies and compiled architectures. It addresses key areas of resource optimization in memory, cpu utilization and network bandwidth. It helps the reader consider the challenges of enterprise scalability.

DataDirect Connect - Data Access Middleware Security Simplifies Business Process Applications

The Internet Security Advisors Group (ISAG), an international information security firm specializing in security assessment, conducted a review of the architecture and functionality of the DataDirect Connect product line. Ira Winkler, founder of ISAG and well-known security expert, wrote the report, which documents his assessment and establishes the need for security features as an integral part of database drivers and providers. The report also provides important information if you’re looking to implement Single Sign-on (SSO) or data encryption.

Service-Oriented Data Access: Building Interoperable, Robust & Reusable Data Services - A white paper by Jason Bloomberg, Senior Analyst, ZapThink

In this white paper, Jason Bloomberg explains the role of data in a SOA, the data issues you face when attempting to layer a service-oriented approach on top of existing data sources, how to solve data integration challenges and address potential data access pitfalls, and how to architect a data services layer to reap the full benefits of SOA.

View all available data connectivity Whitepapers.
Mainframe Integration analyst research report CDC IDMS Whitepapers Weblogic
Getting the Most from System Z

Part I: Redefining Mainframe Economics with the Specialty Engines
November 2008

By Jeff Goldberg, Celent Senior Analyst

With the market crisis, increasing efficiencies and reducing cost are greater issues than ever. Insurance CIOs may decide that expensive technology investments may need to wait, such as that long-planned and long-delayed policy admin replacement project, and will be looking for ways to continue modernizing without the cost.

Learn how the mainframe can be modern and cost-efficient while still providing reliability with the System z specialty engines.

DataDirect Shadow - version 7.1.2 Web Services Performance Analysis

The performance analysis of DataDirect Shadow z/Services v7.1.2 (Shadow z/Services v7) was conducted at the DataDirect Technologies mainframe products development lab in Sugar Land, Texas. Testing was performed in a controlled environment using Shadow z/Services v6.1 and v7.1.2.

Bloor In-Detail Report - DataDirect Shadow v7

By incorporating Shadow into their solutions, ISVs can expand their potential market by including initial or expanded access to mainframe assets as well as enhance their solution TCO by leveraging the most cost effective mainframe integration product on the market.

Nucleus ROI Case Study: DataDirect Shadow in Financial Services Firm

A global financial services firm deployed DataDirect Shadow and its mainframe Web services technology at the early stages of its service-oriented architecture (SOA) adoption. This strategy enabled the company to leverage existing mainframe assets while increasing developer productivity and the ability to deliver new applications to customers.

ROI: 150%
Payback: 11 months

Mainframe SOA Research Report from The Clipper Group

In this report, Clipper Group analyst Anne MacFarland recommends using DataDirect Shadow v7 to make using IBM’s System z9 for SOA less expensive. With the release of DataDirect Shadow version 7, you can offload data traffic (including SOA messaging) to System z9’s zIIP processor and application traffic (including SOA orchestration) to a z9 zAAP processor. By offloading work to these specialty engines, the work gets done faster and is charged according to a less escalating pricing model. The report also details other significant capabilities added in version 7 such as adding DataDirect Connect database driver technology, and more.

View all available mainframe integration Whitepapers.
Data Integration Whitepapers & Industry Studies
How DataDirect XQuery Helps the Insurance Industry Deal with ACORD Standards

Learn how DataDirect XQuery is being used to help the insurance industry develop and manage applications that must adhere to ACORD (Association for Cooperative Operations Research and Development) standards for the insurance, reinsurance, and related financial services industries.

Updating Relational Data with DataDirect XQuery

DataDirect XQuery allows you to update relational data from within XQuery. This is useful for all XQuery applications that need to insert, update, or delete data in relational tables. The addition of update functionality makes DataDirect XQuery 3.0 very well-suited for ETL application scenarios, where it provides efficient XML shredding and transparent relational updates.

Querying XML Columns with DataDirect XQuery

Increasingly, XML is stored in relational databases as structured XML. Some applications will continue to shred XML into a relational format or store XML as CLOB values. Other applications can now take advantage of relational databases that support a native XML data type to represent an XML document or XML document fragment. This paper shows how you can use DataDirect XQuery to query XML stored as character data and query XML stored as XML.

Resolving fn:collection() Errors

No standard way exists to access a relational table in XQuery, so each XQuery implementation defines its own way to do this. DataDirect XQuery uses fn:collection() to access a relational table. This paper provides guidelines to help you troubleshoot and correct common causes of errors that occur when using fn:collection() in an XQuery query.

XQuery Industry Study

XQuery is a new standards-based XML technology from the W3C that provides an easy way to query, transform, and integrate XML data. There are a lot of promising indicators which would lead one to believe in the XQuery revolution, yet to date, no comprehensive XQuery industry study has been published to challenge the statistical validity of such claims, until now.

View all available Data Integration Whitepapers.