Developing and testing 4GL queries in Cloud
Hi,
I wanted to ask about the possibility of creating and testing SQL(4GL) queries in Cloud Infor LN. I know, thah in OnPremise version of Infor LN was tool called Easy SQL, but I know that it is missing in cloud. I don't know how to prepare query for a script or report, check it in editor such as OnPremise Easy SQL - what data they return, what they look like, what type fields are, whether the tables are joined correctly and quickly fix it.
I understand that we don't have access directly to database because it's now multitenant, but I think that this is not an argument for not having such functionality. We can add extensions to sessions, tables, create reports and other objects that use such queries. We even have access to LN Studio, where we have access to various aspects of creating new functionalities. It's not about creating tables, indexes, fields, but about querying data.
How can I develop/test queries in a cloud environment?
I would like to be able to use this prepared query in a script, assign values to variables and use it in the 4GL script.
Comments
-
hello @Artur,
Until the moment I not found any solution to query data in the database in the same way as on-premises.
Only solution I found for LN Cloud is to use the Data Fabric application, but it is not the same.
Looking in Data Fabric - Infor Developer Community
0 -
Maybe helps you:
0 -
Hello Fabiano, I've already had this idea, but I try to find better. This method is not convenient because the table names are different, language is different and I have no guarantee that all tables and fields are loaded into the data lake, so you need to prepare loading to data lake.
In data fabric you have query pplatform like T-SQL MS SQL Server and in 4GL you can't use this functions and statements, so you cannot process set of data to have some result and then use this query in 4GL script.
Do you know if I can use query from data fabric in 4gl script without huge changes? What part of language is common and will work in 4GL?
1 -
@Artur , I dont know how can you do this, never see some solution like that. :(
0