Integrating JIRA with Microsoft Dynamics CRM

integrating-jira-and-microsoft-dynamics-crm

Table of Contents

  • Introduction
  • Background
  • Prerequisites
  • Business scenario
  • Steps
    • Creating free trial Account in APPSeCONNECT
    • Login to APPSeCONNECT for the first time
    • Using Apps
      • Follow the steps to add your app
      • To add your own REST app
    • Assigning Credentials in the Cloud Apps
    • Assigning Credentials
    • Creating Entities
    • Creating Cloud connections
    • Assigning App credentials
    • Creating Workflow
    • Mapping and transformation
    • Creating and deploying to Cloud Environment
  • Putting all together.
  • Things to remember.
  • Conclusion.
  • References

Introduction

Integrating different applications can get complex at times and if only one generic adapter is used to integrate different applications of different authorization, the complexity can increase exponentially. This article will guide a user from the very beginning regarding integrating different apps of different authorization(namely Basic and OAuth 2.0) via the APPSeCONNECT integration platform using a generic adapter.

Connect all your business applications under one single platform to automate the business process and increase your productivity and efficiency!Integrate-Business-Apps-through-APPSeCONNECT

Background

As a business user, it is of utmost importance to seamlessly sync data from my CRM app(Microsoft Dynamics CRM) to my Project management software(JIRA software). With the increase in popularity of the ecommerce market, human interaction can be prone to erroneous data sync and that is where APPeCONNECT comes into play. APPSeCONNECT provides flexibility and reduces human intervention and is also highly scalable. Check out the Benefits of Connecting Dynamics CRM with Ecommerce!

Prerequisites

  • Login to the APPSeCONNECT portal and select “Create App” and then “Create Technology App”.
  • After creating the app, navigate to the connections module and then select create a connection and from there configure the template.
  • The connection needs to be cloud compatible.
  • Then from the manage module, select the primary environment as a cloud environment.
  • Now, navigate to the workflow module and select create a workflow

Business scenario

With APPSeCONNECT we are looking forward to syncing the customers from JIRA software to Mircosoft Dynamics CRM. Also, we will need to keep a track of the issues raised by the customers. So, Issue sync from Microsoft Dynamics CRM to JIRA software.

Steps-

Create Free Trial Account in APPSeCONNECT:

To create an account in APPSeCONNECT follow the below steps:

  1. Open any browser and go to https://portal.appseconnect.com/. You will be prompted with the login screen.
  2. If you are a new user, click on Create an Account for registration.
    Login Screen
  3. Fill up all the details. You will be asked to fill up some basic information about you and your organization to start using the solution. Please fill all the mandatory fields (marked as *).
    Getting started
  4. Click on “Get Started”, to start your trial account with APPSeCONNECT.
  5. Once your account is created, you need to open your mailbox for a message from us. Open that mail and click on the Account Activation link provided.
    Activated Account
  6. Your account is activated now. You can go to https://portal.appseconnect.com/ and log in with your email id and password.

Login to APPSeCONNECT for the First Time:

  1. Open any browser and go to https://portal.appseconnect.com/. You will be prompted with the login screen.
  2. Sign In with your email id and password (given in Activation Email in our inbox).
  3. You will be redirected to a page to reset your password. Fill in the fields and click Save changes.
    Change Password
  4. You will be taken to the Login page. Then log in with an email id and a new set password.

    Login
    Note: Keep the “Remember me” checkbox checked to keep the password saved.
  5. You have to Accept a License Agreement to avail the solutions.
    Accept License
  6. You may provide a Phone Number or Skip it.
  7. If you have completed any of the wizard instructions on your login, then you will be presented with the Dashboard
    Dashboard

To use Apps:

If you have already Registered to APPSeCONNECT and logged in to the portal, then the first thing that you need to do is to add Apps to your solution. 

Follow the Steps to Add your App:

  1. For selecting the Apps, you have to navigate to the Apps page
    Create Apps
  2. Here you can select your application of choice by selecting and saving Apps. On selecting the App (i.e. marking the App as checked).
    Choose Apps
  3. You will get an option to select the version of your App. Select the version from the drop-down and click on the save button.
  4. On clicking the Save button, the App of that particular version will be added to your account.

To add your own REST app

  1. For creating Apps, you have to navigate to the Apps page.
  2. From the top right dropdown select “Create technology App”
    Custom app
  3. Fill in the fields and click on Save
    Note: You can customize the app by providing Icon, Picture, editing descriptions, name,s etc. For that, click on the View button shown on the app:
    JIRA app
  4. After creating the Jira App, it will show up on the list like the image below.
    jira application

Assign Credentials in the Cloud Apps:

To provide cloud credentials in your apps follow the below steps:

  1. Navigate to the Apps page.
  2. Click the “+” button on the app
  3. Click on the Credential button
    add credentials
  4. Click on the “+” button on the REST section then “Add New Credentials”
  5. Fill in the details and then Save
    credential page

 

For Apps using Generic REST Adapter assign credentials in the following way:

  1. Navigate to the Apps page.
  2. Click the “+” button on the app
  3. Click on the Credentials button then “Add New Credentials”
  4. Fill in the details and then Save
    define credentials

