Axis RightFax 8.5 Guía de instalación descargar pdf (Pagina 47)

8-1

8. Configuring Fusion Transportation Intelligence

Configuring Oracle Transportation Management

Scheduling ETL through Oracle Transportation Management Process

Management

You can schedule the ETL to run using the Run ETL process in Oracle Transportation Management

process manager. Run ETL run the ETL from the replicated online database (ROD) or the online

transaction processing (OLTP) database to the historic database (HD).

Since OTM now supports several business intelligence applications, there are properties that must be

set to specify which business intelligence application the ETL loads. Depending on the following

properties, the run ETL will either load either the GTI or FTI tables or both:

 allow_advanced_analytics is the property that controls if FTI is running. If this is set to

TRUE, ETL loads FTI tables only.

 isAllowedGTIAnalytics is the property that control if GTI is running. If this is set to TRUE,

ETL loads GTI tables only.

 if both properties are set to TRUE, then ETL loads both FTI and GTI tables.

Running the ETL

1. Log into Oracle Transportation Management as DBA.ADMIN.

2. Go to Transportation Intelligence > Process Management > Run ETL.

3. Schedule/run the Run ETL process.

4. Check the logs for errors.

Note: Before running the ETL, you must complete the steps mentioned in the following

section “Enabling Oracle Fusion Transportation Intelligence Agents in Oracle Transportation

Management” to enable loading objects into Fusion Transportation Intelligence.

Loading an Oracle Transportation Management Object into Fusion Transportation

Intelligence

For Oracle Transportation Management business objects to be loaded into Fusion Transportation

Intelligence, they must have a status type similar to ##_HD_LOAD_STATUS with a status value of

##_READY_TO_LOAD. For example, order base with a statue type of OB_HD_LOAD_STATUS and a

status value of OB_READY_TO_LOAD. By default, this status type is set to a value of

##_NOT_READY_TO_LOAD.

Note: ## is object code, Shipment code is SH, Order Base code is OB and Order Release

code is OR.

Setting the Status for Existing Objects:

The Oracle Transportation Management installation provides a sample script to set the status on

existing objects. This script is located at:

<otm_install_path>/glog/oracle/script8/advanced_analytics/load_hd_status.sql.

You can customize this script based on your business process and run it in OLTP database by logging

in with glogowner credentials.

1 2 ... 42 43 44 45 46 47 48 49 50 51 52 ... 105 106

Sin comentarios

Axis RightFax 8.5 Guía de instalación Pagina 47