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