> For the complete documentation index, see [llms.txt](https://dbi-services.gitbook.io/omrun-help/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dbi-services.gitbook.io/omrun-help/configuration/data-adaptor.md).

# Data Adaptor

### ![](/files/zHpn0Kr3JoqcJh6Texsw)

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