Looking to connect JD Edwards with HubSpot

Developer Support APIs & Integrations
1

I am looking for some expert advice on how should I go about connect JD Edwards with HubSpot using API.

2

Hi, @AVij21 :waving_hand: Thanks for your question. I have some additional questions that can help you during your research process.

  • What specific data or functionality are you hoping to share between JD Edwards and HubSpot?
  • Is this a one-way sync or a two-way sync?
  • Are you looking for a real-time integration or something periodic?
  • Do any transformations or business logic need to be applied as data moves between the systems?
  • Are there specific security requirements?
  • Do you have a team in place, or are you seeking external resources for this project?
  • Are you looking for a pre-built solution, or a custom-built integration?
  • Have you already explored the available API endpoints on the JD Edwards side?
  • Do you have middleware in place? How do you plan to handle API calls, data formatting, and passing information between the two systems?

Having this info in hand will help you and whomever you partner with have a great chance at a successful outcome.

Have fun building! — Jaycee

3

@Jaycee_Lewis Thank you so much for sharing additional questions. We have asked these question to our client and currently awaiting their response. In the mean time I just wanted to understand the architecture that can be used.

4

Hi there! I didn’t have a solution. My hope was, we can spark a conversation. Lead the way with curiosity :blush:
I checked for existing solutions (I’m sure you did too)

  • Data Sync options in the Marketplace
  • JD Edwards APIs (didn’t find an official document to confirm or rule this one out)
  • Searched for 3rd party options (not much that I can find)

If there are HubSpot-specific question I can research, or invite some of our community members to help with, please let me know.

Have a fantastic weekend! — Jaycee

5

@Jaycee_Lewis I know this is a one of those new situations for us all. I really appreciate additional research. JDE’s API documentation is slightly difficult to read and comprehend as the architeture is very different. Some point we thought as potential solution were:
1. In order to connect HubSpot & JD Edwards, we will create a Private APP in HubSpot.
2. This will generate “Private Access Token” which would only be visible to a super admin in HubSpot and no one else.
3. This access token generate in HubSpot will give certain permission to JD Edward platform to read & write information in HubSpot via API.
4. While establishing the connection between platforms, this access token will be used.
5. Since JD Edwards is a ERP system, the modules that can be best used is the CRM module of it.
6. As JD Edwards is a Oracle product it would work on Data Tables just like any SQL database.
7. We can run queries on these tables to extract data out of them. The data would contain details like Name, Phone Number, Address etc.
8. We can run orchestrations with JDE platform but since we have no insights how the tool is being used, we cannot comment or suggest the best way of orchestration process.
Once we start on it we might have additional insights on this.