RE: data exchange between oracle and sqlserver

  • From: Eren Bayazitoglu <erenb@xxxxxxxxxxxxxxx>
  • To: "Joan.Hsieh@xxxxxxxxx" <Joan.Hsieh@xxxxxxxxx>, oracle_l <ORACLE-L@xxxxxxxxxxxxx>
  • Date: Wed, 1 Feb 2012 17:02:16 -0330

Hello Joan, 

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 or let me know if you 
have any questions.

Eren Bayaz
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.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Hsieh, Joan
Sent: Wednesday, February 01, 2012 3:05 PM
To: oracle_l
Subject: data exchange between oracle and sqlserver

Hi list,

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).



Other related posts: