trinity, Trinity, etl, ETL, sap, SAP, jcs, job control

Powerful new function! Trinity now offers you "run time review and forecast" and "SAP components".

Based on customers' responses and market situation Trinity Data adds new functions in Edition v3.1 as outlined below

A big enhancement in data processing sources: the newly added SAP component!

The SAP component is a new member of the Trinity's data processing family. A SAP user now can interchange data in SAP ERP and open database with this new module! This gives SAP ERP clients one more affordable option in data warehousing implementation and system reporting planning!

Trinity can now get metadata of both table and function of SAP with the SAP Adaptor.

·Table: Metadata that can be acquired are:

# Column Name

# Layout Type

# Data Type

# Data Length

# Description

·Function: Can be genuine SAP RFC or user developed functions:

# Import Parameter

# Export Parameter

# Function Table           

·SAP Reader: Calls SAP RFC functions to read data in a given table or capture feedback data.

·SAP Writer: Calls SAP internal or custom functions to write given data to a specific table. You may write data to one or more target tables (varies with processing logic of individual functions) according to features of the function being called. The SAP Writer may relay data returned by a function to another Plug-in for processing. It features both input and output functions and may deal with multiple input or output nodes at the same time.

A big enhancement in JCS function: Review and forecast for execution schedule!

On top of Trinity's existing comprehensive execution logging, the newly added review (of past execution log) and forecast of (execution status for specific future date) enhances JCS management capacity to a level similar to dedicated operation control software!

·User configurable query conditions: You may set a specific date and number of days (e.g. Range, 1 / 7 / 30 / 90 days) along with the display interval for query outcome (No / Daily / Weekly / Monthly) before running a review or forecast operation.

·Execution status review: Review past execution status according to query conditions to grasp changes in execution performance.

·Execution status forecast: Forecast future execution status for a given interval (e.g. one month) using query conditions and performance history as the basis for scheduling new jobs or adjusting job schedules.