Data Adaptor

OMrun includes various Data Providers that enable you to read most of the popular data formats using SQL statements with predefined connection strings:

Data adaptor
Data format
Installation precondition

Access (OLEDB)

MS Access file format: .ACCDB

MS Office / Data Access Components

Amazon Aurora (MySQL)

Amazon Aurora database

-

Avaloq (Oracle)

Oracle database

Oracle client

Avaloq (TNS Oracle)

Oracle database

Oracle client

Azure Database (MySQL)

Azure database

-

Btrieve/Pervasive (MySQL)

Btrieve/Pervasive database

-

Excel (OLEDB) - HDR

MS Excel file format without header row: .XLS / .XLSX

MS Office / Data Access Components

Excel (OLEDB) + HDR

MS Excel file format with header row: .XLS / .XLSX

MS Office / Data Access Components

Flatfile (OLEDB) - HDR

Simple structured files without header row:

  • .TXT

  • .CSV

  • Hostfile (position oriented)

  • PDF (after conversion)

  • .XML (after conversion)

MS Office / Data Access Components

Flatfile (OLEDB) + HDR

Simple structured files with header row:

  • .TXT

  • .CSV

  • Hostfile (position oriented)

  • PDF (after conversion)

  • .XML (after conversion)

MS Office / Data Access Components

Google Cloud SQL (MySQL)

Google Cloud SQL database

-

IBM AS400 (IBM)

AS400 database

AS400 client

IBM AS400 (OLEDB)

AS400 database

AS400 client

IBM DB2 (OLEDB)

DB2 database

DB2 client

MariaDB (MySQL)

MariaDB database

-

MS DB2 (OLEDB)

DB2 database

DB2 client

MySQL

MySQL database

-

OMIS Variable (OM)

Variable string format (more)

-

Oracle XXg

Oracle database

Oracle client

Oracle XXg (TNS)

Oracle database

Oracle client

PostgreSQL (ODBC)

PostgreSQL database

PostgreSQL client

SAP BW X.X (OLEDB)

MDX format

SAP client

SQL Server 7 (OLEDB)

MS SQL Server

-

SQL Server 7 (SQL)

MS SQL Server

-

SQL Server CE (SQLCE)

MS SQL Server Compact Edition

-

TestDataDB (SQLCE)

MS SQL Server Compact Edition

-

Last updated