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

From Grooper Wiki
← Older editNewer edit →
m Randallkinard moved page 2023:Data Connection to 2023:Data Connection (Object) without leaving a redirect: new naming convention
No edit summary
Line 1: Line 1:
{{AutoVersion}}
{{AutoVersion}}
{{stubs}}
{{stubs}}
<section begin="glossary" />
 
<blockquote>
<blockquote>{{#lst:Glossary|Data Connection}}</blockquote>
'''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).
 
</blockquote>
<section end="glossary" />
Grooper can connect to a Microsoft SQL Server or ODBC-compliant providers (such as Oracle, Db2, MySQL and PostgreSQL).
Grooper can connect to a Microsoft SQL Server or ODBC-compliant providers (such as Oracle, Db2, MySQL and PostgreSQL).


Line 16: Line 15:


== How To ==
== How To ==
=== Create a Data Connection ===
=== Create a Data Connection ===
'''Data Connections''' can be created in any Grooper '''Project'''.
'''Data Connections''' can be created in any Grooper '''Project'''.

Revision as of 15:54, 26 April 2024

This article is about an older version of Grooper.

Information may be out of date and UI elements may have changed.

20252023

STUB

This article is a stub. It contains minimal information on the topic and should be expanded.

database Data Connections connect Grooper to Microsoft SQL and supported ODBC databases. Once configured, Data Connections can be used to export data extracted from a document to a database, perform database lookups to validate data Grooper collects and other actions related to database management systems (DBMS).

  • Grooper supports MS SQL Server connectivity with the "SQL Server" connection method.
  • Grooper supports Oracle, PostgreSQL, Db2, and MySQL connectivity with the "ODBC" connection method.

Grooper can connect to a Microsoft SQL Server or ODBC-compliant providers (such as Oracle, Db2, MySQL and PostgreSQL).

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. 2023:Database Lookup

Use a Data Connection for Database Lookups

Coming soon

Use a Data Connection for Data Export

Coming soon

Known Issues

The Grooper installer ships with various prerequisite components which are installed before the Grooper application. This includes CLR type mappings for various SQL data types. Without additional components installed, users may experience the following error when attempting to preview database tables with unsupported CLR Types (such as geometry and geography data types): 

InvalidOperationException: DataReader.GetFieldType(24) returned null.

To support additional CLR Types (including geometry and geography data types), users need to install the following prerequisite from Microsoft:

Retrieved from "https://wiki.grooper.com/index.php?title=2023:Data_Connection_(Node_Type)&oldid=22339"