I am creating a custom model in modeler. Where could I see the source table names to write the SQL query to connect a table in infor WMS.
First, in Modeler/Connect, you create a Query Based Object containing SQL to extract from your source. Since you are accessing the Data Lake, you can use the Infor Data Lake Compass connector (blue icon in the connection workspace). You will have to hit <Back from the Data Lake object listing in order to access the ... menu to chose Query Based Object creation. Provide a name and paste Compass query syntax SQL (refer to the Data Fabric for syntax assistance https://docs.infor.com/inforos/2023.x/en-us/useradminlib_cloud/default.html?helpcontent=datafabrug/cover.html). Save and click to see a preview. It is best to run the SQL in Data Fabric Compass in Infor Portal before saving in Birst.
You will need to import the source to have access to it in Modeler/Prepare. If you are new to Birst and how to create dimensional modeling in the tool, then it is beneficial to take Infor U course Foundation Birst for Admin.
