Oracle Data Warehouse Administration Console (DAC) - Import - 7.1

Talend Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog

Bridge Specifications

Vendor Oracle
Tool Name Oracle Business Intelligence Data Warehouse Administration Console (DAC)
Tool Version 10.1.3.4
Tool Web Site http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html
Supported Methodology [Data Integration] Multi-Model, Metadata Repository, Data Store (Physical Data Model, Stored Procedure Expression Parsing), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing) via JDBC API
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

BRIDGE INFORMATION
Import tool: Oracle Oracle Business Intelligence Data Warehouse Administration Console (DAC) 10.1.3.4 (http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html)
Import interface: [Data Integration] Multi-Model, Metadata Repository, Data Store (Physical Data Model, Stored Procedure Expression Parsing), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing) via JDBC API from Oracle Data Warehouse Administration Console (DAC)
Import bridge: 'OracleDAC' 10.1.0

BRIDGE DOCUMENTATION
Import Informatica PowerCenter metadata from the Oracle Data Warehouse Administration Console.


Bridge Parameters

Parameter Name Description Type Values Default Scope
DAC repository database type Select the Data Warehouse Administration Console repository database type. ENUMERATED
Oracle
Microsoft SQL Server
IBM DB2 UDB
Oracle  
DAC repository database server Enter the Data Warehouse Administration Console repository database server name or IP address. STRING     Mandatory
DAC repository database port number Enter the Data Warehouse Administration Console repository database server port number. NUMERIC      
DAC repository database name Enter the Data Warehouse Administration Console repository database name for MSSQL or leave it empty for other database types. STRING      
DAC repository database user name Enter the Data Warehouse Administration Console repository database user name. STRING      
DAC repository database user password Enter the Data Warehouse Administration Console repository database user password. PASSWORD      
DAC repository Excecution plans Select the Data Warehouse Administration Console Excecution plans to import. REPOSITORY_SUBSET     Mandatory
DAC path to generated files Enter the path to the destination for generated parameters and model files. If this parameter is specified, the bridge will exit immediately when it has finished creating them, without importing of models. DIRECTORY      
Informatica Domain Informatica Domain Name. This parameter is not applicable for Informatica PowerCenter before 8.0.For connecting to the PowerCenter 7.x or earlier use host name and port number instead and keep this parameter empty. STRING      
Informatica Security Domain Informatica Security Domain Name. This parameter is not applicable for Informatica PowerCenter before 8.0.For connecting to the PowerCenter 7.x or earlier use host name and port number instead and keep this parameter empty. STRING   Native  
Gateway Host Name or Address This parameter is optional for Informatica PowerCenter 8.0 or later, but is required for all versions before 8.0.

For PowerCenter 8.0 and later enter the Informatica Gateway node address. If this parameter is not specified, Informatica will try to locate this address automatically.

For PowerCenter 7.x and earlier enter the Informatica PowerCenter Repository Server address.
STRING      
Gateway Port Number This parameter is optional for the Informatica PowerCenter 8.0 or later but is required for all versions before 8.0.

For PowerCenter 8.0 and later enter the Informatica Gateway node port number. If this parameter is not specified, Informatica will try to locate the port number automatically.

For PowerCenter 7.x and earlier enter the Informatica PowerCenter Repository Server port number.
NUMERIC      
Repository Name For PowerCenter 8.0 and later enter the Repository Service name.

For PowerCenter 7.x and earlier enter the Informatica PowerCenter Repository name.
STRING     Mandatory
Repository User Name Enter the Informatica PowerCenter Repository user name. If this parameter is not specified, default anonymous access is used to read and import repository objects. If this parameter is specified, a matching password must be specified as well. The user must have 'read' permission on PowerCenter folder(s) containing the metadata to import. Also the user must have 'Access Repository Manager' privilege to access the PowerCenter repository content. STRING   Administrator  
Repository User Password Enter the Informatica PowerCenter Repository user password. This parameter is required only if Repository user name is specified. The password can be either plain text or encrypted using Informatica 'pmpasswd' utility. Be sure to set the 'Repository User Password is Encrypted' bridge parameter to tell the system what type of password is used.

This import bridge is warrantied to be 'read only' and will never affect the Repository contents. It is therefore safe to attempt the initial metadata harvesting as 'Administrator' in order to ensure that the entire Repository content is extracted without any access permission issue. Eventually, the administrator can set up a 'read only' user.

Refer to the tool documentation on permissions and security for more details.
PASSWORD      
Repository User Password is Encrypted Set this option to 'True' if you are using an encrypted password based upon the Informatica PowerCenter Repository 'pmpasswd' utility for extra security. Otherwise set this parameter to 'false' BOOLEAN
False
True
False  
Path to PMREP The path to the PMREP application file installed with a PowerCenter client. The client must be compatible with the source PowerCenter Repository server.

Examples:
'c:\Informatica\9.6.1\clients\PowerCenterClient\client\bin\pmrep.exe'
'etc/Informatica/bin/pmrep'
FILE *.*   Mandatory

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Oracle Data Warehouse Administration Console (DAC)"
Metamodel
InformaticaPowerCenter
Mapping Comments
     
Association SourceField, TargetField Built from Foreign Key information
Aggregation KeyType, Nullable  
AssociationRole SourceField, TargetField  
Multiplicity   Based on Source information and KeyType attribute
Source   Based on Foreign Key information
AssociationRoleNameMap SourceField, TargetField  
Attribute SourceField, TargetField  
Description Description  
Name BusinessName Set to Name if BusinessName is not set
Optional Nullable  
PhysicalName Name Attribute Physical Name.Computed from 'name' if not set
Position FieldNumber  
BaseType SourceField, TargetField  
DataType Datatype See datatype conversion array
Name   Based on the datatype
PhysicalName   Derived from the datatype
CandidateKey SourceField, TargetField, TargetIndex  
UniqueKey KeyType, TargetIndex.Unique  
Class Source, Target  
CppClassType   Set to ENTITY
CppPersistent   Set to True
Description Description  
DimensionalRole dimensional Role metadata extension  
DimensionalType dimensional Role Type metadata extension  
Name BusinessName Set to Name if BusinessName is not set
PhysicalName Name Class Physical Name.Computed from the 'name' if not set
ClassifierMap Transformation, Instance  
Name Name  
DataAttribute TransformField  
Description Description  
Name Name  
DataSet Transformation, Instance  
Name Name  
DatabaseSchema Source, Target Tables and views belonging to the owner
Name DBD name or connection name DBD name is for sources only. Connection name if present.
DerivedType SourceField, TargetField  
DataType Datatype See datatype conversion array
Length Precision  
Name Datatype See datatype conversion array
PhysicalName   Derived from the datatype
Scale Scale  
UserDefined   Set to False
DesignPackage Repository, Folder, FolderVersion, Source, Target A SOURCE and a TARGET packages are created to hold the source sub-packages and the target Classes respectively. Packages are also created for Mappings and Workflows.
Description Description  
Name Name, Source.DBDName Name, Source.DBDName
UserDefined   Set to True
FeatureMap TransformField  
Description Expression Description  
Name Name  
Operation Expression  
ForeignKey SourceField, TargetField  
Index TargetIndex  
Name Name  
IndexMember TargetIndexField  
Position   position in XML file
PropertyElementTypeScope   Source and target metadata extensionsare imported as UDPs.
PropertyType   Source and target metadata extensionsare imported as UDPs.
PropertyValue   Source and target metadata extensionsare imported as UDPs.
StoreModel PowerCenter file  
Name   Based on the file name