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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://dbi-services.gitbook.io/omrun-help/configuration/data-adaptor.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.