2023:Data Connection (Node Type): Difference between revisions
Dgreenwood (talk | contribs) No edit summary |
Dgreenwood (talk | contribs) No edit summary |
||
| Line 6: | Line 6: | ||
Grooper can connect to a Microsoft SQL Server or any ODBC-compliant provider. External database table information can be accessed in Grooper by importing a table reference. This will create a '''[[Database Table]]''' child under the '''Data Connection''' in the [[Node Tree]]. | Grooper can connect to a Microsoft SQL Server or any ODBC-compliant provider. External database table information can be accessed in Grooper by importing a table reference. This will create a '''[[Database Table]]''' child under the '''Data Connection''' in the [[Node Tree]]. | ||
'''Data Connections''' can be used to look up values in an external database table. They are also used to export extracted data from Grooper '''Data Elements''' to an existing database table. Furthermore, a new table in a connected database can be created from Grooper using '''Data Elements''' from a '''[[Data Model]]''. | '''Data Connections''' can be used to look up values in an external database table. They are also used to export extracted data from Grooper '''Data Elements''' to an existing database table. Furthermore, a new table in a connected database can be created from Grooper using '''Data Elements''' from a '''[[Data Model]]'''. | ||
</onlyinclude> | </onlyinclude> | ||
Revision as of 11:19, 23 November 2020
Data Connections are created to connect a Grooper Repository to an external database. The Data Connection stores all information needed to access the database. Once connected, Grooper has both read and write access to tables in the database (assuming you have those user rights in the database).
Grooper can connect to a Microsoft SQL Server or any ODBC-compliant provider. External database table information can be accessed in Grooper by importing a table reference. This will create a Database Table child under the Data Connection in the Node Tree.
Data Connections can be used to look up values in an external database table. They are also used to export extracted data from Grooper Data Elements to an existing database table. Furthermore, a new table in a connected database can be created from Grooper using Data Elements from a Data Model.