Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

Reason : 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.

Possible ?

Note : 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 Loging from the ArcGIS editing Window/Session.Does this warrant a different approach ?

Adarsh

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.