---
title: Microsoft Dynamics CRM Adapter for SAP SDI
description: Microsoft Dynamics CRM Adapter for SAP SDI
image: https://resources.advantco.com/hubfs/Imported_Blog_Media/Sap-Endorsed-App-Aug-04-2021-02-39-13-92-PM.png
---

# Microsoft Dynamics CRM Adapter for SAP SDI

[ Admin ](https://resources.advantco.com/knowledge-base/author/admin)  Apr 25, 2018 12:00:00 AM

 

 

In a competitive landscape, businesses need an edge that will help them succeed. Integrating SAP, the leading enterprise resource planning (ERP) solution, with MS Dynamics CRM, a leader in cloud-based customer relationship management (CRM), can play a large role in helping businesses gain that competitive edge by improving collaboration between Marketing, Sales and Support.

The Advantco DynamicsCRM Adapter for SAP HANA Smart Data Integration (SDI) batch loads and/or replicates changed data in real-time from DynamicsCRM to the SAP HANA tables.

 

Key Benefits Include:

 

- Easy Configuration & Setup
- Virtual Table as a Source
- SQL Query Execution: Translates SQL Statement in HANA Syntax into SOQL Syntax and Converts Data from DynamicsCRM into HANA Datatypes
- Supports Execute INSERT/UPDATE/DELETE statement on a virtual table: Translates SQL Statement in HANA syntax into a corresponding SOAP Call
- Real-Time Change Data Capture (CDC)
- Handles Authentication with Salesforce
- Session Reuse Mechanism
- Adjusts Communication Method Dynamically Based on Data Volume to Achieve Best Performance
- Adapter Handles QueryLocator Results

The DynamicsCRM Adapter for SDI makes the remote data available in HANA: Query on Virtual Table.  The Adapter allows users to INSERT/UPDATE/DELETE DynamicsCRM objects by executing INSERT/UPDATE/DELETE statement on a virtual table.  It also provides 1:1 Realtime Replication, just copy data from DynamicsCRM 1:1 HANA.

With the Advantco DynamicsCRM for SAP HANA SDI, it is possible to pull DynamicsCRM data directly into your HANA tables. This eliminates the need for workaround solutions using intermediate databases, saving you significant time and effort.

 

[Microsoft Dynamics](https://resources.advantco.com/knowledge-base/tag/microsoft-dynamics), [Microsoft Dynamics SAP Hana SDI](https://resources.advantco.com/knowledge-base/tag/microsoft-dynamics-sap-hana-sdi)

## Read On

[![](https://blogs.sap.com/wp-content/uploads/2018/07/SDI-Adapter-Image.png) ](https://resources.advantco.com/knowledge-base/use-case-to-s/4hana-smart-data-integration-sdi)

### [Use Case to S/4HANA Smart Data Integration (SDI)](https://resources.advantco.com/knowledge-base/use-case-to-s/4hana-smart-data-integration-sdi)

**First things first, why there was a need to develop SDI?**

[![](https://resources.advantco.com/hs-fs/hubfs/Imported_Blog_Media/near-real-time-data-replication-from-sf-to-sap-hana-using-the-adv-salesforce-adapter-for-sdi-01.jpg?width=352&name=near-real-time-data-replication-from-sf-to-sap-hana-using-the-adv-salesforce-adapter-for-sdi-01.jpg) ](https://resources.advantco.com/knowledge-base/content/near-real-time-data-replication-from-salesforce-to-sap-hana-using-the-advantco-salesforce-adapter-for-sdi)

### [Near real time Data Replication from Salesforce to SAP HANA](https://resources.advantco.com/knowledge-base/content/near-real-time-data-replication-from-salesforce-to-sap-hana-using-the-advantco-salesforce-adapter-for-sdi)

Salesforce provides APIs that enable external applications to receive events in...

[![](https://resources.advantco.com/hs-fs/hubfs/Imported_Blog_Media/Online-Sale-orders-to-backend-SAP-using-Kafka.png?width=352&name=Online-Sale-orders-to-backend-SAP-using-Kafka.png) ](https://resources.advantco.com/knowledge-base/content/meeting-of-worlds-kafka-adapter)

### [Meeting of Worlds – Kafka Adapter](https://resources.advantco.com/knowledge-base/content/meeting-of-worlds-kafka-adapter)

The meeting of two worlds – 3 Vs (volume, variety, and velocity) of big data and the back office...

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Admin",
    "url" : "https://resources.advantco.com/knowledge-base/author/admin"
  },
  "dateModified" : "2021-10-25T19:28:19.597Z",
  "datePublished" : "2018-04-25T04:00:00.000Z",
  "headline" : "Microsoft Dynamics CRM Adapter for SAP SDI",
  "image" : [ "https://resources.advantco.com/hubfs/Imported_Blog_Media/Sap-Endorsed-App-Aug-04-2021-02-39-13-92-PM.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://resources.advantco.com/knowledge-base/product/adapter/microsoft-dynamics-crm-adapter-for-sap-sdi",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://resources.advantco.com/hubfs/Advantco%20logo%20AAC%20V1%20Ai%20file%201.png"
    },
    "name" : "Advantco International"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "NewsArticle",
  "author" : [ {
    "@type" : "Person",
    "name" : "Admin",
    "url" : "https://resources.advantco.com/knowledge-base/author/admin"
  } ],
  "dateModified" : "2021-10-25T19:28:19",
  "datePublished" : "2018-04-25T04:00:00",
  "headline" : "Microsoft Dynamics CRM Adapter for SAP SDI",
  "image" : [ "https://f.hubspotusercontent20.net/hubfs/6260070/Imported_Blog_Media/Sap-Endorsed-App-Aug-04-2021-02-39-13-92-PM.png" ]
}
```

```json
{
  "@context" : "http://schema.org",
  "@type" : "Organization",
  "address" : {
    "@type" : "PostalAddress",
    "addressCountry" : "United States",
    "addressLocality" : "Charlotte",
    "addressRegion" : "NC",
    "postalCode" : "28203",
    "streetAddress" : "1235 East Blvd, Suite E #382 "
  },
  "alternateName" : "advantco",
  "areaServed" : {
    "@type" : "GeoCircle",
    "geoMidpoint" : {
      "@type" : "GeoCoordinates",
      "latitude" : "40.75996223497667",
      "longitude" : "-73.98761007334504"
    },
    "geoRadius" : "150 km"
  },
  "description" : "Feature rich Advantco adapters integrates SAP & Oracle system with top enterprise platforms like Kafka, Salesforce, Azure, and more.",
  "email" : "webadmin@advantco.com",
  "image" : "https://www.advantco.com/hs-fs/hubfs/unnamed%20(2).webp?width=450&height=60&name=unnamed%20(2).webp",
  "logo" : "https://6260070.fs1.hubspotusercontent-na1.net/hubfs/6260070/Advantco%20logo%20AAC%20V1%20Ai%20file%201.png",
  "mainEntityOfPage" : {
    "@id" : "https://resources.advantco.com/knowledge-base/product/adapter/microsoft-dynamics-crm-adapter-for-sap-sdi",
    "@type" : "WebPage",
    "description" : "Microsoft Dynamics CRM Adapter for SAP SDI"
  },
  "naics" : "513210",
  "name" : "Advantco International",
  "sameAs" : [ "https://www.linkedin.com/company/advantco-international-llc" ],
  "telephone" : "",
  "url" : "https://www.advantco.com/"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "WebPage",
  "about" : [ {
    "@id" : "https://resources.advantco.com/knowledge-base/content/advantco-pre-packaged-content-solution",
    "@type" : "WebPage"
  }, {
    "@id" : "https://www.advantco.com/sap-hana-sdi-integration-adapters/sap-hana-sdi-salesforce-integration",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/salesforce-integration-common-requirements-and-use-cases",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/the-top-5-advantages-of-sap-and-salesforce-integration",
    "@type" : "WebPage"
  }, {
    "@id" : "https://www.advantco.com/sap-integration-adapters/sap-salesforce-integration",
    "@type" : "WebPage"
  } ],
  "mainEntity" : {
    "@type" : "WebPage"
  },
  "url" : "https://www.advantco.com/sap-integration-adapters/sap-salesforce-integration"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "WebPage",
  "about" : [ {
    "@id" : "https://resources.advantco.com/knowledge-base/receiving-events-from-dynamics-365-crm-using-webhooks",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/microsoft-dynamics-crm-adapter-for-sap-process-orchestration-and-sap-integration-suite-now-available-on-sap-store",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/adapters-for-sap-hci-integration-with-ms-dynamics-crm-and-rabbitmq",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/sap-cloud-platform-integration-enhancing-the-third-party-application-connectivity-with-new-offerings",
    "@type" : "WebPage"
  } ],
  "mainEntity" : {
    "@type" : "WebPage"
  },
  "url" : "https://www.advantco.com/sap-integration-adapters/sap-microsoft-dynamics-integration"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "WebPage",
  "about" : [ {
    "@id" : "https://resources.advantco.com/knowledge-base/content/sap-cloud-platform-integration-enhancing-the-third-party-application-connectivity-with-new-offerings",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/using-advantco-aws-adapter-to-integrate-sap-and-aws-business-environments",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/integrating-sap-and-aws-business-environments-with-the-advantco-aws-adapter",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/product/adapter/aws",
    "@type" : "WebPage"
  } ],
  "mainEntity" : {
    "@type" : "WebPage"
  },
  "url" : "https://www.advantco.com/sap-integration-adapters/sap-aws-integration"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "WebPage",
  "about" : [ {
    "@id" : "https://resources.advantco.com/knowledge-base/content/google-cloud-platform-adapter-from-advantco-international-now-available-on-sap-store",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/product/adapter/google-cloud-platform-adapter-for-sap-cpi",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/advantco-google-cloud-platform-adapter-integrating-sap-with-gcp",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/advantco-google-cloud-platform-adapter-integrating-sap-with-gcp",
    "@type" : "WebPage"
  } ],
  "mainEntity" : {
    "@type" : "WebPage"
  },
  "url" : "https://www.advantco.com/sap-integration-adapters/sap-google-cloud-integration"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "WebPage",
  "about" : [ {
    "@id" : "https://resources.advantco.com/knowledge-base/consumer-electronics-retailer-turns-to-advantco-amqp-azure-adapters",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/adapters-for-sap-hci-integration-with-ms-dynamics-crm-and-rabbitmq",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/integration-with-microsoft-azure-cloud",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/using-rabbitmqamqp-broker-for-extreme-high-volume-integration-with-sap-hybris-commerce-solution-with-sap-pipo",
    "@type" : "WebPage"
  } ],
  "mainEntity" : {
    "@type" : "WebPage"
  },
  "url" : "https://www.advantco.com/sap-integration-adapters/sap-azure-integration"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "WebPage",
  "about" : [ {
    "@id" : "https://resources.advantco.com/knowledge-base/lessons-learned-from-kafka-integrations-using-the-advantco-kafka-adapter-for-sap-integration-suite",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/kafka-adapter-for-sap-process-orchestration-and-sap-integration-suite-now-available-on-sap-store",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/advantco-kafka-adapter-enables-automobile-leader-to-use-big-data",
    "@type" : "WebPage"
  }, {
    "@id" : "https://resources.advantco.com/knowledge-base/content/kafka-adapter-with-avro-serialization-and-schema-registry",
    "@type" : "WebPage"
  } ],
  "mainEntity" : {
    "@type" : "WebPage"
  },
  "url" : "https://www.advantco.com/sap-integration-adapters/sap-kafka-integration"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "WebPage",
  "about" : [ {
    "@id" : "https://www.advantco.com/sap-integration-adapters/sap-salesforce-integration",
    "@type" : "WebPage"
  }, {
    "@id" : "https://www.advantco.com/sap-integration-adapters/sap-microsoft-dynamics-integration",
    "@type" : "WebPage"
  }, {
    "@id" : "https://www.advantco.com/sap-integration-adapters/sap-aws-integration",
    "@type" : "WebPage"
  }, {
    "@id" : "https://www.advantco.com/sap-integration-adapters/sap-google-cloud-integration",
    "@type" : "WebPage"
  }, {
    "@id" : "https://www.advantco.com/sap-integration-adapters/sap-azure-integration",
    "@type" : "WebPage"
  }, {
    "@id" : "https://www.advantco.com/sap-integration-adapters/sap-kafka-integration",
    "@type" : "WebPage"
  } ],
  "mainEntity" : {
    "@type" : "WebPage"
  },
  "url" : "https://www.advantco.com/"
}
```

```json
{
  "@context" : "https://schema.org/",
  "@type" : "BreadcrumbList",
  "itemListElement" : [ {
    "@type" : "ListItem",
    "item" : "https://advantco.com/",
    "name" : "Home",
    "position" : 1
  } ]
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "ProfessionalService",
  "areaServed" : {
    "@type" : "GeoShape",
    "address" : {
      "@type" : "PostalAddress",
      "addressCountry" : "US"
    }
  },
  "description" : "Advantco helps organizations update and transform their integration landscapes by migrating to SAP BTP Integration Suite, enabling secure, scalable, cloud-native connectivity across SAP and non-SAP systems.",
  "image" : "https://www.advantco.com/hs-fs/hubfs/1-2.png?width=2000&height=1015&name=1-2.png",
  "logo" : "https://www.advantco.com/hs-fs/hubfs/unnamed%20(2).webp?width=300&height=40&name=unnamed%20(2).webp",
  "name" : "SAP BTP Integration Suite Migration Services",
  "provider" : {
    "@type" : "Organization",
    "contactPoint" : {
      "@type" : "ContactPoint",
      "availableLanguage" : [ "English" ],
      "contactType" : "customer support",
      "url" : "https://www.advantco.com/contact-us"
    },
    "logo" : "https://www.advantco.com/hs-fs/hubfs/unnamed%20(2).webp?width=300&height=40&name=unnamed%20(2).webp",
    "name" : "Advantco",
    "sameAs" : [ "https://www.linkedin.com/company/advantco-international-llc/", "https://x.com/AdvantcoAdapter" ],
    "url" : "https://www.advantco.com"
  },
  "serviceType" : [ "SAP BTP Integration Suite Migration", "Legacy Middleware Migration", "Clean Core & Customization Rationalization", "ABAP & API Development" ],
  "url" : "https://www.advantco.com/sap-btp-integration-suite-migration"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "ProfessionalService",
  "description" : "Advantco offers secure, scalable, and cost-optimized AWS cloud services — from landing zone setup and migration to managed operations and AI/ML solutions.",
  "image" : "https://www.advantco.com/hs-fs/hubfs/4%20(1)-1.png?width=316&height=300&name=4%20(1)-1.png",
  "logo" : "https://www.advantco.com/hs-fs/hubfs/unnamed%20(2).webp?width=300&height=40&name=unnamed%20(2).webp",
  "name" : "AWS Cloud Services",
  "provider" : {
    "@type" : "Organization",
    "contactPoint" : {
      "@type" : "ContactPoint",
      "availableLanguage" : [ "English" ],
      "contactType" : "customer support",
      "url" : "https://www.advantco.com/contact-us"
    },
    "logo" : "https://www.advantco.com/hs-fs/hubfs/unnamed%20(2).webp?width=300&height=40&name=unnamed%20(2).webp",
    "name" : "Advantco",
    "sameAs" : [ "https://www.linkedin.com/company/advantco-international-llc/", "https://x.com/AdvantcoAdapter" ],
    "url" : "https://www.advantco.com"
  },
  "serviceType" : [ "AWS Landing Zone Setup", "AWS Application Migration", "Managed AWS Cloud Operations", "AWS AI/ML Solutions" ],
  "url" : "https://www.advantco.com/aws-cloud-services"
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "ProfessionalService",
  "areaServed" : {
    "@type" : "Country",
    "name" : "Worldwide"
  },
  "description" : "Advantco helps organizations harness the full power of Google Cloud by designing, migrating, and managing secure, scalable, and cost-optimized workloads end-to-end.",
  "image" : "https://www.advantco.com/hs-fs/hubfs/4%20(1)-1.png?width=316&height=300&name=4%20(1)-1.png",
  "logo" : "https://www.advantco.com/hs-fs/hubfs/unnamed%20(2).webp?width=300&height=40&name=unnamed%20(2).webp",
  "name" : "Google Cloud Services",
  "provider" : {
    "@type" : "Organization",
    "contactPoint" : {
      "@type" : "ContactPoint",
      "availableLanguage" : [ "English" ],
      "contactType" : "customer support",
      "url" : "https://www.advantco.com/contact-us"
    },
    "logo" : "https://www.advantco.com/hs-fs/hubfs/unnamed%20(2).webp?width=300&height=40&name=unnamed%20(2).webp",
    "name" : "Advantco",
    "sameAs" : [ "https://www.linkedin.com/company/advantco-international-llc/", "https://x.com/AdvantcoAdapter" ],
    "url" : "https://www.advantco.com"
  },
  "serviceType" : [ "Google Cloud Foundation Setup", "Application Migration & Modernization", "Managed Google Cloud Operations", "Data Analytics & AI/ML Solutions" ],
  "url" : "https://www.advantco.com/google-cloud-services"
}
```