Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4658

Data scramble feature

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Unresolved
    • Icon: Major Major
    • Open To Community
    • None
    • Query Engine
    • None

      I have a customer asking for a feature to do data scramble.

      The need is change the production data to be used in another environments without the user know the original data.

      e.g:
      Give the person table:

      CREATE TABLE person (
        id INT PRIMARY KEY,
        name VARCHAR(256) NOT NULL,
        age INT,
        height INT,
        weight DOUBLE
      );
      
      SELECT * FROM TABLE PERSON WHERE ID=1;
      

      Result:
      The name is from row with ID#15, the age is from row with ID#3, the height is from row with ID#5.

      On this way the customer can work with consistent and natural data, but unreal.

              Unassigned Unassigned
              hodrigohamalho Rodrigo Ramalho (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: