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
  • Create views on your data objects stored in Data Lake
  • Export data
  • Explore 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.
  • Data Objects and Views Panel - for exploring Data Catalog objects and views.
  • Ability to search and filter the data objects and data object properties
  • Generate contextual SQL statements and SQL hints to influence data retrieval behaviors
  • Generate contextual administrative SQL code for managing and troubleshooting data in Data Lake
  • Query Editor - for writing SELECT statements and running them.
  • 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
  • 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.