Database replication v1.0 - App Store Module instructions?
I need to train one of our potential partners on the database replication module and the documentation does not provide any instructions. (The excel importer documentation doesn't work either.) I see that creating a new table mapping from "TableMapping_Overview" is the first step, however, what are the dependencies and how does the MX app connect to the external DB? Also, have you added any additional support for other types of database? Please advise. Thanks!
Using the database replication takes
Add MxModelReflection module and add MxObjects_Overview to your menu. choose Sync Objects after deploying.
Add Database_overview and TableMapping_overview to your menu
Define a connection to a database in Database_Overview
Goto TableMapping_Overview and create a mapping between your entity and the database data. Choose the connection made in 3.
Always choose one field as key,
probably a unique id in the db.
Add mappings by attribute, startobject etc.
Run import. It syncs existing data.
For related tables: use 'Association' mapping and choose keys carefully.