Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Transformer Import Configuration File

Transformer Import Configuration File

When you configure a Cognos resource, you can specify a Transformer import configuration file. The Transformer import configuration file is an XML file that describes the mappings between Cognos Content Manager data sources and PowerPlay Transformer models. You create the Transformer import configuration file.
Multiple Content Manager data sources can refer to the same PowerCube generated from a single Transformer model. Each Model element in the XML file corresponds to a single Transformer model (.mdl or pyj) file and lists all the Content Manager data sources that refer to the model's PowerCube. Optionally, the Model element can list the Impromptu Query Definition data sources (<iqd> child elements) that require specific database type other than the default database type. The Transformer import configuration file can have multiple Model elements.
The following code shows a sample Transformer import configuration file:
<ImportConfiguration database="Teradata" dbVersion="1.0.0"> <!-- database: specifies default database for Impromptu Query Definition (IQD) SQL statements--> <!-- dbVersion format: major version.minor version.release--> <Model path="some directory\some model.mdl"> <!--Transformer model (.mdl or .pyj) --> <cmDataSource name="some Cognos datasource name" /> <!-- List IQD data sources for databases other than default --> <iqd name="Customers" database="Oracle" dbVersion="11.1.0"/> <iqd name="Products" database="Microsoft SQL Server" dbVersion="8.0.0"/> </Model> </ImportConfiguration>

0 COMMENTS

We’d like to hear from you!