Creatio / Hubspot Essentials Prebuilt Integration

Creatio / Hubspot Starter Template

Note: Before beginning it is important to understand that while this is a prebuilt integration it is highly recommended that someone who is familiar with both systems, their databases and your processes perform the implementation.  It is also recommended that thorough testing be done prior to turning the integration on.  Improper implementation can result in unwanted records being entered in your systems.
Overview

With your StarfishETL Professional Edition (or higher) subscription, you have free access to our Starter integrations.  This article discusses steps necessary to implement the Starter Template bundle for Creatio and Hubspot Marketing Automation.

Once you have subscribed to StarfishETL, you will be given a document that explains this integration in detail so you know exactly how the integration works.  It will also help make sense of some of the information below.  

HubSpot is cloud based and very easy to connect to.  Creatio can be on-prem or Cloud and StarfishETL supports both.  Please see the Creatio Connector article for more information.

This integration does require the installation of a Creatio Bundle that implements necessary schema changes.  The Starter package is copied into your instance by the StarfishETL team.  You will need to request the Creatio bundle and the starter package from the StarfishETL Team.

Integration Preparation checklist



Prior to beginning the implementation of the HubSpot / Creatio Essentials, please gather the following information: 
  1. User credentials for HubSpot and Creatio
    • Decide which HubSpot and Creatio user accounts you are going to use and obtain necessary login information.
    • Users must have xxxx rights.
  2. Internet access to Creatio
    • If Creatio has been deployed locally, provide Connect Creatio iPaaS appropriate access to Creatio REST API.  Please talk with your Connect Creatio representative to discover which connectivity options are appropriate for your organization.
  3. Connect Creatio User Credentials and Creatio Bundle
    • Register for StarfishETL account – access can be requested at https://designer.starfishetl.com
    • Request the Creatio Bundle and starter package from the StarfishETL team.
      • email support@connectcreatio.com and ask them to:
        • Copy the starter package into the StarfishETL instance you just created 
        • Email you the Creatio Bundle necessary for this integration
    4.  StarfishETL System Variables
      You will need to get the following information to adjust the System Variables when the time comes.  If you do not know what these values are please consult your Creatio Partner for assistance.


StarfishETL Starter Template Setup: Creatio - HubSpot


Creatio Schema Modification

In order for the Creatio - Hubspot integration to function properly, updates need to be made to Creatio.  Below are the steps to update Creatio:

  1. In Creatio, navigate to an existing Activity. If no Activity exists, create one.
  2. Select the View drop down from the upper left corner. This will take you to the Section Wizard.



  3. Drag the String entity from the left menu to the main view


  4. Go back to the Section Wizard main view


  5. Save the changes by selecting Save

  6. Navigate to the Activity, you will see the new field.
Now Creatio is configured to work with the the starter template Hubspot integration.

Setup Connectors

1.  Create connector for Hubspot per these instructions.
2.  Create connector for Creatio per these instructions.

Adjust StarfishETL System Parameters

Now that you have your Connectors configured, go to Projects.  You should see the HubSpot & Creatio Essentials Project that the StarfishETL team uploaded into your instance.  Double click to open.  The first thing to do is to adjust the parameters in this project to fit your needs.
1.  Navigate to the Project’s Variables tab
2. Modify the server time offsets to reflect the time differences of each server
3. ServerTimeOffset-HubSpot – typically US Central time
4.  ServerTimeOffset-Creatio
5.  Connect Creatio iPaaS is on US Central Time
6.  Change ClosedWon and ClosedLost Opportunity Type Ids if different from current selection
7.  Specify User Ids for each Starfish user
8.  Specify the default sales representative for Creatio. This will be used to assign the Leads.
Configure Cross References (Xrefs)
To learn more about cross references, please refer to this article.  

1.  Navigate to the Projects Xref Lists. Two lists will need to be updated to reflect process flow across each system.

2.  Select leadstatustype
3.  Modify the cross reference pairs as required to reflect your workflow
4.  Select Leadcycle Stage – Creatio to HubSpot
5.  Modify the cross reference pairs as required to reflect your workflow 



Testing

It is recommended that you test your integration thoroughly to make sure it is performing per your requirements.  

Set Job Schedule

Hopefully at this point you have configured your integration and tested thoroughly to make sure it is functioning properly.  Now you are ready to go-live.  This means you can set an individual schedule on every job in the Project depending on your needs.

  1. In your Hubspot & Creatio Project open the “Select the HS Contact -to- CRM Contact”  job.
  2. Select the Schedule tab

  3. While in this view, you can modify the schedule frequency for the integration.
  4. The HS Contact -to- CRM Contact Job is the start of a Job Chain. Select Schedule Enabled.
  5. Select the time interval, Every 10 minutes is common.
  6. Select End of Run for the Reschedule From
  7. Leave thread count at 1.
Since all of the integration jobs are in a chain, setting the schedule on the first job is all that's necessary.

Setup Monitoring

Connect Creatio has the ability to monitor for issues with your integration and notify you.  Please read more about that in the Monitoring article.  The Watchdog portion of this article does not apply to this integration, it is for on-prem installations of StarfishETL only.


Congratulations!  You have officially integrated your Hubspot and Creatio.  We hope it is extremely useful for your team.



    • Related Articles

    • Hubspot Connector

      Additional Documentation This Connector is based on the Hubspot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/DHG/ado/ Hubspot Connector Note: As of September 8, 2020 ...
    • Connecting to Creatio

      Follow these steps to connect to Creatio: While in the StarfishETL Cartographer, navigate to the Connections tab Select the Creatio connector, if a connector already exists, that you will be using for the integration If no HubSpot connector appears ...
    • Setup integration update frequency (schedules)

      Setup integration update frequency (schedules)   While in StarfishETL Cartographer, navigate to the Projects tab Select the “HubSpot & Creatio Integration” Project Select the Jobs Tab Select the “Select the HS Contact -to- CRM Contact”  job Select ...
    • Connecting to HubSpot

      Follows these steps to connect to HubSpot While in the StarfishETL Cartographer, navigate to the Connections tab Select the HubSpot connector that you will be using for the integration If no HubSpot connector appears in the list, create a new ...
    • Creatio Connector

      Creatio Connector Versions StarfishETL has two connector types for Creatio. OData: Allows for more complex querying. 4-6k records per hour Data Services: Faster than OData. Approx 30k records per hour Creatio (OData) Advanced Filtering Sometimes it ...