Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for HubSpot offers a high-performing, secure and reliable connectivity solution for ODBC applications to access HubSpot data. Our ODBC driver can be easily used with SQL across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.

    • Creates a relational map of the HubSpot data model and translates SQL statements to HubSpot requests
    • Employs a SQL engine component that provides support to SQL constructs unavailable in HubSpot
    • Integrates with leading BI, analytics and data management applications

    Features

    SQL Up Leveling/ Full ANSI SQL Support

    SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.

    Support for Oracle Security Features

    Our driver supports Oracle Advanced Security Data Integrity Checks, Oracle Wallet SSL Authentication and Oracle Internet Directory (OID) authentication without additional driver configuration.

    Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant

    We keep our SSL version up to date. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy.

    Performance Tuning

    Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)

    TSANet Multi-Vendor Support Channel

    We live for your next big customer. Make sure your customers are successful with 24/7 partner support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.

    Day 1 Support for any new versions

    Day One Support for disruptive technologies with frequent release cycles. With this strategy - the first of its kind for any data connectivity provider - Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources.

    Cross-platform Support

    Use one ODBC driver for all versions of SQL that works across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX .


    Technical Specifications

    Progress DataDirect for ODBC for HubSpot
    Version 8.0.0
    (32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)

    ODBC Version Support

    • Compatible with ODBC 3.8 applications

    Version Support

    • HubSpot API version 2 and 3

    Operating System Support

    Linux x86 (32- and 64-bit for AMD and Intel processors)

    • CentOS Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • Debian Linux x86, version 7.0, 8.0, 9.0, 10.0 and higher
    • Oracle Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • Red Hat Enterprise Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • SUSE Linux Enterprise Server Linux x86, version 10, 11, 12, 15 and higher
    • Ubuntu Linux x86, version 14.04, 16.04, 18.04, 20.04 and higher

    Windows (32- and 64-bit)

    • Windows (x86), version 7, 8.1, 10 and higher
    • Windows Server (x86), version 2008, 2012, 2016, 2019 and higher

    Driver/Client Software Requirements

    • A Java Virtual Machine that is Java SE 8 or higher, including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.


    Related Resources

    Webinar

    DevOps Dilemmas: Best Practices for Business Leaders

    Join us for an inside look at the challenges businesses face when DevOps data is divided across multiple systems. Our expert panel will discuss how they overcome this “DevOps dilemma” here at Progress—and the steps you can take to overcome it too

    Watch Webinar

    Webinar

    Shining the Light on Shadow Analytics with Martech Data Connectivity

    Shadow analytics presents a real problem for modern businesses. But with so many different martech tools in use and so much data being created, data connectivity obstacles can get in the way of productivity. Join us to see how you can overcome shadow analytics with instant connectivity to vital martech data.

    Watch Webinar

    Video

    Connect HubSpot to Tableau with DataDirect

    Follow along in this tutorial video to learn how to connect the Progress DataDirect HubSpot JDBC Driver to Tableau.

    Watch Video

    Paper

    Connect the Unconnectable: Enabling DevOps Dashboards for Siloed Data

    A cross-enterprise view of the DevOps process is key to powering the continuous improvement of the software development lifecycle. In this ebook, you’ll discover how to connect key DevOps tools to your analytics and reporting tools to create a unified DevOps view that addresses four central themes: 

    • Planning and Roadmap
    • Epics, Velocity and Ticketing 
    • Continuous Improvement/Continuous Delivery 
    • Reporting and OKRs 
    Work faster, save money and improve project visibility with a unified, cross-enterprise view of your DevOps process.  

    Download Paper

    Paper

    Shadow Analytics: What It Is and Why You Can’t Afford to Leave It Unchecked

    Thousands of martech solutions are being introduced every year, which makes it difficult to access the data from these solutions for reporting. Now, employees are going rogue and turning to “shadow analytics” to get what they need. So, what is shadow analytics and what can you do to stop it? Find out in our latest whitepaper.

    Download Paper

    Customer Success Stories

    Success Story

    NetSuite Improves Application Connectivity and Integration with DataDirect

    NetSuite needed application data connectivity demanded by existing customers and by the market at large. To solve this problem they leveraged the OpenAccess™ SDK for data connectivity supporting an extensive breadth of standards and implementations.

    Learn More

    Connect any application to any data source anywhere

    A product specialist will be glad to get in
    touch with you