2023:Data Connection (Node Type): Difference between revisions

Revision as of 12:45, 27 June 2023

Data Connections are required 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 certain ODBC-compliant providers (such as Oracle, DB2, MySql and Postgres).

Data Connections are primarily used for two reasons in Grooper

To validate data extracted from a document or to populate fields using values stored in a database.
- This is done using Database Lookups defined on Data Models.
To export collected data to a database.
- This is done using Data Exports defined using Export Behaviors

How To

Create a Data Connection

Data Connections can be created in any Grooper Project.

Use a Data Connection for Database Lookups

Coming soon

Use a Data Connection for Data Export

Coming soon

@@ Line 5: / Line 5: @@
 Grooper can connect to a Microsoft SQL Server or certain ODBC-compliant providers (such as Oracle, DB2, MySql and Postgres).
-'''Data Connections''' are used for two reasons in Grooper
+'''Data Connections''' are primarily used for two reasons in Grooper
-* To validate document data or populate fields Database lookups to populate or validate data when a document's data is extracted.
+* To validate data extracted from a document or to populate fields using values stored in a database.
-*
+** This is done using '''''Database Lookups''''' defined on '''Data Models'''.
-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]]'''.
+* To export collected data to a database.
+** This is done using '''Data Exports''' defined using '''''Export Behaviors'''''
 == How To ==
 === Create a Data Connection ===
-How to create '''Data Connections''' and use them to to export data is discussed more in depth in the '''''[[Data Export]]''''' article.
+'''Data Connections''' can be created in any Grooper '''Project'''.
+{{#lst:Database Lookup|how to create a data connection}}
+=== Use a Data Connection for Database Lookups ===
+Coming soon
+=== Use a Data Connection for Data Export ===
+Coming soon
 [[Category:Articles]]
 [[Category:Version 2023]]
 [[Category:Stub]]