Create and Manage Data Source | Zoho QEngine Help

Create and Manage Data Source

In a nutshell
Data sources in Zoho QEngine centralize test data management within a project for use in data-driven testing. You can create multiple data sources, each holding different datasets that can be accessed and reused across test cases. Data sources can be built manually or imported via a CSV file.

1. Overview

Test cases need the ability to manage and utilize various data sets for ensuring thorough and effective test coverage. This can be achieved through data-driven testing (DDT), which allows for systematic testing across a range of inputs and scenarios.  For better understanding of DDT, refer to the Understand Data-Driven Testing page. 

To effectively manage your test data in Data-Driven Testing (DDT), Zoho QEngine streamlines this process by centralizing data source management within your project. You can create multiple data sources, each holding various data sets that can be accessed and utilized by different test cases. This flexibility allows test cases across the project to access and reuse data, optimizing the testing process. Additionally, data sources can be stored in variables, allowing for seamless adaptation of test data across different environments, such as different web browsers, and Android or iOS versions. 

For example, you prepare a data source containing various usernames and passwords and use these data sets inside your test case. With the mask functionality, the usernames and passwords can be hidden and securely stored. During the test execution, Zoho QEngine automatically reads these values from the data source and runs the login test iteratively for each set of credentials. This helps identify any issues with the login functionality efficiently. 

2. Create Data Source

Follow the step below to navigate to data sources:

  1. Navigate to SettingsData Source



You can create a data source in two different ways; either choose to enter the data manually or upload a file.

  1. Manual Entry
  2. Upload file to create a data source

2.1 Manual entry

In this method, you manually enter the data to create a data source.

  1. Click Create Data Source.



  2. Provide a name for the data source created. Additionally, you may enter a description to help understand the data source better, although this step is optional. 



In the Data Set section, a row and a column are created by default. Each column represents a parameter, while each row represents a dataset.

  1. Begin by entering values into the created parameter. Click Add Column to introduce additional parameters and Add Row to create more datasets for testing.



    Click the ellipsis { } icon and select the Edit option to specify the data type for the parameters you want to define. Next, enter a Data Set Name to reference the dataset in the test case’s <live preview> or <results>.


    Notes
    Note:

    You can only create a maximum of 1000 rows and 300 columns in a data set.
    - The Configure option { } provides flexibility in naming your data sets. You can manually enter your own names or select system-generated ones, known as Default Name (e.g., 'row_01').
    - Alternatively, you can utilize the parameters created to generate data set names.
    - When configuring newly updated data sets, users can choose to either modify the existing data set name or retain the original name for the current data set.

  2. Enable or disable Forecast Failure for each dataset to classify it as a success or failure data set.

  3. Once you've created the data sets required, click Save.

2.2 Upload file to create a data source

You can also create a data source by uploading an external .csv file containing datasets.

  1. Click Upload File to import the external .csv file.



  2. Give the data source a Name, and select a Data Set Name from the dropdown. You can utilize the parameters you have created. 



  3. Click Save. Once a data source is created, you have the flexibility to add additional data sets, as well as make edits to or delete existing ones.


NoteIf a column in the uploaded file is missing a value, a null value will be automatically inserted in the data source template.

3. Update Existing Data Source

After creating your data sources, you can manage them seamlessly. The following are the actions that can be performed related to data sources.
  1. Append Data by Importing Data Set
  2. Manage Data Source

3.1 Append Data by Importing Data Set

You can update the data set in a data source either manually or by importing an external file. Manual editing allows you to directly add or modify individual data sets within the platform. This method is useful for making quick updates to the data sets. Further, to add new datasets manually, simply insert additional rows.


However, for bulk updates on data sets, importing an external dataset file is a more efficient approach. Here's how you can upload an external file to update your data source.

  1. Click Import Data to append more values to the data set.



  2. Upload the relevant file and choose a Data Set Name from the dropdown. You can choose parameters created as the data set name.



Note:
  1.  It is mandatory to have all the existing column names in the uploaded file.
  2. New parameters will be appended as new columns.
  3. Newly added columns will be empty for existing rows in the data source
  1. Click Save.


3.2 Manage Data Source

Zoho QEngine simplifies the management of data sets within your data sources. Here are the actions you can perform on the data stored in your data sources:


3.2.1. Manage Data Sets

You can perform edit, delete, and mask actions on the parameters saved in the columns created. 

i. To change the column name, follow the steps below:

  1. Click on Edit from the drop menu.




  2. Change the name and click Save.




ii. To remove the specified columns and their values, follow these steps:

  1. Click on Delete and confirm the action by clicking on delete.



Similarly, you can delete the values in the data set in bulk. Select the required values to be deleted and click delete.


iii. To mask specific columns and their values, follow these steps:

  1. Click on Mask to hide the values in the selected columns. Similarly, click on Unmask to reveal the values again.
Notes
Note: All the admins, managers, and the tester who created the column have permission to perform the unmask action.

3.2.2 Reference

This gives you the list of test cases that references the data sources.

  1. Click on Reference.



  2. From the list, click on View to see the references inside the respective test case.



  3. Click OK.


3.2.3. Delete Data Source

You can perform the delete action to remove required data sources. 

  1. Click the delete icon beside the data source and confirm your choice by selecting Delete.



Note: If the data set is already used in any of the test cases, remove their references to continue with the delete action.


4. Related Links


5. What's Next?

Next Steps
Previous Steps
Next Steps
You've learned how to create and manage data sources. The next step is to understand how data sources are used in test cases to achieve data-driven testing. 
Previous Steps
Before creating data sources, ensure you have a solid understanding of data-driven testing. Learn more about data-driven testing.
 











        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          Access your files securely from anywhere

            Zoho CRM Training Programs

            Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

            Zoho CRM Training
              Redefine the way you work
              with Zoho Workplace

                Zoho DataPrep Personalized Demo

                If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

                Zoho CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                      All-in-one knowledge management and training platform for your employees and customers.

                                                Create. Review. Publish.

                                                Write, edit, collaborate on, and publish documents to different content management platforms.

                                                Get Started Now




                                                                  You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                      Manage your brands on social media


                                                                        • Desk Community Learning Series


                                                                        • Digest


                                                                        • Functions


                                                                        • Meetups


                                                                        • Kbase


                                                                        • Resources


                                                                        • Glossary


                                                                        • Desk Marketplace


                                                                        • MVP Corner


                                                                        • Word of the Day


                                                                        • Ask the Experts


                                                                          Zoho Sheet Resources

                                                                           

                                                                              Zoho Forms Resources


                                                                                Secure your business
                                                                                communication with Zoho Mail


                                                                                Mail on the move with
                                                                                Zoho Mail mobile application

                                                                                  Stay on top of your schedule
                                                                                  at all times


                                                                                  Carry your calendar with you
                                                                                  Anytime, anywhere




                                                                                        Zoho Sign Resources

                                                                                          Sign, Paperless!

                                                                                          Sign and send business documents on the go!

                                                                                          Get Started Now




                                                                                                  Zoho TeamInbox Resources





                                                                                                            Zoho DataPrep Demo

                                                                                                            Get a personalized demo or POC

                                                                                                            REGISTER NOW


                                                                                                              Design. Discuss. Deliver.

                                                                                                              Create visually engaging stories with Zoho Show.

                                                                                                              Get Started Now








                                                                                                                                  • Related Articles

                                                                                                                                  • Create Data-Driven Test Cases

                                                                                                                                    What does this page cover This page covers how to create a data-driven test case, convert an existing test case to data-driven, and manage its data source settings after setup. 1. Overview Data-driven testing allows you to separate test logic from ...
                                                                                                                                  • Generate test data using Zia

                                                                                                                                    In a nutshell The Generate Data task removes the need to manage and update static test datasets by letting you describe the data you need and generate it on demand. Using Zia, QEngine's AI assistant, you can create realistic, structured sample data ...
                                                                                                                                  • Understand Data-Driven Testing

                                                                                                                                    In a nutshell Data-driven testing (DDT) in Zoho QEngine is a testing approach where a single test case runs against a structured data source containing multiple input datasets. The test case logic remains unchanged while each row in the data source ...
                                                                                                                                  • Live Preview for Data-Driven Testing

                                                                                                                                    In a nutshell Live preview for data-driven testing lets you observe each iteration of a data-driven test case executing in real time before adding it to a suite or test plan. Logs update automatically with each iteration, capturing the inputs ...
                                                                                                                                  • Create manual test cases using Zia

                                                                                                                                    In a nutshell Zia transforms natural language prompts into AI-generated test scenarios with clear steps and expected outcomes, streamlining QA efforts. Using the capabilities of NLP and LLM technology, it suggests relevant test cases to simplify ...
                                                                                                                                    Wherever you are is as good as
                                                                                                                                    your workplace

                                                                                                                                      Resources

                                                                                                                                      Videos

                                                                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                      eBooks

                                                                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                      Webinars

                                                                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                      CRM Tips

                                                                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                                                                        Zoho Show Resources