Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Personal Geodatabase to which editors enter values from some field inputs.

I would like some of the entries, eg Project No ( whose name is unique and has some some related attributes like contractor etc ) to be checked against an MySQL database and pop up properties of that Project number from External DB to be available for comparison during data entry..

This would help to avoid wrong Project name entry , double check whether its the Same project which is currently being entered, based on related properties.

I had a conversation with the Developer of the External Web application from where we want to fetch the data - Its a PHP application having a MySQL database at backend. So basically I would need to have a secure Login from the ArcGIS editing Window/Session.

Does this warrant a different approach?

share|improve this question
It would help to have a bit more detail. Since it is a Personal GDB, I assume you are using ArcGIS? If so, what version? Is the Oracle database an SDE database, or simply stand-alone? What have you tried? Part of what makes GISse work best is the users being able to build off of what someone has already attempted, to help them reach an answer. If you have already tried a couple of things, but they didn't work, please include that information, as that would prevent someone suggesting a duplicate idea. On the other hand, if you have an idea for a process, include that as well. – Get Spatial Mar 24 '13 at 23:04
It sounds like you want to write an editor extension using ArcObjects. Check out some of the samples, walkthroughs, etc. in the ArcObjects SDK Help. If you're not an ArcObjects developer already then you have a steep learning curve ahead of you... – blah238 Mar 25 '13 at 6:28
Hi Blah238 , Please see my edited comment and would that change your above comment/solution to the Question ? – Adarsh Madhavan Mar 25 '13 at 11:45
I don't think that changes anything except which database you need to access (MySQL instead of Oracle). Is there someone else in your organization that knows both ArcGIS development and database access? They would be able to help you much more easily than anyone here. – blah238 Mar 25 '13 at 17:20

It sounds like you just want to load in the MySQL DB table into Arc to compare feature attributes. You should be able to add the table using OLE DB connection, see link below.

Adding OLE DB connections to databases

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.