Re: data move concept
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: ebuddelm@xxxxxxxxx
- 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxx>
>
>> 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
Other related posts:
