PiLog iTransform - Extract Transform Load (ETL)

ETL is the process of extracting the data from various sources, transforming this data to meet your requirement and then loading into a target data warehouse.

PiLog iTransform - ETL Capabilities

Migration projects are relevant for all types companies, including those with generic applications, upgrading, any company who needs to migrate data from one application to another.

PiLog iTransform - ETL Capabilities

Sucessful ETL Implementation

Connect

Extract

Assess

Transform

Validate

Load

Reconcile

Consume

Automate


Benefits

PiLog - iTransform ETL Features

Upload able File Format

  • CSV, XLS. XLSX, XML, TEXT

Database Connections

  • Oracle, MYSQL, MSSQL, MS Access, SQLite, PostgreSQL

ERP Connectivity

  • SAP, Oracle

Design View

  • Refresh, Save, Delete, Execute, View Last Job log

Execution

Scheduled Jobs
Running Jobs
Stoped Jobs

SQL Editor

  • SQL statement and script execution

Content View

  • Views
  • Synonyms
  • Tables
  • Export to popular formats including: XLSX,CSV,XML

Tasks or Jobs

  • Column Mappings
  • Joins
  • Where Clause
  • Order By
  • Group by
  • View Query
  • Advance Settings
  • • Unique Rows
    • Fetch Rows Range
    • Action on Table

Performance

  • Load Data Incrementally
  • Partition Large Tables
  • Process in Parallel

Management

  • Configuring the packages to run at certain times
  • Creating users and giving them the right permissions to run jobs
  • setting alerts of the job fails and email addresses for notifications

PiLog – iTransform Planned Features

Advance data Filtering

  • Denoise
  • Cleansing
  • Summarization

Trigger connection

  • On subjob ok
  • On Subjob Error

Advanced log Events

  • Data Reconciliation
  • Timeline
  • Log History
  • Log Analysis
  • Warning

Work Bench process

  • Assess
  • Validate
  • Consume
  • Automate