For more advanced use cases, such as adding a query-based object from your database, you
can:
Select the Infor Data Lake connector from the
Connector section or click the existing Infor Data Lake
connection from the Connections panel.
Click the Ellipses icon on the connector page, then
select +Add query-based object. This allows you to employ
simple SQL expressions, such as joining tables or creating simplified views of
existing tables.
Specify this information:
Source Name:
Enter the name of the supported Infor Data Lake object.
Query:
Add query to specify the columns you need for reporting.
Note: Incorrect SQL strings can give incorrect
results. We recommend verifying that the SQL you specify is
correct.
Click Import [Connection Name] Data to import the
selected objects to Birst or create an Orchestration workflow. You can click
Edit to edit source column selection for data
import.