> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting to SAP BW in Domo

## Overview

To connect to SAP BW data in Domo, you must establish a DOMO-SAP data link. To do this, you will go through all of the following steps:

1. [Establish an RFC connection between DOMO and BW](#h_a2635c0d-ff35-4b30-bf47-ee85a8733104 "SAP BW Connector")
2. [Create a Logical File](#h_dcb3c085-e171-4d5d-b6e2-deed0188d285 "SAP BW Connector")
3. [Find the Data Structure of your BW Object](#h_69801cf8-6231-4453-93f1-4259332b6b5f "SAP BW Connector")
4. [Build your APD](#h_2a5ec744-50f8-4a9b-8bed-0e274093b27f "SAP BW Connector")

## Step 1: Establishing an RFC connection between Domo and BW

1. In mySAP ERP, run Transaction
   SM59.

   <Frame>
     <img alt="sapbw1.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwD.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=c093eb834f55d67218b2ed08fc146c08" width="594" height="407" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwD.png" />
   </Frame>

2. Select
   **HTTP Connections to External Server** and click **Create**.

   <Frame>
     <img alt="sapbw2.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwF.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=6956ae33110b97681e957ee62bb275eb" width="529" height="360" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwF.png" />
   </Frame>

3. Fill in the following fields:

   * **RFC Destination**
   * **Description 1**
   * **Target Host**
   * **Service No.**
   * **Path Prefix**

     <Frame>
       <img alt="sapbw3.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwG.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=8a1887ab961e99b640f58eb5e381721b" width="674" height="678" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwG.png" />
     </Frame>

4. Click the
   **Logon & Security** tab.

5. Select the
   **Basic Authentication** radio button.

   <Frame>
     <img alt="sapbw4.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw7.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=c9cad7b173677992e5912793a1e956f1" width="666" height="699" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw7.png" />
   </Frame>

6. Scroll down and enter a username and password.

   <Frame>
     <img alt="sapbw5.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw6.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=4ac81d7ab7bcac327e8d89f94d1fb777" width="665" height="726" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw6.png" />
   </Frame>

7. Click
   **Save**.

Your RFC connection is now established.

## Step 2: Creating a Logical File

1. In mySAP ERP, run Transaction
   FILE.

2. Select
   **New Entries**.

   <Frame>
     <img alt="sapbw9.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw0.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=8a891fc1753d4a2b98e203f21972a1f4" width="746" height="336" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw0.png" />
   </Frame>

3. Fill in the fields as follows:

   <table class="mt-responsive-table"><tbody><tr><td class="mt-noheading" colspan="1" rowspan="1"><p> Logical file </p></td><td class="mt-noheading" colspan="1" rowspan="1"><p><span class="mt-font-courier-new"> Z\_DOMO\_DROP\_FILE </span></p></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p> Name </p></td><td class="mt-noheading" colspan="1" rowspan="1"><p><span class="mt-font-courier-new"> Domo drop </span></p></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p> Physical file </p></td><td class="mt-noheading" colspan="1" rowspan="1"><p><span class="mt-font-courier-new"> DOMO TEST\<YEAR>\<MONTH>\<DATE>\_\<HOUR>\<MINUTE>\<SECOND>.csv </span></p></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p> Data format </p></td><td class="mt-noheading" colspan="1" rowspan="1"><p><span class="mt-font-courier-new"> ASC </span></p></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p> Applicat.area </p></td><td class="mt-noheading" colspan="1" rowspan="1"><p><span class="mt-font-courier-new"> FI </span></p></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p> Logical path </p></td><td class="mt-noheading" colspan="1" rowspan="1"><p><span class="mt-font-courier-new"> Z\_DOMO\_DROP </span></p></td></tr></tbody></table>

   <Frame>
     <img alt="sapbw12.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw2.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=0555977471711f924f65556cd19818d2" width="773" height="333" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw2.png" />
   </Frame>

4. Click
   **Save**.

5. Enter your transport information.

## Step 3: Finding the Data Structure of your BW Object

1. In Data Warehousing Workbench, run transaction
   RSA1.

2. Select
   **BI Content**.

   <Frame>
     <img alt="sapbw13.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwA.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=1a0bb28e8226ff697287ea1b0f8c24b8" width="750" height="979" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwA.png" />
   </Frame>

3. Navigate to the desired BW object and double-click it.

4. Click
   **Key Figures**.

   <Frame>
     <img alt="sapbw14.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNvx.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=b7d566f2b60e7e6dd1b8155a3ed15f5e" width="750" height="490" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNvx.png" />
   </Frame>

The data structure of the object opens for you to view.

## Step 4: Building Your APD

1. In Data Warehousing Workbench, run transaction
   RSA1.

2. Open the Analysis Process Designer (APD).

   <Frame>
     <img alt="sap145.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwB.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=ec9c05bfdda97b1fb4d5bcd15a379a7f" width="658" height="364" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwB.png" />
   </Frame>

3. Select
   **General** then click **Create**.

   <Frame>
     <img alt="sapbw15.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwE.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=62a786a9380f19105672efa0e657cef0" width="567" height="360" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwE.png" />
   </Frame>

4. Select
   **General Application**.

   <Frame>
     <img alt="sapbw16.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw8.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=b28fa8475ccf0eda9a934b7d79f1ad63" width="690" height="554" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw8.png" />
   </Frame>

5. Enter a description in the
   **Description** field.

6. Select your Data Source (in this case an InfoProvider).

   <Frame>
     <img alt="sapbw17.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw4.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=4d58e42740e73fc11765a3ea87d893a6" width="621" height="503" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw4.png" />
   </Frame>

7. Name the Data Source.

8. Select an InfoProvider.

   You can also limit the fields sent.

   <Frame>
     <img alt="sapbw18.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw9.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=0e2e35a653c8914ad9137b86fe0a4e13" width="750" height="535" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw9.png" />
   </Frame>

   <Frame>
     <img alt="sapbw19.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwC.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=52dcdc9bde06e8c62d458c6a53a9452c" width="750" height="650" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNwC.png" />
   </Frame>

   <Frame>
     <img alt="sapbw20.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw3.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=80fc9025c8e514e8bb6450d4474a9792" width="750" height="403" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw3.png" />
   </Frame>

9. Select
   **Write Data to File**.

   <Frame>
     <img alt="sapbw21.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNvy.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=74b4f8e9eeec674fdccfc417d4423a65" width="750" height="432" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNvy.png" />
   </Frame>

   <Frame>
     <img alt="sapbw22.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNvz.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=f13fca79bf67c9119c07991cba433087" width="750" height="546" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNvz.png" />
   </Frame>

10. In the
    **Data Target: File** dialog, do the following:

    1. Enter a description for the file in the
       **Description** field.
    2. Select the
       **Application Server** radio button.
    3. Check the box for
       **Logical File Name**.
    4. Enter your new logical file name in the
       **File** field.
    5. Click the green check box.

       <Frame>
         <img alt="sapbw23.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw1.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=f377cb75f73a09f2b8ba2204c6b01725" width="750" height="520" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw1.png" />
       </Frame>

11. Click and drag to connect the nodes.

    <Frame>
      <img alt="sapbw24.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/h3wt9z20TJE_4Mbl/images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw5.png?fit=max&auto=format&n=h3wt9z20TJE_4Mbl&q=85&s=90a181bd6c1d86a204d5c85ca5b5e61f" width="750" height="479" data-path="images/kb/ka05w000001233r-00N5w00000Ri7BU-0EM5w000005vNw5.png" />
    </Frame>

12. Save your changes.

13. Click the
    **Activate** icon.
