The connection failed correct the database connection information and test the connection againNovember 29, 2017
DAC – Data warehouse Administration Console
DAC is Data warehouse Administration Console. This is part of the package which Oracle Corp provides with OBIA (Oracle Business Intelligence (BI) Applications). Oracle Corp has the pre-built solutions for the popular domains (like Order Management, Sales, and Supply Chain Management etc) in the market.
Pre-built means that the Informatica Code (ODI code in the latest versions of OBIA) is ready and can be set up in less time than setting up the Data Warehouse from group up.
Of course, there will be customization based on the need of the organization that’s here custom code is created.
DAC has the workflows (SIL and SDE specific) scheduled based on the base data model provided by Oracle. If there are any shell or PL/SQL scripts which should be part of the schedule these should be part of the Informatica workflows.
An automated job control system for scheduling, monitoring and reporting jobs. The jobs can reside on an Autosys configured machine attached to a network and when it comes to the Data Warehouse environments it can be used to schedule Shell Scripts, bat scripts, relational procedures (wrapped), any ETL tool’s jobs. Basically any jobs which can be triggered can be set up using Autosys, including JAVA, .NET etc.
Autosys is more robust as it is command line and not heavy java based application consuming system resources” Autosys offers more flexibility and varied job types and conditions as well as the application interfaces for SAP, PeopleSoft etc.
There are two ways to setup and use Autosys
1. Using Autosys GUI
• Autosys GUI allows to set the attributes that describe when, where and how a Autosys-job should be run.
• GUI Control Panel is used to define Autosys-jobs Contain fields that correspond to Autosys JIL sub-commands and attributes.
2. Using job Information Language (JIL)
• A specification language that has its own commands to describe when, where and how a Autosys-job should be run.
• The attributes are set b JIL sub-commands
Control-M has better because Autosys’s user interface, functionality and architecture seems a bit old. This is an enterprise level scheduling tool from BMC Software.