Skip to main content
Question

Creating tables in eSDE?

  • February 23, 2024
  • 4 replies
  • 95 views

matthewb
Contributor
Forum|alt.badge.img+11

I am reading data from a PostGIS table and writing to an ArcGIS eSDE, but I’m not able to create tables in the eSDE from FME, I can only write to tables created by ArcGIS Pro in the eSDE, is this normal?   I'm getting an ArcObjects error ‘-2147220655’, DBMS table not found.

 

4 replies

nielsgerrits
VIP
Forum|alt.badge.img+64

My guess is you use a connection file with permissions to insert update delete, but not create tables? Do you use the same connection file as you use in Pro?


matthewb
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • February 23, 2024

I’m able to write to tables that already exist in the sde, just not create new tables in the sde using FME.  I have to create the table in ArcGIS Pro, then write to it.  


nielsgerrits
VIP
Forum|alt.badge.img+64

I’m able to write to tables that already exist in the sde, just not create new tables in the sde using FME.  I have to create the table in ArcGIS Pro, then write to it.  

Yes I understand. But do you use the same connectionfile when working from PRO and when using FME?


matthewb
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • February 26, 2024

I’m able to write to tables that already exist in the sde, just not create new tables in the sde using FME.  I have to create the table in ArcGIS Pro, then write to it.  

Yes I understand. But do you use the same connectionfile when working from PRO and when using FME?

Yes.  Same login and user.