EDB Postgres Advanced Server
Security - Password policy management, session tag auditing, data redaction, SQL injection protection, and procedural language code obfuscation
Performance - Query optimizer hints, SQL session/system wait diagnostics
Developer Productivity - Over 200 pre-packaged utility functions, user-defined object types, autonomous transactions, nested tables, synonyms, advanced queueing
DBA Productivity - Throttle CPU and I/O at the process level, over 55 extended catalog views to profile all the objects and processing that occurs in the database
Oracle Compatibility - Offers compatibility for schemas, data types, indexes, users, roles, partitioning, packages, views, PL/SQL triggers, stored procedures, functions, and utilities
Gartner about EDB (Advantages):
Leading PostgreSQL solution provider: EDB is the reference vendor for PostgreSQL technology, and interest in PostgreSQL and compatible databases is constantly growing.
Support and Community: EDB is highly regarded for its expert support and contributions to the open community, maintaining a balance between open-source approaches and commercial products.
Easy Migration: EDB facilitates migration from other systems, especially Oracle, through advanced optional compatibilities that significantly reduce the need for code conversion.
Integration of the IBM Cognos Analytics platform with the EDB Postgres database
The integration between the IBM Cognos Analytics platform and the EDB Postgres database enables a high level of efficiency and reliability in analytical systems with fast implementation and optimized data management.
IBM Cognos Analytics natively supports connection to the EDB Postgres database via JDBC and ODBC connectors, ensuring stable and secure data transfer and full compatibility with the existing infrastructure.
During the implementation of the decision support system, Comping developed an architecture that enables the consolidation of data from various business systems (POS, ERP, HR) into a single DWH database based on EDB Postgres. Such an approach enables centralized reporting and advanced analytics in Cognos, with fast access to large amounts of data.
The acquired knowledge and experience in working with complex data structures and database integrations enable Comping to quickly adapt and integrate the IBM Cognos Analytics system with other business platforms.
This combination of IBM Cognos Analytics and EDB Postgres brings lower maintenance costs, shorter report delivery times and greater data security, while maintaining high performance and the ability to expand to additional objects or business segments.
