Database Load Generation

Overview

This tool can be used to quickly generate multiple rows for each of the application transactional tables to easily support database load testing.

Key Features & Functionality

  • Reads database metadata to automatically pull tables and columns
  • Provides multiple generators for generating data of different types (users, groups, folders, documents, location data, health data, personal data, etc..)
  • Connects to Appian database to generate and populate data in one step
  • Support the addition of new generators

If you have ideas for more generators, please leave a comment!

Anonymous
  • Hi team,

    We are trying Data Generation App and have come across the below error.

    Database - SQL Server 

    Also , Is the tool compatible with SQL Server ?

    There are system Stored procedures used in the tool like (sp_MSforeachtable and dependent SPs) that are not available in SQL Server built-ins. So, we created custom SP. When running the Data Generation smart service got above error . 

    Do you have any advice on how to resolve this error?

    Thanks,

    Ramya

  • v2.1.0 Release Notes
    • Fixed deprecated api with latest sdk

  • v2.0.3 Release Notes
    • Added a license file

  • Hi Michael,
    When running the SQL Script for MariaDB to create the tables/procedures we are seeing the following error message:

    SQL Error [1064] [42000]: (conn=1263934) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET AUTOCOMMIT = 0;
    START TRANSACTION;
    SET time_zone = "+00:00";

     

    DELIMIT...' at line 2

     

    Error position: line: 1

    Any advice or hint how to fix, or with which version of MariaDB the script is compatible with?

    Thanks,

    Juergen

  • Make sure that you unzip the parent zip before dragging it in the file upload field.

  • I'm dealing with an issue regarding the "Install Application" step of the PDF. Presumably, this is supposed to be done via the 'Import' feature within Appian Designer, but when I click into the downloaded zip and try uploading the application>new>Data Generation (zip file), I get the following a!packageTypeFunction error: 

    HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = ER3RS] : [valid:false,syntaxError:false,value:Expression evaluation error: An error occurred while executing a save: Expression evaluation error at function a!packageTypeFunction [line 4]: ]

    Am I missing the mark on how to go about installing the application? 

  • v2.0.2 Release Notes
    • Bug Fixes:
    • Add localization to DG Generate Data model
    • Fix db script to remove DEFINER
    • Fix 1.2.X to 2.0.0 upgrade zip
    • Adding missing datetime2 to sqlserver script

  • If you download the zip from this appmarket entry it contains a pdf with the installation documentation. The documentation for using the app can be found on the Data Generator site once you have installed it.

  • Hi,

    Can you please tell, what will be the next steps to initiated the data generation app after installing the Data Generation as a plugin ?

  • Thanks Michael, that worked a charm!