Database | Driver | |
---|---|---|
Actian Matrix (formerly ParAccel) . | WINDOWS | LINUX ODBC Driver for ParAccel Download | MAC Actian Matrix JDBC Driver . Download |
Actian Vector | WINDOWS | LINUX VW ODBC Driver Download | MAC VW JDBC Driver Download |
Alation | WINDOWS | LINUX | MAC Alation Readme | |
Amazon Athena | WINDOWS | LINUX Amazon Athena JDBC driver Download | MAC Amazon Athena JDBC driver Installed with MicroStrategy |
Amazon Aurora (MySQL Compatible) | WINDOWS | LINUX MySQL ODBC driver (Unicode version) Download | MAC MySQL JDBC driver Download |
Amazon EMR | WINDOWS | LINUX MicroStrategy Hive ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Hive JDBC Driver Installed with MicroStrategy |
Amazon Redshift | WINDOWS MicroStrategy ODBC Driver for Amazon RedShift Wire Protocol Installed with MicroStrategy | LINUX | MAC MicroStrategy JDBC Driver for Amazon RedShift Wire Protocol Installed with MicroStrategy |
Amazon S3 | WINDOWS | LINUX | MAC Amazon S3 Readme | |
Apache Drill | WINDOWS | LINUX MicroStrategy Drill ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Drill JDBC Driver Installed with MicroStrategy |
Apache Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Hive JDBC Driver Installed with MicroStrategy |
Apache Impala | WINDOWS | LINUX MicroStrategy Impala ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Impala JDBC Driver Installed with MicroStrategy |
Apache Solr | WINDOWS | LINUX | MAC Apache Solr Driver Readme | |
Apache Spark SQL | WINDOWS | LINUX MicroStrategy Spark ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Spark JDBC Driver Installed with MicroStrategy |
Arcadia Data | WINDOWS | LINUX MicroStrategy Impala ODBC driver Installed with MicroStrategy | MAC MicroStrategy Impala JDBC driver Installed with MicroStrategy |
AtScale | WINDOWS | LINUX | MAC AtScale Driver Readme | |
Box | WINDOWS | LINUX | MAC Box Driver Readme | |
CA Technologies Rally | WINDOWS CA Technologies Rally Driver Readme | LINUX | MAC CA Technologies Rally Driver Readme |
Cassandra | WINDOWS | LINUX MicroStrategy Cassandra ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Cassandra ODBC Driver Coming soon to MicroStrategy |
Cirro | WINDOWS | LINUX Cirro Contact representative | MAC Cirro Coming soon to MicroStrategy |
Cisco Data Virtualization | WINDOWS | LINUX Cisco DV ODBC Driver Download | MAC Cisco DV JDBC Driver Download |
Clipboard | WINDOWS | LINUX | MAC Clipboard Installed with MicroStrategy | |
Cloudera CDH Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Impala JDBC Driver Installed with MicroStrategy |
Concur | WINDOWS | LINUX | MAC Concur Installed with MicroStrategy | |
Cvent Data | WINDOWS | LINUX | MAC Cvent Data Readme | |
Data.world | WINDOWS | LINUX | MAC Data.world Driver Readme | |
DataDirect Cloud | WINDOWS | LINUX | MAC DataDirect Cloud ODBC Driver Contact representative | |
Denodo | WINDOWS | LINUX PostgreSQL ODBC driver Installed with MicroStrategy | MAC PostgreSQL JDBC driver Download |
Dropbox | WINDOWS | LINUX | MAC Dropbox Installed with MicroStrategy | |
Druid | WINDOWS | LINUX | MAC Druid Driver Readme | |
ElasticSearch | WINDOWS | LINUX | MAC ElasticSearch Driver Readme | |
Eloqua | WINDOWS | LINUX | MAC Eloqua Driver Installed with MicroStrategy | |
EXAsolution | WINDOWS | LINUX EXAsolution ODBC driver Download | MAC EXAsolution JDBC driver Download |
WINDOWS | LINUX | MAC Facebook Installed with MicroStrategy | ||
Fitbit | WINDOWS | LINUX | MAC Fitbit Readme | |
Google Analytics | WINDOWS | LINUX | MAC Google Analytics Driver Installed with MicroStrategy | |
Google BigQuery | WINDOWS | LINUX MicroStrategy Google BigQuery ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Google BigQuery JDBC Driver Installed with MicroStrategy |
Google Drive | WINDOWS | LINUX | MAC Google Drive Installed with MicroStrategy | |
Hadoop | WINDOWS | LINUX | MAC Hadoop Gateway Readme | |
Hbase via Phoenix | WINDOWS | LINUX | MAC Phoenix JDBC Driver Download | |
Hortonworks HDP Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Hive JDBC Driver Installed with MicroStrategy |
HP Vertica | WINDOWS Vertica ODBC Driver Download LINUX Vertica ODBC Driver Download | MAC Vertica JDBC Driver Download |
Hubspot | WINDOWS | LINUX | MAC Hubspot Installed with MicroStrategy | |
IBM Cognos TM1 | WINDOWS | LINUX MicroStrategy MDX Cube Provider Installed with MicroStrategy | |
IBM DB2 for i | WINDOWS | LINUX MicroStrategy ODBC Driver for DB2 Wire Protocol Installed with MicroStrategy | MAC MicroStrategy Db2 JDBC Driver Installed with MicroStrategy |
IBM DB2 for Linux, UNIX and Windows | WINDOWS | LINUX MicroStrategy ODBC Driver for DB2 Wire Protocol Installed with MicroStrategy | MAC MicroStrategy Db2 JDBC Driver Installed with MicroStrategy |
IBM DB2 for Z/OS | WINDOWS | LINUX MicroStrategy ODBC Driver for DB2 Wire Protocol Installed with MicroStrategy | MAC MicroStrategy Db2 JDBC Driver Installed with MicroStrategy |
IBM Informix | WINDOWS | LINUX IBM Informix ODBC Driver from the Informix Client Software Development Kit Download | MAC IBM Informix JDBC Driver Download |
IBM Informix Extended Parallel Server | WINDOWS IBM Informix ODBC Driver from the Informix Client Software Development Kit Download LINUX IBM Informix ODBC Driver from the Informix Client Software Development Kit Download MAC IBM Informix JDBC Driver Download | WINDOWS IBM Data Server Driver Package Download LINUX IBM Data Server Driver Package Download |
IBM Netezza/IPS | WINDOWS | LINUX Netezza ODBC Driver Download | MAC Netezza JDBC Driver Download |
Infobright | WINDOWS | LINUX MySQL ODBC driver (Unicode version) Download | MAC MySQL JDBC driver Download |
Informatica Data Services | WINDOWS | LINUX Informatica Data Source ODBC Driver Contact representative | MAC Informatica Data Source JDBC Driver Contact representative |
Jira | WINDOWS | LINUX | MAC Jira Readme | |
Kognitio WX2 | WINDOWS | LINUX Kognitio ODBC Driver Contact representative | MAC Kognitio JDBC Driver Contact representative |
MapR Drill | WINDOWS | LINUX MicroStrategy Drill ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Drill JDBC Driver Installed with MicroStrategy |
MapR Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Hive JDBC Driver Installed with MicroStrategy |
MapR Spark | WINDOWS | LINUX MicroStrategy Spark ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Spark JDBC Driver Installed with MicroStrategy |
MariaDB | WINDOWS | LINUX MySQL ODBC Driver (Unicode version) Download | MAC MySQL JDBC Driver Download |
Marketo | WINDOWS | LINUX | MAC Marketo Driver Installed with MicroStrategy | |
MarkLogic | WINDOWS | LINUX MarkLogic SQL ODBC Driver Download | |
MemSQL (3.x and 4.x only) | WINDOWS | LINUX MySQL ODBC Driver (Unicode version) Download | MAC MySQL JDBC Driver Download |
Microsoft Azure Cosmos DB | WINDOWS | LINUX Microsoft Azure Cosmos DB Driver Readme | |
Microsoft Azure HDInsights | WINDOWS | LINUX MicroStrategy Hive ODBC Driver Installed with MicroStrategy | MAC MicroStrategy Hive JDBC Driver Installed with MicroStrategy |
Microsoft Azure SQL Data Warehouse | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol Installed with MicroStrategy | MAC MicroStrategy SQLServer JDBC Driver Installed with MicroStrategy |
Microsoft Azure SQL Database | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol Installed with MicroStrategy | MAC MicroStrategy SQLServer JDBC Driver Installed with MicroStrategy |
Microsoft SQL Database | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol Installed with MicroStrategy | MAC MicroStrategy SQLServer JDBC Driver Installed with MicroStrategy |
Microsoft SQL Server | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol Installed with MicroStrategy | MAC MicroStrategy SQLServer JDBC Driver Installed with MicroStrategy |
Microsoft SQL Server Analysis Services | WINDOWS | LINUX MicroStrategy MDX Cube Provider Installed with MicroStrategy | |
Microsoft SQL Server Parallel Data Warehouse | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol Installed with MicroStrategy | MAC MicroStrategy SQLServer JDBC Driver Installed with MicroStrategy |
MongoDB | WINDOWS | LINUX MicroStrategy MongoDB ODBC Driver Installed with MicroStrategy | MAC MicroStrategy MongoDB JDBC Driver Installed with MicroStrategy |
MongoDB Connector for BI | WINDOWS | LINUX | MAC MySQL JDBC driver Download | |
Mulesoft | WINDOWS | LINUX | MAC Mulesoft Driver Readme | |
MySQL | WINDOWS | LINUX MySQL ODBC driver (Unicode version) Download | MAC MySQL JDBC driver Download |
Neo4J | WINDOWS | LINUX | MAC Neo4J Driver Readme | |
OBIEE | WINDOWS | LINUX | MAC OBIEE Driver Installed with MicroStrategy | |
Okta | WINDOWS | LINUX | MAC Okta Driver Readme | |
Oracle Database | WINDOWS | LINUX MicroStrategy ODBC Driver for Oracle Wire Protocol Installed with MicroStrategy | |
Oracle Essbase | WINDOWS | LINUX MicroStrategy MDX Cube Provider Installed with MicroStrategy | |
Paypal | WINDOWS | LINUX | MAC Paypal Installed with MicroStrategy | |
Pivotal Greenplum | WINDOWS | LINUX DataDirect ODBC Drivers for Pivotal Greenplum Download | MAC DataDirect JDBC Drivers for Pivotal Greenplum Download |
PostgreSQL | WINDOWS | LINUX PostgreSQL ODBC driver Installed with MicroStrategy | MAC PostgreSQL JDBC driver Download |
Presto | WINDOWS | LINUX | MAC Presto JDBC Driver Installed with MicroStrategy | |
Salesforce | WINDOWS | LINUX Microstrategy ODBC driver for Salesforce Installed with MicroStrategy | MAC Microstrategy JDBC driver for Salesforce Installed with MicroStrategy |
SAP HANA | WINDOWS | LINUX SAP HANA HDBODBC64 ODBC Driver Download | MAC SAP HANA JDBC Driver Download |
SAP Netweaver BW | WINDOWS SAP Java Connector Download | LINUX SAP Java Connector Download |
SAP Sybase ASE | WINDOWS | LINUX MicroStrategy ODBC Driver for Sybase ASE Wire Protocol Installed with MicroStrategy | MAC MicroStrategy Sybase ASE JDBC Driver Installed with MicroStrategy |
SAP Sybase IQ | WINDOWS | LINUX | MAC Sybase IQ ODBC Driver Contact representative | |
ServiceNow | WINDOWS | LINUX | MAC ServiceNow Installed with MicroStrategy | |
Sharepoint Files | WINDOWS | LINUX | MAC Sharepoint Files Readme | |
Shopify | WINDOWS | LINUX | MAC Shopify Installed with MicroStrategy | |
Snowflake | WINDOWS | LINUX Snowflake DSII Driver Download | MAC Snowflake JDBC Driver Download |
Splunk | WINDOWS | LINUX Splunk ODBC Driver Download | |
Square | WINDOWS | LINUX | MAC Square Installed with MicroStrategy | |
Stratio Crossdata | WINDOWS | LINUX | MAC Stratio Crossdata Installed with MicroStrategy | |
SurveyMonkey | WINDOWS | LINUX | MAC SurveyMonkey Readme | |
TapClicks | WINDOWS | LINUX | MAC TapClicks Readme | |
Teradata | WINDOWS Teradata ODBC Driver Download LINUX Teradata ODBC Driver Download | MAC Teradata JDBC Driver Download |
Teradata Aster | WINDOWS | LINUX Aster ODBC Driver Download | MAC Aster JDBC Driver Download |
XML Files | WINDOWS | LINUX | MAC XML Files Readme | |
Yellowbrick | WINDOWS | LINUX XML Files Readme | MAC PostgreSQL JDBC driver Download |
Zendesk | WINDOWS | LINUX | MAC Zendesk Connector Installed with MicroStrategy |
We suggest that you use the MD5 checksums and GnuPG signatures to verify the integrity of the packages you download. Connector/ODBC is a standardized database driver for Windows, Linux, Mac OS X, and Unix platforms. This article provides commands for installing the ODBC driver from the bash shell. If you want to download the packages directly, see Download ODBC Driver for SQL Server. Microsoft ODBC 17. To install Microsoft ODBC driver 17 for SQL Server on macOS, run the following commands. Redis ODBC Driver for Mac Unicode enabled 32/64-bit ODBC Driver for Mac. Connect to Redis high-performance data stores from popular Mac applications like FileMaker Pro and Office for Mac. Trusted Mac download Actual ODBC Driver for Access 3.2. Virus-free and 100% clean download. Get Actual ODBC Driver for Access alternative downloads.
Similar to Windows, macOS utilizes named data sources (DSNs) for connecting ODBC-based client applications to Snowflake.
In this Topic:
Prerequisites¶
Operating System¶
For a list of the operating systems supported by Snowflake clients, see Operating System Support.
iODBC¶
The Snowflake ODBC driver for Mac requires iODBC, which is available for download from:
To install iODBC:
- After downloading iODBC, double-click on the downloaded .dmg file.
- Double-click on the installer file,
iODBC-SDK.pkg
, and follow the prompts.
Note
iODBC provides a GUI administrator tool for configuring drivers and DSNs; however, this tool has not been tested for use with Snowflake and, therefore, should not be used to create or manage DSNs. Use ODBC Manager instead.
ODBC Manager — Optional/Recommended¶
![Download Odbc Driver For Mac Download Odbc Driver For Mac](/uploads/1/2/6/5/126591007/528908714.jpeg)
ODBC Manager is a GUI tool for configuring drivers and creating/managing DSNs. The tool is optional because you can also create DSNs manually by editing the appropriate
odbc.ini
file. ODBC Manager is available from:To install ODBC Manager:
- After downloading ODBC Manager, double-click on the downloaded .dmg file.
- Double-click on the installer file,
ODBCManager.pkg
, and follow the prompts.
The installer installs ODBC Manager in the
~/Applications/Utilities
directory.Step 1: Install the ODBC Driver¶
To install the Snowflake ODBC driver for macOS:
- If you haven’t already downloaded the driver, download it now. For details, see Downloading the ODBC Driver.
- Double-click on the downloaded .dmg file,
snowflake_odbc_mac-<version>.dmg
. - Double-click on the installer file,
snowflakeODBC_<version>.pkg
, and follow the prompts.You will likely be prompted for the administrator/sudo password for the machine on which you are installing the driver.
If you choose the default directory when prompted, the installer installs the ODBC driver files in the following directories:
Step 2: Configure the ODBC Driver¶
To configure the ODBC driver for macOS, create one or more data source (DSNs), which are stored in the following files, depending on the type of DSN you create:
- User DSNs:
~/Library/ODBC/odbc.ini
- System DSNs:
/Library/ODBC/odbc.ini
To create a DSN, either use ODBC Manager or edit the appropriate
odbc.ini
file.Creating a DSN Using ODBC Manager¶
To create a DSN in ODBC Manager:
- Start ODBC Manager.
- Click on User DSN or System DSN.
- Click the Add button.
- Select the driver to use (Snowflake) and click OK.
- Enter the name of the DSN and optionally a description.
- Create a Keyword/Value pair for each DSN parameter:
- Click Add to create a Keyword/Value pair.
- Select Keyword and replace it with the parameter name.
- Select Value and replace it with the value for the parameter.
Repeat this process for each parameter. For details about the parameters that can be set for each DSN, see ODBC Configuration and Connection Parameters. - Click OK to create the DSN.
If you are creating the first user or system DSN for the ODBC driver, ODBC Manager creates the
odbc.ini
file in the corresponding directory for the type of DSN you are creating. If you are creating additional DSNs, ODBC Manageradds entries for each DSN to the existing odbc.ini
file.Creating a DSN by Adding an Entry in the odbc.ini
File¶
If a user or system DSN has already been created for the driver, add the new entry to the
odbc.ini
file that already exists in the corresponding directory for the type of DSN you are creating. If you are creating the first DSNfor the driver, you must manually create the odbc.ini
file and add the entry to the file.For each DSN, specify:
- DSN name and driver name (Snowflake), in the form of
<dsn_name>=<driver_name>
. - Directory path and name of the driver file, in the form of
Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
. - Connection parameters, such as
server
anduid
(user login name). Any connection parameters you add to the DSN do not need to be specified in the ODBC connect string. - Any additional parameters, such as default
role
,database
, andwarehouse
.
Parameters are specified in the form of
<parameter_name>=<value>
. For details about the parameters that can be set for each DSN, see ODBC Configuration and Connection Parameters.The following example illustrates an
odbc.ini
file containing two drivers, testodbc1
for account xy12345
(located in the AWS US West region) and testodbc2
for account yz23456
(located in the AWS US East region):Note the following:
- Both
testodbc1
andtestodbc2
have default roles. testodbc2
also has a default database and warehouse.
Step 3: Test the ODBC Driver¶
Download Odbc Driver For Ms Access 64 Bit
You can use the
iodbctest
command line utility provided with iODBC to test the DSNs you create.When prompted for the ODBC connect string, enter the required connection parameters (DSN name, server, user login name, and password), as well as any other parameters that you would like to enter as part of the connect string. Theconnect string takes parameters in the form of
<parameter_name>=<value>
, e.g. dsn=testodbc2
, with each parameter separated by a semi-colon (;
) and no blank spaces. For the list of supported parameters, seeODBC Configuration and Connection Parameters.Microsoft Odbc Driver Download
Note
Download Odbc Driver For Macos
If you set the server and user login name in the DSN, the only required parameters in the connect string are the DSN name and user password.
Download Odbc Driver For Mysql
For example: