Equivalent to SQL Server Integration Services

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ashwah
    New Member
    • Aug 2007
    • 15

    Equivalent to SQL Server Integration Services

    Hi,

    I have recently been on a site visit to see a my conterpart department in another company and the demostrated the they used SQL Server Intergration Services to process data from a number of sources.

    Is there an equivalent to SSID on Oracle? What options are there for scheduling jobs in general?

    I am pretty new to Oracle so even the basic suggestions would be welcome!

    Ash
  • Dave44
    New Member
    • Feb 2007
    • 153

    #2
    well for scheduling jobs oracle 10G and higher has dbms_scheduler, it has a lot of options for run times and resource usage management.

    Im not sure what SSID is in sqlserver and so cant speak to the that.

    Comment

    • ashwah
      New Member
      • Aug 2007
      • 15

      #3
      Thanks for your suggestion. I will look into it.

      Comment

      • ashwah
        New Member
        • Aug 2007
        • 15

        #4
        Sorry, it's not SSID, it's SSIS. I just wondered if there an equivalent in Oracle. In fact I've heard there is but I don't know anything about it.

        The situation is that we have commited to using an Oracle system. But we have a lot of jobs that could benefit from being scheduled in an intellegent way as in SSIS.

        Any pointers would be apreciated,
        Ash

        Comment

        Working...