Features

• Connection to Snowflake - This data connector enables various ODBC-aware applications to connect to Snowflake directly via HTTPS. If you have no direct access to Snowflake via HTTPS, you have the option of establishing a connection through a proxy server.
• Snowflake Standard SQL - Supports all of the Snowflake standard SQL expressions, including functions and operations, and all of the Snowflake data types, including:
  • Aggregate functions
  • Array functions
  • Datetime functions
  • Geography functions
  • JSON functions
  • Navigation functions
  • Net functions
  • Hash functions
• Integration - The driver is compatible with 3rd-party data analysis tools, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.
• Cost-Effective Deployment - A standalone installation file that doesn't require the user to deploy and configure any additional software such as a database client or a vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.
• Platforms Variety - The driver can be used with 32-bit and 64-bit applications on both platforms, so there is no need to configure the driver, applications or environment.
• Fully Unicode-Compliant Driver - You can retrieve and modify any data in multilingual Snowflake databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.
• ODBC Conformance - ODBC driver for Snowflake provides full support for common ODBC interface:
  • ODBC API Functions support.
  • ODBC Data Types support.
  • In addition, it provides support for Advanced Connection String parameters. Thus allowing any desktop and web applications to connect to Snowflake from various environments and platforms that support ODBC.
• DML Operations - Devart ODBC driver for Snowflake provides support for DML which allows you to modify data in a Snowflake data warehouse in the same way as in any other SQL database:
  • INSERT
  • UPDATE
  • DELETE
• Snowflake Compatibility - The ODBC driver has full support for Snowflake field data types and, moreover, the driver is compatible with the Snowflake API itself.
  • Snowflake API.
  • Snowflake Data Types.
• Advanced Data Conversion - Advanced Data Conversion mechanisms have been implemented that provide bi-directional mapping between any Snowflake and ODBC data types.
• High Performance - Every operation with Snowflake becomes significantly faster using features such as local data caching, connection pooling, and much more.
• Verified Compatibility With Data Integration Tools - Devart ODBC drivers are verified to be compatible with leading analytics and reporting tools, various IDEs, and programming languages. Get fast and secure access to your data in any application:
  • Database Management Software
    • SQL Server Management Studio (SSMS)
    • Microsoft Access
    • DBeaver
    • RazorSQL
    • and others
  • Business Intelligence & Analytics Software
    • Power BI
    • Tableau
    • QlikView
    • TIBCO Spotfire
    • and others
  • Document Management Software
    • Microsoft Excel
    • LibreOffice
    • OpenOffice
    • StarOffice
    • and others
  • Application Development Tools
    • Microsoft Visual Studio
    • Python, PHP
    • FileMaker
    • C++ Builder
    • and others