Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Data Sets
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Data Type Reference for Hadoop
  22. Glossary

Configuring tdwquery

Configuring tdwquery

You must configure the tdwquery properties file before you can run a query.
  1. Browse to the following location and find the properties file
    userConfig.ilm
    :
    <Informatica installation directory>/TDM/utilities/tdwquery/conf/
  2. Use a text editor to open the file and enter the values of the properties in the file.
    You must configure the following properties:
    Property
    Description
    TDW_REPO_URL
    The URL of the test data repository that you want to connect to. The URL appears in the
    Repository
    tab of the
    Administrator | Repository and Mart
    view in Test Data Manager.
    USERNAME
    Name of the TDM user that runs the query. The TDM user must have the Test Data Manager Service View Project privilege and at least read permission on the data set version.
    PASSWORD
    Password of the TDM user.
    DOMAINNAME
    Name of the domain to which the TDM user belongs.
    NAMESPACE
    Namespace of the TDM user.
    SERVICENAME
    Name of the Test Data Manager Service
    MARTNAME
    Name of the test data mart where you stored the data set version.
    DATASETVERSIONNAME
    Name of the data set version that you want to run a query on.
    PAGENUMBER
    Required if you enter a value for PAGESIZE. The number of the page that you want to view.
    PAGESIZE
    Required if you enter a value for PAGENUMBER. The number of records that you want to appear on each page.