Image

Supported Databases

Apparo imports all data to your own relational databases and stores it in freely definable database tables.
Apparo can read/write - from/into these databases:

  • Amazon Aurora PostgreSQL
  • Amazon Redshift
  • Apache Derby
  • Databricks
  • Exasol
  • Google BigQuery
  • IBM DB2 / IBM DB2 Client (e.g. for z/OS DB2)
  • IBM i Series
  • IBM Netezza
  • IBM Informix
  • IBM Warehouse
  • Microsoft SQL Server
  • Microsoft Azure SQL
  • MySQL
  • Oracle (optional using service name) / Oracle Client / Oracle URL
  • Postgres
  • SAP HANA
  • SAP ASE
  • SAP IQ
  • SAP SQL Anywhere
  • Teradata
  • Trino

All Apparo definitions (Apps, Business Cases, Forms, Import-Masks) are stored in a database repository.

The following databases are supported for the Apparo repository:

  • Oracle
  • Microsoft SQL Server
  • Microsoft Azure SQL
  • IBM DB2
  • Internal database (for tests)
Image

Supported Excel formats

Whether old versions, the most current or simplified. Apparo supports all common Excel file formats.

Apparo supports the following formats:

    • XLS,  Excel files saved with Excel 2003 or older
    • XLSX, Excel files saved with Excel 2007 and newer
    • CSV, When the data is saved as comma separated format only
    • .Excel, If you want to allow the import of all types in one application
Image

No client installations

Client installations can be expensive, which is why Apparo doesn’t require it.

Users work exclusively in a browser.:

  • Supported are all current browsers
  • Microsoft Internet Explorer, Microsoft Edge, Google Chrome, Firefox and Apple Safari
  • No need to install any software, patches or the like
  • Your users can start straight away