You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2008-06-17 19:01:25

WarrenM
Member
1 post

WarrenM said:

General question on functionality...

Hello,
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.

Warren M

Offline

#2 2008-06-17 22:48:19

mcoudert
Member
55 posts

mcoudert said:

Re: General question on functionality...

Hi Warren,

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.

--
Mathieu

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy