[postgis-users] export table from postgis to arcsde

[Randall, Eric]

I use Pentaho Data Integration for something similar, though mostly the other direction.
Using sql scripts, shp2pgsql/pgsql2shp, and python scripts generated from modelbuilder/ArcGIS toobox
tools,  Pentaho is then used as the organizing/scheduling/executing tool.  Works nicely.
I also use it for PostgreSQL/SQL Server/Oracle transfers and such.


Eric


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Paul
Ramsey
Sent: Wednesday, June 18, 2008 5:37 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] export table from postgis to arcsde


If you have control of both the pgsql and the sde, you could use
ogr2ogr and a windows scheduler or cron job to fire it off and
directly translate from pgsql to sde.

P

On Wed, Jun 18, 2008 at 8:07 AM, Paragon Corporation <lr at pcorp.us> wrote:
> I use a PostgreSQL pgagent job to do nightly dumps of a PostgreSQL view put
> as an ESRI shape file.  I have people on the other end that have some
> automated routine for importing this shape file into a SQL Server ArcSDE.
> I'm not sure how they do that, but I assume there most be some automated
> tool they use that loads shapefiles into ArcSDE.
>
> Hope that helps,
> Regina
>
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Benedetto Porfidia
> Sent: Tuesday, June 17, 2008 5:49 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] export table from postgis to arcsde
>
> I have a postgis database and i need to export a view from it to a sde db
> that is a source for arcims service. I should update a sde table with the
> postgis view. How can I do it?
> any hint is appreciated.
> Benedetto
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users