Wind River Spas TORNADO Spécifications

Netezza CorporationCorporate Headquarters26 Forest St., Marlborough, Massachusetts 01752tel 508.382.8200 fax 508.382.8300 www.netezza.comNetezza ODBC,

x

xiList of FiguresFigure 1-1: ODBC Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Figure 1-2: JDBC Configur

xii

xiiiPrefaceThis document describes the Netezza appliance implementations of International stan-dards for a Structured Query Language Call Level Interf

xivSymbols and ConventionsThis guide uses the following typographical conventions: Italics for emphasis on terms and user-defined values such as user

xvLearning MoreFind detailed specifications for the Microsoft ODBC implementation of the SQL CLI stan-dards at the following: http://msdn.microsoft.co

xvi

1-1C H A P T E R 1IntroductionWhat’s in this chapter Background Architecture Process Installation Files AccessThis chapter provides general inform

1-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideOLE DB was designed as a higher-level replacement for, and success

20751-12 Rev.5 1-3ArchitectureIn a Netezza appliance two-tier client-server system, the data source is stored on the Netezza appliance, which handles

The specifications and information regarding the products described in this manual are subject to change without notice. All statements, information,

1-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideFigure 1-2: JDBC Configuration.In a Netezza appliance two-tier cli

20751-12 Rev.5 1-5Installation Files AccessOLE DBThe process for setting up OLE DB on your system is as follows.1. Install the appropriate Netezza app

1-6 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideIf you need one of the .tar files, use the tar command to uncompre

2-1C H A P T E R 2Support and Release CompatibilityWhat’s in this chapter Supported Platforms Release Compatibility Matrix ODBC Driver Version Supp

2-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideThe OLE DB provider is supported on the Windows clients shown in T

20751-12 Rev.5 2-3ODBC Driver Version SupportNote: Different driver/provider and software versions may have different available functions, so for full

2-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideJDBC Driver Data Source SupportUp to 4.5.x, JDBC driver implementa

3-1C H A P T E R 3Installing and Uninstalling Client ToolsWhat’s in this chapter Windows Client Tools Installation UNIX/Linux Client Tools Installat

3-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideTable 3-2 describes the environment variables the installation pro

20751-12 Rev.5 3-3UNIX/Linux Client Tools Installation4. The Setup Type window is displayed. Select from the following installation types: Typical —

Botan LicenseCopyright (C) 1999-2008 Jack Lloyd2001 Peter J Jones2004-2007 Justin Karneges2005 Matthew Gregan2005-2006 Matt Johnston2006 Luca Piccarre

3-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideClient Tools Installation Procedure for UNIX/LinuxThis section des

20751-12 Rev.5 3-5Uninstalling Client Tools for UNIX/LinuxTo remove the Netezza appliance client tools for Windows for the ODBC driver, the JDBC drive

3-6 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guidecd /usr/localrm -f -r nzThe above commands remove the nz directory

4-1C H A P T E R 4ODBC Drivers and Driver ManagersWhat’s in this chapter ODBC Drivers ODBC Driver ManagersThis chapter explains ODBC drivers and dri

4-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideODBC Driver PropertiesThis section describes the meaning and purpo

20751-12 Rev.5 4-3ODBC Driver ManagersFor performance reasons, depending on the database management system software used, some API functions may bypas

4-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guidethird-party ETL and BI software tools. It is not necessary to inst

20751-12 Rev.5 4-5ODBC Driver Managers4. Run the following command to extract the contents of the unixODBC-2.2.12.tar file:tar -xvf unixODBC-2.2.12.ta

4-6 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideAssumptionsThe installation procedure for the DataDirect driver ma

