Application Enhancement

Common Scenarios

• Foreign employees or customers need the application in their language
• Overseas offices established and need local language support
• Regulatory requirement to provide multiple language options
• Want to add languages without touching existing code

Solutions

Enable is a runtime internationalization tool that intercepts your PowerBuilder application's text at runtime and replaces it with translations.

Key benefit: Add multi-language support without modifying your source code. Translators work in Excel files, not in PowerBuilder.

• Fast implementation (weeks, not months)
• No source code changes required
• Non-technical translators can work directly
• Easy to add more languages later

Common Scenarios

• Users complain the interface looks outdated
• Need better data visualization (charts, dashboards)
• Want to improve usability without complete redesign
• Management wants "Windows 11 look and feel"

How Ultimate Suite Works

Ultimate Suite for PowerBuilder (USPB) provides modern UI controls that integrate seamlessly with your existing PowerBuilder applications.

Key benefit: Drop in modern components without rebuilding screens. Add charts, calendars, and contemporary design elements instantly.

• Professional charts and graphs
• Modern calendar and date pickers
• Enhanced filtering and search
• Dashboard components

Common Scenarios

• Security risks hidden in the code (unsafe patterns, hard-coded secrets, missing checks)
• Need to implement multi-factor authentication (MFA)
• Want to integrate with Active Directory / LDAP / Entra ID
• The user base is growing, and permission management is complex.
• Access rules scattered throughout code, hard to manage
• Compliance requirements for access logging and control
• Hard to demonstrate "who can do what" (roles/screens/functions) during audits
• Difficulty maintaining consistent security across multiple PB applications / versions

Solutions

• Detect and fix security weaknesses in PowerBuilder code (PB 2025 + Visual Expert)
• Reduce "security logic" inside the application. Externalize authentication and authorization from PB code (PB 2025 + Visual Guard).
• Implement MFA and flexible login flows (PB 2025 + Visual Guard)
• Integrate with AD/Entra ID (PB 2025 + Visual Guard)
• Implement Single Sign-On (SSO) with Windows accounts (PB 2025 + Visual Guard)
• Implement role based access control (RBAC), mapped to screens and business functions (PB 2025 + Visual Guard).
• Generate a full application audit trail for compliance (PB 2025 + Visual Guard)

Common Scenarios

• Planning an upgrade from an older database version (e.g., Oracle 11g or SQL Server 2008/2012).
• Want to estimate the migration effort before committing resources.
• Worried about deprecated features that may break the code afterward.
• Need to understand the impact of changes (for instance a datatype) on the code.
• Want to reduce technical debt before upgrading (unused objects, obsolete patterns).
• Need audit-ready documentation of the migrated database.
• Want to compare before/after schemas and code to validate the migration checklist.
• Want to optimize performance and continuously monitor quality and regressions.

Solutions

• Scope & metrics in minutes: automatic inventory of database objects and code volume.
• Model the data structure: generate ER diagrams to understand the data model.
• Clean up before you migrate: detect potentially unused objects ("dead code").
• Find deprecated elements: identify where outdated types, functions, packages, or syntax are used.
• Impact analysis ("What happens if I change X?"): instantly see all dependencies, and use a matrix to avoid missed references.
• Validate changes with comparisons: compare schema/code between versions.
• Generate documentation automatically: document data model, objects, code, parameters, references for long-term maintenance.
• Post-upgrade optimization & continuous monitoring: find slow code, missing indexes, quality/security issues, etc.