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.

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.

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

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