topic Re: Work on HubSpot Data with Talend Open Studio for Data Integration in Talend Studio

Work on HubSpot Data with Talend Open Studio for Data Integration

AkGz — Fri, 26 Aug 2022 11:05:50 GMT

Hi community,

Currently, I'm trying to connect HubSpot in Talend Open Studio for Data Integration but I can't find anything on this topic or How to do it without pay a custom connector.

Someone already work with Talend and HubSpot to extract, create, modify or work on data ?

The really need is to create a connection in Talend to HubSpot to retrieve the tables and work on it.

Thanks

Re: Work on HubSpot Data with Talend Open Studio for Data Integration

Raghava534 — Fri, 26 Aug 2022 11:51:12 GMT

Can you have a try with JDBC connectors

Re: Work on HubSpot Data with Talend Open Studio for Data Integration

Anonymous — Mon, 29 Aug 2022 08:44:05 GMT

Hello,

Could you please give us some specification about HubSpot Data you are trying to connect? With Hubspot API, you could use tRESTXXX component to extract data through API call or using a JDBC API connection and extracts fields based on a query.

Best regards'

Sabrina

Re: Work on HubSpot Data with Talend Open Studio for Data Integration

AkGz — Wed, 31 Aug 2022 07:06:02 GMT

Hello @Raghava reddy , Hello @Xiaodi Shi

First thanks for your answer,

It seems that is possible with JDBC connector, but I'm unable to create one on myself or to have a paid one for now.

Is there any chance to have an example with tRestXXX ? I already tried with tRestClient but unclear for me. It seems that it's limited with the output format and the volumetry ?

Or if you have example of JDBC connector that you already use.

Thanks for help

FYI:

OS: Windows 11 Pro x64

Talend Open Studio for Data Integration Version: 8.0.1

Re: Work on HubSpot Data with Talend Open Studio for Data Integration

Stamen_Nikolov — Thu, 10 Nov 2022 10:25:21 GMT

Hi all,

I am currently trying to do the same with JDBC, but still unable to make it work. Anyone with recent feedback on this? Thank you!