oracle.odi.generation.support

Class DDLGeneratorServiceImpl

java.lang.Object

oracle.odi.generation.support.DDLGeneratorServiceImpl

All Implemented Interfaces:

IDDLGeneratorService

public final class DDLGeneratorServiceImpl
extends java.lang.Object
implements IDDLGeneratorService

Default IDDLGeneratorService implementation.

Since:

11.1.1.3.0

Constructor Summary

Constructors

Constructor and Description
DDLGeneratorServiceImpl(OdiInstance pOdiInstance) Construct a DDLGenerationServiceImpl to use as a IDDLGeneratorService for the DDL generation service.

Method Summary

Modifier and Type	Method and Description
DDLDifferences	computeDDLDifferences(java.lang.Number pOdiModelId, java.lang.String pOdiContextCode, boolean pProcessTablesOutsideOfModel) Computes a DDLDifferences object for a given ODI Model ID.
java.lang.Number	generateProcedure(java.lang.String pProcedureName, java.lang.Number pOdiActionGroupId, java.lang.Number pOdiFolderId, DDLDifferences pDDLDifferences) Invokes the DDL generator service to create a procedure with all DDL statements that match the list of differences defined in the pDifferences parameter.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DDLGeneratorServiceImpl

public DDLGeneratorServiceImpl(OdiInstance pOdiInstance)

Construct a DDLGenerationServiceImpl to use as a IDDLGeneratorService for the DDL generation service.

Parameters:

pOdiInstance - to use for service.

Method Detail

computeDDLDifferences

public DDLDifferences computeDDLDifferences(java.lang.Number pOdiModelId,
                                            java.lang.String pOdiContextCode,
                                            boolean pProcessTablesOutsideOfModel)
                                     throws DDLGeneratorServiceException

Description copied from interface: IDDLGeneratorService

Computes a DDLDifferences object for a given ODI Model ID. Note that the differences are calculated between the saved repository model and the database. Changes applied to the model that are not saved will not be used to calculate the differences.

Specified by:

computeDDLDifferences in interface IDDLGeneratorService

Parameters:

pOdiModelId - Existing ODI Model ID

pOdiContextCode - Context Code for existing OdiContext used to access the tables in a schema.

pProcessTablesOutsideOfModel - Indicator to ask the generator if it needs to compare all tables of the schema with the tables of the ODI Model or limit only to the tables already defined in the ODI model.

Returns:

The DDLDifference object that exposes the list of differences

Throws:

DDLGeneratorServiceException - if pOdiContext or pOdiModelId cannot be found, or any other error.

generateProcedure

public java.lang.Number generateProcedure(java.lang.String pProcedureName,
                                          java.lang.Number pOdiActionGroupId,
                                          java.lang.Number pOdiFolderId,
                                          DDLDifferences pDDLDifferences)
                                   throws DDLGeneratorServiceException

Description copied from interface: IDDLGeneratorService

Invokes the DDL generator service to create a procedure with all DDL statements that match the list of differences defined in the pDifferences parameter.

Specified by:

generateProcedure in interface IDDLGeneratorService

Parameters:

pProcedureName - Name of the procedure that the generator will create.

pOdiActionGroupId - ID of the ODI Action Group to use. When set to null, it will use the Generic Action Group as defined in ODI Topology.

pOdiFolderId - Destination Folder ID in which the procedure will be created.

pDDLDifferences - the DDLDifferences object as obtained initially from computeDDLDifferences() and eventually modified with setToGenerate(true) on some of the DDLDiff differences.

Returns:

Created ODI Procedure ID.

Throws:

DDLGeneratorServiceException - if pOdiModelId, pOdiFolderId or pOdiActionGroupId cannot be found, or any oother error.