PADB uses standard interfaces (ANSI SQL, ODBC, JDBC) and supports all of the popular commercial and open-source BI and data integration tools (e.g., Business Objects, Cognos, Diginome, Informatica, Information Builders, JasperSoft, Microsoft, Microstrategy, Pentaho, Talend, and so on).
PADB is SQL92 compliant and supports the most important analytic extensions in the SQL99 and SQL:2003 standards including analytic functions, window functions and correlated sub-queries. The database also provides ParAccel-specific features, and recognizes and accepts a variety of common stored procedure languages used in traditional BI environments.
Security Features
PADB offers column-level encryption to aid applications that require extra data security (e.g., Financial Services, Healthcare, etc.). The encryption implementation takes advantage of the columnar nature of the DBMS and particularly its compression to offer exceptional performance in encryption scenarios. PADB also runs in Payment Card Industry (PCI) and Security Technical Implementation Guides (STIG) compliant environments.