Netezza ODBC, JDBC, and OLE DB Installation and Configuration Guide Document Number: 20751-12 Rev. 5 Software Release: 6.0.2 Revised: May 3, 2011 Netezza Corporation Corporate Headquarters 26 Forest St., Marlborough, Massachusetts 01752 tel 508.382.8200 fax 508.382.8300 www.netezza.
The specifications and information regarding the products described in this manual are subject to change without notice. All statements, information, and recommendations in this manual are believed to be accurate. Netezza makes no representations or warranties of any kind, express or implied, including, without limitation, those of merchantability, fitness for a particular purpose, and non infringement, regarding this manual or the products' use or performance.
Botan License Copyright (C) 1999-2008 Jack Lloyd 2001 Peter J Jones 2004-2007 Justin Karneges 2005 Matthew Gregan 2005-2006 Matt Johnston 2006 Luca Piccarreta 2007 Yves Jerschow 2007-2008 FlexSecure GmbH 2007-2008 Technische Universitat Darmstadt 2007-2008 Falko Strenzke 2007-2008 Martin Doering 2007 Manuel Hartl 2007 Christoph Ludwig 2007 Patrick Sona All rights reserved. Redistribution and use in source and binary forms, for any use, with or without modification, of Botan (http://botan.randombit.
Table of Contents Preface 1 Introduction Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1 Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2 ODBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2 JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
ODBC Driver Manager Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3 Windows Driver Managers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3 Linux/UNIX Driver Managers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3 unixODBC Driver Manager Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-4 DataDirect Driver Manager Installation. . . . . . . . . . . . . . . . . . . . . . .
ODBC Driver Search Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A-1 ODBC Driver Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A-2 unixODBC Driver Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A-2 unixODBC Driver Manager Search Behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . A-2 Compatibility. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
viii
List of Tables Table 2-1: Netezza Supported Platforms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1 Table 2-2: OLE DB Windows Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2 Table 2-3: Implementation, Netezza Driver/Provider, and Software Compatibility . 2-2 Table 2-4: Netezza ODBC Driver Version Support . . . . . . . . . . . . . . . . . . . . . . . 2-3 Table 2-5: Data Source Support Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
x
List of Figures Figure 1-1: ODBC Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2 Figure 1-2: JDBC Configuration.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4 Figure 3-1: Add or Remove Programs Window.. . . . . . . . . . . . . . . . . . . . . . . . . . 3-5 Figure 3-2: Program Entry. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-5 Figure 5-1: ODBC Data Source Administrator Window. . . . . . . . .
xii
Preface This document describes the Netezza appliance implementations of International standards for a Structured Query Language Call Level Interface (SQL CLI). This Netezza Performance Server ODBC, JDBC and OLE DB Installation and Configuration Guide brings together all the information you need to install and configure the Netezza ODBC drivers, JDBC drivers, OLE DB, and Netezza appliance data sources.
Symbols and Conventions This guide uses the following typographical conventions: Italics for emphasis on terms and user-defined values such as user input Upper case for SQL commands; for example INSERT, DELETE Bold for command line input; for example, nzsystem stop If You Need Help If you are having trouble using the Netezza appliance, you should: 1. Retry the action, carefully following the instructions given for that task in the documentation. 2.
Learning More Find detailed specifications for the Microsoft ODBC implementation of the SQL CLI standards at the following: http://msdn.microsoft.com/en-us/library Find more information on the Oracle Sun Developer Network JDBC implementation of the SQL CLI at the following: http://java.sun.com/reference/api/index.html Find more information on the Microsoft OLE DB implementation at the following: http://msdn.microsoft.
xvi
CHAPTER 1 Introduction What’s in this chapter Background Architecture Process Installation Files Access This chapter provides general information about ODBC, JDBC, and OLE DB. Background The International standard for SQL defines a standard high-level language for accessing and manipulating the data stored in a relational database.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide OLE DB was designed as a higher-level replacement for, and successor to, ODBC, to support a wider variety of non-relational databases that do not necessarily implement SQL (for example, object databases and spreadsheets). OLE has a client-provider model, where clients request access to data, and providers are the software component interface allowing access to the data.
Architecture In a Netezza appliance two-tier client-server system, the data source is stored on the Netezza appliance, which handles all database access processing. The ODBC driver on the client system uses a network connection to a Postgres process running on the Netezza appliance host, which coordinates SQL statement processing functions. JDBC The JDBC architecture consists of four major components: Java Application.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Figure 1-2: JDBC Configuration. In a Netezza appliance two-tier client-server system, the data source is stored on the Netezza appliance, which handles all database access processing. The JDBC driver on the client system uses a network connection to a Postgres process running on the Netezza appliance host, which coordinates SQL statement processing functions.
Installation Files Access OLE DB The process for setting up OLE DB on your system is as follows. 1. Install the appropriate Netezza appliance client tools. See the next section “Installation Files Access” and Chapter 3, “Installing and Uninstalling Client Tools.” 2. Select the OLE DB provider to install. See Chapter 7, “Installing and Configuring OLE DB.” 3. Configure the data source. See Chapter 7, “Installing and Configuring OLE DB.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide If you need one of the .tar files, use the tar command to uncompress the package.tar.z file, for example: tar cli.package.tar.z You can download client kits such as ODBC, JDBC, OLE DB, or Netezza client CLIs for your Netezza client users to update to the latest software release.
CHAPTER 2 Support and Release Compatibility What’s in this chapter Supported Platforms Release Compatibility Matrix ODBC Driver Version Support ODBC Standards Conformance and API Versions JDBC Driver Data Source Support This chapter shows the supported platforms and compatibility.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Table 2-1: Netezza Supported Platforms (continued) Operating System 32-bit 64-bit SPARC SPARC x86 x86 HP-UX 11i versions 1.6 and 2 (B.11.22 and B.11.23) Itanium PA-RISC Itanium PA-RISC IBM AIX 5.1, 5.2, 5.3, 6.1 with 5.0.2.
ODBC Driver Version Support Table 2-3: Implementation, Netezza Driver/Provider, and Software Compatibility Implementation OLE DB Netezza Driver/ Provider Netezza Appliance Software 4.5.x 4.6.x 5.0.x 6.0.x 4.0.x, 4.0.x, 4.5.x, 4.6.x, 4.5.x, 4.5.x, 4.6.x, 5.0.x, 4.6.x, 5.0.x 4.6.x, 5.0.x, 6.0.x 5.0.x, 6.0.x 6.0.x Note: Different driver/provider and software versions may have different available functions, so for full functionality, you may need to change your driver/provider or software version.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide JDBC Driver Data Source Support Up to 4.5.x, JDBC driver implementations for data sources had some limitations, such as not allowing users to set different connection properties, such as: securityLevel, caCertFile, loggerType, etc. In 4.
CHAPTER 3 Installing and Uninstalling Client Tools What’s in this chapter Windows Client Tools Installation UNIX/Linux Client Tools Installation Uninstalling Client Tools for Windows Uninstalling Client Tools for UNIX/Linux This chapter provides information about installing the Netezza appliance client tools on your system. These tools help the ODBC drivers, JDBC drivers, and OLE DB Provider that Netezza supplies connect to a Netezza appliance from a client system.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Table 3-1: Minimum Space Requirements for Clients Installing Disk Space Needed JDBC 10 MB OLE DB 100 MB Table 3-2 describes the environment variables the installation program adds for the Netezza Performance Server console applications.
UNIX/Linux Client Tools Installation 4. The Setup Type window is displayed. Select from the following installation types: Typical — (Recommended for most client systems) Installs the nzadmin program, the online help files, the documentation, and the console utilities, including the loader. Minimal — Installs the nzadmin program and online help files.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Client Tools Installation Procedure for UNIX/Linux This section describes the steps for installing the Netezza client tools on a UNIX/Linux client system. 1. Run the client program for the type of system you are installing on. For example, for a 64-bit Linux system, you would select linux64cli.package.tar. For directions, see “Installation Files Access” on page 1-5. Make sure to mount it, if it is not automatically mounted on your system.
Uninstalling Client Tools for UNIX/Linux To remove the Netezza appliance client tools for Windows for the ODBC driver, the JDBC driver, and/or the OLE DB provider, use the standard Add or Remove Programs control panel interface. Click Start > Control Panel > Add/Remove Programs and select the Netezza entries on the list of installed programs. Figure 3-1 shows the Add or Remove Programs Control Panel window. Figure 3-1: Add or Remove Programs Window. Select the entry in the Add/Remove list to remove.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide cd /usr/local rm -f -r nz The above commands remove the nz directory and all of its subdirectories and files from the /usr/local directory. 3-6 20751-12 Rev.
CHAPTER 4 ODBC Drivers and Driver Managers What’s in this chapter ODBC Drivers ODBC Driver Managers This chapter explains ODBC drivers and driver managers. You can have only one ODBC driver installed on your system at a time. If you need a different driver, remove the installed driver and install the different one. For more information on this procedure, see Chapter 3, “Installing and Uninstalling Client Tools.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide ODBC Driver Properties This section describes the meaning and purpose of each ODBC driver property. Parameters define the properties of Netezza ODBC drivers, configured either through Windows or a UNIX/Linux configuration file. Use this information to select appropriate values for each driver property during the driver configuration process.
ODBC Driver Managers For performance reasons, depending on the database management system software used, some API functions may bypass the driver manager and access the ODBC driver directly. ODBC Driver Manager Functions The driver manager handles a number of functions that all ODBC applications need, regardless of the particular ODBC driver they use or the data source they access.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide third-party ETL and BI software tools. It is not necessary to install the Netezza-licensed version of the DataDirect driver manager to access the Netezza ODBC drivers. You can find information on the DataDirect line of ODBC products at the following: http://www.datadirect.com unixODBC Driver Manager Installation This section provides instructions for installing the open source unixODBC driver manager.
ODBC Driver Managers 4. Run the following command to extract the contents of the unixODBC-2.2.12.tar file: tar -xvf unixODBC-2.2.12.tar 5. Run the following command to change to the subdirectory created when the unixODBC-2.2.12.tar file was extracted: cd unixODBC-2.2.12 6. Run the following command to configure the software and set the installation directory to /usr/local/unixODBC: ./configure --prefix=/usr/local/unixODBC Note: To configure without the GUI, run the following command: .
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Assumptions The installation procedure for the DataDirect driver manager is the same for all supported Linux and UNIX systems. However, the exact file names for the manager are platform-specific. The installation directory is /opt. If you choose another directory, modify the following files: odbc.sh (if using sh or bash) odbc.csh (if using csh) odbc.ini The odbc.ini and odbcinst.
ODBC Driver Managers 8. Change directory to example: cd example 9. Run the example program (example), specifying a DSN (NZSQL is the default), login, and password. You should see the following output: ./example DataDirect Technologies, Inc. ODBC Example Application. Enter the data source name : NZSQL Enter the user name : admin Enter the password : password Enter SQL statements (Press ENTER to QUIT) SQL> If an error occurs, contact Netezza Customer Support. 20751-12 Rev.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide 4-8 20751-12 Rev.
CHAPTER 5 Installing and Configuring ODBC What’s in this chapter Installing and Configuring ODBC for Windows Configuring ODBC for UNIX/Linux This chapter describes the procedures used to install and configure ODBC drivers and data sources for Windows or UNIX/Linux systems. You can have only one ODBC driver installed on your system at any given time. If you need a different driver, you will need to remove the installed driver and install the different one.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Silent install; Visual Studio 8 (VC8) libraries are not installed and Translation Options are set to the default value c:\>nzodbcsetup.exe -i silent Silent install; Visual Studio 8 (VC8) libraries are installed and Translation Options are set to the default value c:\>nzodbcsetup.
Installing and Configuring ODBC for Windows ters that are outside the basic set, do not select the optimize option. This causes the characters that you enter to be converted to the proper encodings so that they appear correctly in your query results. Click Next after selecting. 6. The ODBC driver requires the Visual Studio 8 (VC8) Libraries on the client system. If the installation program finds the VC8 libraries, it uses the installed files and proceeds to the Pre-Installation Summary window.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Data Source Configuration Procedure The following outlines the procedure to configure a Netezza appliance data source. Note: This procedure is for configuring a 32-bit DSN on a 32-bit system or a 64-bit DSN on a 64-bit system. 32-bit DSNs do not display in the 64-bit administrator. On a 64-bit system, launch the administrator using the following: C:\windows\syswow64\odbcad32.exe 1.
Installing and Configuring ODBC for Windows 2. Select either the System DSN tab or the User DSN tab and select either Configure or Add: Selecting Add displays the Create New Data Source Window, as shown in Figure 5-2. Select NetezzaSQL as the driver and click Finish. The ODBC Driver Setup Window is displayed. Figure 5-2: Create New Data Source Window. Selecting the System DSN tab displays a list of System Data Sources, as shown in Figure 5-3.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide ODBC Driver Setup Window The ODBC Driver Setup Window, as shown in Figure 5-4, Figure 5-5, Figure 5-6, and Figure 5-7 allows you to configure the DSN and Driver Options. Figure 5-4: ODBC Driver Setup Window DSN Options. Enter appropriate values for the DSN Options. If your application supplies a user name and password, these can be left blank, since your application’s user name and password take precedence over the ones specified here.
Installing and Configuring ODBC for Windows The Advanced Options tab shows more options, as shown in Figure 5-5. Figure 5-5: System DSN Advanced Configuration Options. You can change these or accept the default options. 20751-12 Rev.5 Read Only — A boolean value that controls whether the database allows read-only access (only SQL Select statements are allowed), or full access. The default is deselected, which allows full access. To modify data, do not select the checkbox.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Load Max Errors — Tells the system to abort after N bad input rows. Default is 1, and 0 means no limit, with a maximum of 2,147,483,647 (the largest signed 32bit integer). Date Format — Specifies the desired date format as one of the following values: 1 — YMD. This is the default.
Installing and Configuring ODBC for Windows system administrator for the database to which you are attempting to connect. Refer to the Netezza Administrator’s Guide for information on security and authentication. The Driver Options tab allows you to configure global driver options, as shown in Figure 5-7. Figure 5-7: Driver Options. Enable Debug Logging — Select this box if you want the system to log information about each ODBC connection.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Finish the Configuration A successful connection message indicates that you have successfully configured an entry for the system data source. To end the configuration process, close all the open dialog boxes. Configuring ODBC for UNIX/Linux This section describes the process for configuring ODBC and your Netezza appliance data source for UNIX/Linux.
Configuring ODBC for UNIX/Linux Trace TraceAutoStop TraceFile = 0 = 0 = /tmp/sql.log Note: The Netezza ODBC driver properties are explained in Table 4-1 on page 4-2. Use this table to select appropriate values for the configuration entries in your .odbcinst.ini file. The CharacterTranslationOption can be set to “all’ or “latin9.” ODBC Driver Configuration Steps for UNIX/Linux The following are the steps to configure a Netezza ODBC driver on a UNIX/Linux client system: 1.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide You may want to place the .odbcinst.ini file in a different location, and you may want to do the configuration as the superuser, rather than as an ordinary user. These issues are discussed in Appendix A, “ODBC Configuration Files.” This step assumes you are logged in as an ordinary user and are placing the .odbcinst.ini file in your home directory. What you do in this step depends on whether or not the .odbcinst.
Configuring ODBC for UNIX/Linux Servername — The server host name or IP address of your Netezza appliance. Password — A valid password for accessing the system data source. The following shows the contents of a file named odbc.ini.sample, which is in the nz/ lib directory after you have installed your ODBC drivers. The sample file describes a system data source found on every Netezza appliance, and includes comments explaining each parameter.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide ;When set to true, use old (2.5) functionality for returning schemas in SQLTables. LegacySQLTables = false ;Specifies login timeout in seconds. LoginTimeout = 0 ;Specifies query timeout in seconds. QueryTimeout = 0 ;Specifies date format as follows ; 1: YMD ; 2: MDY ; 3: DMY DateFormat = 1 ;When selected, driver treats SQL_C_NUMERIC buffers as SQL_C_CHAR buffers. NumericAsChar = false ;Return SQL_BIT as "1"/"0" when char.
Configuring ODBC for UNIX/Linux [ODBC] IANAAppCodePage=4 InstallDir=/opt/odbc32v51 Trace=0 TraceDll=/opt/odbc32v51/lib/odbctrac.so TraceFile=odbctrace.out UseCursorLib=0 Note: The data source properties are explained starting on page 5-6. Use this information to select appropriate values for the entries in your .odbc.ini file. Data Source Configuration Steps for UNIX/Linux The following are the steps to configure Netezza appliance data sources on a UNIX/Linux client system: 1.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide ODBC Connectivity Validation for UNIX/Linux To validate that you can use ODBC to connect to an Netezza appliance data source, use the interactive SQL query program called isql. The isql program is installed on your system when you install the unixODBC driver manager (See “unixODBC Driver Manager Installation” on page 4-4.) You can use isql to run SQL queries against both the system data source and any user data sources you configure.
Configuring ODBC for UNIX/Linux isql -v NZSQL If your connection is successful, you will see a response similar to the following: +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | +---------------------------------------+ 3. The system database in the NZSQL data source contains a table named _t_dslice. Enter the following command to query the _t_dslice table: select * from _t_dslice 4.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide 5-18 20751-12 Rev.
CHAPTER 6 Installing and Configuring JDBC What’s in this chapter Installing JDBC for Windows Installing JDBC for UNIX/Linux Configuring a JDBC Data Source (Windows Only) This chapter describes the procedures to install and configure JDBC. You can have only one JDBC driver installed on your system at any given time. If you need a different driver, you will need to remove the installed driver and install the different one.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Complete the following steps to install the JDBC driver. 1. Start the installation program by double-clicking the nzjdbcsetup.exe program. For directions, see “Installation Files Access” on page 1-5. 2. A language option window is displayed, which controls the language for the installation program. Accept the default of English and click OK. 3. The Introduction window is displayed. Review the information and click Next. 4.
Configuring a JDBC Data Source (Windows Only) 2. Copy Driver to Client System. 3. Modify Environment Variable. JDBC Driver Installation Procedure for UNIX/Linux on an Unsupported Platform The following sections describe each of the above steps in the procedure for installing the JDBC driver on the client system. 1. Change to the appropriate directory on your Netezza appliance host: cd /nz/kit/sbin 2. Use the rcp or ftp command (using binary transfer mode) to copy the JDBC driver to your client machine.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Figure 6-1: List of Data Sources screen. 3. The Datasource Configuration screen is displayed. Select the Connection Options tab and enter the information in the appropriate fields: Figure 6-2: Datasource Configuration Connection Options. Data Source— Name of the data source (Mandatory). Host— Name of the host to connect to (Mandatory). Port— Port number (Mandatory). Database— Database (Catalog) name (Mandatory).
Configuring a JDBC Data Source (Windows Only) Figure 6-3: Datasource Configuration Advanced Options. Batch Size— Number of rows to be fetched in a cycle. Default - 256. Login Timeout— Maximum wait time to make a connection. Default - infinite. Read Only— Read Only property for the connection. Default - false. Auto Commit— Auto Commit property for the connection. Default - true. Log Level— Log Level for the connection. Default - OFF. Logger Type— The type to be used for logging.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Preferred Unsecured — Connections that do not use SSL are preferred, but a connection will not be refused solely because it uses SSL encryption. Only Unsecured — Only connections that do not use SSL to encrypt data will be accepted. This provides increased performance but carries the risks that come with an unencrypted connection.
CHAPTER 7 Installing and Configuring OLE DB What’s in this chapter Installing OLE DB Provider Configuring an OLE DB Data Source This chapter describes the procedure for installing the Netezza OLE DB provider on a Windows client system, configuring the provider and data sources, and testing for connectivity to Netezza appliance data sources. Installing OLE DB Provider This section describes the steps and procedure for installing the Netezza OLE DB provider on a Windows client system.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide 4. Install the Visual Studio 8 libraries. 5. Review the installation options. 6. Finish the installation. OLE DB Provider Installation Procedure This section describes each of the steps in the procedure for installing a Netezza OLE DB provider. The examples are for a Windows XP system for version 5.0. The procedure is the same on other Windows systems. Complete the following steps to install the OLE DB provider. 1.
Configuring an OLE DB Data Source OLE DB Data Source Configuration Validation Steps The following are the steps to validate connectivity to the database: 1. Create an empty .udl file. 2. Open the Data Link Properties dialog box. 3. Select Netezza OLE DB Data Provider. 4. Specify the Netezza system. 5. Enter User ID and Password. 6. Select a database catalog to connect to. 7. Test the database connection. 8. Verify the connection. 9. In case of an unsuccessful connection, review parameters.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Figure 7-1: OLE DB Provider: Selection Tab. 3. In the list of OLE DB Providers, select Netezza OLE DB Data Provider (which was installed as part of the OLE DB Provider installation procedure) and click Next. The OLE DB Connection tab appears, as in Figure 7-2. 7-4 20751-12 Rev.
Configuring an OLE DB Data Source Figure 7-2: OLE DB Provider: Connection Tab. 4. In the Data Source box, specify the name of the Netezza system on which the database resides. 5. Specify appropriate values for User ID and Password. 6. From the drop-down list, choose the name of the database catalog to connect to. 7. Click the Test Connection button in the lower right corner of the Connection Tab. 8.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide Figure 7-4: OLE DB Provider: Advanced Tab. 7-6 20751-12 Rev.
APPENDIX A ODBC Configuration Files What’s in this appendix Netezza ODBC Driver unixODBC Driver Manager DataDirect Driver Manager Investigating Client System Configuration This appendix introduces advanced considerations for configuring ODBC drivers and data sources on Linux/UNIX client systems, with respect to locating the .odbcinst.ini and .odbc.ini configuration files. Netezza ODBC Driver This section discusses the names and locations of the two ODBC configuration files.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide 3. If the driver does not find hidden configuration files in the current user’s home directory, it next looks in the /usr/local/etc directory for the two non-hidden files odbcinst.ini and odbc.ini. If the two configuration files exist as hidden files in the /usr/local/etc directory, the driver ignores them.
DataDirect Driver Manager Place hidden configuration files in each user’s home directory if each user needs to access different Netezza appliance data sources. Place non-hidden configuration files in the /usr/local/etc directory if all users will access the same Netezza appliance data sources. With the unixODBC driver manager, you do not need to use the NZ_ODBC_INI_PATH environment variable.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide 2. Shared Configuration Files. Use this method if you would like all users of the Linux/ UNIX client system to use the same set of ODBC configuration files. Configure the NZ_ODBC_INI_PATH environment variable so it specifies the /etc directory, and place the two non-hidden configuration files odbcinst.ini and odbc.ini in the /etc directory.
APPENDIX B Troubleshooting What’s in this appendix ODBC Debug Logging and Driver Manager Tracing JDBC Debug Logging OLE DB Debug Logging This appendix introduces methods for tracking system activity, which can help in detecting problems and troubleshooting issues. A debug log provides you with a record of system activity, so you can take steps to correct problems.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide 7. Click OK to save your settings. Figure B-1: Enabling Debug Logging Enabling ODBC Logging in UNIX/Linux Use the following steps to enable ODBC Logging in UNIX/Linux: 1. Open the .odbcinst.ini file. 2. In the NetezzaSQL section, set DebugLogging = true. 3. Save and close the file. The ODBC log will be saved in the LogPath value, and the log file name is nzodbc_.log. ODBC Driver Manager Tracing By default, tracing is disabled.
JDBC Debug Logging Enabling ODBC Driver Manager Tracing for UNIX/Linux Use the following steps to enable ODBC Driver Manager Tracing in UNIX/Linux. 1. Open the .odbcinst.ini file. 2. Make the following changes in ODBC: Trace = 1 TraceAutoStop = 0 TraceFile = /tmp 3. Save and close the file. The log file will be saved in /tmp.
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide loggertype You can set the following case-insensitive log format types: loggertype=text (Default) loggertype=html logdirpath You can set the directory path for the log files, as in the following: logdirpath= The default values for logdirpath are as follows: Windows: UNIX/Linux: /tmp/ C:\ Connection String Examples Separate connection string components with a semicolon, as in the following exam
Index Index A Windows 6-1 online documentation Oracle Sun Developer Network URL -xv architecture 1-2 C M Character Translation Option window 5-2 client tools uninstall Windows 3-4 configuration files. See ODBC driver or data source configuration files. configuration. See ODBC or JDBC driver or data source configuration. MDAC 4-3 Microsoft Data Access Component (MDAC) 4-3 D data source configuration. See ODBC or JDBC data source configuration. data sources. See ODBC or JDBC data sources.
Index Optimize for ASCII character set option 5-2 R release compatibility 2-2 S supported platforms 2-1 U unixODBC driver manager A-2 installation procedure 4-4 installation steps 4-4 V Visual Studio 8 (VC8) Libraries 5-3 Index-2
