Biml API Reference
AstOracleDestinationNode Type
BimlStudio 2017

The Oracle Destination loads data into an Oracle database that uses a database table, a view, or an SQL command. This is done specifically using the Attunity Oracle Connector.
Inheritance Hierarchy
Assembly:
Biml (in Biml.dll)
Language Element:
Properties
  Name Summary
Annotations
This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code.
(Inherited from AstNode)
AnticipatedPreferredOutputPath
Gets the PreferredOutputPath that is anticipated after modifying the referenced script component project. This exists to deal with script component tasks that can change preferred outputs
(Inherited from AstTransformationNode)
BatchSize
This value specifies how many rows can be loaded into the destination table in each batch before additional rows are requested from the data flow pipeline. The default value is 100.
BatchSizeDefaultValue
Gets the default value for the BatchSize property
BimlFile
This value specifies the BimlFile in which the Biml code that defines AstNode resides.
(Inherited from AstNode)
CanAutoLayoutMoveSinkAnchors
Gets a value to indicate whether autolayout is permitted to rearrange sink anchors on the design surface to reduce edge overlapping
(Inherited from AstTransformationNode)
CanAutoLayoutMoveSourceAnchors
Gets a value to indicate whether autolayout is permitted to rearrange source anchors on the design surface to reduce edge overlapping
(Inherited from AstTransformationNode)
Columns
This value specifies how the component should map columns in the data flow to columns in the destination. Columns that are not explicitly listed in this collection are automatically mapped based on name.
Connection
This value specifies the Oracle connection to use when loading the data.
DataflowInputs
Gets a collection of all dataflow input paths for this transformation
(Inherited from AstTransformationNode)
DataflowOutputs
Gets a collection of all dataflow output paths for this transformation
(Inherited from AstTransformationNode)
DataflowOverrides
Provides a collection of objects to override properties of the component, its input paths, its output paths, and its consituent dataflow columns.
(Inherited from AstTransformationNode)
DefaultCodePage
This value specifies which code page to use when the data source does not provide code page information.
DefaultCodePageDefaultValue
Gets the default value for the DefaultCodePage property
Destination
This value specifies the location to which the data is written.
Error
Gets the error string for this node, if any
(Inherited from AstNode)
ErrorCount
Gets the count of error diagnostics that have been generated for this node
(Inherited from AstNode)
ErrorHandling
This value specifies how errors are handled by default in columns processed by the component. This can be overriden at the component or column level for specific cases.
(Inherited from AstTransformationNode)
ErrorOutput
Gets the error output path for this transformation
FlowFile
This value specifies the containing code file of this node for Xml Binding purposes.
(Inherited from AstNode)
ForceDisableIncrementalChangeTracking
This value specifies whether changes to property values of this node should be automatically reflected in the corresponding Biml code. Its primary use is for temporary nodes that will never be persisted into BimlFiles.
(Inherited from AstNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstNamedNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstScopeBoundaryNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstTransformationNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstSingleInTransformationNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstDestinationTransformationNode)
FriendlyTypeName
Gets the friendly name of the type of this node
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstNamedNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstScopeBoundaryNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstTransformationNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstSingleInTransformationNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstDestinationTransformationNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
ImportedScopeChildren
Gets this ScopeBoundary's referenceable items. This is used to notify the children items when this item's ScopedName changes.
(Inherited from AstScopeBoundaryNode)
InputPath
This specifies the input path that will be used by this dataflow component. If an input path is not specified, the dataflow component will attempt to automatically discover an appropriate input path based on the surrounding dataflow.
(Inherited from AstSingleInTransformationNode)
IsAstNodeReadOnly
Gets a value indicating whether this node is currently in a read-only state
(Inherited from AstNode)
IsInBrokenLiveBimlScript
Specifies whether or not this object is part of a live BimlScript containing an error, which means that this is a cached object that may be out-of-date
(Inherited from AstNode)
ItemLabel
Gets a label that can be used to identify this node
(Inherited from AstNode)
LabelOutputPathAnchors
Gets a value that indicates whether or not this transformation needs to provide visible anchor labels in the package designer
(Inherited from AstTransformationNode)
LobChunkSize
This value specifies the chunk size that should be allocated of Large Object (LOB) columns.
LobChunkSizeDefaultValue
Gets the default value for the LobChunkSize property
LocaleId
This value specifies which locale is used by the dataflow task.
(Inherited from AstTransformationNode)
LocaleIdDefaultValue
Gets the default value for the LocaleId property
(Inherited from AstTransformationNode)
MaximumErrorCount
This value specifies the maximum number of errors that may be encountered before the component execution fails.
MaximumErrorCountDefaultValue
Gets the default value for the MaximumErrorCount property
MessageCount
Gets the count of message diagnostics that have been generated for this node
(Inherited from AstNode)
Name
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.
(Inherited from AstNamedNode)
NameDefaultValue
Gets the default value for the Name property
(Inherited from AstNamedNode)
ObjectTag
This property provides a general purpose storage mechanism for .NET objects to be associated with AstNode objects. It supplements the annotation system, which is intended for use with string-based metadata.
(Inherited from AstNode)
ParentItem
This value specifies the parent of the current node. All nodes must have a valid parent in the Biml framework, except for the root node.
(Inherited from AstNode)
ParentXObjectMappingProvider
This value specifies the parent of the current node for Xml Binding purposes.
(Inherited from AstNode)
PreferredOutputPath
Gets the preferred output path for the transformation. This output path will support automatic connections to single-input transformations that directly follow in the Biml code
(Inherited from AstTransformationNode)
PropertyChangeNotificationTarget
Gets a reference to the ViewModel object for this node. This property should only be used by the internal Biml framework.
(Inherited from AstNode)
ReferenceCount
Gets or sets the total number of other node properties that hold a reference to this node.
(Inherited from AstNamedNode)
References
Gets collection of FrameworkItemReference objects, which track rich information about the properties that hold references to this node.
(Inherited from AstNamedNode)
RefId
Returns the SSIS refid that is used to reference this item from within an SSIS package or dataflow.
(Inherited from AstNamedNode)
ScopeBoundary
Gets the scope boundary for this node
(Inherited from AstNode)
ScopeBoundary
Gets the ScopeBoundary for this referenceable item
(Inherited from AstNamedNode)
ScopedName
Gets the scoped name which can be used to uniquely identify this object among other objects of its type
(Inherited from AstNamedNode)
ScopedNamePrefix
Gets the prefix to use for ScopedName calculations
(Inherited from AstNamedNode)
SsisSafeName
Returns a version of the Name that has been cleaned of invalid characters for SSIS.
(Inherited from AstNamedNode)
SsisSafeScopedName
Returns a version of the ScopedName that has been cleaned of invalid characters for SSIS.
(Inherited from AstNamedNode)
StaticInputPathLabels
Gets a collection of the labels that should be used for each of the transformation dataflow input paths in the package designer
(Inherited from AstTransformationNode)
StaticOutputPaths
Gets a collection of the output paths that were statically defined for this transformation. This includes all of the system-defined output paths for various components.
(Inherited from AstTransformationNode)
SymbolTable
Gets a reference to the symbol table that stores a reference to this and all other named objects in the project
(Inherited from AstNamedNode)
SymbolTableProvider
Gets the symbol table provider for this node
(Inherited from AstNode)
TransactionSize
This value specifies how many rows can be added in a single transaction before a new transaction must created on the Oracle server. The default value is 100.
TransactionSizeDefaultValue
Gets the default value for the TransactionSize property
TransferBufferSize
This value specifies the size in kilobytes (KB) of the memory buffer that is used to transfer data to the Oracle server. The default value is 64.
TransferBufferSizeDefaultValue
Gets the default value for the TransferBufferSize property
TreeDepth
Gets the distance between this node and the root item
(Inherited from AstNode)
UseFastLoadIfAvailable
This value specifies whether Oracle conventional bulk load options are used.
UseFastLoadIfAvailableDefaultValue
Gets the default value for the UseFastLoadIfAvailable property
UseNoLogging
This value specifies whether target table logging should be disabled. Logging is typically disabled to reduce the quantity of redo metadata that is generated on the server.
UseNoLoggingDefaultValue
Gets the default value for the UseNoLogging property
UseParallelLoad
When set to true, this value indicates that the data can be loaded into the Oracle target table via multiple parallel data transfers.
UseParallelLoadDefaultValue
Gets the default value for the UseParallelLoad property
UserDefinedItems
Gets the child items of this node that were defined in user code
(Inherited from AstNode)
ValidateExternalMetadata
This value specifies whether the data flow transformation is validated against columns that originated in external data sources. When server assets such as tables and stored procedures are created during processing, ValidateExternalMetadata is normally set to False, which prevents validation from completing at compile time.
(Inherited from AstTransformationNode)
ValidateExternalMetadataDefaultValue
Gets the default value for the ValidateExternalMetadata property
(Inherited from AstTransformationNode)
VisibleVariables
Gets a collection of all variable nodes that are available to be used by this transformation. It includes variables defined by this transformation and any tasks/packages that contain this transformation
(Inherited from AstTransformationNode)
WarningCount
Gets the count of warning diagnostics that have been generated for this node
(Inherited from AstNode)
XmlMapping
Gets the XML binding information that is used to track the Biml code that corresponds to this node
(Inherited from AstNode)
Methods
  Name Summary
