2 posts in this topic
I am using MirrorSync 3.02
My scenario has 2 teams each syncing to the same file on the server.
We will have 2 Sync configs, 1 for each team.
Team A Sync config using JDBC
Team A will get an offline copy of the same file that is on the server, with ALL the data.
Team A will sync ALL tables (2 way sync).
No problem there.
Team B Sync config using JDBC
Team B will get an offline copy of the same file that is on the server, but with only a SUBSET of the data (we will take a full offline copy and then delete many of the records).
Team B will sync a subset of the tables (2 way sync).
When team B syncs, will MirrorSync detect the missing records as deletes and the delete the associated records on the server? ( this is not what we want ).
If yes, is there a way to prevent this or a better way to handle it? XML and the customization script and disable deletes?
I need some help. I have a database with id and need to update the name of the current record only from an oracle database. I can connect (odbc) to the oracle database and can import by match, but there are some many records and takes a while. Is there a better solution, like jdbc, or a plugin. Currently using filemaker 14 on windows 7. Please advice.
By Tony Morosco
I am investigating interrelating FileMaker and ArcGIS databases. I am from the botanical world and design databases on a simplified level, so please bear with me!
For instance, (and this is an over-simplified version) in both ArcGIS and FileMaker, we have a field in our databases which lists a plants status as alive or dead. Both of these databases are available outside, in the garden. We often would like to update just one source, and correct a plant's status in the garden on both systems. This would alter both the ArcGIS and the FileMaker databases, through just one update, probably in FileMaker Pro is my guess.
I am imagining this can be accomplished through JDBC, ODBC, or SQL. Ideally it would be via SQL. It will provide a portal between the two systems, and update each others tables whenever the need arises.
From what I understand, this should be possible. If for some reason we can't get the two databases talking directly with each other, perhaps inter-relating the two with a back-end SQL database is a possibility? We may try to build a FileMaker web portal to an ArcGIS web-viewer which can be updated, but it is kinda kludgey and does not update both tables.
If anyone knows a method how this can be accomplished, please let me know! Or reccomendations on where I can post to the correct forum.
And please let me know if I am not making any sense or I am garbling the language. I am known for both. ;-)