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:
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.