CPQ database setup

[VinayKumarS]

Hello Everyone,

We are doing CPQ integration. I have added below properties in the hybris local.properties.

crm.system_type=MySQL

crm.database_hostname=localhost

crm.database=crm

crm.database_port=3306

crm.database_user=crm

crm.database_password=crm

crm.ssc_jndi_usage=false

Initialized the system.

Added RFC Desitination, SAP Base store configurations. and did the initialization. But no error. Initialization successful. But cpq database not updated with any data...

Can anyone has an idea??? please do needful.

Thanks

Samudrala

[VinayKumarS · Accepted solution]

I have found the issue. I am doing SAP configuration initialization. CPQ Initial load button is not enabled in HMC. We will have to go backoffice -> SAP Integrations -> SAP Base Store Configurations -> Select the configuration which we created for dataloader. Then you will have a button to do initial load.

[Former Member]

Did you check the logs in the console after data loader ran successfully? Once you run the data loader it would create tables in CPQ DB (eg: INSERT|/SAPCND/CONFIG|FIELDNAME_EVAL_TYPE|EVAL_TYPE INSERT|/SAPCND/CONFIG|FIELDNAME_EVALUATION|EVALUATION and COMM_**tables) If you do not see any errors and no data, you may have to use filters while running the dataloder (KB FIlters , Material Filter and Condition filter) I would prefer a condition filter by one table and run the loader, if you know about any KB details, you can use KB filter as well. Hope your ECC system is Unicode complaint.

[Former Member]

The filter files control, which configuration models, and prices are transferred. Table CRMATAB in ERP needs to be set up correctly, regarding the pricing tables to replicate. See details in the Hybis CPQ documentation, and in the installation guide, linked from there. https://help.hybris.com/6.3.0/hcd/8b3f53c38669101497c2f71cb181fbbf.html