CCO Manager Configuration concern with Sap Business one V 10 Hana data base

[Tharindu]

Dear Experts ,

We have new configuration requirement of Sap Customer checkout and Customer checkout manager integration with Sap Business one version 10 Hana environment . First we tried to connect the US demo data base and while doing the Customer checkout manager configuration part we got below error when try to connect the data base. Credentials were all correct but the error is there .

In this environment, As usually used separate servers for application server and the data base server . For your kind reference here is the application server sap connection information for further reference .

Really appreciated if some one can advise what could be the reason for the above error and a way to get rid of that. And want to know that if there are more than one data bases in HANA server how we could select the correct data base in the CCOM configuration part .

Thanks and Best Regards,

Tharindu .

[anderson_schmitt]

Hi Tharindu,

You need to create a specific database for the CCO manager, it is not connected with your SAP B1 database.

Refer to the documentation below for further information:

https://help.sap.com/viewer/8f711df7d2aa4f1aa29f88c86cef2081/2.0.12/en-US/09937f9882ac490fb0508f0ce8...

In your SAP HANA, create a new schema for example CCOm.
https://help.sap.com/viewer/8f711df7d2aa4f1aa29f88c86cef2081/2.0.12/en-US/ae351eeb53344dae8265881e09...

Then, in the initial configuration of the CCO manager, in the Database Schema name enter CCOm.

Regards,
Anderson

[Tharindu]

Hi Anderson ,

Really appreciated your quick support on my concerns and also thanks for sharing those valuable information .

Kindly note that the reason why i was asked to connect with sap b1 data base because in SQL we have facility to create customer checkout manager related tables with in business one data base right by putting the business one data base name there.

jdbc:sqlserver://[server addr]:1433;databaseName=[database name]).

In HANA environment how is the data base recognize by the system . Is it from the instance number .

jdbc:sap://[server addr]:30015; the port 30015 has the format 3<instance number>15).

So Can you kindly advice how is possible to find this instance number related to our data base .

Many Thanks and best regards ,

Tharindu .