DataFakery Studio
๐Ÿ  Home๐Ÿ’ฌSupport
  • What is DataFakery Studio?
    • ๐Ÿš€What's new in 2025.1
      • Changelog Archive
    • Editions / Licenses
    • Installation requirements
    • Setup guide
    • ๐Ÿ‘ฉโ€๐Ÿ’ปRoadmap
  • Guides
    • Creating a DataFakery Project
    • Anonymize Microsoft SQL Server Data Source
    • Anonymize PostgreSQL Database
    • Anonymize MySQL Database
    • Docker Integration
    • Export to CSV File
  • Fundamentals
    • Project
    • Data Sources
    • Data Models
      • Virtual Tables
    • Generators / Fakers
      • Strings
      • Numbers
      • Date & Time
      • Custom Expression
      • Text Pattern
      • Regular expressions
      • Foreign Keys Generator
      • Table Lookups
      • Default Values
      • Sequence Generator
      • Constant Value
      • List Values
    • Randomizer Options
    • Optimizations
    • Data Exploration
  • Extras
    • Data Storage
    • Keyboard Shortcuts
    • Appearance / Theme
  • Support
    • Contact Support
    • Troubleshooting
Powered by GitBook
On this page
  • Usage
  • Active / Inactive Fakers
  • Faker Suggestions
  • Faker Definition
  • Available Fakers
  • String Values (char / string)
  • Numeric Values (integer / float / decimal)
  • Date and Time
  • Database Identities
  • Misc Values

Was this helpful?

  1. Fundamentals

Generators / Fakers

Each generator or faker in our tool contains a unique configuration that determines how data is created or modified for each column. These configurations can be customized to suit your specific needs.

PreviousVirtual TablesNextStrings

Last updated 11 months ago

Was this helpful?

What is the difference between Faker and Generator?

Many people use the terms 'Faker' and 'Generator' interchangeably, and for our purposes, they mean essentially the same thing. While some may argue that a Faker modifies existing data, and a Generator creates new data, we do not differentiate between the two for our use case.

In our tool, both options are used to create realistic, customizable data that can be used for a variety of purposes. Whether you need to generate fake names, addresses, or other data, our tool provides a simple and efficient way to create the information you need.

Usage

In the Fakers Menu, you can define the desired fakers for each column. The selection is context-sensitive: if you select a column with an existing faker configuration, it will load automatically. If no configuration exists, you can set a new faker.

Active / Inactive Fakers

You can activate or deactivate each faker for individual columns. Simply click on the green arrow to activate or the grayed-out 'X' icon to deactivate. Columns marked as inactive will be ignored during further processing, including file export, database export, and other operations.

Faker Suggestions

When working with your data models, you can easily suggest and apply fakers to your data fields/columns.

How to Use

  1. Select a Data Field: Click on any data field within your model to open the Faker Suggestions window.

  2. Choose Fakers: In the Faker Suggestions window, you will see a list of available fakers. Each faker corresponds to a different type of data (e.g., Job Title, First Name, Last Name).

  3. Apply Fakers:

    • Select All: Click on All to select all suggested fakers.

    • Deselect All: Click on None to deselect all fakers.

    • Individual Selection: Check or uncheck individual fakers as needed.

  4. Confirm: Click OK to apply the selected fakers to the data field, or Cancel to discard changes.

Faker Definition

The Faker Configuration panel allows you to configure and manage fakers for your columns. Here is a description of the key options and functionalities available in this panel:

Main Features

  1. Suggest Faker

    • Icon: โšก (Lightning bolt)

    • Description: Click this button to suggest a faker based on the data field type. The system will automatically provide a suitable faker for the selected data field.

  2. Delete Faker

    • Icon: ๐Ÿ—‘๏ธ (Trash can)

    • Description: Click this button to remove the currently active faker from the data field. This action will reset the faker settings for the selected field.

  3. Open Documentation

    • Icon: โ“ (Question mark)

    • Description: Click this button to open the documentation for fakers. This will provide detailed information on how to configure and use fakers effectively.

Configuration Options

  • Column Name (e.g. FirstName)

    • Field: Name of the data field currently being configured.

    • Type: Specifies the type of data (e.g., Name).

    • Faker: Displays the currently active faker. If no faker is active, it will show "[No Faker active]".

  • Randomizer Options

    • Table-wide seed in use: Option to use a table-wide seed for randomization.

      • Use Column Seed: Check this box to use a column-specific seed.

    • Fill Factor: Adjust the fill factor for the faker. This determines the percentage of the column to be filled with fake data.

By utilizing these features, you can easily configure and manage fakers for your data fields, ensuring that your data generation process is both efficient and tailored to your specific needs.

Available Fakers

You can use multiple different Fakers based on your use case. See the list below for all available options.

String Values (char / string)

Numeric Values (integer / float / decimal)

Date and Time

Database Identities

Misc Values

(Names, Titles, Addresses and many more)

Missing something? A data type? A data source? Anything else?

String Generator
List Value Generator
Regular Expressions
Custom Expressions Generator
Text Pattern Generator
Number Generator
Date Time Generator
Foreign Key Generator
Table Lookup Generator
Sequence Generator
Default Value Generator
Constant Values Generator
List Value Generator
Let us know about your specific needs.
Active / Inactive Fakers
Auto Suggest Generators/Fakers