SYS-CON MEDIA Authors: Liz McMillan, Carmen Gonzalez, Zakia Bouachraoui, Roger Strukhoff, David Linthicum

Article

How to transfer data from Microsoft dynamics 365 for sales to a database using dbsync

Transfer data stored in Microsoft Dynamics 365 to a database such as MSSQL or MySQL.

Cloud data and cloud based applications have grown exponentially over the past years. Combining data sources and applications has become a major challenge for many companies. One of these important applications is Microsoft Dynamics 365 for Sales.

Microsoft Dynamics 365 for Sales is an application that helps companies to interact with current and potential customers. It is widely used due to its convenient characteristics.

Often the data stored in Microsoft Dynamics 365 for Sales has to be transferred to a database such as MSSQL or MySQL.

In this article, you will learn how to do this by using DBSync Cloud Workflow.

Introducing DBSync Cloud Workforce

DBSync is an integration platform that facilitates the integration between different systems. It manages all the communication, data translation and process interaction among the various connected applications.

This platform uses different processes, also known as business processes, to synchronize data between different databases and applications. These processes, in turn, use connectors to link different databases and applications.

DBSync presents you with a series of connectors. Among them, is the Microsoft Dynamics CRM connector, which has two versions, namely online and on premise.

These connectors allow you to move data in and out of Microsoft Dynamics 365 for Sales, in order to populate data warehouses, synchronize master databases, and streamline transaction details and online payments.

How to transfer from MS Dynamics 365 for Sales to a database

You will now see the necessary steps to transfer data from MS Dynamics 365 for Sales to MySQL. However, the same steps apply to other databases, such as MSSQL, Oracle, and PostgreSQL.

Step 1: Create a new project.

Here you are presented with two options: importing an existing project or defining a new one.

In order to create a new project, you must press the button Create New Project. Then, you will be prompted to enter a name for your project and save it.

Figure 1 – Create a new project

Step 2: Create a connector for each system that you intend to work with.

As we you connecting Microsoft Dynamics 365 for Sales to a database, you need to create two connectors, one for each resource. One connector will be of type Database Connector and the other of type MSCRM Online Connector.

https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/2-Create-a-con... 768w" height="653" width="1209" alt="Create a connector" src="http://www.mydbsync.com/blogs/wp-content/uploads/2018/03/2-Create-a-connector.png" class="alignnone size-full wp-image-2175" />

Figure 2: Create a connector

Step 3: Create a process.

Once you are connected to the source and the destination, you need to create a process that defines the transfer task. For this, you must press the button Create New Process and input a name. Just remember that process names cannot contain spaces.

https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/3-Create-a-pro... 768w" height="622" width="1179" alt="Create a process" src="http://www.mydbsync.com/blogs/wp-content/uploads/2018/03/3-Create-a-process.png" class="size-full wp-image-2172" />

Figure 3: Create a process

Step 4: Create a workflow.

Each process may have several different workflows. In order to create a new workflow, you must press the Create New Workflow button. The system will ask for a workflow name. Just remember that the workflow name mustn’t contain any empty spaces. Each workflow will contain a trigger and one or more rules.

https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/4-Create-a-wor... 720w, https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/4-Create-a-wor... 768w, https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/4-Create-a-wor... 340w" height="625" width="1000" alt="Create a workflow" src="http://www.mydbsync.com/blogs/wp-content/uploads/2018/03/4-Create-a-workflow.png" class="alignnone size-full wp-image-2174" />

Figure 4: Create a workflow

Step 5: Configure a trigger.

A trigger lets you define a query to your data source, in our case Microsoft Dynamics 365 for Sales. You are presented with two options: query builder and advanced query builder. These alternatives give you the freedom to handle a query at different levels of sophistication, and according to your level of skills.

Step 6: Create a rule.

You can have one or more rules for each workflow. Each rule defines the data destination and a mapping between source and destination.

https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/5-Trigger-and-... 720w, https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/5-Trigger-and-... 768w, https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/5-Trigger-and-... 340w" height="649" width="1035" alt="Trigger and rule creation" src="http://www.mydbsync.com/blogs/wp-content/uploads/2018/03/5-Trigger-and-rule-creation.png" class="size-full wp-image-2171" />

Figure 5 – Trigger and Rule creation

Step 7: Define a map:

A map connects source and target fields. With DBSync, the mapping is very easy as you can connect the source-destination field pairs by dragging and dropping.

 

https://www.mydbsync.com/blogs/wp-content/uploads/2018/03/6-create-a-map... 768w" height="469" width="929" alt="Create a map" src="http://www.mydbsync.com/blogs/wp-content/uploads/2018/03/6-create-a-map.png" class="size-full wp-image-2169" />

Figure 6 – Create a map

Step 8: Run the process.

You can do it manually or via a scheduler. Manual runs are useful for sporadic tasks (See figure 3). The scheduler lets you manage repeated runs, or run the process at a specific date and time.

What follows

