Managing ODI Settings

Administrator users can choose the ODI Settings option from the Tools menu to stop, start, and reset ETL ODI session data and to edit the default settings in individual load plans. When you click the ODI Settings menu option, the current state of the ODI service (running or not running) is loaded into the application. The available load plans are listed in the ODI Mappings section.

Important: Changes are not allowed to any of the Core ODI framework objects. If a change is needed, the object in question must be used as a template, that is, the original object can be downloaded, changed and before being uploaded, both the name and Global ID must be changed as well. For detailed information, see the ODI Framework Rules Guide on MOS.

The following options and actions are available:

Service

Stop - Click Stop to stop the ODI agent. The ODI agent is responsible for scheduling and executing load plans. If the agent is stopped, no load plans will be executed. The status below changes to: Service isn't currently running.

Start - Click Start to start the ODI Service. The status below changes to: Service is currently running. This option is used to reset the service once issues that caused it to fail have been corrected.

Reset/Clean ODI Session Data

Start - This option is used to reset ODI session data (such as clearing error logs) if a load plan failed before it finished. You use this command after you have corrected the issues with a failed load plan. See instruction for how to Download and Replace load plan files, below. You can use the Log Viewer to look up ODI logs, and troubleshoot problems. Once the problem is resolved, click Start to reset ODI process.

ODI Mappings

This grid lists the available load plans by Name, along with their Description and Status (see list below), Last Changed date, and Actions available. You use the Download option on the Action menu to download a load plan file that needs to be modified, or use the Replace option to upload a modified load plan file. Use the Start and Stop options to start and stop individual load plans.

Status

Load plans can have one of the following statuses, which are displayed in the Status column:

Active - active schedules exist for this load plan.

Active for Period – schedules are active for this load plan but only during a specific period of time.

Inactive – schedules are currently inactive, the load plan will never run.

Unknown – the application has not found a schedule for the load plan.

To Download a load plan file:

Click the Actionicon in the row of the load plan that you want to download, and click Stop, if it is enabled, to stop the load plan.
Click Download. This displays a password prompt.
In the Create Password for Upload field, enter a password that meets the following criteria:

Contains 8-30 characters
Contains at least one alpha character of upper or lower case
Contains at least one numeric character or at least one of the following special characters: @ # % + / =

Click Accept. This downloads the file to your computer.
Make any needed modifications to the file.

To Replace a load plan file:

Click the Actionicon in the row of the load plan that you want to replace, and click Stop, if it is enabled, to stop the load plan.
Click Replace. This displays a File Uploader dialog.
Drag the file that you previously downloaded and edited into the File Uploader, or click to locate the file and move it to the File Uploader.
In the Password field, enter the same password that you used to download the file.
Click Accept. This replaces the file.
Click the Start button on the Actions menu to restart the load plan.

About Last Changed status

The time displayed in the Last Changed column is updated based on the following actions:

When the Status is Unknown, the Last Changed time is not updated when the user performs the Stop, Start, Replace, or Download actions.
When the Status is Active or Inactive, the Last Changed time is updated when the user executes the Stop, Start, or Replace commands from the Action menu.
When a load plan is uploaded through the application.
When any configuration changes to the load plan are performed in the ODI Studio:

If the scheduler for a load plan in Active or Inactive status is deleted in the ODI studio, the Status changes to Unknown, and the Last Changed time is updated to the time of deletion.
Active for Period status can only be assigned in ODI Studio. The Last changed time is updated and the status changes to Active when the user executes the Start command in the application.

_____________________________