Hero Backgroud Elements 2
Reading Time: 10 Min

How to Connect a Third-party ETL Tool

Learning Article
  • Today’s demands on businesses and their Business Intelligence tools are growing with the ever-increasing volume of available data. The source, structure, collection, and process of transformation and loading of your data(bases) should not stand in the way of processing your data flow and end-user analysis.

    In SAP Data Warehouse Cloud, you already have access to a wide variety of data connections, and you can upload and access your data in several ways. In order, for example, to load your already transformed data into SAP Data Warehouse Cloud, you can set up a connection to a third-party ETL tool of your choice.

    Let’s now look at how to do that:

    1. First, create a database user. To do that, start by going to the space you want the user to have access to. Scroll down to the Database Access tab:
    2. Click on Create:
    3. Enter the database username suffix and then enable required checkboxes to give required privileges to the new user. The required privileges are as follows: Read access, HDI Consumption, and Write access
    4. While enabling the HDI Consumption check box, you may see a pop-up like the following. Click on OK.
    5. If you are satisfied with the privileges you enabled, click on Create. You will see a window appears with all the details related to the new user. Copy the password and save it somewhere safe, since you will need it later.

      If you lose the password or lock the database user by giving the wrong password several times, you can easily go to the “i” icon and request a new password:

    6. You can see that the database user is created and added to the user list when you look at the details of the space.
    7. After the user is created, copy the hostname and password.
    8. Then open your third-party ETL tool. Please keep in mind that any ETL tool you wish to use with SAP Data Warehouse Cloud needs to be able to use SQL.
    9. You can now connect your third-party ETL tool to the specific space in DWC using the hostname and password that were generated during the creation of the database user.
    10. If the connection is successful, you will see your local schema in your ETL tool, and – vice versa – you will see the connected ETL tool’s databases in the Space in SAP Data Warehouse Cloud. From here on, you can now use the connected external data from your third-party tool to build data models using the Data Builder.

    Now that we showed you how to connect an ETL tool, why not try it for yourself on your SAP Data Warehouse Cloud tenant?

    If you want to continue learning how to use SAP Data Warehouse Cloud, please see our Learning Tracks.