...
- A Data Bank tool (described in Data Banks for Test Scenarios and Data Banks for Message Responders).
- A supported data source that is associated with the test scenario or responder suite—including Parasoft data repositories, data groups, Excel files, csv files, and SQL databases.
- A variable set that is associated with the test scenario (described in Working with Variables).
...
Configuring a Repository Data Source
Parasoft’s Data Repository is designed to help teams define, extend, and review large and/or hierarchical data sets for use in Parasoft messaging tools.
...
A repository data source is a "wrapper" for the repository data source that allows you to consume it in Parasoft messaging tools—in the same manner as you would consume data from an Excel data sheet or CSV file.
To configure a repository data source:
Use the Rows controls to indicate the range of rows you want to use. If you only want to use selected rows, click the Range button, then enter the desired range (assuming a one-based index) by typing values into the From and To fields. For example, to use only the first 10 rows, enter 1 in the From field and 10 in the To field. To use only the fifth row, enter 5 in the From field and 5 in the To field.
- Specify the repository to which this data source will connect.
- For Host, specify which Data Repository server you want to connect to. You can select one of the servers connected through TDM—or you can specify a new server. If the named server does not yet exist, it will be created.
- For Port, specify the port for that Data Repository server.
- For Repository name, select or enter the name of the repository you want to use. You can select one of the repositories connected through TDM—or you can specify a new repository. If the named repository does not yet exist, it will be created.
- Enter the username and password for connecting to this Data Repository server .
- Specify the data set to which this data source will connect. It’s okay to specify a data set that does not yet exist. However, that data set will need to exist (and contain data) by the time you start applying tools to use this data source.
...
- Use the Rows controls to indicate the range of rows you want to use. If you only want to use selected rows, click the Range button, then enter the desired range (assuming a one-based index) by typing values into the From and To fields. For example, to use only the first 10 rows, enter 1 in the From field and 10 in the To field. To use only the fifth row, enter 5 in the From field and 5 in the To field.
- Specify the database to which this data source will connect.
- For Database type, select the type of database you want to connect to. The driver for the specified database type must be available on your CLASSPATH.
Info title Using a different type of database If the database you want to use is not listed under Database type, select Custom. You can then specify a driver class in the Driver class field. Type the path to the appropriate JDBC driver class, including the package name.
- Specify the settings for that particular type of driver. Settings will vary from driver to driver.
- In the SQL Query area, type or copy the SQL query that expresses which data you want to use. A preview of the resulting data will be shown in the Columns area.
- (Optional) Enable Close connection if you want to close the connection to this database. It is recommended when you plan to use the data source only once, and it doesn't need to wait for another command. It is not recommended when you plan to have multiple data sources all connecting to the same database. In that case, all of the data sources can share a connection—and do not need to waste resources on a new connection each time.
...
Anchor | ||||
---|---|---|---|---|
|
...