Note: This sample is for TIBCO Cloud Integration - Connect. For TIBCO Scribe Online classic see TIBCO Scribe® Online Samples And Examples.

Details

The attached flow queries HubSpot contacts and uses them to create leads in Microsoft Dynamics365/CRM. Follow the instructions in this article to download and import the flow and then run it to see how it migrates your data.
 
IMPORTANT: Running the attached flow modifies data in your Microsoft Dynamics 365/CRM account by adding HubSpot contacts as leads. If you do not want to alter data in your Microsoft Dynamics 365 / CRM account, best practice is to sign up for a trial version of Microsoft Dynamics 365 / CRM to use with this flow.


For additional information, see the Integrate HubSpot and Microsoft Dynamics 365 CRM with TIBCO Cloud Integration video.

Requirements

• A trial or paid subscription for TIBCO Cloud™ Integration - Connect.
• A trial or paid Microsoft Dynamics 365 / CRM account with permissions to create records.
• A trial or paid HubSpot account.
• If you are using a trial subscription to TIBCO Cloud™ Integration - Connect, you should already have a Cloud Agent installed.  If not, install a Cloud Agent. See Provisioning a Cloud Agent in the help for more information.

 
Step 1: Install Connectors
 
Connectors allow TIBCO Cloud ™ Integration - Connect to communicate with other systems, like HubSpot.

1. Select Marketplace from the menu bar.
2. Apply the Connect filter in the filter section.
3. Use the Search field to find the HubSpot Connector.
4. Select it and click Enable on the right side of the page.
5. Use the Search field to find the Microsoft Dynamics 356/CRM Connector.
6. Select it and click Enable on the right side of the page.

Step 2: Set Up Your Connections
 
A Connection is the configuration of the parameters required by the Connector to communicate with a specific application.
 
Note: If you have existing HubSpot or Dynamics 365/CRM Connections, you can use those instead of setting up new Connections. However, you will have to reassign Connections in the sample flow after importing it.

1. From the menu bar, select Connections.
2. Click the Create button in the upper right corner to add a new Connection. Configure the Connection fields as follows:
   • Apply the Connect filter.
   • Connector Type - Search for HubSpot and fill in the required fields.  For detailed information about connecting to HubSpot, see the HubSpot Connector help.
   • Name - Enter HubSpot.  This is the name of the Connection in the sample flow and allows the flow to locate the Connection when it is imported.
   • Account number - Enter your assigned HubSpot account number.
3. Select Authenticate to open the HubSpot authorization page. Select Authorize.
4. Click Test to test your Connection  and then OK to exit and save your Connection configuration.
5. On the Connections page, click the Create button in the upper right corner to add a new Connection. Configure the Connection fields as follows:

• Connector Type - Select Microsoft Dynamics 365/CRM. For detailed information about connecting to Dynamics 365/CRM, see the Microsoft Dynamics 365/CRM Connector help.
• Name - Enter DynamicsCRM.  This is the name of the Connection in the sample flow and allows the flow to locate the Connection when it is imported.
• Deployment Type - Select the type of Microsoft Dynamics 365 /CRM deployment mode you are using.  If you are using a trial account, Online would be the most common option.
• URL - Enter the URL you use to connect to Microsoft Dynamics 365 / CRM.
• User ID - Your Microsoft User ID.
• Password - Your Microsoft Password.
• Click the browse link to find your CRM Organization.

6. Click Test to test your Connection, and then OK to exit and save your Connection configuration.

 
Step 3: Create An App
 
Apps contain an Agent, flow instructions, and Connection information. These objects function in concert to move data from one datastore to another.

1. Select Apps from the menu.
2. Click the Create/Import button.
3. Choose On a schedule from the Connect category.
4. Click the Create New App button.
5. Click New_Connect_App at the top of the page and modify it to make the name “HubSpot-Dynamics 365/CRM”.

 
Step 4: Import the Sample Flow
 
A flow is a visual representation of the instructions needed to integrate your data.

1. Download the Sample Flow attached to this article. It should download to your default downloads location or ask you where to save it.
2. In the new App you just created, HubSpot-Dynamcis365/CRM, click the New Flow button.
3. Choose Import.
4. In the Import dialog select Choose File and browse to the HubSpotDynamics365CRMMaps.json file you downloaded.
5. Click the file and select Open to import the flow. Note that the flow name starts with Imported-.

 
Step 5: Complete the Flow
 
Imported flows are always marked as Incomplete.  To enable the flow, you need to open it and verify that there are no errors.

1. Click the Imported - HubSpot Contacts -> Dynamics 365 CRM Leads flow to open it. If you created Connections with names that match the Connection names in the flow, you should not have to change anything. Note, you may need to wait for each Connector to retrieve its metadata.
2. If a matching Connection cannot be found, a warning message displays. Select Reassign on the Gear menu  when hovering over the connector to choose a replacement Connection.
3. You can review the flow Block by Block to see the logic used to integrate the data.
4. Click Validate, Apply and then OK to save and close the flow.
5. Your flow may still have the status of Incomplete. Click the context menu for that flow and unlock the flow to enable it.
6. If your flow still has the status of incomplete you may need to open the flow, click validate, apply and ok.

 
Step 6: Test Your App

1. After closing the flow, wait for the App status to change from Preparing to Ready.
2. When the status says Ready, click the RUN button at the top of the Apps page to test your App. When the App starts, the RUN button turns grey and says STOP.
3. Click the Execution History tab to see the status of the running app. As the data is integrated, the Execution History is updated with the number of records processed. When the app is finished running, Execution History shows Completed Successfully if there were no errors.

You have now successfully imported and run a HubSpot to Microsoft Dynamics 365 / CRM integration, which creates leads in Microsoft Dynamics 365 / CRM from HubSpot contacts.



For more Sample Maps, see TIBCO Cloud™ Integration - Connect Samples And Examples.

DISCLAIMER


Copyright (c) 2020, TIBCO Software Inc. All rights reserved.


No Support. You acknowledge that TIBCO will not provide any maintenance or support for this software. You have no right to receive any upgrades, patches, enhancements, bug fixes, new versions or new releases of the software.


Internal Use Only License Grant. TIBCO hereby grants you a limited, non‐transferable, non‐exclusive license to use the software solely for your internal business purposes. The name of TIBCO Software Inc. may not be used to endorse or promote products derived from this software without specific prior written permission of TIBCO Software Inc.


THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT OWNERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Step-by-step instructions for importing and running a Sample TIBCO Cloud Integration - Connect Sample Flow