BCP IN Oracle - Repost
-
Hello Folks, This is a repost. I would like to know whether there exist any products for performing workflow kind of data transformation and bulk insert, similar to Microsoft DTS for Oracle. My requirement is i need to execute tasks sequentially based on success or failure. Give me a pointer. thanks Venkat Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
-
Hello Folks, This is a repost. I would like to know whether there exist any products for performing workflow kind of data transformation and bulk insert, similar to Microsoft DTS for Oracle. My requirement is i need to execute tasks sequentially based on success or failure. Give me a pointer. thanks Venkat Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
http://www.experts-exchange.com[^]
"Der Geist des Kriegers ist erwacht / Ich hab die Macht" StS
sighist | Agile Programming | doxygen -
Hello Folks, This is a repost. I would like to know whether there exist any products for performing workflow kind of data transformation and bulk insert, similar to Microsoft DTS for Oracle. My requirement is i need to execute tasks sequentially based on success or failure. Give me a pointer. thanks Venkat Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
Hmmm... I'm curious. Why not using DTS? It seems you already have it. Kant wrote: Actually she replied back to me "You shouldn't fix the bug. You should kill it"
-
Hello Folks, This is a repost. I would like to know whether there exist any products for performing workflow kind of data transformation and bulk insert, similar to Microsoft DTS for Oracle. My requirement is i need to execute tasks sequentially based on success or failure. Give me a pointer. thanks Venkat Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
Oracle doesn't have a built in workflow system like SQL server. It does have most of the services that are found in that system but no one that I know of, including Oracle, has written then infrastrutre arround them to provide that kind of facility. The closest thing that comes to it is what Oracle does call a workflow system, which is more targeted at database- trigered internallized business cases. Typically the type of tasks are accomplished using DTS are done in Oracle using shell/batch scripts, PL/SQL, or Pro* languages. Mark Mark Conger Sonork:100.28396
-
http://www.experts-exchange.com[^]
"Der Geist des Kriegers ist erwacht / Ich hab die Macht" StS
sighist | Agile Programming | doxygenthanks Cheers, Venkatraman Kalyanam Chennai - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
-
Hmmm... I'm curious. Why not using DTS? It seems you already have it. Kant wrote: Actually she replied back to me "You shouldn't fix the bug. You should kill it"
Daniel Turini wrote: Why not using DTS? It seems you already have it. I can not have DTS library without having SQL Server. (its my assumption) Cheers, Venkatraman Kalyanam Chennai - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
-
Daniel Turini wrote: Why not using DTS? It seems you already have it. I can not have DTS library without having SQL Server. (its my assumption) Cheers, Venkatraman Kalyanam Chennai - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
Venkatraman wrote: I can not have DTS library without having SQL Server. (its my assumption) AFAIK, the cheapest SQL Server license already includes DTS, and it's much more cheap than anything you can buy for Oracle. I agree that deploying a SQL Server only for this is overkill, but I've seen it being done before. Kant wrote: Actually she replied back to me "You shouldn't fix the bug. You should kill it"
-
Venkatraman wrote: I can not have DTS library without having SQL Server. (its my assumption) AFAIK, the cheapest SQL Server license already includes DTS, and it's much more cheap than anything you can buy for Oracle. I agree that deploying a SQL Server only for this is overkill, but I've seen it being done before. Kant wrote: Actually she replied back to me "You shouldn't fix the bug. You should kill it"
Daniel's right. In shops that have a SQL server already running alot of times they will use it as a middleman to provide this kind of functionality. There are other packages out there that do this but none I've seen integrate with Oracle real well. They are more like universal data transformation packages, struggling to stay platform independent. Mark Conger Sonork:100.28396