Command—loaddata for RDBMS Connections - trillium_discovery - trillium_quality - Latest

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841

You can connect directly to an IBM DB2 or ORACLE relational database management system (RDBMS) and create an entity by importing data from database tables stored in the system.

Before you issue the loaddata command, create a loader connection for your DB2 or ORACLE data source. The loader connection specifies where the data source files are located and allows the loaddata command to connect to the data source and initiate the data import process.

Syntax

loaddata <loader_connection> username <username> password <password> table <table_name>

where,

<loader_connection>

Name assigned by the repository administrator to the loader connection.

<username>

User ID required to validate the connection to the data source.

You must always provide the username and password parameters when connecting directly to a relational database management system (RDBMS).

<password>

Password required to validate the connection to the data source. Use this parameter if a login name and password are required.

<table_name>

Name of the relational database table to be imported.

Optional Parameters

Parameter

Description

jobname <job_name>

Job ID or name of the data load job.

columns {names}

Indicates the names of the columns from which to import data.

skip <number>

Number of rows to skip before starting to import data rows. All rows after the skipped rows will be loaded to the repository. For example, if your file has 300 rows and you select to skip the first 99, the system will load 200 rows, starting with the 100th row.

first <number>

Number of records from the beginning of the file to load (for example, the first 1000 records).

random <percentage>

The degree to which you want to randomly sample a percentage of records from the file.

Example

This command loads data over a special loader connection named db2conn which has been set up for an IBM DB2 database. There are three table columns that will be loaded: team blue, player, and score.

loaddata db2conn username db2user password db2pwd jobname db2load1 table championship columns {{team blue} player score}

When multiple columns are represented within a space-delimited line of column names, be sure to enclose them in braces ({}). If a column name contains whitespace, enclose the column name in braces ({}) also.