troubleshooting Question

using toad to automate etl from oracle query to sql server table

Avatar of avoorheis
avoorheis asked on
Oracle Database
6 Comments3 Solutions1830 ViewsLast Modified:
I just transfered to a new group who mostly uses oracle and toad (I have little oracle experince; use Access and sql server often). No one seems to use any automation and I want to find out if it's possible to schedule a query to run, from oracle tables, and save the results to a sql server table.

If that can't be done, can I just save to a test file (I can then use ssis to load that data into sql server).

It looks like Toad has a scheduler (we're using Toad for Oracle v. 9.5.0.31, no add-ons), so, can I schedule with that, or, should I use the command line interface and schedule with windows task scheduler (it's on a win 2003 server box)?

thanks
alan
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros