OMrun Help Online Manual for OMrun Version 4

Data Adaptor


OMrun Data Object Icon

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
Avaloq (Oracle)

Oracle database

Oracle client
Avaloq (TNS Oracle)

Oracle database

Oracle client
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 without header row:

  • .TXT
  • .CSV
  • Hostfile (position oriented)
  • PDF (after conversion)
  • .XML (after conversion)
MS Office / Data Access Components
IBM AS400 (IBM)

AS400 database

AS400 client
IBM AS400 (OLEDB)

AS400 database

AS400 client
IBM DB2 (OLEDB)

DB2 database

DB2 client
MS DB2 (OLEDB)

DB2 database

DB2 client
MySQL

MySQL database

MySQL client
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

-

Data Providers are maintained in the OMrun Adaptor dialog and the data is stored in omrundataprovider.cfg. Data Providers can be customized: see Customize your own Data Adapter.


List of reserved Keywords

All data base adapters are failing to handle specific reserved data base expressions used in aliases. Below there is a list (not complete) of unallowed aliases for specific data bases.