Skip to content

Custom Query Tab

Application database > Analytical Workspaces tile > workspace tile > Virtual Datasets and Datasources tab > datasource tile > Query tab

Application database > Navbar > Analytic Information hub > workspace tile > Virtual Datasets and Datasources tab > datasource tile > Query tab

Purpose of the tab

This tab allows you to define the queries (one for every DBMS platform for every possible database from which to read) that define the datasource. To define parametric queries, the syntax of the cell fields can be used. On saving, the query is validated on the application database from which the data are read, using the syntax specified in the corresponding tab.

Note: CLOB/BLOB etc. fields are not supported. If they are inserted in the query to create the datasource, a warning message will appear.

Custom Query

Element Description
MsSql body Allows you to enter the SQL query that will be used in the case of a primary MsSql connection.
Oracle body Allows you to enter the SQL query that will be used in the case of a primary connection of Oracle type.
Postgres body Allows you to enter the SQL query that will be used in the case of a primary PostgreSQL connection.
Hana body Allows you to enter the SQL query that will be used in the case of a primary connection of Hana type.
Other Body Allows you to enter the SQL query that will be used in the case of a secondary or tertiary connection.
Connection Allows you to select the connection on which to perform the query. Secondary connections are marked with prefix (S) and tertiary connections with prefix (T). Primary connection means a connection defined as primary in the configuration file of the standalone.xml application server. A secondary connection is a connection defined as secondary in the configuration file of the standalone.xml application server. A tertiary connection is a schemaless connection defined as primary or secondary in the configuration file of the standalone.xml application server. Note: in workspace import/export operations, the datasource's association with the database remains. Note: If a database other than the current database in this field is selected, the datasource will not appear among those available for DTP operations to insert/enrich from another Dataset.
Preview Shows a temporary table with a preview of the query results (max. 30 rows). Note: the preview does not support queries with reporting parameters or Analytical Workspaces.