In the example we will show you how to add geocoding information to your Data Warehouse with Wilcon Data Warehouse Builder:

First select your customer master file, in this case it is the table “Kunden_K”.

Also add a stored procedure which will run after the data conversion.

Select the Fields you really need to add the Latitude-Longitude Information only and choose them for the Conversion.

It is a good idea to filter the Source Data to get the records which still do not have a Geocoding Information.

Select – if possible – Country, ZIP, City and Streetname for the use of the Geocoding Module. And create names for the Longitude and Latitude columns.

The Stored Procedure which will run at the end of the Conversion updates the Customer Master Table with the Geo Information from the DWH Builder. That’s it!


Contact – Get in touch with Wilcon Data

Main Office

Wilcon Data GmbH
Habichtweg 1
41468 Neuss, Germany

Tel.: +49 2131 316493-0

If you have any questions or need more information, don’t hesitate to contact us. We will answer your request immediately!

Please use our contact form.

6 + 1 = ?