Yellowbrick Data Warehouse Connector

Back Next

Yellowbrick Data Warehouse sources in mappings

In a mapping, you can configure a Source transformation to represent a Yellowbrick Data Warehouse source.

The following table describes the source properties that you can configure in a Source transformation:

Property	Description
Connection	Name of the source connection, or create a connection parameter.
Source type	Type of the source object. Select Single Object, Multiple Objects, or Parameter. To define a parameter, select Parameter as the source type, and then specify the parameter in the Parameter property.
Object	Name of the source object.

The following table describes the Yellowbrick Data Warehouse query options that you can configure in a Source transformation:

Property	Description
Filter	Filter value in a read operation. Click Configure to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source. You can specify the following filter conditions: Not parameterized . Use a basic filter to specify the object, field, operator, and value to select specific records. Completely parameterized . Use a parameter to represent the field mapping. Advanced . Use an advanced filter to define a more complex filter condition.
Sort	Add conditions to sort records. You can specify the following sort conditions: Not parameterized. Select the fields and type of sorting to use. Parameterized. Use a parameter to specify the sort option. Sort Order. Sorts data in ascending or descending order, according to a specified sort condition.

Property

Description

Filter

Filter value in a read operation. Click

Configure

to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source.

You can specify the following filter conditions:

Not parameterized
. Use a basic filter to specify the object, field, operator, and value to select specific records.

Completely parameterized
. Use a parameter to represent the field mapping.

Advanced
. Use an advanced filter to define a more complex filter condition.

Sort

Add conditions to sort records.

You can specify the following sort conditions:

Not parameterized.
Select the fields and type of sorting to use.

Parameterized.
Use a parameter to specify the sort option.

Sort Order.
Sorts data in ascending or descending order, according to a specified sort condition.

The following table describes the Yellowbrick Data Warehouse advanced source properties that you can configure in a Source transformation:

Property	Description
Pre-SQL	The pre-SQL commands to run a query before you read data from Yellowbrick Data Warehouse.
Post-SQL	The post-SQL commands to run a query after you write data to a target.
SchemaPolicy	Policy for naming the schemas for tables. Select one of the following options: None Specified FromImport FromConnection
SchemaName	Name of the schema. Required if you select the Specified option for SchemaPolicy.
Filter Condition	Not applicable
IsNative	Not applicable
TableName	The table to read from. If not specified, use the table name in the source definition. You must add the Table name without quotes. Do not use this value to modify user-specific SQL snippets from other attribute fields, such as PreSQL and PostSQL. You must ensure that the table name specified in the SQL snippets matches the table name specified here
Tracing Level	Not applicable