Create a Static Data Source

Created by David Rumley, Modified on Mon, 12 Aug at 3:35 PM by David Rumley

Currently the data providers in Alchemy include:

  • CSV – data from a delimited file
  • Synthetic – generated data matching specific patterns or format(s)
  • Static – finite list of data included with the suite, not external

One great example of using static data in a Suite would be a test where you would like to iterate over the months-of-the-year or, days-of-the-week.  In this example we’ll explain how to create a static data table that contains the months of the year.


Create a Static Data Source


Step 1: Navigate to the Data Tab in your suite

  • First, navigate to the Data tab in Alchemy.  You will need to have a Suite open, so, either click on an existing suite or create a new suite, then go to the data tab inside the suite.
  • Here, I have opened my suite called “WDU” and I have navigated to the data tab:


Step 2: Add Data Source

  • Now, click the ‘+ Add Data Source’ button at the top right.  Give the data source a name like ‘Stan’ or maybe ‘Months’.  Make the type ‘Static’. Just leave the data format field as ‘CSV’, and click on the ‘Create Data Source’ button.

Step 3: Add Table

  • Now you have an empty data source (no tables).  The next step is to click the ‘Add Table’ button in the data source area.  Name the table ‘MonthTable’ and click the ‘Add Table’ button in the Add Table dialog.

Step 4: Add a Field or Colum to the Table

  • Next, we will add a column or a field to our table to hold data.  Click the Add button while the table is selected like so:
  • Just give the new column/field a name like ‘MonthColumn’.  Now you should see a child under the MonthTable indicating that your table now has a single field or column in which you may place data.  

Step 5: Add the Data to the Column(s)

  • Select the table name by clicking once on it.  
  • Now you should see table properties in the right-hand side of the display indicating Name, Description,Table Properties.  Inside the Table Properties section, there is a single section called ‘Data’.  Type in the months of the year into this space, making sure to press ‘enter’ on your keyboard after each entry (even after December if you want, doesn’t matter).

Note:  If you add more than one column to your data table, make sure to type commas to separate the field data for each row.   Here, I have added a weather column to my table to show you how that would look.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

© Orasi Software, Inc. | All Rights Reserved.