Skip to main content
Question

read multiple sde connect file

  • June 29, 2018
  • 4 replies
  • 61 views

dbklingdom
Contributor
Forum|alt.badge.img+7

Hello,

I need to read 124 SDE GDSs to access and report a table that is common to all of them 'Tracts'.

I tried the information in the following URL, but it is not working: https://knowledge.safe.com/articles/20203/how-to-read-all-feature-classes-from-multiple-esri.html

Any help would be appreciated.

Brian

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.

4 replies

trentatsafe
Safer
Forum|alt.badge.img+6

Hi @dbklingdom,

In the article you linked, I believe you were trying the comment from Mita. In the workspace you have, your Reader Resource will have a Feature Types to Read parameter. By Default, this will not be a Published Parameter. If you right click this Parameter, and select Create User Parameter(for Default Value you can select a single table for starters). Once this parameter is created, you will want to Link the Feature Types to Read on your Schema to Read format to the User Parameter just created(by Default it should be named FEATURE_TYPES).

 

 

Let me know if you require further assistance.

dbklingdom
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • July 2, 2018

Hello,

So I have been able to get a read out of a table/s from all of the 124 GDBs I have to read. however I am still need to be able to sort by GDB name/s, which I think should be fme_basename and I'm getting NULLs. I've followed both Mita and Trent's instruction, but if any one has a suggestion to get the GDB names it would be appreciated


dbklingdom
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • July 9, 2018

,

Trent I still get a variety of errors on every setup I try. I'd to see if you have some time today to give this another go please.


dbklingdom
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • July 9, 2018

The result that i am getting, is the first GDB bring read and stops there. And I am still getting NULLs for fme_basename and fme_dataset??