Odbc For Mac Os X



Odbc for mac os x 10.10

ODBC Administrator is a 32-bit utility in the Mac OS X operating system for administering ODBC, which enables interaction with ODBC-compliant data sources.Features include connection pooling, trace log creation, and ODBC driver management, among other administration features. Although Apple started including the underlying iODBC libraries in Mac OS X 'Jaguar' (10.2.x), and has continued to do. Configuring Mac OS X Data Source Names. There are two methods, which users may employ to configure Mac OS X data source names. Expert users may configure the ODBC.preference file with TextEdit or a similar text editor. Novice users may use an Aqua GUI ODBC Administrator. The ODBC.preference File. ODBC Manager is a replacement for Apple's ODBC administrator utility, which is no longer included with Mac OS X (starting with Snow Leopard). ODBC Manager also addresses some of the problems. Refer to your Mac OS X shell documentation for details on how to set environment variables permanently. Configure Hive ODBC Connections on Mac OS X. See Configuring ODBC Connections for Linux for details on creating ODBC connections. ODBC Manager is a replacement for Apple's ODBC administrator utility, which is no longer included with Mac OS X (starting with Snow Leopard). ODBC Manager also addresses some of the problems.

System Requirements

  • Mac OS X version 10.6.8 or later
  • 100 MB of available disk space
  • iODBC 3.52.7 or above
  • unixODBC 2.2.12 or above

The MapR ODBC Driver with SQL Connector for Apache Hive requires a Hadoop cluster with the Hive service installed and running. The MapR ODBC Driver with SQL Connector for Apache Hive is suitable for use with all versions of Hive. The driver supports both 32- and 64-bit client applications.

Download the MacOS Hive ODBC connector from https://package.mapr.com/tools/MapR-ODBC/MapR_Hive/MapRHive_odbc_2.6.1.1001/MapRHiveODBC.dmg.

Installation

Odbc

The MapR ODBC Driver with SQL Connector for Apache Hive driver files are installed in the following directories:

  • /opt/mapr/hiveodbc/ErrorMessages – Error messages files directory
  • /opt/mapr/hiveodbc/Setup – Sample configuration files directory
  • /opt/mapr/hiveodbc/lib/universal – Binaries directory

To install the MapR ODBC Driver with SQL Connector for Apache Hive:

  1. Double-click to mount the MapRHiveODBC.dmg disk image.
  2. Double-click MapRHiveODBC.pkg to run the Installer.
  3. Follow the instructions in the Installer to complete the installation process.
  4. When the installation completes, click Close.

Configuration

Setting the DYLD_LIBRARY_PATH Environment Variable

Odbc

The DYLD_LIBRARY_PATH environment variable must include the paths to:

Odbc
  • Installed ODBC driver manager libraries
  • Installed MapR ODBC Driver with SQL Connector for Apache Hive shared libraries

For example, if ODBC driver manager libraries are installed in /usr/local/lib, then set DYLD_LIBRARY_PATH as follows:

export DYLD_LIBRARY_PATH=/usr/local/lib/opt/mapr/hiveodbc/lib/universal

Refer to your Mac OS X shell documentation for details on how to set environment variables permanently.

Configure Hive ODBC Connections on Mac OS X

See Configuring ODBC Connections for Linux for details on creating ODBC connections.

You can use an ODBC client tool to connect to Impala from Mac OS X. Install the driver and configure it to pass a SQL query to Impala. After you install the driver, see Configure the MapR Impala ODBC Driver for Linux and Mac OS X.

Before you install the driver, verify that your system meets the following prerequisites:
  • Mac OS X version 10.8 or later
  • 100 MB of available disk space
  • iODBC 3.52.7 or above
To install and configure the MapR Impala ODBC Driver, complete the following steps:
  1. Download the MapR Impala ODBC Driver.
  2. Install the MapR Impala ODBC Driver on the machine from which you connect to the Impala service. The driver supports 32- and 64-bit applications. To install the driver:
    1. Double-click to mount the MapRImpalaODBC.dmg disk image.
    2. Double-click MapRImpalaODBC.pkg to run the Installer.
    3. Follow the instructions in the installer to complete the installation process.
    4. When the installation completes, click Close.
    MapR Impala ODBC Driver files install in the following locations:
    • /opt/mapr/impalaodbc/ErrorMessages – Error messages files directory
    • /opt/mapr/impalaodbc/Setup – Sample configuration files directory
    • /opt/mapr/impalaodbc/lib/universal – Binaries directory
  3. Update the DYLD_LIBRARY_PATH environment variable. The DYLD_LIBRARY_PATH environment variable must include the paths to the:
    • Installed ODBC driver manager libraries
    • Installed MapR Impala ODBC Driver for Impala shared libraries

    For example, if the ODBC driver manager libraries are installed in /usr/local/lib, then set DYLD_LIBRARY_PATH to the following:

Odbc For Mac Os X 10.8

Next Step: See Configure the MapR Impala ODBC Driver for Linux and Mac OS X.