---
title: "Video: How to replicate a data table from Salesforce to SAP Hana"
description: This video replicates a data table from Salesforce to SAP Hana using Advantco's Salesforce Adapter.  This table is a real-time connection to Salesforce whereas a real table is the replicated data located in the Hana server. Integrate Salesforce and SAP Hana.
image: https://resources.advantco.com/hubfs/Replicate%20data%20from%20Salesforce%20to%20SAP%20Hana%20Advantco.png
---

# Video: How to replicate a data table from Salesforce to SAP Hana

[ Admin ](https://resources.advantco.com/knowledge-base/author/admin)  Oct 27, 2021 10:31:39 AM

 

The solution we provide here is based on SAP Smart Data Integration (SDI) tools which provide features to support data replication from external resources to SAP HANA. The two most important components in this context are the Data Provisioning Server, which is a native SAP HANA process, and the Data Provisioning Agent, which is a container running outside the HANA environment. The Advantco Salesforce adapter is deployed on the Data Provisioning Agent host and can be configured from the HANA environment duration a remote source is created. The remote source is the connection from SAP HANA to the Salesforce instance.T

 

This video demonstrates how to replicate a data table from Salesforce to SAP Hana using Advantco's Salesforce Adapter.

 

1. Deploy our adapter on our data provision agent, allowing it to work with a data provision server so that it can be deployed on any environment after the adapter is deployed on the agent.
2. Register with the server and create our remote source. 
     1. Define our remote source: Salesforce properties
     2. After creating the remote source, you can see all the objects in our Salesforce instances.
3. Create a virtual table for the account object. This table is a real-time connection to Salesforce whereas a real table is the replicated data located in the Hana server.
4. After creating the virtual table by right-clicking, you can see every field under the account object including custom fields. You can also query the account object by opening the contents of the virtual table and making a real-time call to Salesforce.
5. Replicate the data to a local server on a real table and select the remote source we defined earlier; the target schema and virtual table schema.
6. Add objects from the Salesforce instance. Select a prefix name, as it’s important to have initial and real-time with structure in order to replicate the data initially and afterwards.
7. Replicate this table in Hana. Select the fields you want to replicate and delete those that are not needed.
8. Refresh your tables after executing the replication task in SAP Hana.

Would you like to [request more information](https://www.advantco.com/request-more-info) or learn about our free trial and no-cost proof of concept?

 

[Salesforce](https://resources.advantco.com/knowledge-base/tag/salesforce), [Salesforce SAP Hana SDI](https://resources.advantco.com/knowledge-base/tag/salesforce-sap-hana-sdi), [video](https://resources.advantco.com/knowledge-base/tag/video)

## Read On

[![SFDC Adapter for SAP SDI](https://resources.advantco.com/hs-fs/hubfs/Imported_Blog_Media/Sap-Endorsed-App-Aug-04-2021-02-44-42-76-PM.png?width=352&name=Sap-Endorsed-App-Aug-04-2021-02-44-42-76-PM.png) ](https://resources.advantco.com/knowledge-base/product/adapter/sfdc-sdi)

### [SFDC Adapter for SAP SDI](https://resources.advantco.com/knowledge-base/product/adapter/sfdc-sdi)

In a competitive landscape, businesses need an edge that will help them succeed. Integrating...

[![Advantco Salesforce Adapter for SAP Hana SDI Integration](https://resources.advantco.com/hs-fs/hubfs/Hana%20SAP%20to%20Salesforce%20Integration.png?width=352&name=Hana%20SAP%20to%20Salesforce%20Integration.png) ](https://resources.advantco.com/knowledge-base/content/the-sap-certified-sfdc-adapter-provides-real-time-replication-of-changed-data-from-salesforce.com-to-hana-tables-press)

### [Advantco Partners with Global Airline Leader to Connect SAP HANA](https://resources.advantco.com/knowledge-base/content/the-sap-certified-sfdc-adapter-provides-real-time-replication-of-changed-data-from-salesforce.com-to-hana-tables-press)

**Advantco is pleased to announce that the Salesforce (SFDC) Adapter for HANA SDI was selected by a...**

### [Advantco SFDC Adapter for SAP HANA® Smart Data Integration Now Live](https://resources.advantco.com/knowledge-base/content/advantco-sfdc-adapter-for-sap-hana-smart-data-integration-now-live-on-sap-app-center)

*SFDC Adapter for SAP HANA Smart Data Integration Helps Customers Combine Salesforce Data with...*

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Admin",
    "url" : "https://resources.advantco.com/knowledge-base/author/admin"
  },
  "dateModified" : "2022-05-02T18:57:06.616Z",
  "datePublished" : "2021-10-27T14:31:39.000Z",
  "headline" : "Video: How to replicate a data table from Salesforce to SAP Hana",
  "image" : [ "https://resources.advantco.com/hubfs/Replicate%20data%20from%20Salesforce%20to%20SAP%20Hana%20Advantco.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://resources.advantco.com/knowledge-base/video-how-to-replicate-a-data-table-from-salesforce-to-sap-hana-using-advantcos-salesforce-adapter",
    "@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" : "VideoObject",
  "contentUrl" : "https://6260070.fs1.hubspotusercontent-na1.net/hubfs/6260070/Video%20How%20to%20replicate%20a%20data%20table%20from%20SFDC%20to%20SAP%20Hana%20SAP%20Hana%20using%20Advantcos%20Salesforce%20Adapte.mp4",
  "dateModified" : "2022-05-25T05:10:58.060Z",
  "description" : "",
  "duration" : "PT3M51S",
  "height" : 1080,
  "name" : "Video How to replicate a data table from SFDC to SAP Hana SAP Hana using Advantcos Salesforce Adapte",
  "thumbnailUrl" : "https://api-na1.hubapi.com/filemanager/api/v3/files/thumbnail-redirect/57876681536?portalId=6260070&size=medium",
  "uploadDate" : "2021-10-19T13:05:22.437Z",
  "width" : 1614
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "NewsArticle",
  "author" : [ {
    "@type" : "Person",
    "name" : "Admin",
    "url" : "https://resources.advantco.com/knowledge-base/author/admin"
  } ],
  "dateModified" : "2022-05-02T18:57:06",
  "datePublished" : "2021-10-27T14:31:39",
  "headline" : "Video: How to replicate a data table from Salesforce to SAP Hana",
  "image" : [ "https://f.hubspotusercontent20.net/hubfs/6260070/Replicate%20data%20from%20Salesforce%20to%20SAP%20Hana%20Advantco.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/video-how-to-replicate-a-data-table-from-salesforce-to-sap-hana-using-advantcos-salesforce-adapter",
    "@type" : "WebPage",
    "description" : "This video replicates a data table from Salesforce to SAP Hana using Advantco's Salesforce Adapter.  This table is a real-time connection to Salesforce whereas a real table is the replicated data located in the Hana server. Integrate Salesforce and SAP Hana. "
  },
  "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"
}
```