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:
| MS Office / Data Access Components |
Flatfile (OLEDB) + HDR | Simple structured files with header row:
| 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