Skip to Content
avatar image
Former Member

Connection between Cloud and On-Premise System

If we have SAP on Cloud and another in-house system On-Premise, how do we communicate these two systems? Let's says both are using SQL database, are we able to retrieve SAP data directly from On-Premise system via SQL command without PI or middleware?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 19, 2014 at 07:21 PM

    You should use:

    1) webservices

    2) SAP HANA CLoud Integration

    3) PI

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2014 at 11:51 AM

    Hey everbody,

    This topic is of interest for me, too. I try to implement a connection vice versa.

    I need to get data out of the cloud to analyse them and I found some Webservice (Query Journal Entries, Query Supplier Invoices, ...) which would perfom very well.

    But I have not yet understood how to activate them. As far as I can tell, they are not part of any "Communication Arrangement" provided by SAP byDesign, am I wrong? Where do I get a username and a password that are authorized to use these services?

    Thanks in advance!

    Janna

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Janna,

      You need 2 things to set up and use a Web Service. You're now able to perform all the steps through the front-end user interface.

      The first is a Communication Scenario - this is used to group the Web Services made accessible. For example, you could set up a Communication Scenario called "Journal Entry Retrieval" and specify that it uses the "QueryJournalEntryIn".

      You then create a Communication Arrangement that uses this Communication Scenario (this is specified in the first step when setting up a Communication Arrangement). You'll see in the subsequent steps you can then set a Username/Password or use certificate-based authentication.

      Once the Communication Arrangement is set up and activated, you'll be able to connect to the Web Service Endpoint (you can see these in the Communication Arrangement technical details) using the credentials that you specified.

  • avatar image
    Former Member
    Oct 01, 2014 at 10:29 AM

    You can also try HANA Cloud Connector :-)

    But it only works with SAP HANA Cloud Platform.

    SAP HANA Cloud Connector

    Add comment
    10|10000 characters needed characters exceeded