In this article, you have learned how to connect Microsoft Dynamics 365 for Sales and a database. This is just one of the many uses of DBSync Cloud Workflow. There are many more for you to explore. Ready to try? Go to the DBSync website (http://www.mydbsync.com/) and sign up for a free trial.

More Stories By Rajeev Gupta

As CEO of DBSync, Rajeev has led the strategic emphasis on the integration space, while also ensuring alignment between customer needs and product development. He has extensive experience with application architecture and on-demand computing. He earned his MBA from Owen School of Management, Vanderbilt University.

Latest Stories
The platform combines the strengths of Singtel's extensive, intelligent network capabilities with Microsoft's cloud expertise to create a unique solution that sets new standards for IoT applications," said Mr Diomedes Kastanis, Head of IoT at Singtel. "Our solution provides speed, transparency and flexibility, paving the way for a more pervasive use of IoT to accelerate enterprises' digitalisation efforts. AI-powered intelligent connectivity over Microsoft Azure will be the fastest connected pat...
There are many examples of disruption in consumer space – Uber disrupting the cab industry, Airbnb disrupting the hospitality industry and so on; but have you wondered who is disrupting support and operations? AISERA helps make businesses and customers successful by offering consumer-like user experience for support and operations. We have built the world’s first AI-driven IT / HR / Cloud / Customer Support and Operations solution.
ScaleMP is presenting at CloudEXPO 2019, held June 24-26 in Santa Clara, and we’d love to see you there. At the conference, we’ll demonstrate how ScaleMP is solving one of the most vexing challenges for cloud — memory cost and limit of scale — and how our innovative vSMP MemoryONE solution provides affordable larger server memory for the private and public cloud. Please visit us at Booth No. 519 to connect with our experts and learn more about vSMP MemoryONE and how it is already serving some of...
Darktrace is the world's leading AI company for cyber security. Created by mathematicians from the University of Cambridge, Darktrace's Enterprise Immune System is the first non-consumer application of machine learning to work at scale, across all network types, from physical, virtualized, and cloud, through to IoT and industrial control systems. Installed as a self-configuring cyber defense platform, Darktrace continuously learns what is ‘normal' for all devices and users, updating its understa...
Codete accelerates their clients growth through technological expertise and experience. Codite team works with organizations to meet the challenges that digitalization presents. Their clients include digital start-ups as well as established enterprises in the IT industry. To stay competitive in a highly innovative IT industry, strong R&D departments and bold spin-off initiatives is a must. Codete Data Science and Software Architects teams help corporate clients to stay up to date with the mod...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
Platform9, the leader in SaaS-managed hybrid cloud, has announced it will present five sessions at four upcoming industry conferences in June: BCS in London, DevOpsCon in Berlin, HPE Discover and Cloud Computing Expo 2019.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
When you're operating multiple services in production, building out forensics tools such as monitoring and observability becomes essential. Unfortunately, it is a real challenge balancing priorities between building new features and tools to help pinpoint root causes. Linkerd provides many of the tools you need to tame the chaos of operating microservices in a cloud native world. Because Linkerd is a transparent proxy that runs alongside your application, there are no code changes required. I...
In his general session at 21st Cloud Expo, Greg Dumas, Calligo’s Vice President and G.M. of US operations, discussed the new Global Data Protection Regulation and how Calligo can help business stay compliant in digitally globalized world. Greg Dumas is Calligo's Vice President and G.M. of US operations. Calligo is an established service provider that provides an innovative platform for trusted cloud solutions. Calligo’s customers are typically most concerned about GDPR compliance, application p...
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is foundational - something customers routinely cite as a top pain point. In his session at @DevOpsSummit at 21st Cloud Expo, Bill Borsari, Head of Systems Engineering at Datera, explored how organizations can reap the bene...
"NetApp's vision is how we help organizations manage data - delivering the right data in the right place, in the right time, to the people who need it, and doing it agnostic to what the platform is," explained Josh Atwell, Developer Advocate for NetApp, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Druva is the global leader in Cloud Data Protection and Management, delivering the industry's first data management-as-a-service solution that aggregates data from endpoints, servers and cloud applications and leverages the public cloud to offer a single pane of glass to enable data protection, governance and intelligence-dramatically increasing the availability and visibility of business critical information, while reducing the risk, cost and complexity of managing and protecting it. Druva's...
Kubernetes as a Container Platform is becoming a de facto for every enterprise. In my interactions with enterprises adopting container platform, I come across common questions: - How does application security work on this platform? What all do I need to secure? - How do I implement security in pipelines? - What about vulnerabilities discovered at a later point in time? - What are newer technologies like Istio Service Mesh bring to table?In this session, I will be addressing these commonly asked ...
BMC has unmatched experience in IT management, supporting 92 of the Forbes Global 100, and earning recognition as an ITSM Gartner Magic Quadrant Leader for five years running. Our solutions offer speed, agility, and efficiency to tackle business challenges in the areas of service management, automation, operations, and the mainframe.