20751-12 Rev.5 4-7ODBC Driver Managers8. Change directory to example: cd example9. Run the example program (example), specifying a DSN (NZSQL is the d

4-8 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide

5-1C H A P T E R 5Installing and Configuring ODBCWhat’s in this chapter Installing and Configuring ODBC for Windows Configuring ODBC for UNIX/LinuxT

5-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Silent install; Visual Studio 8 (VC8) libraries are not installe

20751-12 Rev.5 5-3Installing and Configuring ODBC for Windowsters that are outside the basic set, do not select the optimize option. This causes the c

5-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideData Source Configuration ProcedureThe following outlines the proc

20751-12 Rev.5 5-5Installing and Configuring ODBC for Windows2. Select either the System DSN tab or the User DSN tab and select either Configure or Ad

5-6 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideODBC Driver Setup Window The ODBC Driver Setup Window, as shown in

20751-12 Rev.5 5-7Installing and Configuring ODBC for WindowsThe Advanced Options tab shows more options, as shown in Figure 5-5. Figure 5-5: System D

5-8 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Load Max Errors — Tells the system to abort after N bad input ro

20751-12 Rev.5 5-9Installing and Configuring ODBC for Windowssystem administrator for the database to which you are attempting to connect. Refer to th

vTable of ContentsPreface1 IntroductionBackground . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

5-10 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideFinish the Configuration A successful connection message indicate

20751-12 Rev.5 5-11Configuring ODBC for UNIX/LinuxTrace = 0TraceAutoStop = 0TraceFile = /tmp/sql.logNote: The Netezza ODBC driver

5-12 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideYou may want to place the .odbcinst.ini file in a different locat

20751-12 Rev.5 5-13Configuring ODBC for UNIX/Linux Servername — The server host name or IP address of your Netezza appliance. Password — A valid pas

5-14 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide;When set to true, use old (2.5) functionality for returning sche

20751-12 Rev.5 5-15Configuring ODBC for UNIX/Linux[ODBC]IANAAppCodePage=4InstallDir=/opt/odbc32v51Trace=0TraceDll=/opt/odbc32v51/lib/odbctrac.soTraceF

5-16 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideODBC Connectivity Validation for UNIX/LinuxTo validate that you c

20751-12 Rev.5 5-17Configuring ODBC for UNIX/Linuxisql -v NZSQLIf your connection is successful, you will see a response similar to the following:+---

5-18 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide

6-1C H A P T E R 6Installing and Configuring JDBCWhat’s in this chapter Installing JDBC for Windows Installing JDBC for UNIX/Linux Configuring a JD

viODBC Driver Manager Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3Windows Driver Managers. . . . . . . . . .

6-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideComplete the following steps to install the JDBC driver.1. Start t

20751-12 Rev.5 6-3Configuring a JDBC Data Source (Windows Only)2. Copy Driver to Client System.3. Modify Environment Variable.JDBC Driver Installation

6-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideFigure 6-1: List of Data Sources screen.3. The Datasource Configur

20751-12 Rev.5 6-5Configuring a JDBC Data Source (Windows Only)Figure 6-3: Datasource Configuration Advanced Options. Batch Size— Number of rows to b

6-6 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Preferred Unsecured — Connections that do not use SSL are prefer

7-1C H A P T E R 7Installing and Configuring OLE DBWhat’s in this chapter Installing OLE DB Provider Configuring an OLE DB Data SourceThis chapter d

7-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide4. Install the Visual Studio 8 libraries.5. Review the installatio

20751-12 Rev.5 7-3Configuring an OLE DB Data SourceOLE DB Data Source Configuration Validation StepsThe following are the steps to validate connectivi

7-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideFigure 7-1: OLE DB Provider: Selection Tab.3. In the list of OLE D

20751-12 Rev.5 7-5Configuring an OLE DB Data SourceFigure 7-2: OLE DB Provider: Connection Tab.4. In the Data Source box, specify the name of the Nete

viiODBC Driver Search Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A-1ODBC Driver Considerations . . . . . . .

7-6 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideFigure 7-4: OLE DB Provider: Advanced Tab.

A-1A P P E N D I X AODBC Configuration FilesWhat’s in this appendix Netezza ODBC Driver unixODBC Driver Manager DataDirect Driver Manager Investig

A-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide3. If the driver does not find hidden configuration files in the c

20751-12 Rev.5 A-3DataDirect Driver ManagerPlace hidden configuration files in each user’s home directory if each user needs to access different Netez

A-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide2. Shared Configuration Files. Use this method if you would like a

B-1A P P E N D I X BTroubleshootingWhat’s in this appendix ODBC Debug Logging and Driver Manager Tracing JDBC Debug Logging OLE DB Debug LoggingThi

B-2 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide7. Click OK to save your settings.Figure B-1: Enabling Debug Loggi

20751-12 Rev.5 B-3JDBC Debug LoggingEnabling ODBC Driver Manager Tracing for UNIX/LinuxUse the following steps to enable ODBC Driver Manager Tracing i

B-4 20751-12 Rev.5Netezza ODBC, JDBC and OLE DB Installation and Configuration GuideloggertypeYou can set the following case-insensitive log format ty

viii

ixList of TablesTable 2-1: Netezza Supported Platforms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1Table 2-2: OLE DB Windows Suppo