PiLog iTransform - Extract Transform Load (ETL)
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.
.png)
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
Successful ETL Implementation
Connect
Extract
Assess
Transform
Validate
Load
Reconcile
Consume
Automate
Benefits
-
Cloud Based Platform
-
Easily Accessible for Business Users
-
Configure Once, Re-Use Several Times
-
Term & Users Based Licensing
-
Best for Setting up CXO Dashboards
-
Pre-built Connectors, Transformations
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