Re: Data Masking

From: Jeremiah Ocasio <jocasio(at)kaleidoscopemediasystems(dot)com>
To: Iñigo Salvat <inigo(at)isalvat(dot)es>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Data Masking
Date: 2014-12-15 22:30:25
Message-ID: CAKqpGf5WUAaUoo8XiTDed9g-vxRKw0OK7qGxPNEbpBP5tmNgJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,

For your masking action are you looking to de-identify user specific data
for testing purposes? if that is the case I found this article helpful when
setting up my test environment.

http://www.mssqltips.com/sqlservertip/3091/masking-personal-identifiable-sql-server-data/

Thanks,
Jeremiah

On Sun, Dec 14, 2014 at 3:52 AM, Iñigo Salvat <inigo(at)isalvat(dot)es> wrote:
>
> Hi all,
>
> The goal is to recover production data and mask it in a second server for
> testing purposes.
>
> Thanks for your help,
>
> Iñigo
>
>
> El 12/12/14 21:58, Jeremiah Ocasio escribió:
>
> Hello,
>
> What is your goal for the Masking? There are lots of options out there
> but letting us know the environment you wish to work within and the end
> goal of the masking will help get you the best answers.
>
> Thanks,
> Jeremiah
>
> 2014-12-10 13:56 GMT-08:00 Iñigo Salvat <inigo(at)isalvat(dot)es>:
>>
>> Hi all,
>>
>> Does any of you know about a good data masking tool for databases that
>> include support for Postgresql, of course, and any other odbc/jdbc database.
>>
>> Thanks,
>>
>> --
>> Iñigo Salvat
>>
>> __________________
>> La presente información se envía únicamente para la persona a la que va
>> dirigida y puede contener información de carácter confidencial o
>> privilegiada. Cualquier modificación, retransmisión, difusión u otro uso de
>> esta información por personas o entidades distintas a la persona a la que
>> va dirigida está prohibida. Si usted lo ha recibido por error por favor
>> contacte con el remitente y borre el mensaje de cualquier ordenador. Para
>> el caso de que este mensaje vaya a ser contestado por la misma vía, ha de
>> saberse que su respuesta podría ser conocida por terceros al entrar en la
>> red. Por ello, si el mensaje incluye contraseñas, números de tarjetas de
>> crédito o cualquier otra información que usted considere confidencial,
>> sería más seguro contestar por otra vía y cancelar su transmisión. El autor
>> no puede asumir la responsabilidad derivada del hecho de que terceras
>> personas puedan llegar a conocer el contenido de este mensaje durante su
>> transmisión.
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>
>
> --
> Jeremiah Ocasio
> jocasio(at)kaleidoscopemediasystems(dot)com
>
>
>
> 1200 Westlake Ave N, Suite 604
> Seattle, WA 98109
> Tel: 855-247-5231
> Fax: 206-400-2712
>
> This electronic mail communication is intended only for the individual or
> entity to which it is addressed and contains privileged and confidential
> information. If you receive this communication in error, please advise us
> by return e-mail or call us immediately at 855-247-5231 and delete this
> communication and all copies and attachments. Any dissemination,
> distribution or copying of this communication is strictly prohibited.
>
> IRS Circular 230 disclosure: To ensure compliance with requirements
> imposed by the IRS and other taxing authorities, we inform you that any tax
> advice contained in this communication (including any attachments) is not
> intended or written to be used, and cannot be used, for the purpose of (i)
> avoiding penalties that may be imposed on any taxpayer or (ii) promoting,
> marketing or recommending to another party any transaction or matter
> addressed herein.
>
>
>

--
Jeremiah Ocasio
jocasio(at)kaleidoscopemediasystems(dot)com

1200 Westlake Ave N, Suite 604
Seattle, WA 98109
Tel: 855-247-5231
Fax: 206-400-2712

This electronic mail communication is intended only for the individual or
entity to which it is addressed and contains privileged and confidential
information. If you receive this communication in error, please advise us
by return e-mail or call us immediately at 855-247-5231 and delete this
communication and all copies and attachments. Any dissemination,
distribution or copying of this communication is strictly prohibited.

IRS Circular 230 disclosure: To ensure compliance with requirements imposed
by the IRS and other taxing authorities, we inform you that any tax advice
contained in this communication (including any attachments) is not intended
or written to be used, and cannot be used, for the purpose of (i) avoiding
penalties that may be imposed on any taxpayer or (ii) promoting, marketing
or recommending to another party any transaction or matter addressed herein.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Iñigo Salvat 2014-12-16 07:44:36 Re: Data Masking
Previous Message Kido Kouassi 2014-12-15 18:30:10 Re: Yum Install postgresql93 with SSL