> 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/data-queries.md). # Data Queries ### ![](/files/Z8MC6hrZYZ8klXuJKcmg) OMrun queries data from the data sources with different syntax formats: | Data adaptor | Query format | Comment | | ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Access (OLEDB) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | Avaloq (Oracle) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | Avaloq (TNS Oracle) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | Btrieve/Pervasive (MySQL) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | Excel (OLEDB) - HDR |

SELECT
F1 AS Alias1,
\[...],
FX AS AliasX
FROM \[worksheet name$]

| | | Excel (OLEDB) + HDR |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM \[worksheet name$]

| | | Flatfile (OLEDB) - HDR |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM \[FileName.csv]

If delimiter matches the local PC config settings it is possible to query the flatfile without a schema.ini file. Any column can be queried by "F\":

SELECT
F1 AS Alias1,
F2 AS Alias2,
\[...],
FX AS AliasX
FROM \[FileName.csv]

|

File schema.ini needed (same directory as the flatfile):
\[Sample.txt]
ColNameHeader=False
Format=CSVDelimited
MaxScanRows=0
Col1=Column1 Text Width 10
Col2=Column2 Text Width 30
\[...]
ColX=ColumnX Text Width 30

| | Flatfile (OLEDB) + HDR |

SELECT
Column1 AS Alias1,
Column2 AS Alias2,
\[...],
ColumnX AS AliasX
FROM \[FileName.csv]

|

File schema.ini needed (same directory as the flatfile):
\[Sample.txt]
ColNameHeader=True
Format=CSVDelimited
MaxScanRows=0

| | IBM AS400 (IBM) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM @DB\_Schema.TableName

| | | IBM AS400 (OLEDB) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM @DB\_Schema.TableName

| | | IBM DB2 (OLEDB) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM @DB\_Schema.TableName

| | | MS DB2 (OLEDB) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM @DB\_Schema.TableName

| | | MySQL |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM @DB\_Schema.TableName

| | | OMIS Variable (OM) | n/a | OMrun variable format, no specific data adapter | | Oracle XXg |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM @DB\_Schema.TableName

| | | Oracle XXg (TNS) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | PostgreSQL (ODBC) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM @DB\_Schema.TableName

| | | SAP BW X.X (OLEDB) |

SELECT
{\[ZINZRU].\[1ROWCOUNT]}
ON COLUMNS,
{\[ZINZRU].\[LEVEL01].Members}
DIMENSION PROPERTIES
\[ZINZRU].\[2ZINZRU],
\[...],
\[ZINZRU].\[2ZINZSSREG] ON ROWS
FROM \[$ZINZRU]

|

Data saved into internal SQL Server CE
(see MDX options)

| | SQL Server 7 (OLEDB) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | SQL Server 7 (SQL) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | SQL Server CE (SQLCE) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | | TestDataDB (SQLCE) |

SELECT
Column1 AS Alias1,
\[...],
ColumnX AS AliasX
FROM TableName

| | --- # 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/data-queries.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.