Forum Discussion

nsgood82's avatar
nsgood82
14 years ago

Data Driven Testing with Multiple Data Sources


Does anyone have experience writing data driven tests from
multiple data sources?


Here are some assumptions for the kind of data I’m talking
about.



  • The application aggregates data from many
    different systems of record across the enterprise.  For simplicity, let’s just assume we’re dealing
    with two entities, customers and products

  • A customer has relationships to multiple products

  • The same product can have a relationship to
    multiple customers


I realize I could put a customer and all his attributes into
one row along with that customers products, but then I would be replicating and
maintaining a lot of duplicate data.  And
the number of fields in each row would get very unwieldy.


Does TestComplete support relational data models or a
mechanism to join data sources together?

1 Reply

  • karkadil's avatar
    karkadil
    Valued Contributor
    14 years ago
    I recommend using database in your case to store all data. In this case it will be easy to select necessary rows using SQL queries.

    Otherwise you will have to write your own functions which will basically duplicate SQL functionality.