Skip to Content

Automatic conversion of address data to geocoordinates

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/574da256ef15f82ae10000000a4450e5.html 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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 29, 2017 at 07:28 PM

    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-micro-services/), 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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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:

      geocoding SPRO

      Some custom solutions that can be used (I am using bottom one without issues):

      ZGEOCODE

      GEOCODER CES

      BR,

      Akil