Thursday 22 March 2018

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


SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

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

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

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

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

4.2. Create a Virtual Table

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

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

4.3. Query on Virtual table

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

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

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:

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

5.2. Run replication task

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

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

5.3. View result

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

SAP HANA smart data integration, SAP HANA Certifications, SAP HANA Learning, SAP HANA Tutorials and Materials

1 comment: