2023:Data Connection (Node Type): Difference between revisions
Dgreenwood (talk | contribs) No edit summary |
Dgreenwood (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
</blockquote> | </blockquote> | ||
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 ''' | 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> | ||
How to create '''Data Connections''' and use them to to export data is discussed more in depth in the '''''[[Data Export]]''''' article. | |||
Revision as of 12:24, 12 October 2021
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.
How to create Data Connections and use them to to export data is discussed more in depth in the Data Export article.