Features

• Extended SQL Syntax - Work with Marketo objects just as with SQL tables. The extended SQL syntax allows you to use all the SQL benefits in SQL-92 compatible SELECT statements:
  • Complex JOINs
  • WHERE conditions
  • Subqueries
  • GROUP statements
  • Aggregation functions
  • ORDER statements
• 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

Why Choose Devart ODBC Driver for Marketo?

• Integration - The driver is compatible with third-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems, such as Visual Studio.
• Cost-Effective Deployment - A standalone installation file that doesn't require the user to deploy and configure any client software or vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations with hundreds of machines.
• Platforms Variety - The Marketo ODBC driver can be used by 32-bit and 64-bit applications on x32 and x64 Windows platforms, as well as on Linux and macOS. Therefore, the driver, applications, and environment do not need to be configured in any additional way.
• Fully Unicode-Compliant Driver - With this fully Unicode-compliant driver, you can properly retrieve and modify any multilingual Marketo data, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.

Connection to Marketo
This connectivity solution enables various ODBC-aware applications to connect to Marketo directly via HTTPS. If you have no direct access to Marketo via HTTPS, you have the option of establishing a connection through a proxy server.

Marketo ODBC Driver Overview

• DML Operations - Devart ODBC Driver for Marketo provides support for DML which allows you to modify data in Marketo the same way as in SQL databases:
  • INSERT
  • UPDATE
  • DELETE
• ODBC Conformance - ODBC driver for Marketo provides full support for common ODBC interface:
  • ODBC API Functions support
  • ODBC Data Types support
  • In addition, support is provided for Advanced Connection String parameters, allowing any desktop and web applications to connect to Marketo from various environments and platforms that support ODBC.
• High Performance - Every operation with Marketo becomes significantly faster using such capabilities of this ODBC driver for Marketo as local data caching, connection pooling, and much more.
• Advanced Data Conversion - Advanced Data Conversion mechanisms have been implemented providing a bi-directional mapping between Marketo and ODBC data types.
• Marketo Compatibility - Full support for Marketo field data types and, the driver is compatible with the Marketo API itself.
  • Marketo API
  • Marketo Data Types