We realize in the cloud we cannot access the database, but i am going to ask if it's possible to add query to pull data? We need to add a query we use on site but didn't move to the cloud. Is there any way we can do it?
Check out the SQL Data Viewer. It will allow you to query the database and return the results to a grid.
marketplace.infor.com/.../mongoose---sql-data-viewer
If all the data is in Mongoose, you should be able to build an IDO to replicate the query
For more complex queries, or to join to data not in Mongoose, we use the ETL tool to synchronize data from the data lake into an Azure SQL database. Once you have done that, you can call a stored procedure in an external database and present the result into a grid, or run the data aggregation overnight, and write the data back into Mongoose.
thank you all for the answers, The data viewer will not work the query has many joins and calculations. So i assume the ETL tool is the way to go. Anywhere i can read/learn about it?
You can always create your own REST API's (in .Net for instance) to allow sending requests to the Local SQL Instance.These API's can then be integrated into ION as any external API's.
