> 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/version-4.x/configuration/data-adaptor.md).
# 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:
- .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 |
| 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 | - |
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## 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, and the optional `goal` query parameter:
```
GET https://dbi-services.gitbook.io/omrun-help/version-4.x/configuration/data-adaptor.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
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.