Skip to Content

SAC import data from HANA system

Hello

In our company they are doing some tests regarding SAC and the different ways we can get information from other SAP Systems. One of the tests we are trying to do is to get import data from our HANA system.

We already did the Live connection and it is working fine but the import connection is always unable to find the system.

In the SAP cloud connector I created the mapping for HTTPS to our HANA system and it is reachable here (I also tried HTTP and TCP in the meantime, which were also all reachable from the cloud connector). But once I got to SAC connections and try to add the import from HANA connection it always gives the error that it can't find the system. I'm sure all my system variables are correct for the connection.

The import data from HANA I'm trying to do is multiple with tenant (not sure if it makes a different).

Any ideas on what I'm missing?
Also is this even possible, because it's very weird that on some sites there are guides that say how to do the import data from HANA while other don't mention the import from HANA option in SAC and even notes saying that it is not possible.

Kind regards
Sven

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

11 Answers

  • Posted on Oct 22, 2019 at 02:25 PM

    Hi Sven,

    You're welcome! Looking forward to learn the outcome.

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Martijn van Foeken

      The problem got resolved, a colleague of mine found the problem.
      Apparently the C4A_AGENT was not updated to the latest version and updating it to the latest version solved the whole issue.
      I didn't even think of updating the agent because in SAC when I checked the default location it said that the agent was correct and could be reached even thought this was not the case.

      So in short don't trust SAC messages update everything just to be sure :) .

      Kind regards
      Sven

  • Posted on Oct 31, 2019 at 08:34 AM

    Hi Sven,

    Great to hear that the issue got resolved by updating the Cloud Agent: Please keep an eye on the support matrix and release notes of the waves to ensure you have the required version deployed: https://wiki.scn.sap.com/wiki/display/BOC/SAP+Analytics+Cloud+Support+Matrix. If you add /C4A_AGENT/deploymentInfo after the host and port of you Cloud Agent you can check the latest version deployed.

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2019 at 10:30 AM

    Hi Sven,

    If your HANA systems is a multi-tenant system, please select that option and provide the tenant database name. When creating the connection, please open the Developer Tools in Chrome and check the console and network tab for additional information.

    The import option was recently added as part of a wave upgrade. Prior to this, the only option was to use OData. But now you are able to connect and import data from a HANA system directly from SAC.

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2019 at 01:53 PM

    Hi Sven,

    Can you expand the request payload or response from the 200 response? The request might receive a response but it could return more information about why the connection is invalid.

    Are you using the correct host? Did you try connecting on the IP address?

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

    • Yes I opened the response and I get a 405 Method not allowed. So now I'm backtracing everything in the backend to see if I missed something. But at the moment I'm not seeing anything wrong. The cloud connector is configured, the cloud agent is installed, in SAC the cloud agent is linked everything is reachable. So maybe something in HANA itself is blocking it and giving a 405 method not allowed?

      Also the host is correct (host works fine on hana studio) also tried the ip still the same error.

      Kind regards
      Sven

  • Posted on Oct 22, 2019 at 07:22 AM

    Hi Sven,

    Are you using the same hostname/port to create the connection in SAP Analytics Cloud as in the HANA Studio? I guess you need to use the https port configured in HANA.

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Martijn

      I already tried all of them the one from hana studio, the https port and the http port.
      Unfortunately no success yet.
      I went a bit further in our systems today and found some more information maybe you know more about this.
      We are using 2VM's one VM has our HANA system running and the other one has the cloud connector and agent running.

      I have not found information about this on the internet yet, but does the cloud connector and agent maybe have to be on the same host as the on premise system you are trying to connect to? Or is it enough to configure the location of our HANA system in the cloud connector subaccount? because at the moment I have the second and it says it is reachable so i thought this would be good.

      This is everything that was done until now maybe you see a crucial step which I'm missing.On the cloud connector VM we have a tomcat with the Cloud Agent and we have cloud connector installed all is up and running. in the cloud connector a subaccount was created which is connected. In the subaccount I did mapping to the HANA VM using mapping to back-end system: SAP HANA with the correct host a HTTPS connection to the HTTPS port and the host is reachable. In SAC the subaccount is linked and the cloud agent is linked all is reachable.

      Kind regards
      Sven

  • Posted on Oct 22, 2019 at 11:13 AM

    Hi Sven,

    Could you try the following: open Chrome Developer Tools and create a HANA connection. Look for the clientRequest?connectionTypeID request on the Network tab. Please look at the Preview tab and share the details. There is more information about the actual connection SAC is trying when reaching out to your HANA system.

    It's fine that another VM is used to host the Cloud Connector and Cloud Agent.

    Please share the results!

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 22, 2019 at 12:15 PM

    Hi Sven,

    That's indeed different than when I create a connection to an SAP HANA system and deliberately use incorrect connection values.

    Seems that you connection request is directly cut-off. Almost seems like an SSL issue. Is there a valid SSL certificate applied on the hostname of your HANA system?

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Martijn

      euhm good question. In the documentation I don't really see this step.
      Is there a way I can easily check this (I didn't do all the configuration myself so I can't say for sure if it' setup or not)?

      But I've had this issue before of the SSL certificate for BW and then we got an error saying something about SSL and CORS problems and I already solved that one back then. So at the moment it says that the certificate is valid in SAC.

      Also is there a guide as how to do this if it turns out that it is not yet configured?

      Kind regards
      Sven

  • Posted on Oct 22, 2019 at 01:03 PM

    Hi Sven,

    Please browse to the xs admin page in your HANA system: https://hostname:port/sap/hana/xs/admin/ and check if the URL has a valid certificate in the browser.

    You can check the following SAP KBA: 2502174 - HANA Basic How-To Series - Securing HANA XS classic via SSL / HTTPS - using Web Dispatcher Administration and pse container.

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Martijn

      I just checked the XS admin and the URL has a valid certificate.
      Question: do I have to do something with the certificate in the cloud connector configuration->on-premise (I guess not cause otherwise the mapping would already gives errors,no?)?

      Kind regards
      Sven

  • Posted on Oct 22, 2019 at 01:31 PM

    Hi Sven,

    Ok, that rules out an SSL issue. No, you don't have to do anything regarding the certificate in the Cloud Connector.

    Can you check if there is anything displayed in the Log and Trace Files section in the Cloud Connector?

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 22, 2019 at 01:48 PM

    Hi Sven,

    I'm running out of options. All seems to be configured correctly. Can you validate that there is no firewall issue on the jdbc port used in HANA between the client and the HANA system?

    Kind regards,

    Martijn van Foeken | Interdobs

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Martijn

      Yes same for me that's why I already came to SCN to get more options for which btw a very big thank you for all your ideas up until now, they really helped me rule out a lot op options that I didn't think about. If all else fails I'll have to create a ticket to SAP.

      Sorry to ask again but how can I best check the firewall on the jdbc port? as far as I can see on the VM I don't see a jdbc port. Is there a standard port for this? But wouldn't issues on a port with the firewall not already display when connecting with hana studio?

      Kind regards
      Sven

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.