DataDirect Updates ODBC Drivers

April 21, 2009 Alex Woodie

DataDirect Technologies last week announced a new release of its ODBC driver, which supports all major relational database management systems, including DB2 for IBM i (DB2/400). With version 6 of DataDirect Connect for ODBC, the company has delivered enhancements in the area of application development, performance, bulk loads, and failover.

As a subsidiary of database and SOA software developer Progress Software, DataDirect Technologies is tasked with building an array of drivers and adapters that allow customers and partners to move data via ODBC, JDBC, ADO.NET, XQuery, SOAP, and other standards. With the amount and types of data being stored by companies exploding, driver makers like DataDirect have their hands full in keeping up with all the developments and evolving standards.

With DataDirect Connect for ODBC version 6, the company has delivered numerous updates and enhancements aimed at keeping on par with enterprises’ new IT investments and evolving standards. The biggest new feature in version 6 may be support for the open source PostgreSQL and Greenplum databases. PostgreSQL, which is developed and maintained by the PostgreSQL Global Development Group, is very popular on Linux, while Greenplum, a commercial open source product developed by the Greenplum company, is known for its scalability for business intelligence and data warehousing workloads.

Version 6 also introduces a feature called Bulk Load. DataDirect says this feature is ideal for users who need to perform a variety of bulk data operations, such as loading a database from scratch, or exporting data from one database into another. The feature boost the performance of existing batch operations without the need for application code changes, the company says.

Also new in version 6 is Application Failover, a new feature that automatically redirects ODBC requests to an alternate database server if the primary server is unavailable due to a hardware failure or traffic overload. This feature works with or without data replication or clustering technology, and is only available for DB2, Oracle, Sybase, and MySQL databases.

rnVersion 6 also gains support for the version of DB2 that ships with IBM i 6.1. This release also offers SSL encryption with client authentication support on all three versions of DB2–DB2 for IBM i (DB2/400), DB2 for z/OS, and DB2 for LUW (Linux, Windows, and Unix). For a full list of features in DataDirect Connect for ODBC 6.0, see the release notes.

DataDirect Supports i 6.1 with .NET Data Provider

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Tags:

Sponsored By
KEY INFORMATION SYSTEMS

Smart i Mobile and DB2 Panel at COMMON

· Smart i Mobile at Key Info booth 501
· New Panel on DB2 Web Query

Smart i Mobile Debuts at Key Info booth 501
Smart i Mobile is being introduced at the 2009 COMMON Conference & Expo by Key Information Systems at booth 501.

Smart i mobile enables users to receive data from the Smart i BI platform and will run on a Blackberry, iPhone or any handheld mobile device.

Smart i Mobile provides an executive dashboard on mobile devices that will initially run on the Android platform. Android brings Internet-style innovation and openness to mobile phones and was designed by the Google and the Open Handset Alliance and allows developers to write managed code in the Java language, controlling the device via Java compatible code running on a virtual machine especially designed for mobile devices. See: www.android.com and www.openhandsetalliance.com.

Smart i Mobile was designed in collaboration between Key Information Systems, Systech Solutions and Intelligent Applications Hatchery LLC. It allows users to view a graphical representation of critical data generated by Smart i Appliance, an IBM i based data warehousing implementation.

Smart i Mobile graphs will directly link to the numerous Smart i reports generated by IBM DB2 Web Query. Data is automatically refreshed each time the information in Smart i data warehousing reports is updated. Clickable graphs allow users to navigate through the data behind the graphs.

Click here for more information

New Panel on DB2 Web Query
Here's the newest addition to COMMON's 2009 program:

Title Power i as an Industrial Strength Native BI Platform
When April 28th; 2:00 - 3:15 pm

Background
The Power i is an excellent platform for data marts or an enterprise-level data warehouse. It is robust, reliable and the cornerstone of thousands of data centers. However, it's lacking in BI applications. IT has had to resort to different platforms based on MS SQL Server or UNIX for BI services to provide analytics services.

Covered
    · What is the state of IBM's DB2 Web Query data warehousing tool and how has it changed?
    · What new products are taking advantage of the new capabilities of Web Query?
    · Who has been using these new BI analytics products?

Should I Attend?
Yes, if you use or are interested in IBM's DB2 Web Query plus an ETL data transformation tool to make your i platform server your main BI machine.

What Will I Learn?
    · Why to consider the Power i as a BI analytics platform at your installation
    · Learn about using IBM DB2 Web Query as the BI engine
    · How Open Source ETL (Extract, Transform and Load) and Data Integration tools can move data
      from any database to the System i or the IBM Power Server.
    · Hear direct experiences from members of FIDM and the Smart i launch team.

Click here for more information

Additional information
Pete Elliot                                            Alberto Saavedra
Director of Marketing                         Sales Director
Key Information Systems Inc.            Systech Solutions
pelliot@keyinfo.com                     albertos@systechUSA.com
1.310.259.7444                                  1.818.439.0106
www.keyinfo.com                         www.systechUSA.com

Admin Alert: And /QOpenSys and /QOpenSys and /QOpenSys and. . . Don’t Ignore the View

Table of Contents

Recent Posts

Subscribe

Pages

Search