Using the Compass application page

Compass is a Data Fabric tool for querying the contents of Data Lake for data analysis and exploration, ad-hoc data exports, data management, and troubleshooting.

You can start Compass in the Data Fabric application in these ways:

  • Click the Query the Data Lake link on the Home page
  • In the navigation menu, select Compass.
Note: The Compass page is not available in Infor Government Solutions.

In Compass, you can run these tasks:

  • Write and run SQL queries against Data Lake.
  • Create views on your data objects stored in Data Lake.
  • Export data.
  • Explore catalogs, collections, data objects, and properties.
  • Execute administrative tasks within Data Lake.

Compass offers these elements and functionality:

  • Multi-tabbed query development with up to 10 concurrent tabs.
    • Each tab operates as an independent query workspace with its own query context (Data Lake). The data source icon is displayed on the tabs to indicate the active context. When the tabs are renamed, the context remains the same. By default, the tabs are named after the data source.
  • Catalog Browser Panel: For exploring catalogs, collections, data objects, and views across available data sources. The panel operates independently of the active query tab. You can perform these actions in the panel:
    • Search and filter data objects and data object properties.
    • Generate contextual SQL statements and hints for data retrieval.
    • Generate a contextual administrative SQL code for Data Lake data management and troubleshooting.
  • Query Editor: For writing and running SELECT statements. The editor has these characteristics:
    • Syntax highlighting
    • Contextual auto-suggest for SQL keywords, custom keywords, and data object and data object property names
    • SQL formatting
    • Font size controls
  • Results Panel: For previewing the query results. The panel has these characteristics:
    • Success and error messages
    • Result set in a data grid
    • Exporting a result set

With Compass editor, you can write simple or advanced SQL SELECT statements and run them to retrieve data.

These supported SQL statements are available:

  • SELECT statements
  • Standard SQL dialect

SQL comments are supported within a statement.

For Data Lake, these additional options exist:

  • SELECT statement with Infor-supported functions for handling variations, deleted objects, and archived objects
  • Admin statements to manage the formatted Data Lake objects
  • CREATE, ALTER, and DROP statements for views.