Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. 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_SERVICE_URL
    The URL of the Test Data Warehouse Service that you want to connect to.
    For example,
    http://testhost:7705/tdw
    .
    USERNAME
    Name of the test data warehouse user that runs the query. The user must have the Test Data Warehouse Service View Data in Data Set privilege and at least read permission on the data set.
    PASSWORD
    Password of the test data warehouse user.
    DOMAINNAME
    Name of the domain to which the test data warehouse user belongs.
    NAMESPACE
    Namespace of the test data warehouse user.
    TDWSERVICENAME
    Name of the Test Data Warehouse Service.
    TESTDATAWAREHOUSENAME
    Name of the test data warehouse where you stored the data set.
    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.