Re: data move concept

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 24 Aug 2009 12:12:25 +0100
Message-ID: <7765c8970908240412g3d7c30ffq4f16b86f1ec99b05_at_mail.gmail.com>

more generally the first 3 considerations at http://www.intelligententerprise.com/channels/information_management/showArticle.jhtml;jsessionid=BHE2JTPS1VAILQE1GHRSKH4ATMY32JVN?articleID=207002081&pgno=1 probably
apply here. I'd generally say, at least start with an automated tool - complete with error trapping, logging, auditing etc etc (all the instrumentation people don't normally put into hand-crafted things) - and then deal with performance as a performance tuning exercise afterwards. There can of course be rather a large dollar cost to this recommendation.

On 8/24/09, Eric Buddelmeijer <ebuddelm_at_gmail.com> wrote:
>
> Brian,
>
> If you are really talking about concepts, you could also look into Oracle
> Warehouse Builder (OWB) and/or Oracle Data Integrator (ODI). Underneath both
> will use the techniques described in the other reactions, of course. But if
> you are talking about error trapping and re-runable and not too much coding
> yourself, you could look into one or both of these options.
>
> regards,
> Eric.
>
>
> 2009/8/18 Zelli, Brian <Brian.Zelli_at_roswellpark.org>
>
>> Hello all,
>> I have systems that need to take data from other systems like most of
>> you probably have to do. I need to take from sql server and other oracle
>> systems. I can do it the old fashion way of creating flat files, ftp and
>> sqlload. But with the tools of 10g is there a better way? Something that
>> is reliable, re-runnable, error trapping, etc.....
>>
>> I tested some things like:
>>
>> - DTS from sql server 2000 into a temp table and then ran scripts against
>> the temp table
>> - Created a link to oracle and did a select into
>> - flat file and sqlload
>>
>> Anything else? I just want to try and use something current and reliable
>> for moving and loading data. I am open to all kinds of ideas.
>>
>>
>> ciao,
>>
>> Brian
>>
>>
>>
>>
>> This email message may contain legally privileged and/or confidential
>> information. If you are not the intended recipient(s), or the employee or
>> agent responsible for the delivery of this message to the intended
>> recipient(s), you are hereby notified that any disclosure, copying,
>> distribution, or use of this email message is prohibited. If you have
>> received this message in error, please notify the sender immediately by
>> e-mail and delete this email message from your computer. Thank you.
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 24 2009 - 06:12:25 CDT