2023:Data Connection (Node Type)

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 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.

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 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.