# Data Adaptor

### ![](https://2873353689-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfK1YJaTCqOiS0L22wVKG%2Fuploads%2Fgit-blob-82a409549d31b8d9fc2afc92887e9262c1cd3f24%2FIcon_TOB_data.png?alt=media)

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    | <p>Simple structured files <strong>without</strong> header row:</p><ul><li>.TXT</li><li>.CSV</li><li>Hostfile (position oriented)</li><li>PDF (after conversion)</li><li>.XML (after conversion)</li></ul> | MS Office / Data Access Components |
| Flatfile (OLEDB) + HDR    | <p>Simple structured files <strong>with</strong> header row:</p><ul><li>.TXT</li><li>.CSV</li><li>Hostfile (position oriented)</li><li>PDF (after conversion)</li><li>.XML (after conversion)</li></ul>    | 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                                                                                                                                                                              | -                                  |