Home
Administration Utility
Use the Administration Utility Command Line Interface (CLI) to manage Spectrum components and data.
Data Sources
Data source CLI commands manage connection between the Spectrum Technology Platform and data sources.
JDBC Database
Connections
dbconnection add

Welcome
Perform administrative tasks required to manage the operation of Spectrum Technology Platform on your system.
Getting Started
Configure and run a new installation of Spectrum Technology Platform.
Approval Flows
Define approval flows that data stewards use to review and accept records generated in a job by Exception Monitor.
Security
Perform tasks to secure your data on the Spectrum Technology Platform2022.1.0.
Data Sources
Configure data sources from which to load and process data in Spectrum Technology Platform2022.1.0.
Spectrum Databases
Manage databases that contain data from trusted data providers. These include databases used by Enterprise Tax, Geocoding, Global Sentry, Universal Addressing, Spatial and Routing.
Services
Access Spectrum Services through a REST or SOAP web service interface.
Flows
Schedule and manage job execution, options, and defaults.
Performance
Perform tasks to get optimal performance from your Spectrum Technology Platform environment.
Monitoring
Monitor system performance and configure notification and use system and audit logs.
Backup and Restore
Schedule or create backups and restore the Spectrum Technology Platform server.
Settings
View and configure Data Stewardship and Context Graph settings.
Administration Utility
Use the Administration Utility Command Line Interface (CLI) to manage Spectrum components and data.
- Getting Started with the Administration Utility
  The Administration Utility provides command line access to administrative functions. You can execute the commands interactively or in scripts. Some administrative functions are not available in the Administration Utility. For these functions you can use the Spectrum Management Console.
- Audit Log Information
  Audit Log Information CLI commands adds JSON activity and count information to the audit log files.
- Spectrum Business Glossary
  Spectrum Business Glossary CLI commands list, import and export glossary entities.
- Data Stewardship
  The Data Stewardship CLI command deletes exception records from the repository.
- Context Graph
  The Administration Utility Command Line Interface (CLI) provides Context Graph (contextgraph) commands to manage models, view jobs and job status, and manage model schemas, queries, and metadata.
- Data Sources
  Data source CLI commands manage connection between the Spectrum Technology Platform and data sources.
- Dataflows
- Entities
- Folders
- Information Extraction
- Jobs
- Spectrum Lineage & Impact Analysis
- Spectrum Machine Learning
- Match Keys
- Match Rules
- Best of Breed Rules
- Metadata Connections
- Notification
- Open Parser Cultures
- Open Parser Domains
- Performance Monitor
- Permissions
- Physical and Logical Models
- Process Flows
- Product Data
- Profiles
- Roles
- Scorecard
- Search Indexes
- Services
- Spectrum Databases
- Service pool size
- System
- Tables
- Tokens
- User Accounts
Spectrum properties
Reference information for spectrum-container.properties properties and proxy server settings.
About Spectrum Technology Platform
An overview of Spectrum, its data management architecture, its platform architecture, and its modules and components.

dbconnection add

The dbconnection add command creates a connection between Spectrum Technology Platform and a database.

Usage

dbconnection add --n ConnectionName --d Driver --h Host --o Port --i Instance --u Username --p Password --l "property:value"

Required	Argument	Description
Yes	--n `ConnectionName`	Specifies the name for the connection. The name can be anything you choose.
Yes	--d `Driver`	Specifies the driver for the type of database you want to connect to. To view a list of database drivers available on your server, use the dbdriver list command.
Yes	--h `Host`	Specifies the host name or IP address of the database server.
No	--o `Port`	Specifies the network port to use for communication with the database server.
No	--i `Instance`	Specifies the database instance to connect to.
No	--u `Username`	The user name to use to connect to the database, if required.
No	--p `Password`	The password to use to connect to the database, if required.
No	--l "`property`:`value`"	Specifies a comma-separated list of connection property and value pairs for the driver. To view the list of valid properties for a driver, open Spectrum Management Console, go to Resources > Data Sources, then click the Drivers tab. Select the driver you want then click the Edit button to view its connection properties.

Example

This example creates a connection to a database located on the host MyServer. The name of the connection will be NorthernRegionCustomers. It will use the driver ExampleSQLDriver which takes two connection properties: ExampleProp1, which is given a value of 123, and ExampleProp2, which is given a value of 456.

dbconnection add --n NorthernRegionCustomers --d ExampleSQLDriver --h MyServer --l "ExampleProp1:123,ExampleProp2:456"