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

[former_member203046]

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".

[Former Member]

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 <account name> -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

[former_member40112]

Hi Borislav,

Token generated may be useful for you .

First double check data center where your HCI-DS is hosted. HCP and HCI -DS should be on same datacenter.

Second: check Application name -b <host>:<application name>

Thanks, Brijesh

[Former Member]

HI Brijesh,

Thanks but it works fine in my case. I only posted because it might be for others also helpful. 🙂

[former_member40112]

Hi ,

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

Appreciate if you can share your knowledge .

Thanks, Brijesh

[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.

[former_member384109]

Hi Tomohiro Ono,

Please check below link to helpful for your issue.

Regards,

Ankit Patel

[Former Member]

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.

[nathan_qi]

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.

[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 <I account name which was same for all the members> -u <Here, I used my SCN id not Admin SCN> -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.