[Progress Communities] [Progress OpenEdge ABL] Forum Post: 2020.2 Progress DataDirect for JDBC for HubSpot Driver: Initial Preview Release

Status
Not open for further replies.
A

Avadhoot Kulkarni

Guest
Feature Description: The Progress DataDirect for JDBC for HubSpot (HubSpot driver) driver supports SQL read‐only access for JDBC applications to HubSpot services. The driver provides access to data in HubSpot Cloud service, which can be pulled into a data visualization tool to get important insights into marketing operations. Besides, the driver employs a SQL engine component that provides support to SQL constructs to provide the most comprehensive SQL support and JDBC standard‐based connectivity to BI and ETL tools. To support SQL access to HubSpot service, the driver creates a relational map of the HubSpot data model and translates SQL statements to HubSpot REST API requests. Minimum Requirements: The driver is compatible with JDBC 2.0, 3.0, 4.0, 4.1, and 4.2. The driver requires a Java Virtual Machine (JVM) that is Java SE 8 or higher, including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions. Authentication The HubSpot driver supports the following authentication methods: API Key Authentication OAuth 2.0 Authentication Connection information required to establish a connection to HubSpot services using API Key Authentication: authenticationMethod=UrlParameter; apikey Connection information required to establish a connection to HubSpot services using OAuth: Client ID Client Secret Refresh Token You must register an application with HubSpot to obtain the required connection information. See the HubSpot documentation for specific information on this process: OAuth 2.0 Overview Configuration Manager The driver includes a browser-based tool, Progress DataDirect HubSpot Configuration Manager, which allows you to generate connection URLs, test connections, and execute test queries. To open the Configuration Manager, double-click the driver-jar file; or, execute the following command at a command prompt in the directory containing your driver jar file: java -jar hubspot.jar From the browser window, provide values of the connection properties you want to configure in the corresponding fields. A connection URL will generate in the Connection String field as you provide settings. Documentation for the various connection properties will be displayed in the right pane of the Configuration Manager on clicking any property, or its text entry box. Limitations/Known Issues: The driver currently supports connections to the QUOTES_V3 endpoint only through API key authentication. The driver currently provides access to several endpoints that are currently in the beta stage of development. Their availability and working are dependent on HubSpot service continuing to support them. Installation Guides: Progress® DataDirect® Installation Notes: The preview installation will expire in 15 days after it is installed. No control numbers are required. For Serial Number, you can enter a numeric value, such as 123. Use Case: JDBC compliant applications needing connectivity to HubSpot to perform read-only queries. BI tools for data analysis. ETL tools performing operations (reading) data from HubSpot. Requested Feedback: Are you able to use the driver out of the box? If not, please provide details about the challenges you faced/are facing. What are your primary use cases, and is this driver solving them? Is the driver's performance acceptable for your primary use case? If not, please provide details on your use case, What operation is performed? How much is the data size? What are the expectations? What application do you envision building with the data available from HubSpot? What other data source connectivity you would need to make that vision reality. Download Information: User's Guide: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=31BX59J531Z25 Windows Installer: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=2VRD2UDCT3HVD All-platforms Installer: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=1VXVZOZZJTMRZ

Continue reading...
 
Status
Not open for further replies.
Top