│ Grooper Help - Version 25.0
25.0.0017 2,127
  • Overview
  • Help Status

Data Connection

Node Grooper.Core

Defines a connection to a database.

Remarks

Overview

A Data Connection stores the settings required to connect to a database. Once created, a Data Connection can be referenced when configuring database lookups, exports, or other DBMS-related actions throughout Grooper.

Data Connections encapsulate all connection details, such as server address, authentication, and provider-specific options, making it easy to manage and reuse database connectivity across multiple objects and processes.

Usage

  • Reference a Data Connection when configuring Data Table exports, lookups, or other database operations.
  • Use the 'Connection Settings' property to select and configure the specific database provider and its options.
  • Test the connection using the available commands to ensure connectivity before deploying to production.

Best Practices

  • Store Data Connections in a dedicated Project to simplify environment management (e.g., DEV/TEST/PROD).
  • Use descriptive names and documentation for each Data Connection to clarify its purpose and target environment.

Properties

NameTypeDescription

Design Tabs

General Configure a database connection, enumerate tables / views, and preview data.
Reports View reports for a node.
Advanced View or edit advanced details about a node.

Context Menu Commands

Command Shortcut Description
database Create Database Creates a new database on the server associated with this connection.
table Create Table Generates database tables from Grooper data elements..
table Drop Table Deletes a table from the database.
database Test Connection Tests the data connection by making a connection to the server.

See Also

Repository ConnectionODBCSQL Server

Used By

Database Schema ImporterDatabase LookupLexiconData ExportDatabase Table

Notification