Skip to main content
Question

Link ESRI geodatabase to a ‘.mdb’ database

  • January 21, 2020
  • 1 reply
  • 31 views
V

I am working on a project where I have to create maps. I have a file gdb and a personal database .mdb. Everytime I have to create a map I have to join them. Is there any way that the .mdb file can be just linked to the .gdb file so I dont have to do the join operation? Is there a way where the attributes that are stored in the .mdb file are just incorporated in the file geodatabase without doing the join operation?

I further intend to convert the file geodatabase to a shape file, such that each feature layer has its own attribute table.

Any help willl be much appreciated. Thanks in advance!

@takashi @david_r @redgeographics

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.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • 8392 replies
  • January 22, 2020

If the data doesn't change between each time you generate a map, you could perhaps pre-process your data by merging the data once and then writing the merged data to a new .gdb.

Depending on the software you use to create the maps, you could also write all the data to a "real" database such as PostGIS and index the merge fields. You can then use SQL joins (e.g. using the SQLExecutor) to do the joins in the database rather than in FME, it should be much quicker.

Community Stats

32,078
Posts
121,802
Replies
39,709
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.