The LEAP

Automation insights and productivity tips from LEAPWORK.

All Posts

How to Drive Test Automation with Excel, Databases, and ODBC

Driving automation in LEAPWORK with pre-defined data from an Excel file is easy with the Read Excel block. But sometimes you need more real-time access.

For instance, if you routinely change the data in the Excel file before running your automation cases, re-adding the file every time can be cumbersome. The changes can even be made by other people in your organization who are not involved in the automation process.

You may also want to write results or other data back to the Excel file for further processing later. For instance, you can update the same Excel file every day with more and more results and even use it as a human-readable format for exchanging data between different systems.

See video demonstration

The following is an example of how Excel files can be used as a live data source in LEAPWORK and how to read and write to it using a Database block with an ODBC connection.

 

 

Using an ODBC connection to Excel (or a csv- or txt-file for that matter) can be a powerful way to read, manipulate and write data.

The ODBC query syntax can unfortunately be somewhat confusing, and documentation from Microsoft is sparse.

The following are a few links to articles and blog posts where the Excel ODBC driver is discussed:

Everything you need for codeless test automation

Learn more about codeless test automation in our guide to reducing risk, lowering costs, and driving value with test automation.

CTA-StartTrial-2

Claus Topholt
Claus Topholt
CTO and co-founder of LEAPWORK.

Related Posts

How to Automate Mobile Web Testing with Codeless Selenium

With brick and mortar stores closed during an on-going pandemic, websites, especially e-commerce websites, have to focus more than ever on creating quality customer experiences online. This has created a need for faster testing and new website functionality.

What is Mobile Web Testing and Why Should It Be Automated?

Websites and web applications are a huge part of how businesses acquire customers. Just one poor customer experience can sway their purchasing decision, especially in e-commerce.  Users who have a negative experience on a mobile website are 62 percent less likely to purchase from that business in the future. - Think with Google. 

Streamlining System Upgrades in ServiceNow with Automated Testing

For many enterprise businesses, ServiceNow is an operational backbone. But twice a year, panic unfolds. ServiceNow release two major mandatory upgrades requiring extensive testing. And more often than not, functional and regression testing gets postponed or left behind.  When these tests are postponed or skipped, it leaves businesses open to risk. In these key moments, system administrators and developers face pressure to complete functional and regression testing at speed.