To create an entity, schema, attributes, and action for the Apps:

  1. Go to your REST app (say Jira) -> Schema -> Add Schema and then attributes
  2. You can import your schema by clicking the “Import Schema” button.
  3. You can import schemas in XML, JSON formats.
  4. You can add your actions and by clicking the “Add Action” button shown in the apps where you can define your End Point, HTTP Method, Accept Type, Action filters.
    SchemasExample ACtion filter

To create Cloud Connection:

Based on your App selection, you will be creating Templates, which will be nothing but pre-defined connection frameworks for reusing. Follow the steps below:

  1. Navigate to Connections page-> Click Create Connection button
  2. Give a Connection Name then click on Configure Connector
    ConnectorCall
  3. In the Create connection window fill in the required details then click on Add Template.add template
  4. Then select the connection, check the checkbox “Is cloud Supported” and Save.
    Supported cloud

To assign App credentials in the cloud Connection:

  1. Go to the cloud connection and hover over it
  2. Click on the extreme right button “Configuration  Assignment”.
    Selecting
  3. Select the assignments of both apps and Save changes
    Protocol Selection
  4. Then Deploy the connection by checking the toggle button on hovering over the any side of connection
    select config
  5. The complete connection will be looked like this.
    successful deploy

 

To Create Workflow:

  1. Navigate to the Workflow menu.
  2. Click on the “Create Workflow” button
    create new workflow
  3. Give your workflow a name and description
    description
  4. Now to start designing your workflow, on the workflow drawing pane drag and drop the “Start” node
  5. Then drag and drop the “General Touchpoint” node
    General Touchpoint
  6. In the opened window select the Connection side from the dropdown then click on the “Create touchpoint” button
    create touchpoint
  7. Provide the details and proceed accordingly and Finally click on the “Finish” button.
    Touchpoint details
  8. The drawing pane will be looked like
    drawing
  9. The Drag and drop “End” node (which is not mandatory) and link all the nodes
  10. Now go back to the Workflow page and activate your workflow by clicking the top right toggle button on your workflow.
  11. You must Publish your workflow in the cloud from the Publish button within your workflow to make it up and running.

To map fields between two apps:

You can do mapping during the step To Create Workflow or you can follow the below steps afterward:

  1. Go to your workflow
  2. Click on the Process node in the group node then click on the Mapping button.
    Mapping

    • Follow the below link to understand mapping in details: Map your fields as per your requirement. I am showing here the mappings that i have done to execute my workflow.
      Transformation

Note: https://docs.appseconnect.com/transformation/overview/
After each time change in mapping, you need to Publish your workflow.

To create Cloud Environment

APPSeCONNECT On-Premise Agent is a hybrid tool that sits on your own server and is configured on the cloud and does the actual data synchronization with the help of other concerned adapters while the Cloud Agent is a similar tool that performs the same function as the on-premise agent but is present on the cloud itself. No server is required to configure or sync using the cloud agent.

Follow the below steps to set up your cloud environment in APPSeCONNECT:

  1. Navigate to Environments under the manage menu.
    Environment
  2. Now click on the “Create Cloud environment” button
  3. Fill in the details as required and Save.
    Create new environment
  4. You have been able to create the Cloud Environment.
    cloud agent creation complete
  5. Keep the cloud environment as “Primary Agent” by clicking on the checkbox beside your environment name.

Putting all together

Now you are ready to take the step towards executing your workflow and getting data synced from one application to another. APPSeCONNECT gives you the leverage to execute and schedule your workflow Manually or Automatically.

  1. To execute your workflow go to your workflow then Click on the Edit button and click on the Play button
    showing environment
  2. It gives you to visualize your whole process with user-friendly messages and indications of execution
    executing workflow
  3. You can schedule your workflow to execute automatically whether they will be running in an hourly interval or in minutely.
    Execution
    Now when you schedule the workflow using the button shown above, you will see the interface below.
    scheduler
  4. You can check your execution result in your “Resync Bucket” under the “Properties section on the right side which shows how many and which data are pushed to the destination application or not pushed.
    Execution status
  5. From the “Snapshot” button shown on the top bar of the workflow, you can see the execution log details in “Log Bucket” from which you can easily understand how the data are successfully posted or why the data are not posted, what are the errors behind it.
    Snapshot

 

Things to Remember

  • The primary environment should be a cloud environment
  • The connection should be cloud compatible
  • The app using the Generic REST adapter should follow authorization either “Basic” or “OAuth” or else No Authorization at all.

Conclusion

I hope now you can easily integrate any apps using the Generic REST adapter with another app that will automate your business process and save your time and manpower. So without any hesitation opt for APPSeCONNECT and start syncing in the cloud.

References

Search

Search

Free Trial / Demo

Try the APPSeCONNECT Integration Platform for 30 Days or request a free demo.
APPSeCONNECT-Horizontal Logo_SVG
appseconnect-New-Logo_2022.png

Start Your Automation Journey With Pre-Built Connectors.

Get a Demo. Try it Free.

g2 summer badges for popup
we use cookies
We use cookies to personalize your experience. Your visit and usage of this website is subject to acceptance of our Privacy Notice and Cookie Policy.