Hans Karlsen (talk | contribs) (Created page with "==== SQLExport serverside action ==== The SQLExport action is an action used to write data from your model into another external SQLdatabase. It is an alternative way to expor...") |
Hans Karlsen (talk | contribs) |
||
| Line 1: | Line 1: | ||
==== SQLExport serverside action ==== | ==== SQLExport serverside action ==== | ||
The SQLExport action is an action used to write data from your model into another external SQLdatabase. It is an alternative way to export data – way | The SQLExport action is an action used to write data from your model into another external SQLdatabase. It is an alternative way to export data – a way that needs no other external components or maintenance than what MDriven Server provides. | ||
SQLExport requires 'connectionstring' on root, 'data' as a Nesting that contains the datarow(s) to insert or update and on data - 'queryforinsert','queryforupdate' and 'queryforselectcount' as attributes (if queryforselectcount returns 0 the queryforinsert is used, else update). | SQLExport requires 'connectionstring' on root, 'data' as a Nesting that contains the datarow(s) to insert or update and on data - 'queryforinsert','queryforupdate' and 'queryforselectcount' as attributes (if queryforselectcount returns 0 the queryforinsert is used, else update). | ||
| Line 8: | Line 8: | ||
The very common case of “replicating” some model driven data to another database is implemented and scheduled in minutes. | The very common case of “replicating” some model driven data to another database is implemented and scheduled in minutes. | ||
[[File:Exporting files from MDriven Server 06.png|frameless| | [[File:Exporting files from MDriven Server 06.png|frameless|769x769px]] | ||
[[Category:Advanced]] | [[Category:Advanced]] | ||
[[Category:MDriven Server]] | [[Category:MDriven Server]] | ||
Revision as of 13:17, 31 January 2020
SQLExport serverside action
The SQLExport action is an action used to write data from your model into another external SQLdatabase. It is an alternative way to export data – a way that needs no other external components or maintenance than what MDriven Server provides.
SQLExport requires 'connectionstring' on root, 'data' as a Nesting that contains the datarow(s) to insert or update and on data - 'queryforinsert','queryforupdate' and 'queryforselectcount' as attributes (if queryforselectcount returns 0 the queryforinsert is used, else update).
Update 2018-10-18: you can now use 'connectionstringodbc' and the logic will use ODBC connection instead.
The very common case of “replicating” some model driven data to another database is implemented and scheduled in minutes.
