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

9-1

9. Configuring Global Trade 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 Global Trade Intelligence > Process Management > Run ETL.

3. Schedule/run the Run ETL process.

4. Check the logs for errors.

Note: All of the GTM objects included in GTI are automatically loaded.

Loading an Oracle Global Trade Management Object into Global Trade

Intelligence

By default, the Global Trade Management objects supported by GTI are all loaded into GTI. Please see

the Data Flow to Global Trade Intelligence online help topic for complete details.

Unloading a Global Trade Management Object from Global Trade Intelligence

You can unload (soft delete) data from the Global Trade Intelligence historical database (HD). When

data is deleted from GTM/OTM, you can mark that record as deleted in the Global Trade Intelligence

HD. The record remains in the HD, but is it filtered out using the GTI_DEFAULT VPD profile.

There are several PUBLIC automation agents and agent actions intended for use with Global Trade

Intelligence to enable this functionality. Please see the Data Flow to Global Trade Intelligence online

help topic for complete details.

Mandatory Oracle Transportation Management User Role (VPD Profile)

Configuration

Identify the Oracle Global Trade Intelligence users. Assign the appropriate Business Intelligence Role

to each user.

Oracle Global Trade Intelligence offers additional external predicates. These are available under the

following standard VPD Profile shipped with the Oracle Transportation Management application:

1 2 ... 48 49 50 51 52 53 54 55 56 57 58 ... 105 106

Sin comentarios

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