Skip to Content

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

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

 

 

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:

 

 

 

For more detail about Replication behaviour, please refer: https://help.sap.com/viewer/71c4a6e6b4dc4a5ab3e17bb1d7e98104/2.0_SPS02/en-US/e9d2bb9dd8ab4c0180e69b8a7e1a1e93.html

 

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:

 

6. Summary

With Advantco Dynamics 365 CRM adapter for SAP HANA SDI, it is possible to pull Dynamics 365 CRM data directly into your HANA tables. The adapter support also update to Dynamics 365 CRM thru update of the virtual table records.

 

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply