19 December 2011 at 10:19pm
(Last edited: 19 December 2011 10:20pm),
I have the mySQL database for SS up and running. All tables OK and tables for DataObject created.
SS works fine.
Here's the situation : there is a external loader software which will load every 24Hr several tables from
a central DATAMART somewhere in the country and pull these tables in the MySQL database,
which is also the MySQL database for the SS installation. This loading mechanism works fine and several
external tables are updated in my SS MySQL database.
The goal is to use these external tables in my SS platform as DataObjects.
I found nothing in Ingo's book about this. Just until now, I read in some forum that it should be possible
to work with external tables, but never how.
How do i "wrap" these external tables into SS DataObjects ?
Did you intend to view this data within DOM? The solution I give is to get the data into dataobject sets - mainly, I'd imageine for template parsing, nothing here to then view the data within the DOM (or MOdelAdmin) - that would be much harder.
20 December 2011 at 3:01am
(Last edited: 20 December 2011 3:01am),
I don't connect to an external DB.
The tables are succesfully created by the external loader software into the database used by SS.
The problem is that these databasetables should be a part of my local datamodel in SS.
There will be relationships between local defined tables and the external tables.
I have to use the tables as if it were dataobjects, created by SS, and manage it with DOM in the CMS.
20 December 2011 at 6:50am
I think only option 2 is possible. The purpose of all this is that changes in the corporate databases, spread all over the country,
are automatically propagated into the local copies (being the database tables in the SS MySQL databases).
If I read them into DataObjects and then write them back to the database, the "living link" is broken. If there is a change in the central corporate database table, which will be propagated automatically by the loader, it will not be reflected anymore in the database table which is connected with the object.
So my last chance is option 2. Being a rookie, is there any docu available somewhere ?