ODBC Query Syntax - trillium_discovery - trillium_quality - Latest

The following is the default syntax for queries used with the ODBC Reporting Adapter:

SELECT * FROM "SCHEMA"."user_name"."query_name"

Entity queries (queries associated with entities in the repository) have the following syntax:

SELECT * FROM "SCHEMA"."user_name"."entity_name(entity_id)"

Where

• SELECT signifies that this type of SQL statement is a query.

• * specifies that all columns and rows be returned by default.

• FROM "SCHEMA". SCHEMA is the default name of the repository database and FROM instructs the query to extract data from it.

• "user_name" is the name of the owner of the query (the user who created the query) in double quotes (“”).

• "query_name" is the name of the Trillium query you are running. The double quotes around the name are optional.

• entity_name(entity_id) is the name and unique reference/object ID number for the entity.

For example, the default syntax for "show_all_br" owned by OAUSER is:

SELECT * FROM "SCHEMA"."OAUSER"."show_all_br"