in QueryPairs and Staging Queries, and in Test Suite Connection overrides).įor details on setting up a Connection to Microsoft Excel, see the article Configuring Connections: Microsoft Excel via the QuerySurge JDBC Driver for Excel. QuerySurge Excel connections can be set up in the QuerySurge Admin view, and be utilized in the same manner as any other Connection types (i.e. Data can also be extracted from joined excel sheet ranges either within the same sheet, or from different sheets, or from sheets in different Excel files. QuerySurge can extract data from both entire sheets or specific ranges within them. In this document we discuss the approach for extracting data from a Microsoft Excel sheet. With the QuerySurge's built-in JDBC driver for Excel, data testers can use familiar SQL syntax to retrieve query data from a Microsoft Excel sheet and validate it against any QuerySurge-supported Source or Target.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |