[teiid-issues] [JBoss JIRA] (TEIID-4658) Data scramble feature

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins reassigned TEIID-4658:
-------------------------------------

      Component/s: Query Engine
    Fix Version/s: Open To Community
         Assignee:     (was: Steven Hawkins)


I'm not sure we have quite enough here to make a good proposal of what built-in support Teiid or tooling should provide.  It could be that the process of anonymozing is something that is more of an implementation pattern, rather than a set piece of server functionality.  Let's continue the discussion on this issue.

> Data scramble feature
> ---------------------
>
>                 Key: TEIID-4658
>                 URL: https://issues.jboss.org/browse/TEIID-4658
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Rodrigo Silva
>             Fix For: Open To Community
>
>
> 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:
> {code:java}
> CREATE TABLE person (
>   id INT PRIMARY KEY,
>   name VARCHAR(256) NOT NULL,
>   age INT,
>   height INT,
>   weight DOUBLE
> );
> {code}
> {code:java}
> SELECT * FROM TABLE PERSON WHERE ID=1;
> {code}
> 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.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)