{"id":9412,"date":"2020-12-22T11:26:58","date_gmt":"2020-12-22T10:26:58","guid":{"rendered":"https:\/\/www.rapidviews.io\/blog\/uncategorized\/connectez-votre-sap-cloud-platform-scp-a-votre-hana-on-premise"},"modified":"2025-03-28T16:24:32","modified_gmt":"2025-03-28T15:24:32","slug":"connect-scp-to-hana-on-premise","status":"publish","type":"post","link":"https:\/\/dev.rapidviews.io\/en\/blog\/sap-cloud-platform\/connect-scp-to-hana-on-premise","title":{"rendered":"Connect your SAP Cloud Platform (SCP) to your HANA On Premise"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"9412\" class=\"elementor elementor-9412\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-69e17faf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"69e17faf\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-65e03af3\" data-id=\"65e03af3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f11b530 elementor-widget elementor-widget-heading\" data-id=\"f11b530\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">The SAP Cloud Platform (SCP)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1037cba4 elementor-widget elementor-widget-text-editor\" data-id=\"1037cba4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The SCP is a <strong>cloud-based application development<\/strong> and extension platform available as a service (PaaS).<\/p><p>This platform allows you to enrich or create applications, without <strong>infrastructure constraints<\/strong>, to cover various domains :<\/p><ul><li>Analytical<\/li><li>Predictive<\/li><li>IoT<\/li><li>Big Data<\/li><li>API<\/li><li>UX<\/li><\/ul><p>These applications can be developed using current technologies such as JavaScript, HTML5 (fiori) or Java. In addition, numerous services for mobility, collaboration, integration, storage (HANA database) or security can be activated on demand.<\/p><p>Finally, as it is an SAP product, <strong>integration with the ERP ECC6 and S\/4HANA is simplified.<\/strong><\/p><p>In the world of <strong>Business Intelligence<\/strong>, with this type of infrastructure, one of the first needs is to repatriate the data to the cloud so that it can be exploited by the applications.<\/p><p>In this article, we will look at the <strong>connection between the SAP Cloud Platform (with an enabled HANA instance) and an On Premise HANA database<\/strong>. The objective is data replication via the <a href=\"https:\/\/www.decivision.com\/blog\/sap-hana\/smart-data-integration-repliquez-vos-donnees-en-temps-reel-sur-sap-hana\">Smart Data Integration<\/a> (SDI) module<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74cb0f48 elementor-widget elementor-widget-heading\" data-id=\"74cb0f48\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Connecting the cloud and the on-premise\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c042f22 elementor-widget elementor-widget-text-editor\" data-id=\"5c042f22\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Connections between cloud tools and on-premises tools are often problematic: network blocking, often delicate configuration, security, etc. To overcome this, SAP has developed a specific tool for HANA systems, the <strong>Data Provisioning Agent (DPA).<\/strong><\/p><p>It is through the DPA that the connection is made possible. In our example, this tool acts as an interface between the cloud and your company network.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50631f77 elementor-widget elementor-widget-image\" data-id=\"50631f77\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/connexion-cloud-on-premise.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2c39c9dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c39c9dd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-wider\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6263da98\" data-id=\"6263da98\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6c6ec032 elementor-widget-divider--view-line_text elementor-widget-divider--element-align-right elementor-widget elementor-widget-divider\" data-id=\"6c6ec032\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t\t<span class=\"elementor-divider__text elementor-divider__element\">\n\t\t\t\tStay connected !\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa82ba elementor-widget elementor-widget-heading\" data-id=\"aa82ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Subscribe to the Rapid Views Newsletter !<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-59f38b59 elementor-widget elementor-widget-text-editor\" data-id=\"59f38b59\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: #ffffff;\">Stay up to date with our latest blog posts, upcoming webinars and news!<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79e2cc67 elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"79e2cc67\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;button_width&quot;:&quot;20&quot;,&quot;step_next_label&quot;:&quot;Suivant&quot;,&quot;step_previous_label&quot;:&quot;Pr\\u00e9c\\u00e9dent&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Inscription Newsletter (EN)\" aria-label=\"Inscription Newsletter (EN)\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"9412\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"79e2cc67\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"Connect your SAP Cloud Platform (SCP) to your HANA On Premise\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"9412\"\/>\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-40 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-email\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tYour e-mail address\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-xs  elementor-field-textual\" placeholder=\"Your e-mail address\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-20 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-sm\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Register<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-311dfb7c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"311dfb7c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-194d2fda\" data-id=\"194d2fda\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-27e19e7 elementor-widget elementor-widget-heading\" data-id=\"27e19e7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Installation of the DPA<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6290f48c elementor-widget elementor-widget-text-editor\" data-id=\"6290f48c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\" style=\"text-align: justify;\">The sources (*) of the DPA are available for download from the SAP Download Center :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cccd9e2 elementor-widget elementor-widget-image\" data-id=\"cccd9e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/installation-dpa.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-360fbb8c elementor-widget elementor-widget-text-editor\" data-id=\"360fbb8c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>*The sources exist for Windows and Linux<\/p><p>Once the sources are downloaded, run the setup.exe and follow the installation steps.<\/p><p>At the second step, pay particular attention to the &#8220;Domain\\Username for Agent service&#8221; field:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f63696c elementor-widget elementor-widget-image\" data-id=\"6f63696c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/installation-dpa-etape-2.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e155c94 elementor-widget elementor-widget-text-editor\" data-id=\"1e155c94\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>This user must exist on the system where the DPA is installed and must have sufficient rights to start and stop services.<\/p><p>Once the fields have been filled in, click on next and then &#8220;install&#8221;.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-05560fd elementor-widget elementor-widget-heading\" data-id=\"05560fd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">DPA configuration<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78a8a849 elementor-widget elementor-widget-text-editor\" data-id=\"78a8a849\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Our DPA is installed, we now need to configure it to <strong>communicate with our SCP platform<\/strong>.<\/p><p>All the configuration is done in command line, open a command prompt and go to the bin folder of the directory where the DPA has been installed:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2be7485 elementor-widget elementor-widget-image\" data-id=\"2be7485\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-1.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1b06dee7 elementor-widget elementor-widget-text-editor\" data-id=\"1b06dee7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Then run the following command to start the configuration :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-262676b elementor-widget elementor-widget-image\" data-id=\"262676b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-2.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b57fc8a elementor-widget elementor-widget-text-editor\" data-id=\"b57fc8a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The configuration tool is launched :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4190c45c elementor-widget elementor-widget-image\" data-id=\"4190c45c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-3.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4003a4 elementor-widget elementor-widget-text-editor\" data-id=\"d4003a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Start the agent first (option 2 then option 1). Return to the main menu and choose option 6 :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-937c8d5 elementor-widget elementor-widget-image\" data-id=\"937c8d5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-4.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae8534f elementor-widget elementor-widget-text-editor\" data-id=\"ae8534f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Select option 1 and enter the requested information :<\/p><p><strong>Enter Use encrypted JDBC connection[true]<\/strong> : true<br \/><strong>Enter Host Name :<\/strong> Host name of the hana cloud instance<br \/><strong>Enter Port Number<\/strong> : port of the hana cloud instance<br \/><strong>Enter Agent Admin HANA User<\/strong> : user (this user must have been created on the hana cloud instance)<br \/><strong>Enter Agent Admin HANA User password<\/strong> : user password<br \/><strong>Enter HANA User Name for Agent Messaging<\/strong> : DPA<\/p><p><strong>Do you want to create a new SAP HANA user with the specified Agent XS HANA User credentials ?<\/strong> : true<\/p><p>After the entry, the agent will inform you that the connection is established :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-da64398 elementor-widget elementor-widget-image\" data-id=\"da64398\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-5.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-899dac6 elementor-widget elementor-widget-text-editor\" data-id=\"899dac6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The connection is established, we still need to register our agent on the SCP platform and <strong>deploy the adapter for connections to HANA On Premise<\/strong>.<\/p><p>Go back to the main menu and select option 7 and then option 1:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0e67e4b elementor-widget elementor-widget-image\" data-id=\"0e67e4b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-6.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec647dd elementor-widget elementor-widget-text-editor\" data-id=\"ec647dd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The Host Name Agent should have the same name as the machine deploying the DPA. This should be automatically filled in, in our example &#8220;dpa&#8221;.<\/p><p>Press Enter. The configuration agent will ask you for an Agent Host Name. This will also be filled in automatically. You should get this result :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3cec0e elementor-widget elementor-widget-image\" data-id=\"a3cec0e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-7.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-383d62a elementor-widget elementor-widget-text-editor\" data-id=\"383d62a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Finally, save the adaptation. Return to the main menu and choose option 8 and then option 2 :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-039fd80 elementor-widget elementor-widget-image\" data-id=\"039fd80\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/configuration-dpa-etape-8.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8798e08 elementor-widget elementor-widget-text-editor\" data-id=\"8798e08\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Go to the <strong>&#8220;web-ide&#8221; administration console<\/strong> <strong>of your SCP instance<\/strong> and check that the adapter is registered :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45f6fb3 elementor-widget elementor-widget-image\" data-id=\"45f6fb3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/vertification-adapter.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a97bcc elementor-widget elementor-widget-text-editor\" data-id=\"0a97bcc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The connection is correctly established, we can start replicating the data.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3524ba elementor-widget elementor-widget-heading\" data-id=\"f3524ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Data replication<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80c3d4e elementor-widget elementor-widget-text-editor\" data-id=\"80c3d4e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Several technical solutions exist to replicate data. Here, we will focus on the SDI module. On your <strong>Hana Cloud instance<\/strong>, create a &#8220;Remote Source&#8221; :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d869aa elementor-widget elementor-widget-image\" data-id=\"2d869aa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/replication-donnee.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e00ab4 elementor-widget elementor-widget-text-editor\" data-id=\"7e00ab4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Enter a name for your source and select the Adapter we registered earlier. The source location is the DPA we registered with the SCP.<\/p><p>Enter the host and port of your on premise server and the connection credentials.<\/p><p>If the connection has been correctly configured, <strong>the list of schemas and tables of your On Premise system will be displayed in the SCP platform :\u00a0<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2abbc7 elementor-widget elementor-widget-image\" data-id=\"a2abbc7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/liste-schema-et-table-systeme-on-premise.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea7ba31 elementor-widget elementor-widget-text-editor\" data-id=\"ea7ba31\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In development mode, start by creating a virtual table from a table in your on premise HANA database :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-837b0f8 elementor-widget elementor-widget-image\" data-id=\"837b0f8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/creation-table-virtuelle-sap-hana.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3bf9415 elementor-widget elementor-widget-text-editor\" data-id=\"3bf9415\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Then create a <strong>flowgraph<\/strong> with the virtual table we just created as source data :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab5f5ba elementor-widget elementor-widget-image\" data-id=\"ab5f5ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2020\/12\/creation-flowgraph.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9bea158 elementor-widget elementor-widget-text-editor\" data-id=\"9bea158\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Deploy and run your flowgraph. <strong>The data is now replicated in your SCP tenant.<\/strong><\/p><p><span style=\"text-decoration: underline;\"><strong>Note :<\/strong><\/span> For more information on SDI (Smart Data integration), <a href=\"https:\/\/www.decivision.com\/blog\/sap-hana\/smart-data-integration-repliquez-vos-donnees-en-temps-reel-sur-sap-hana\">please see this blog post.<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ee2863c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ee2863c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-970f1e8\" data-id=\"970f1e8\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2c4593a4 elementor-widget elementor-widget-heading\" data-id=\"2c4593a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Expert's conclusion<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-766e318 elementor-widget elementor-widget-text-editor\" data-id=\"766e318\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Through the <strong>SAP Cloud Platform (SCP)<\/strong> and the <strong>Data Provisioning Agent (DPA)<\/strong>, SAP offers us the possibility to easily replicate data from our on-premise systems to the cloud in a secure manner.<\/p><p>The DPA supports a large number of data sources and has its own SDK to develop its own connectors.<\/p><p>Combined with the functionality of the SDI (Smart Data Integration) module, we have a wide range of tools at our disposal to make all company data available to the SCP platform.<\/p><p><strong>An SCP platform combined with our RapidViews FI-CO, SD, MM, PP products will allow you to accelerate your BI deployment in the Cloud.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In this article we will focus on the connection between the SAP Cloud Platform (with an activated HANA instance) and an On Premise HANA database. <\/p>\n","protected":false},"author":6,"featured_media":59587,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[593],"tags":[],"class_list":["post-9412","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-cloud-platform"],"_links":{"self":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/9412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/comments?post=9412"}],"version-history":[{"count":0,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/9412\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media\/59587"}],"wp:attachment":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media?parent=9412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/categories?post=9412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/tags?post=9412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}