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
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 with 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	-