RE: data exchange between oracle and sqlserver
Date: Wed, 1 Feb 2012 17:02:16 -0330
We've come across with these type of sensitive information projects and have helped many clients through our data masking technologies.
The way it works is that, the data is scanned to automatically discover and categorize as sensitive (as per PCI, HIPAA, etc.) and mask (aka anonymize, de-identify, etc.) so it's no longer sensitive, but realistic enough to run accurate testing and QA.
Referential integrity is preserved throughout this process and it can be configured so that each individual data is always masked to the same masked data, over time and across multiple data bases, including Oracle and SQL.
Please feel free to download the Best Practices White Paper on http://www.datamasking.com/resource-library/white-papers or let me know if you have any questions.
Data Security Consultant
Camouflage Software Inc.
T: 709.722.1200 x214 F: 709.576.6775
Toll Free: 1.866.345.8888
66 Kenmount Road . St. John's . NL . Canada . A1B 3V7
Notice - This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this communication in error, please notify the sender immediately and delete this communication from your mail box.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hsieh, Joan Sent: Wednesday, February 01, 2012 3:05 PM To: oracle_l
Subject: data exchange between oracle and sqlserver
The following is the question from our developer who is looking for a solution for the new system and business requirement. He proposed ODBC gateway, ETL tools. I would greatly appreciated if you can provide any other ideas.
We are looking into integrating PeopleSoft Campus Solutions (aka PSCS and new SIS) with various third parties. Some of these will be done using XML messages over HTTP. Unfortunately we still have vendors who rely on files or table load mechanisms only.
One of the critical integrations is between Financial Aid's PowerFAIDS (SQL Server db) and PSCS. This software works only through inserting data into an interface table or through file loads (which then load the same interface table). All outbound interfaces are through queries which generate file exports. We are trying to avoid the file exports.
We are trying to eliminate file base integration as it is insecure and requires the use of shared drives. These files will contain legally protected Personal Identifiable Information which should not be lying around on servers or people's computers.
Business requirements require the exchange of information twice per business day for some interfaces, or once per day for others (which is why I think the ETL method would work adequately).
http://www.freelists.org/webpage/oracle-l Received on Wed Feb 01 2012 - 14:32:16 CST