Events
  Name Summary
ItemLabelChanged
The ItemLabelChanged event occurs when the name of this node or any scope boundary ancestor (as determined by following ParentItem to the AstRootNode) name changes.
NameChanged
The NameChanged event occurs when the Name property of the current node has changed to a new value and that value has been committed.
NameChanging
The NameChanging event occurs when the Name property of the current node is receiving a new value but that value has not yet been committed.
ScopeBoundaryChanged
The ScopeBoundaryChanged event occurs when any ancestor (as determined by following ParentItem to the AstRootNode) changes in such a way as the ScopeBoundary for this node changes. This will force the ScopedName of this node to change if it is an AstNamedNode.
ScopedNameChanged
The ScopedNameChanged event occurs when the name of this node or any scope boundary ancestor (as determined by following ParentItem to the AstRootNode) name changes.
Extension Methods
  Name Summary
AddAnnotation(AnnotationType,String)
Adds an annotation to an AstNode
[Extension Method: Import namespace Varigence.Biml.Extensions]
AddAnnotation(AnnotationType,String,String)
Adds an annotation to an AstNode
[Extension Method: Import namespace Varigence.Biml.Extensions]
EnumerateAncestors
Returns the ancestors of the current node
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetBiml()
Retrieve the Biml that represents the AstNode
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetTag(String)
Gets the first annotation with a matching tag and returns the value. If the tag is not found, returns an empty string.
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetTag(String,Boolean)
Gets the first annotation with a matching tag and returns the value. If the tag is not found, returns an empty string.
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetTag(String,Boolean,Boolean)
Gets the first annotation with a matching tag and returns the value. If the tag is not found, returns an empty string.
[Extension Method: Import namespace Varigence.Biml.Extensions]
.NET API Metadata
Assembly:
Biml
Friendly Name:
OracleDestination
Abstract:
False
Referenceable:
True
Root Item:
False
Scope Boundary:
False
Symbol Table Provider:
False
Xml Schema Name:
Varigence.Languages.Biml.Transformation.Destination.AstOracleDestinationNode
Xsd Namespace:
http://schemas.varigence.com/biml.xsd
Referenceable:
True
Scope Boundary:
False