Skip to Content
Technical Articles
Author's profile photo Frank Schuler
Frank Schuler
June 6, 2023 2 minute read

Extend SAP Datasphere with SAP Open Connectors

To follow this blog, you would need an SAP Business Technology Platform account. I got a Pay-As-You-Go account that lets me get started for free. Then cost based on usage:

The trial version of the BTP does currently not provide access to SAP Data Sphere.

I then follow How to create an SAP Datasphere service instance in the SAP BTP Platform? By Jeetendra Kapase.

To access SAP Open connectors Subscribing to Integration Suite is required.

Subsequently I add Extend Non-SAP Connectivity via Manage Capabilities -> Activate Capabilities:

As a result, I got access to Open Connectors:

There I find my Organization and User Secret that I need to Data Sphere to Open Connectors:

To do so, I go into Connection where it is possible to Integrate you SAP Open Connectors account:

Where I chose my SAP BTP Account Region and provide my Open Connectors Organization and User Secret:

This gives me access to my Open Connectors from SAP Datasphere:

Which allows me to connect to several third party data sources powered by SAP Open Connectors, e.g. GitHub for which I created an instance:

I then Chose Connection Type Open Connectors which presents me with my Open Connection Instance:

And get my Datasphere GitHub connection:

Therefore, if you cannot find the Connector Type you need from the standard SAP Connector Type offering, I would recommend to connect to your SAP Open Connect Account.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Martin Kreitlein
      Martin Kreitlein

      Hello Frank,

      Thanks a lot for this informative Blog. This is the way you would expect the SAP Help pages for Datasphere look like! With screenshots and detailed information! Perfect.

      Still one specific question remains, and maybe you can give me some insights here, too?!

      I'm looking for the method to load data from a MS Sharepoint list into SAP Datasphere, but according to the Connectors Catalog there is no option for MS Sharepoint, but at least I can find MS SQL Server.

      Edit, 9.6.23: I found it unter "Sharepoint" now... I looked only under Microsoft 🙁

      However this question remains open:

      According to this Blog, you should be able to connect a MS SQL Server via the Data Provisioning Agent already, and would not need that Open Connector. Is that true? Or is it only working with DPA on a Windows Server? (The one we have is part of Rise private cloud).

      Thanks for sharing any insights,

      Martin

      Author's profile photo Michael Hamm
      Michael Hamm

      Hi Martin,

      MS SQL server can already be used via DP Agent. Just enable MssqlLogReaderAdapter. No driver needed (the docu is confusing). Bundled MS driver is "quite old" 9.x .  It's independent of Linux/Windows.

      Prepare Connectivity to Microsoft SQL Server

      Microsoft SQL Server Connections

      BR,

      Michael