Re: data move concept
Date: Mon, 24 Aug 2009 12:12:25 +0100
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:
> 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.
> 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.
>> 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-lReceived on Mon Aug 24 2009 - 06:12:25 CDT