User Guide > tdwquery > 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.