Databases
A database is a connection configuration for a corporate database. It includes a name, a driver, and a description, plus connection properties in attribute-value format.
What it is used for
Define database connections that scripts can use to execute SQL queries, ingest transactional data, and extract information for analysis.
Configuration
| Field | Description |
|---|---|
| Name | Configuration identifier in Gredit |
| Driver | Connection driver type (ODBC) |
| Description | Descriptive text for the database |
Connection properties
Parameters in attribute-value pairs:
| Property | Description |
|---|---|
Host | Database server address |
Database | Database name |
Port | Connection port |
UserName | Connection user |
Password | Connection password |
Trace | Trace enablement (and any others required by the driver) |
Usage in scripts
Scripts can optionally associate a configured database to:
- Execute SQL queries
- Connect to the database and read or write data
- Extract information for analysis
Relationship with other modules
- Accounts: Each database belongs to an account
- Scripts: A script can have one or more associated databases (optional)
- Permissions: Database configuration is subject to role-based permissions