Oracle CRM On Demand Connector > Mappings and Mapping Tasks with Oracle CRM On Demand Connector > Oracle CRM On Demand Sources in Mappings
  

Oracle CRM On Demand Sources in Mappings

To read data from an Oracle CRM On Demand database, configure an Oracle CRM On Demand object as the Source transformation in a mapping.
Specify the name and description of the Oracle CRM On Demand source. Configure the source and advanced properties for the source object.
The following table describes the properties that you can configure for an Oracle CRM On Demand source:
Property
Description
Connection
Name of the Oracle CRM On Demand source connection.
Source Type
Type of the Oracle CRM On Demand source. You can choose from the following source types:
  • - Single
  • - Multiple
  • - Parameter
Object
Name of the source object.
You can specify a custom query for a source object.
Filter
Configure a simple filter to remove rows at the source. You can improve efficiency by filtering early in the data flow. A simple filter includes a field name, operator, and value.
Sort
This property is not applicable for Oracle CRM On Demand Connector.
You can set the tracing level in the advanced properties session to determine the amount of detail that appears in the log for this transformation.
The following table describes the tracing level values:
Tracing Level
Description
Terse
The Secure Agent logs initialization information, error messages, and notification of rejected data.
Normal
The Secure Agent logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes session results, but not at the level of individual rows.
Verbose Initialization
In addition to normal tracing, the Secure Agent logs additional initialization details, names of index and data files used, and detailed transformation statistics.
Verbose Data
In addition to verbose initialization tracing, the Secure Agent logs each row that passes into the mapping. Also notes where the Secure Agent truncates string data to fit the precision of a column and provides detailed transformation statistics.
When you configure the tracing level to verbose data, the Secure Agent writes row data for all rows in a block when it processes a transformation.