I have some questions about how to integrate static database with spatial databases.
I have several static data bases on different platforms (Oracle, MySQL, SQL Server) I want to turn into spatial data for some users to work in QGIS.
Step 1: geocode data Initially I wanted to create a routine to geocode the data using OSM and OpenLayers.
Step 2: Provision of the data in spatial database These data should be available in Oracle Spatial (is a standardization that I follow). This is where my questions begin what better way to do this integration? There are business information that should not go to the bank so I have space, for example, a SQL Server based with static data a routine that geocodes the data and provides the correposndentes in Oracle Spatial geometries. That is the best?