Skip to main content
Solved

Read from esri geodatabase without connection file

  • June 21, 2022
  • 2 replies
  • 26 views
G
Forum|alt.badge.img

I'm trying to add a esri sde geodatabase reader to a workbench without an sde connection file. I have an example workbench I got from someone else, (but who left the company) with a geodatabase reader where I can just fill in the user credentials and server instance, and then it will read the database.

 

imageSo in te example above a new connection file is not needed. However, if I try to add a new reader I can only add one when I provide it with a sde connection file. Can someone tell me how to get parameters like in the picture with an esri sde geodatabase reader?

Best answer by andreaatsafe

Hi @gbazzz​ ,

The use of a username, password and instance name was removed from the "GEODATABASE_SDE" format starting in FME 2015.

So the reader that is in the workspace you have, is likely from FME 2014 or prior.

 

In FME 2015 and newer, the ESRI Geodatabase SDE (GEODATABASE_SDE) format, we made connection files the ONLY way to connect to an Esri Geodatabase (ArcSDE) - removing the options for building a connection using parameters or OS Authentication.

It's no longer possible to add a reader that is configurable with username, password and instance. You might be able to create a reader like this by copying the old one to a new workspace and carrying on as such.

-Andrea

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

andreaatsafe
Safer
Forum|alt.badge.img+14
  • andreaatsafeSafer
  • Safer
  • 444 replies
  • Best Answer
  • June 21, 2022

Hi @gbazzz​ ,

The use of a username, password and instance name was removed from the "GEODATABASE_SDE" format starting in FME 2015.

So the reader that is in the workspace you have, is likely from FME 2014 or prior.

 

In FME 2015 and newer, the ESRI Geodatabase SDE (GEODATABASE_SDE) format, we made connection files the ONLY way to connect to an Esri Geodatabase (ArcSDE) - removing the options for building a connection using parameters or OS Authentication.

It's no longer possible to add a reader that is configurable with username, password and instance. You might be able to create a reader like this by copying the old one to a new workspace and carrying on as such.

-Andrea

G
Forum|alt.badge.img
  • gbazzz
  • Author
  • 2 replies
  • June 30, 2022

That is a pitty, but at least I won't have to spent time looking further. thank you!

Community Stats

32,062
Posts
121,727
Replies
39,689
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.