Oracle Data Warehouse Administration Console (DAC) - Import
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
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 |
| Data Profiling |  |
| Incremental Harvesting |  |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: Oracle / Oracle Business Intelligence Data Warehouse Administration Console (DAC) version 10.1.3.4 via JDBC API
See http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html
Metadata: [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)
Component: OracleDAC version 11.2.0
OVERVIEW
Import Informatica PowerCenter metadata from the Oracle Data Warehouse Administration Console.
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at https://metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with -backup option, although this common option is not implemented on all bridges for technical reasons).
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | |||
| DAC repository database type | Select the Data Warehouse Administration Console repository database type. | ENUMERATED |
|
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 Execution plans | Select the Data Warehouse Administration Console Execution 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 import bridge will exit immediately when it has finished creating them, without importing of models. | DIRECTORY | ||||||
| Informatica Domain | Informatica Domain Name. 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. 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 | 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 | 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 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' import 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 | ||||
| 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, e.g. '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 |