Features

• Connection to HubSpot - The connectivity solution enables various ODBC-aware applications to connect to HubSpot directly via HTTPS. If you have no direct access to HubSpot via HTTPS, you have the option of establishing a connection through a proxy server.
• Extended SQL Syntax - The ODBC driver provides an opportunity to work with HubSpot 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.
  • and many more.
• DML Operations - Devart ODBC Driver for HubSpot provides support for DML which allows you to modify data in HubSpot the same way as in SQL databases:
  • INSERT.
  • UPDATE.
  • DELETE.
• Cost-Effective Deployment - The ODBC driver is 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.
• ODBC Conformance - The driver provides full support for common ODBC interface:
  • ODBC API function support.
  • ODBC Data Types support.
• In addition, it provides support for Advanced Connection String parameters, allowing any desktop or web application to connect to HubSpot from various environments and platforms that support ODBC.
• HubSpot Compatibility - The ODBC driver has full support for HubSpot field data types and the driver is compatible with the HubSpot API itself.
• Metadata caching greatly improves performance while decreasing the number of requests sent to cloud applications.