cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect HANA database with SAP CAI ???

I have a trial version-I have created a database in HANA and i would like to connect that database to my chatbot CAI.

how to connect??

any resources??

Accepted Solutions (1)

Accepted Solutions (1)

Dan_Wroblewski
Developer Advocate
Developer Advocate

I would say follow philip.mugglestone video on exposing SAP HANA Cloud tables via OData:

Then just use the API action in a skill in SAP Conversational AI.

pmugglestone
Product and Topic Expert
Product and Topic Expert
0 Kudos

Thanks daniel.wroblewski !

There's more recent version of this tutorial here: SAP HANA Academy

We didn't have chance to publish any tutorials consuming the OData service from CAI as yet however.

Dan_Wroblewski
Developer Advocate
Developer Advocate
0 Kudos

philip.mugglestone I wrote the tutorials in the Tutorial Navigator for SAP Conversational AI. If you need someone to create the video tutorials, I'd be happy to help.

0 Kudos

Thank you sir..

0 Kudos

@daniel.wroblewski The video link was useful for creating Odata...

i am retrieving the data in the POSTMAN but not able to receive in my SAP CAI chatbot.

ERROR:ERROR WHILE CALLING API

0 Kudos

then i changed my GET URL

please help me out...

Dan_Wroblewski
Developer Advocate
Developer Advocate
0 Kudos

The error says you have the wrong header. Can you send the header that is expected (see header tab)?

Also, can you use the API action instead of the webhook one? Webhook requires that the call return JSON in a certain format that CAI understands as a message type.

0 Kudos

this is the headers tab

sir you meant that i should connect with API SERVICE rather than using WEBHOOK??

Dan_Wroblewski
Developer Advocate
Developer Advocate
0 Kudos

I’m saying 2 separate independent things

  • The error message you were getting says you sent the wrong header, so I suggested sending the right header — see the message in debug tab
  • You are using the web hook action — this requires that the response be formatted to fit with CAI and I assume the HANA OData service doesn’t, so you should use the simpler API action
0 Kudos

ok sir Thank you..

Answers (1)

Answers (1)

alichtenau
Advisor
Advisor
0 Kudos
Dan_Wroblewski
Developer Advocate
Developer Advocate

paul-pinard Maybe we should add this scenario to the tutorials

Paul_P
Product and Topic Expert
Product and Topic Expert
0 Kudos

daniel.wroblewski Totally agree!