Extreme newbie here...
I'm curious whether or not Talend & SDI could be used to:
- read a SQL Server database that contains point coordinates in seperate columns (X,Y,Z)
- convert those coordinates to point geomtries
- populate PostGIS (or preferably Oracle) with the point features?
Thanks so much for any info/guidance/help provided.
Indeed SDI could be very useful to read X and Y columns values from an SQL Server database (using tMSSqlServerInput), then convert these coordinates into 2D point geometrie (s2DPointReplacer) and finally load these geometries into a PostGIS database (sPostgisOutput).
At the time being Oracle spatial format is not supported in SDI.