Skip to main content
Solved

Read from esri geodatabase without connection file

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

View original
Did this help you find an answer to your question?

2 replies

andreaatsafe
Safer
Forum|alt.badge.img+12
  • andreaatsafeSafer
  • Safer
  • 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
  • June 30, 2022

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

Reply


Helpful Members This Week

Community Stats

31,549
Posts
119,598
Replies
39,190
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.