Yesterday, Simba officially announced our suite of. Every time I go to a Big Data conference like O’Reilly Strata or Hadoop Summit, I see a plethora of Macs. It seems that a lot of Data Scientists use Macs. In fact, Tableau, which seems to be the BI tool of choice in the Big Data space is soon coming out with a. Microsoft Excel on the Mac is also quite popular and many of us have wondered when Microsoft will come out with a full version of Pivot Tables on Mac Excel. The Simba ODBC drivers on the Mac include Hive, HBase, Cassandra, and MongoDB. Some of these drivers are already in production like the Hive Mac ODBC driver we have with Hortonworks.
Hortonworks has put together some good resources around this driver including this tutorial document: ““. If you are using HDP, you can download the Hive Mac ODBC driver here:.
Alternatively, you can go to the Simba website and get access to all the. Some of the Mac ODBC drivers are in Beta so if you can’t find the one you want, please email us: solutions at Simba dot com and we can get you set up quite quickly. All of the Simba Mac ODBC drivers are based on the. SimbaEngine ODBC SDK is the core tool that Simba uses to build all of our drivers.
Feb 23, 2018 I too need to get a Driver Manager working with the 12.2 Instant ODBC driver for Excel 2016 Oracle data sources. As you have probably noticed, there is a huge documentation gap. Oracle has not documented a working solution for installing any Driver Manager with their driver.
SimbaEngine ODBC SDK is also the tool used by many database companies to build their own ODBC drivers. So, if there is an ODBC driver that you need but can’t find, we can easily build it using SimbaEngine. The advantage of SimbaEngine is that it is fully cross platform.
This means SimbaEngine supports Mac, Windows, Linux, Solaris, AIX, and HP/UX. Therefore, an ODBC driver built using SimbaEngine can be deployed on any operating system. Post navigation. Simba is the industry choice for standards-based data access and analytics solutions, and for innovation in data connectivity.
Our reputation as the connectivity pioneer means we’re the preferred partner for SDKs – ODBC, JDBC, OLE DB for OLAP (ODBO) and XML for Analysis (XMLA) – and our technology is embedded into today’s most popular BI and analytics applications. A subsidiary of Magnitude Software, the unified data application management leader, Simba provides connectivity solutions that are pivotal to the vast operational efficiencies delivered by the Magnitude portfolio of products.
The following sections show how to connect to Excel from two driver managers available on Mac OS X, iODBC and unixODBC; you will provide the necessary connection properties in a DSN and execute SQL to Excel. The ExcelFile, under the Authentication section, must be set to a valid Excel File. Using a Driver Manager ODBC-compliant applications connect to the driver through a driver manager. After you connect, the driver manager loads the driver and passes function calls from the application to the driver.
The driver manager also implements some functions for metadata discovery about the registered drivers and DSNs. DSNs and drivers can be defined for a specific user or system wide. Ensure that you install the driver after installing a driver manager: The installation modifies the driver manager configuration files, if they exist, to register the driver with iODBC and unixODBC and create system DSNs with empty values for commonly required properties. IODBC On Mac OS X, the CData ODBC Driver for Excel 2016 is preconfigured for use with the iODBC driver manager, as are many other products like Filemaker Pro and Tableau.
The iODBC installation installs its own GUI, the iODBC Administrator, and several utilities for testing the connection and executing SQL queries. You can find the latest version of iODBC on the iODBC site. Note: Other GUIs that use iODBC are available: The ODBC Administrator tool can be downloaded from the Apple support site. However, it is no longer maintained. As an alternative, you can use the ODBC Manager tool from Actual Technologies. Using the iODBC Administrator You can create user DSNs, which are restricted to the currently logged in user, by opening the iODBC Administrator from Launchpad.
To modify the system DSN installed by the driver or create a system DSN, you will need to open the iODBC Administrator with elevated permissions. To do so, you can enter the following command into a terminal: sudo /Applications/iODBC/iODBC Administrator.app/Contents/MacOS/iODBC Administrator Another alternative is to enable the root user on your system and then log in under that user.
Please refer to the Apple documentation for more information. After opening the iODBC Administrator, you will see the CData Excel Source listed under the System tab. Select the DSN and click the Configure button to set connection properties as name-value pairs. Using the iODBC Configuration Files It is recommended to use the iODBC Administrator GUI to create ODBC data sources; however, you can also modify the configuration files of the iODBC driver manager, odbc.ini and odbcinst.ini. Odbc.ini ODBC data sources are defined in sections in the odbc.ini file. Privileges Path User /Users/myuser/Library/ODBC/odbc.ini System /Library/ODBC/odbc.ini The driver installation creates a system DSN with empty values for commonly required properties. Modifying iODBC's system-wide settings requires elevated permissions; to do so, you can use the sudo command to open a text editor from the terminal.
For example: sudo nano /Library/ODBC/odbc.ini In addition to the connection properties required to connect to your data source, the Driver property specifies either a driver definition in the odbcinst.ini file or the path to the driver library. You can also define User and Password properties in this section. CData Excel Source Driver = CData ODBC Driver for Excel MyConnectionProperty1 = My Value1 MyConnectionProperty2 = My Value2 Additionally, in the ODBC Data Sources section, the DSN must be set to a driver defined in the odbcinst.ini file. For example: ODBC Data Sources CData Excel Source = CData ODBC Driver for Excel odbcinst.ini This file contains ODBC drivers registered with the driver manager.
With iODBC, drivers can be available to only one user account or drivers can be available system wide. The installation of the driver automatically registers the driver, enabling system-wide access. Privileges Path User /Users/myuser/Library/ODBC/odbcinst.ini System /Library/ODBC/odbcinst.ini Drivers are defined in sections in the odbcinst.ini file.
The section name specifies the name of the driver. In this section, the Driver property specifies the path to the driver library. The driver library is the.dylib file located in the lib subfolder of the installation directory, by default in /Applications/CData ODBC Driver for Excel. CData ODBC Driver for Excel Driver = /Applications/CData ODBC Driver for Excel/lib/libexcelodbc.dylib The ODBC Drivers section must also contain a property with the driver name, set to 'Installed'.
ODBC Drivers CData ODBC Driver for Excel = Installed Testing the Connection You can use the iODBC Demo to connect to Excel and execute SQL queries. IODBC Demo Follow the procedure below to connect from the iODBC Demo:. Open Launchpad and search for 'iODBC'. If you need to connect to Excel from an application that can use only the ANSI ODBC API, click iODBC Demo Ansi. Otherwise, click iODBC Demo Unicode.
In the Environment menu, click Open Connection. Select the DSN on the corresponding tab and test the connection. You can now execute SQL statements to Excel: In the SQL menu, click Execute SQL. UnixODBC The unixODBC driver manager is widely supported by Python, Ruby, and other scripting languages. Installing unixODBC You can use the Homebrew package manager to install prebuilt binaries. To install Homebrew, run the following command: /usr/bin/ruby -e '$(curl -fsSL After installing Homebrew you can install unixODBC with the following command: brew install unixodbc Configuring the Driver The driver can easily be configured for the unixODBC driver manager by modifying its configuration file, cdata.odbc.excel.ini, which must be located next to the driver library. The driver library is the.dylib file located in the lib subfolder of the installation directory, by default /Applications/CData ODBC Driver for Excel.
In the configuration file, set the DriverManagerEncoding property to UTF-16. (On Mac OS X, the driver defaults to the encoding used by iODBC, UTF-32.) Driver DriverManagerEncoding = UTF-16 Using the unixODBC Configuration Files The unixODBC driver manager reads information about drivers from an odbcinst.ini file and about data sources from an odbc.ini file. Odbc.ini ODBC data sources can be accessible by only specific users or system wide. Privileges Path User /Users/myuser/.odbc.ini System /usr/local/etc/odbc.ini The driver installation creates a system data source with empty values for commonly required connection properties. You can access it in the terminal with a command like following: nano /usr/local/etc/odbc.ini In addition to the connection properties required to connect to your data source, the Driver property specifies either a driver definition in the odbcinst.ini file or the path to the driver library. You can also define the User and Password properties in this section.
CData Excel Source Driver = CData ODBC Driver for Excel Description = My Description MyConnectionProperty1 = My Value MyConnectionProperty2 = My Value2 odbcinst.ini The driver installation registers the driver with unixODBC, enabling system-wide access, by creating an entry in this file. Privileges Path System /usr/local/etc/odbcinst.ini The name of the section is the driver name.
The Driver property specifies to the path to the driver library. CData ODBC Driver for Excel Driver = /Applications/CData ODBC Driver for Excel/lib/libexcelodbc.dylib Testing the Connection You can use the isql tool, available in most unixODBC packages, to test the connection and execute SQL queries to Excel. When testing the connection, use the -v flag to output any messages from the driver manager and the driver. Isql -v 'CData Excel Source' Uninstalling the Driver The easiest way to uninstall is to open Terminal and run the included uninstall.sh script, located in the installation directory.
To ensure that the driver has sufficient permissions to remove all of the installed files, you will need to run the script as root or with sudo. Note that this script needs to be run from the installation directory, so you will need to run both of the following commands, or adjust the first command to your installation directory.
Cd /Applications/CData ODBC Driver for Excel sudo./uninstall.sh.