The Informatica Insights Portal is a lightweight web dashboard that provides a clear view of Informatica metadata and performance statistics.
- Browse folders, workflows, sessions, and DB connections
- Visualize dependencies between Informatica components
- Analyze performance of workflows and sessions (with ML-based insights)
- Identify bottlenecks and anomalies in execution
- Fast, low-impact access
The portal pulls metadata and execution stats once from the production database and caches them locally, minimizing impact on the production Informatica environment.
Built for developers, analysts, and admins who need visibility into Informatica processes and performance.
Full documentation available at:
👉 https://aviciot.github.io/informatica_insight_portal/
- Admin and user roles with permission control - allowing fine-grained restrictions to sections or operations based on user roles.
- Centralized settings via
config.yaml - Environment and database configuration management
- View folders, workflows, sessions, command tasks, and connections
- Search and filter processes by keyword or metadata
- Interactive tree view of:
- Folders → Workflows → Sessions → Scripts
- Command Tasks
- Connections
- Table Dependencies
- Trace all processes related to a specific database or connection
- Display of session execution data
- Insight into command task usage and linkages
- Identify broken or missing connections
- Visualize workflow and session execution durations
- Spot long-running or abnormal tasks
- Filter by date range, workflow, or session type
- Useful for performance tuning and troubleshooting
The portal is designed for speed and low impact on production systems.
All relevant Informatica metadata and execution statistics is cached in an internal database , allowing the app to:
- Minimize direct queries to the Informatica repository
- Operate independently from the production environment
- Deliver fast performance even for large datasets
This approach ensures a smooth, responsive user experience while preserving system stability.
Note ,This is the very first release — focused on foundational features for metadata visibility, performance monitoring, and system understanding. More to come....
“Find all workflows connected to Database X and detect any sessions that consistently run over 30 minutes.”
- Search by Connection or Table Name
- Compare Workflow Definitions (Planned)
- Admin Panel for cache reset and config control
- Export to CSV (Planned)
- Python
- SQLAlchemy
- SQLite / PostgreSQL /Oracle
- YAML for configuration
Explore the key features of the Informatica Insights Portal through the following screenshots.
Full visibility into Informatica components: workflows, sessions, connections, and command tasks.
Flat table showing all components in a workflow — sessions, commands, dependencies, and more.
Visual representation of workflow structure:
Workflows → Sessions → Commands → Connections → Related Tables
*DB details and commands(if any)
Find all processes interacting with a specific database or connection.
Search workflows by referenced table name (source/target/attribute match).
Connect to Informatica metadata via DB connection or tnsnames.ora/odbc.ini.
Explore the structure of the internal SQLite/PostgreSQL Insight DB.
Visualize workflow and session execution trends over time. Useful for identifying long-running tasks and performance issues.
Compare Average Runtime of Multiple Workflows
Analyze workflow execution trends, overlaps, and anomalies.
Longest & Shortest Workflow Runs
With the workflow in context - Session Stats
Zoom in on specific run date and see all sessions run information as date, duration error and erros message
Workflow trends
Daily & Hourly Trends
HeatMap
For the selected workflow, see how average runtime varies by day and hour
Anomalous Insights for Workflow in context
Sessions Runtime Anomalies for the workflow in context - user allow to exclude specific session,worklet
Overlap impact - in many case , some workflow shows bad performance as they impacted while running in parallel to other workflow(WIP)
Manage users, roles, and track login activity from the built-in admin panel.
Track when users accessed the portal.
For development purpose , the app allows bypassing the logging screen and security .
YAML-based config editor and internal database tools.
Edit config.yaml directly from the UI.
For questions or contributions, please contact aviciot@gmail.com