Connecting to SAP ECC Data in Domo

​

Intro

​

Architecture

1. A Service-Oriented Architecture (SOA) is created in ECC and published for subscription (Publish & Subscribe).
2. The service generates a Web Service Definition Language (WSDL) XML file which defines the flow of data.
3. Domo then calls the service through the WSDL and requests data as defined by the WSDL.
4. ECC then interrogates the call and sends data through the SOA packet.
5. This is all controlled and defined in SAP ECC and Netweaver.

​

Connection Summary

1. Do all of the following in your development system:
   1. Establish an RFC user for DOMO
   2. Create the ZZDOMO Function Group
   3. Find your ICF server path
   4. Load your first DOMO function module
   5. Create an Enterprise Service
   6. Publish your new service using SAP SOA
   7. Send an email to DOMO with:
      • Server Path
      • DOMO RFC username and password
   8. Test your first web service with a DOMO representative
   9. Load all additional web services
   10. Test all services in the Development Environment
2. Transport all of the above to a Quality Assurance System and test thoroughly.
3. Transport all of the above to a Production, or BI System.

​

Connection Steps

​

Step 1: Establish an RFC user for Domo

1. Log onto the SAP ECC system.
2. Access the activity using one of the following navigation options:
   1. Call transaction code SU01.
   2. In the SAP ERP GUI, choose Tools > Administration > User Maintenance > Users.
3. In the User field, enter ERP2DOMO.
4. Select Create (F8).
5. On the Maintain User screen, enter information as shown here:
   1. On the Address tab page, enter the following:
      • Last Name: ERP2DOMO
      • Function: <Enter your function>
   2. On the Logon Data tab page, enter the following:
      • User Type: System
      • Password: <Enter your password>
   3. On the Defaults tab page, enter the following:
      • Logon Language: EN
   4. On the Profiles tab page, enter the following:
      • Profile: SAP_ALL and SAP_NEW
   5. Save your entries (Ctrl - S).
   Note: The ERP2DOMO user has the profiles SAP_ALL and SAP_NEW assigned, which gives him full authorization rights. If this authorization is not applicable to your project, you can restrict the rights of this user according to SAP Note 0338537.

​

Step 2: Create the ZZDomo Function Group

1. Run transaction SE80 (/nSE80).
   
2. Select Repository Browser.
3. Select Function Group in the menu.
4. Enter ZZDOMO in the empty field then hit Enter.
   
5. Click Yes.
6. In the Short text field, enter Domo Function Group, then hit Enter.
7. Select your Business Intelligence package then click Save. (If you don’t have a B.I. package, use a package starting with “z”).
8. Enter or select your CTS request number for your Domo development, then click Save.
   

​

Step 3: Find Your ICF Server Path

1. Run transaction SICF (/nSICF ).
   
2. Click the Execute icon.
   
3. Navigate to path default_host > sap > bc > gui > sap > its > webgui > SE61-DISPTXT.
4. Right-click and select Test Service.
   
   If the webgui service does not contain the SE61-DISPTXT sub-element, right-click on the webgui service and select Test Service.
5. Copy the IE path and email it to Domo.
   

​

Step 4: Load Your First Domo Function Module

1. In your development client, run transaction SE37 (/ nSE37 ).
2. Input the provided function module name, then click Create. In this example, the name is Z_DOMO_PP.
   
3. Enter ZZDOMO in the Function Group field.
   
4. In the Short text field, describe your function module.
5. Click Save.
6. In the Import tab, enter the input fields from your load sheet. Make sure to check the boxes for Optional and Pass Value.
   
7. In the Attributes tab, select Remote Enabled Module.
   
8. In the Tables tab, enter your return tables from your load sheet.
   
9. Copy the code section from your load sheet.
10. Paste the copied code into the Source code tab.
    
11. Click the Check icon.
    
12. Click the Save icon.
    
13. Click the Activate icon.
    
14. Click the green checkmark at the bottom of the screen.
    

​

Step 5: Create an Enterprise Service

1. Run transaction SE80 (/nSE80 ).
2. Under Function Group, enter ZDOMO then click on the dropdown to open the list of function modules.
3. Right-click on your new function module and select Create > Enterprise Service.
   
4. Name the new service and give it a description, then click Continue.
5. Click Continue again.
6. Select a security profile, then click Continue.
   
7. Select your Package and Transport Request, then click Continue.
8. Click Complete.
9. Click Activate.
10. Click Continue.

​

Step 6: Publish Your New Service Using SAP SOA

1. Run transaction SOAMANAGER (/ nSOAMANAGER ). This launches the web-based SOA Manager.
2. Click Log On.
3. Log in using your ECC credentials.
   
4. Select Service Administration.
5. Select Single Service Configuration.
6. In the Search Pattern field, enter the name of the new enterprise service, then click Go.
   
7. Select your service, then click Apply Selection.
   
8. Open the Configuration tab.
9. Click Create Endpoint.
   
10. In the Service Information dialog, enter the following:
    • The service name (match the name of the service)
    • A description
    • A binding name
      
11. Click Apply Settings.
12. Check the box for User ID/Password.
    
13. Scroll up and click Save.
14. Open the Overview tab.
15. Click Display selected Binding’s or Service’s WSDL URL.
    
16. Copy the URL and email it to Domo.

​

Next Steps

1. 1. Send an email to DOMO with:
      • Server Path
      • DOMO RFC username and password
   2. Test your first web service with a DOMO representative
   3. Load all additional web services
   4. Test all services in the Development Environment
2. Transport all of the above to a Quality Assurance System and test thoroughly.
3. Transport all of the above to a Production, or BI System.

​

Function Module Specifications

​

Troubleshooting

• Test the connection to the web service using SoapUI.
• Run the function module locally in the SAP environment.