fhs
Volume 9, Number 16 -- April 21, 2009

DataDirect Updates ODBC Drivers

Published: April 21, 2009

by 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.

\r\nVersion 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.


RELATED STORY

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


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


Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

Essex Technology Group:  AS/400 to Power & Beyond Roadshow with Dr. Frank Soltis, May 18-21
Halcyon Software:  Do more with less resource with Message Management
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada


 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
The Four Hundred
The State of PHP on the Power Systems i

IBM Tweaks Some i Deals, Nukes Some Old i Tools

Come On Out, Power6+, You Win

As I See It: Berry Berry Annoying

First Quarter Sees Largest Tech Job Losses Since 2002

Four Hundred Guru
A Bevy of BIFs: Dealing with a Bad Date

A Bevy of BIFs: %CHAR, %EDITC and %EDITW

Admin Alert: And /QOpenSys and /QOpenSys and /QOpenSys and. . .

Reader Feedback: Programming E-mail Notification When a Robot/SCHEDULE Job Fails

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
April 18, 2009: Volume 11, Number 16

April 11, 2009: Volume 11, Number 15

April 4, 2009: Volume 11, Number 14

March 28, 2009: Volume 11, Number 13

March 21, 2009: Volume 11, Number 12

March 14, 2009: Volume 11, Number 11

TPM at The Register
Canonical punts Ubuntu Jaunty Jackalope

King Larry launches Oracle-Sun combo at Big Blue, Cisco

HP pits Matrix against Cisco's California

Microsoft puts Sun's Tremblay in SiArch

HP goes sweet sixteen with HP-UX 11i update

BNT and IBM discover patent love to block Unified Cisco

Dell chases Sparc shops with migration offer

IDC: Linux to benefit from recession

IBM-free Sun unwraps Nehalem EP servers

Big-iron brains powers Schooner appliance power

Dell adds VC hotshot to board

IBM serves System S streaming super

Sun software - Does it make diddly?

Nehalem aces OLTP test on HP iron

THIS ISSUE SPONSORED BY:

New Generation Software
PowerTech
S4i Systems
Vision Solutions
Key Information Systems


Printer Friendly Version


TABLE OF CONTENTS
Nimsoft Delivers Business View of IT with BSM Express

Telephony Application Integrates with PBX Today and VoIP Tomorrow

Falconstor VTL Drives Efficiency into System i Backups

Spell/400 Provides a Green-Screen Spell Checker

VAI Offers Panasonic Toughbooks to ERP Customers

News Briefs and Product Shorts:

SEEBURGER Unveils Invoice Processing System . . . Sainsbury's Taps Wesupply for Supply Chain Visibility . . . ArcSight Delivers SIEM to Mid Market Customers . . . HiT Bolsters Performance of DBMoto Replicator . . . DataDirect Updates ODBC Drivers . . .

Four Hundred Stuff

BACK ISSUES




 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement