Mircosoft Dynamics 365 CRM adapter for SAP SDI

1. Overview

The Advantco Dynamics 365 adapter is an adapter for SAP HANA Smart Data Integration (SDI), its purpose is to batch load or to replicate changed data in real time from  Dynamics 365 CRM to the SAP HANA tables.

This blog describes how to replicate Account data from Dynamics 365 CRM in HANA tables.

2. Adapter Architecture

The Dynamics 365 Adapter acts as a bridge. It open a connection to Dynamics 365 CRM and read the source data and translate the values into the Hana datatype value.

3. Key features

Below are some of main features covered by this adapter.

◈ Support Microsoft Dynamics CRM Web API (REST API)

◈ Authenticate users via OAuth 2.0

◈ Support for proxy authentication.

◈ Real-time change data capture (CDC).

◈ Improve performance by using Bulk Operations

◈ Bi-directional updates.

4. Account Retrieval Use Case

The goal is to make this data of Account on Dynamics 365 CRM available in SAP HANA by Querying the remote Account via Virtual table (data is not physically moved to the cloud, but remains in its original source.)

4.1. Create a Remote Source

We can browse the metadata tables which are provided by the adapter, each table correspond to one Entity.

4.2. Create a Virtual Table

After creating a remote source, we can create a virtual table to retrieve data for account as below:

4.3. Query on Virtual table

Open the SQL console, input and run the sql statement with the result as below:

5. Account Replication Use Case

The goal is to make this data of Account on Dynamics 365 available in SAP HANA by using replication task feature

5.1. Create a Replication Task

Go to the workbench editor: https://myhana.us3.hana.ondemand.com/sap/hana/ide/editor/

Create the Replication task as below:

5.2. Run replication task

After save the replication task, click run task with the result as below:

5.3. View result

After the replication task done, go to the schema to see the new tables: