Siebel JDB Connector Documentation Reference

Connector to manipulate specific data to Oracle Siebel JDB.

Configurations

Siebel Configuration

Parameters

Name	Type	Description	Default Value	Required
Name	String	The name of this configuration. With this name can be later referenced.		x
Connection	Username Password	The connection types that can be provided to this configuration.		x
Default View Mode Bus Comp	Number		3
Data Sense Filter Query Bus Objects	String
Data Sense Filter Query	String
Data Sense Filter Query Bus Comp	String
Data Sense Filter Query Int Objects	String
DataSense Filters	Number		3
Other	Boolean		true

Name

Type

Description

Default Value

Required

Name

String

The name of this configuration. With this name can be later referenced.

Connection

Username Password

The connection types that can be provided to this configuration.

Default View Mode Bus Comp

Number

Data Sense Filter Query Bus Objects

String

Data Sense Filter Query

String

Data Sense Filter Query Bus Comp

String

Data Sense Filter Query Int Objects

String

DataSense Filters

Number

Other

Boolean

true

Connection Types

Username Password

Parameters

Name	Type	Description	Default Value	Required
User	String			x
Password	String			x
Server	String			x
Port	String		2321
Server Name	String			x
RSA Encryption	Boolean		false
Object Manager	String			x
Language	String		ENU
Encoding	String		utf8
Reconnection Strategy	Reconnect Reconnect Forever	A retry strategy in case of connectivity errors

Name

Type

Description

Default Value

Required

User

String

Password

String

Server

String

Port

String

2321

Server Name

String

RSA Encryption

Boolean

false

Object Manager

String

Language

String

ENU

Encoding

String

utf8

Reconnection Strategy

Reconnect
Reconnect Forever

A retry strategy in case of connectivity errors

Operations

Create Business Component

http://www.mulesoft.org/schema/mule/siebel:create-business-component

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Business Object Component Type	String			x
Business Component Fields	Object		#[payload]
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Business Object Component Type

String

Business Component Fields

Object

#[payload]

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Create Result

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Delete Business Component

http://www.mulesoft.org/schema/mule/siebel:delete-business-component

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Business Object Component Type	String			x
Business Component Id	String			x
View Mode	Number		3
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Business Object Component Type

String

Business Component Id

String

View Mode

Number

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Boolean

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Execute

http://www.mulesoft.org/schema/mule/siebel:execute

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Service Name	String			x
Method Name	String			x
Input	Object		#[payload]
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Service Name

String

Method Name

String

Input

Object

#[payload]

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Object

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Execute Business Service

http://www.mulesoft.org/schema/mule/siebel:execute-business-service

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Business Service	String			x
Input Properties	Object		#[payload]
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Business Service

String

Input Properties

Object

#[payload]

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Object

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Execute Siebel Adapter

http://www.mulesoft.org/schema/mule/siebel:execute-siebel-adapter

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Integration Object	String			x
Method	Enumeration, one of: Insert Upsert Update Delete Query QueryPage Execute Synchronize			x
Input Properties	Object		#[payload]
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Integration Object

String

Method

Enumeration, one of:

Insert
Upsert
Update
Delete
Query
QueryPage
Execute
Synchronize

Input Properties

Object

#[payload]

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Object

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Query Business Components

http://www.mulesoft.org/schema/mule/siebel:query-business-components

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Business Object Component Type	String			x
Query Definition	Query Definition		#[payload]
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Business Object Component Type

String

Query Definition

#[payload]

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Array of Object

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Query Join Business Components

http://www.mulesoft.org/schema/mule/siebel:query-join-business-components

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Business Object Component Type	String			x
Query To Join Definition	Query To Join Definition		#[payload]
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Business Object Component Type

String

Query To Join Definition

#[payload]

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Array of Object

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Update Business Component

http://www.mulesoft.org/schema/mule/siebel:update-business-component

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Business Object Component Type	String			x
Search Spec	Object			x
Business Component Fields	Object		#[payload]
View Mode	Number		3
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Business Object Component Type

String

Search Spec

Object

Business Component Fields

Object

#[payload]

View Mode

Number

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Update Result

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Upsert Business Component

http://www.mulesoft.org/schema/mule/siebel:upsert-business-component

Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use.		x
Business Object Component Type	String			x
Business Component Fields	Object		#[payload]
Record Ids	Array of String
View Mode	Number		3
Target Variable	String	The name of a variable on which the operation's output will be placed

Name

Type

Description

Default Value

Required

Configuration

String

The name of the configuration to use.

Business Object Component Type

String

Business Component Fields

Object

#[payload]

Record Ids

Array of String

View Mode

Number

Target Variable

String

The name of a variable on which the operation's output will be placed

Output

Type

Upsert Result

For Configurations.

Siebel Configuration

Throws

SIEBEL:CONNECTIVITY
SIEBEL:RETRY_EXHAUSTED

Types

Reconnect

Field	Type	Default Value
Frequency	Number
Count	Number
Blocking	Boolean

Field

Type

Default Value

Frequency

Number

Count

Number

Blocking

Boolean

Reconnect Forever

Field	Type	Default Value
Frequency	Number

Field

Type

Default Value

Frequency

Number

Create Result

Field	Type	Default Value
Created Objects	Array of String
Error	Siebel Exception
Success	Boolean

Field

Type

Default Value

Created Objects

Array of String

Error

Siebel Exception

Success

Boolean

Siebel Exception

Field	Type	Default Value
Cause	Any
Detail Message	String
Detailed Message	String
Error Code	Number
Error Message	String
Localized Message	String
Major Number	Number
Message	String
Minor Number	Number
Stack Trace	Array of Any
Suppressed	Array of Any

Field

Type

Default Value

Cause

Any

Detail Message

String

Detailed Message

String

Error Code

Number

Error Message

String

Localized Message

String

Major Number

Number

Message

String

Minor Number

Number

Stack Trace

Array of Any

Suppressed

Array of Any

Query Definition

Field	Type	Default Value
Fields	Array of String
Records	String
Search Expression	String
Search Spec	Object
Sort Spec	String
View Mode	Number

Field

Type

Default Value

Fields

Array of String

Records

String

Search Expression

String

Search Spec

Object

Sort Spec

String

View Mode

Number

Query To Join Definition

Field	Type	Default Value
Business Object Component Type To Join	String
Fields	Array of String
Fields To Retrieve Join	Array of String
Join Condition	Object
Records	String
Search Expression	String
Search Spec	Object
View Mode	Number

Field

Type

Default Value

Business Object Component Type To Join

String

Fields

Array of String

Fields To Retrieve Join

Array of String

Join Condition

Object

Records

String

Search Expression

String

Search Spec

Object

View Mode

Number

Update Result

Field	Type	Default Value
Error	Siebel Exception
Success	Boolean
Updated Objects	Array of String

Field

Type

Default Value

Error

Siebel Exception

Success

Boolean

Updated Objects

Array of String

Upsert Result

Field	Type	Default Value
Created Objects	Array of String
Error	Siebel Exception
Success	Boolean
Updated Objects	Array of String

Field

Type

Default Value

Created Objects

Array of String

Error

Siebel Exception

Success

Boolean

Updated Objects

Array of String