Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBCREATE CONNECTOR

Purpose

To create a connector.

Prerequisites

Can be in any context; the name is a name of the connector's owning location and a new connector name separated by slash.

Syntax

createConnectorCommand =  OMBCREATE ( CONNECTOR "QUOTED_STRING" SET [ 
          "setPropertiesClause" SET ] "setReferenceToLocationClause" [ SET 
          "setReferenceIconSetClause" ] )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceToLocationClause =  ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createConnectorCommand

Create a new connector. Connector name is specified as parent location name and a connector name separated by a slash as follows: 'LOCATION_NAME/NEW_CONNECTOR_NAME'.

setPropertiesClause

Set specified properties of the connector.

setReferenceToLocationClause

Set the name of the location which the connector references.

setReferenceIconSetClause

Set specified Icon Set.

propertyNameList

The names of the properties whose values you want to set.

propertyNameList

Properties for CONNECTOR:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the connector.

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the connector.

Name: DATABASE_LINK_NAME
Type: STRING(30)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Database Link name.

propertyValueList

The values for the named properties.

propertyValue

A property value.

CONNECTOR Object

Table 6-9 CONNECTOR Object

Property Type Choices Min Max Default Description

DEPLOYABLE

BOOLEAN

true, false

none

none

true

Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true