Pieter de Jong Pieter de Jong
Mar 29, 2016 6:19:55 PM
3 easy ways to integrate Salesforce and Microsoft Dynamics AX

Many companies use Microsoft software together with Salesforce, the company behind the leading CRM solution. As recently announced, Microsoft and Salesforce are strengthening their strategic partnership and plan to deliver additional integrations and apps that make it easier to get the benefit of Office software used together with Salesforce.

Companies also use Salesforce and Microsoft Dynamics AX in the same environment. It’s not at all difficult to integrate the two. We recommend three easy ways to integrate Dynamics AX and Salesforce to accomplish this:

  • The preferred option: using Open Database Connectivity (ODBC) and STAEDEAN Connectivity Studio
  • Dynamics AX to Salesforce integration by means of representation state transfer (REST) and Connectivity Studio
  • Salesforce to Dynamics AX integration with STAEDEAN Web Service Studio
Done within minutes: ODBC

Instead of spending more time and money than you need to, you can simply purchase an ODBC driver for Salesforce from Devart and use Connectivity Studio to map the different data models. The driver supports all widely used APIs to make it possible to read, update, delete, and insert. You can also use this driver also to integrate with, for example, Microsoft Excel.

Salesforce and AX integration 1

With this ODBC driver, you can connect to Salesforce within minutes. Just create your document for ODBC and define your data model. Then specify the account table and a list of fields you want to use in the document in your message. One of the most frequent integration tasks involves bringing customer records from the ERP into the CRM solution. That’s what we assume in this example.

Salesforce and AX integration 2

Then map customers from Dynamics AX to Salesforce.

Salesforce and AX integration 3

And now you can export customer records to Salesforce.

From Dynamics AX to Salesforce by using REST

You can use Connectivity Studio to create an integration with Salesforce, using standard functionality. To do this, you need a JSON document, which helps define the Salesforce data model and the Windows connector to define the REST web service, which Salesforce supports.

Salesforce and AX integration 4

The record IDs in Dynamics AX serve as unique identifiers for each record. Salesforce has a similar approach, with an ID field for each record. In Connectivity Studio, you can easily link the two to make the integration seamless and simple.

Salesforce and AX integration 5

This integration provides full flexibility to integrate sales orders with customers, products, employees, orders, and more.

Another option is to apply a Salesforce Object Query Language (SOQL) query. SOQL is only supported for reading data when running a query.

Salesforce to AX integration with Web Service Studio

You also can integrate from Salesforce to Microsoft Dynamics AX. By using Apex or other tools, you can call up external web services. In Connectivity Studio, those are defined in real time or semi-real time for bulk uploads, and in Web Service Studio only in real time. That makes it possible to send changes from Salesforce to Microsoft Dynamics AX. The diagram below highlights what the complete workflow looks like when you perform resource assignments as batch updates. The Change State action handler creates assignments based on the setting in the Resource Management Setup.

Salesforce and AX integration 6

Another way to go would be storing files and importing them in XML, JSON, or text format. This, too, is simple and easy to implement.

As you see, integrating Dynamics AX and Salesforce is easy to do. With any questions related to today’s blog post and our Data Integration Solution, contact us.

Pieter de Jong Pieter de Jong
TI_LOGO_TI-Logo-color andAXP_365

have now rebranded to

staedean-logo-teal