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:
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
-
Last updated