07-28-2017 4:35 PM - edited 02-03-2024 11:07 PM
Dear Community,
is there something like a „scheduled service“ that converts customer addresses to coordinates in order to use it for geospatial segmentation?
According to https://uacp2.hana.ondemand.com/viewer/d0ff60c77eef4a1090ddd046cfb339e8/1705%20500/en-US/574da256ef1... we have to export all customer records, convert it manually (here.com) and import it again? So it isn’t possible to use geospatial segmentations without manual exports/imports?
Thank you,
regards,
Peter
There are few ways to do it that I'm aware of.
1. If you are using C4C as one of the data source, you can use cloud micro service from SAP to enrich location address. This integration is out of the box and you pay for the service usage. Data from C4C with standard location info will be then replicate to Marketing for segmentation.
2. If you are loading data via SAP BOBJ Data Services, there is also option/plugin to enrich data with locations. This approach is more suitable for initial load though (or daily load via SAP Data Service ETL)
3. If your data are already in Hybris Marketing, you can use OpenChannel integration. We did similar thing to enrich data (not location though) from 3rd party source. In MKT, you will run the campaign for those customer that you want to have address standardization. OC campaign send out those customer with current addresses. With HCI you can transform the message and call to address API (e.g. https://blogs.sap.com/2017/04/21/1705-address-validation-standardization-for-accounts-using-sap-dqm-..., receive the standardized address and update back to MKT via customer Odata interface.
With SAP DQM Micro service available, i think sooner or later there probably will be a standard integration between SAP MKT and DQM Microservice to do this work. It is good to check if SAP have this in the roadmap to avoid unnecessary development.
Regards,
Mai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Peter,
Besides the above suggested methods, yMKT also has the CRM geocoding functionalities available. So you could connect with an online API (openstreetmap, google etc.) without using HCI. Do go through the limits of the API you would like to use, and see whether that might be an option.
See for instance:
Some custom solutions that can be used (I am using bottom one without issues):
BR,
Akil
User | Count |
---|---|
7 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.