Skip to Content

I can't connect from HCI-DS to our HANA DB of HCP.

Hello,team.

I'm using HANA Cloud Platform and Integration DataService.

Could you tell me how to resolve step about this issue?

//Question

- Could tell me how to set application-id of "neo grant-schema-acces" command?

Example> D:\HCP\SDK\tools>neo grant-schema-access --host

ap1.hana.ondemand.com --account xxxx --application S0015090084:erpif

--user xxxxx --id ihc

---> --application S0015090084:erpif // This is bad parameter becauseI can't register our HCP HANA DB, so I don't know connect rule of

application-id.

- I want to know specific rule about application-id when I use "neo grant-schema-access" command, and I want to know how to create application-id if use HCI-DS.

//Issue

- I can't register our HCP HANA DB to DATASTORES of our HCI-DS.

- I don't know how to set parameters about "neo grant-schema-acces" because I didn't found application-id rule from SAP note and SCN.

//I executed step.

I executed below step beacuse I would like to getting how to connect

from

HCI-DS to our HCP HANA DB. So I looked this document.

http://scn.sap.com/docs/DOC-64599

---

1. Setup HCP Console Client on my PC.

2. I tried get to Access token.

D:\HCP\SDK\tools>neo grant-schema-access --host ap1.hana.ondemand.com

--account xxxx --application XXXXXX:erpif --user xxxxx --id xxxx

SAP HANA Cloud Platform Console Client

Password for your user:

Access token to bind application 'XXXXX:erpif' to schema 'ihc':

sxdhkrbz76iarfc5fnmzwjowv8fmlw54e10geubrkmdf3qf04

3. I confirmed access token

D:\HCP\SDK\tools>neo list-schema-access-grants --host

ap1.hana.ondemand.com -a xxxxx --user xxxx --id xxx -p "xxxxx"

SAP HANA Cloud Platform Console Client

Schema Access Grants:

Access Token Schema ID

Granted To

Bound

sxdhkrbz76iarfc5fnmzwjowv8fmlw54e10geubrkmdf3qf04 ihc

S0015090084:erpif no

3. Login to our HCI-DS.

https://hcids.ap1.hana.ondemand.com/DSoD/session/logon#projects_tab_view

4. I tried to add DATASRORES for connect to our HCP HANA Database, but

happen error.

->Could you confirm capture?

//Add information

I confirmed GRANTED_ROLES of our HANA DB.

---

SQL:SELECT DISTINCT ROLE_NAME FROM GRANTED_ROLES WHERE ROLE_NAME LIKE

'NEO_%'

Result:Role name is "YYYY.XXX_DEV".

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Feb 04, 2016 at 12:28 AM

    Trick is in the -application . Please notice that this is not official reply, this is only work for my case.

    neo grant-schema-access --host ap1.hana.ondemand.com

    --account xxxx --application XXXXXX:erpif --user xxxxx --id xxxx

    This parameter should be <account name>:<application name>

    acount name:

    please take a look at your HCI portal address, it should be same as it.

    For example, my portal is: https://hcidstest.hana.ondemand.com/DSoD/session/logon

    Then, my account should be hcidstest

    application name:

    According to what I tested, this is related with your DataStore type.

    • if it's coming from production, it's dsprod.
    • If it's coming from sandbox, it's dstest.

    Where is production and sandbox? Navigate into DataStore tab and notice the selection on your far right!

    One last thing, if you are using the HCP in ap1, I don't know if you should put your HCI in the same region or not. Reason is, when you define the application, we didn't have chance to define the region. In another word, we don't know if we can use HCI to move the data from one HCP data center into another HCP data center.

    My 2 cents.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Folks,

      I am facing similar issue on integrating HCI data store to HCP HANA DB Schema instance. I'm with developer role access and got DB schema ID created by account administrator for organization P0123.

      Now, I access the my HCI account as Admin for P0123 organization and created datastore with  name "hanahci".

      To generate token through neo SDK console I used the following command :

      neo grant-schema-access -h us1.hana.ondemand.com -a -u -i SampleDB -b hcids:hanahci

      Token generated Successfully but when I used on my HCI accout for integration I'm facing the following issue : " Could not activate the neo connection: hanahci: Account and/or Application does not match the access token "

      PFA : Screen Shot.

      Please input some suggestions.

      Regards,

      Sai.

      Acc_Err.PNG (167.7 kB)
  • avatar image
    Former Member
    Mar 29, 2016 at 10:18 AM

    hi i had the same problem , but then i used this command

    C:\neo_cmd_tool\tools>neo list-schema-access-grants -h <landscape host> -a <account name> -u <SCN ID> -i <Schema id>

    Enter password for user..

    A list will come up with already existing access tokens for the Schema. copy paste the one whose status is 'yes'.

    if not revoke the access token , try from this link :

    SAP HANA Cloud Platform

    then again grant access token for your application and schema id.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2016 at 10:23 AM

    Hi Tomohiro Ono,

    Please check below link to helpful for your issue.

    [SAP HANA Academy] Live 4 ERP Agility: HCI-DS HCP Datastores

    Regards,

    Ankit Patel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 29, 2016 at 09:47 AM

    Hi ,

    Are you able to find solution ? I'm facing the same issue.

    Appreciate if you can share your knowledge .

    Thanks, Brijesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      C:\neo_cmd_tool\tools>neo list-schema-access-grants -h <landscape host> -a <account name> -u <SCN ID> -i <Schema id>

      Enter password for user..

      A list will come up with already existing access tokens for the Schema. copy paste the one whose status is 'yes'.

      if not revoke the access token , try from this link :

      SAP HANA Cloud Platform

      then again grant access token for your application and schema id.

  • avatar image
    Former Member
    May 31, 2016 at 04:01 PM

    Hi together,

    I have the same Problem and my issue was the NEO command.

    First I try with folowing command:

    neo grant-schema-access -h hcids.hana.ondemand.com -a (account name) -b hcids:p0XXX -u (SCN User ID) -i test.hci.connect

    and Access Tokken was generated:

    Access token to bind application 'hcids:p0XXX' to schema 'test.hci.connect': 1taz4bvvglsh4l8ai99w7ambb8xyuutnugaydgddbds27nyvur

    But I receive the same Error:

    " Could not activate the neo connection: hana_hci_to_hcp: Account and/or Application does not match the access token "

    In my case the problem was in HANA system –b (HCI-DS system)! Please try with folowing:

    neo grant-schema-access -h hana.ondemand.com -a -b hcids:dsprod -u <userName> -i <schemaID>

    ******************************************************

    For Europe (hana.ondemand.com or eu1.hana.ondemand.com):

    neo grant-schema-access -i <schemaID> -a <account> -h hana.ondemand.com -u <userName> -b hcids:dsprod


    For US (us1.hana.ondemand.com):

    neo grant-schema-access -i <schemaID> -a <account> -h us1.hana.ondemand.com -u <userName> -b hcidsus1:dsprodus1

    For Australia (ap1.hana.ondemand.com):

    neo grant-schema-access -i <schemaID> -a <account> -h ap1.hana.ondemand.com -u <userName> -b hcidsap1:dsprodap1

    **********************************************************

    Best regards,

    Borislav

    Add comment
    10|10000 characters needed characters exceeded