Tag: SQL

Today in my series on performance tuning Progress DataDirect products, I’m going to shed some light on a few of the tuning options available in our Connect for JDBC driver for SQL Server. Performance Tuning Options The SQL Server JDBC driver offers a wealth of options...

Data & AI DataDirect

Paul Griffin February 22, 2010

Bulk Loading Oracle without SQL*Loader | Part 2 - Loading Data into Oracle with ODBC Driver

As you've done with DB2 in part 1, you need to configure a Progress DataDirect ODBC Driver for the target database, which is Oracle.

Enter all of the connection information for the target Oracle database.

Do a "Test Connect" to...

Data & AI

Greg Stasko October 30, 2009

Bulk Loading Oracle without SQL*Loader | Part 1 – Extracting the data from DB2

In this post, we’ll focus on the extraction of the data from the DB2 system. You’ll learn how to configure your machine to easily extract data from DB2 on z/OS in preparation for a bulk load without running any command-line utilities or writing any SQL! Requirements: A current Windows machine,...

Data & AI

Greg Stasko October 29, 2009

Bulk Loading Oracle without SQL*Loader | An Overview

You have an ongoing requirement to move data from one database to another. In this case, your operational data is in DB2 database running on z/OS on the company mainframe. There is a business need to periodically copy the data to an Oracle database. (The DB2 system is “off-limits” when it comes to ad...

Data & AI

Greg Stasko October 28, 2009