Plug-in (Function & Smart Service)Free

Data Generation

by Appian Corporation

Description

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

Features

  • 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 - MariaDB, PostreSQL, SqlServer, and Oracle sql setup scripts included
  • Supports the addition of new generators

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

Release notes

Added more error logging.

Version history (22)

2.2.1

Bug fixes

2.2.0

Added check for identity columns in SQL Server, updates to base application

2.1.0

Fixed deprecated api with latest sdk

2.0.3

Added a license file

2.0.2

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

2.0.1

Release 2.0.1 Bug Fixes:

  • Added en_GB locale to process models missing localization

2.0.0

Release 2.0.0 New Features:

  • App updated to 22.3
  • Now uses OOTB execute stored procedure
  • UX enhancements
  • New Generators
  • Next available primary key
  • UUID
  • Postgres Support
  • Support generating to multiple data sources
  • Updated documentation
  • Added process to resync records after data generation

Bug Fixes:

  • Added more comprehensive generator errors
  • Run a delete on a table without inserting data
  • Fixed mariadb issue with too a table with too many columns
  • Fixed re-enabling of constraints after data generation
  • Issue with preview not updating

1.2.3

Security Updates

1.2.2

Security Updates

1.2.1

1.2.1 - Updating generator types for MsSQL

1.2.0 - Adding support for Microsoft SQL

1.0.9 - Fixing bug with missing delete settings

1.0.8 - Added configurable number of values in each database insert statement using DG_NUMBER_VALUES - reduces size of DB audit log when inserting high volumes of records

1.0.7 - Adding ability to delete data from tables on a conditional basis before data generation

1.0.6 - Including sql setup scripts for Oracle, adding error handling for empty groups and folders

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.2.0

1.2.0 - Adding support for Microsoft SQL

1.0.9 - Fixing bug with missing delete settings

1.0.8 - Added configurable number of values in each database insert statement using DG_NUMBER_VALUES - reduces size of DB audit log when inserting high volumes of records

1.0.7 - Adding ability to delete data from tables on a conditional basis before data generation

1.0.6 - Including sql setup scripts for Oracle, adding error handling for empty groups and folders

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.9

1.0.9 - Fixing bug with missing delete settings

1.0.8 - Added configurable number of values in each database insert statement using DG_NUMBER_VALUES - reduces size of DB audit log when inserting high volumes of records

1.0.7 - Adding ability to delete data from tables on a conditional basis before data generation

1.0.6 - Including sql setup scripts for Oracle, adding error handling for empty groups and folders

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.8

1.0.8 - Added configurable number of values in each database insert statement using DG_NUMBER_VALUES - reduces size of DB audit log when inserting high volumes of records

1.0.7 - Adding ability to delete data from tables on a conditional basis before data generation

1.0.6 - Including sql setup scripts for Oracle, adding error handling for empty groups and folders

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.7

1.0.7 - Adding ability to delete data from tables on a conditional basis before data generation

1.0.6 - Including sql setup scripts for Oracle, adding error handling for empty groups and folders

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.7

1.0.7 - Adding ability to delete data from tables on a conditional basis before data generation

1.0.6 - Including sql setup scripts for Oracle, adding error handling for empty groups and folders

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.6

1.0.6 - Including sql setup scripts for Oracle, adding error handling for empty groups and folders

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.5

1.0.5 - Adding generators for Appian Constants, minor UI updates

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.4

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.4

1.0.4 - Fixing bug introduced with IX in 1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.3

1.0.3 - Adding import/export functionality

1.0.2 - Adding the following generators weighted list for (string, int, double, date, and datetime), relative date and datetime, regex replacement, foreign key dropdowns for tables and columns

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import

1.0.1

1.0.1 - Storing whether columns are nullable and defaulting column export settings to false if nullable and speeding up import