Currently, I am able to directly cut/past the BAQ query into SQL studio, but it does not always work. I always end up rewriting it. Is there any easier method?

Thanks @richardh and welcome to our Forum, i have done what you suggested, the outcome file will certainly help analysing the performance of the BAQ query, but i need the SQL code to use it in different App as well as here, could you please explain how can be generated/viewed from this file? [ima…

I did the former already a few days ago. However, the execution plan is a graphical representation of the executed SQL. Is there a way to extract the requested query vs. the executing query? An Oracle database can track the submitted query and the executing query. My end Goal is to convert the BA…

You need to develop and test the SQL first. Then you can create a database View if you have DBA privileges. You will need to create a schema to contain all your custom views and to isolate them from Epicor views. Additionally, you will need to grant specific access to the view. The command for creat…

[image] asmar: My end Goal is to convert the BAQ query to SQLserver SQL query and define a database View that can be accessed by an ASP application, SharePoint App, or MS Power BI. Isn’t that already solved by calling the REST API BAQSvc? You can call the BAQ query from any client consuming t…

We are currently running 10.1.400.38, is REST API BAQSvc available for this release? In the meantime, I need to create the VIEW for these existing applications. Thanks for your idea and suggestion. I will need to test this in the very near feature, and after I attend my scheduled training on REST …

I had hoped REST would be useful for Power BI. So far I haven’t found a single situation where it isn’t too slow and unresponsive. If you have any tips to make it work effectively, please share!

it much easier to clear the view from the SQL code of BAQ Phrase the way i recommend then run it straight a way in MSSM Epicor database, and will be ready for all SQL based applications

@asmar Oops, sorry, I didn’t see the version you working with. I believe REST is available since 10.1.500/600, so the suggestion may not apply to you, however, I believe you should still consider that once you or your customer upgrades to the latest version, they will have that feature available. @…

To answer the original question, LINQ generated SQL is different from high performance written SQL and I haven’t ever seen anything to convert the two. @dhewi Look at using Dataflows to load the BAQ data to your SSAS instance for PowerBI. You can now mix SSAS summaries with direct queries now by us…

Well, the problem with Power BI is that it’s most useful when there’s a massive amount of data, and that’s where REST seems to falter, as you say. I remain hopeful we can make good use of REST for other projects we have on our agenda, and I think it’s a great thing to have available. I’ve just been…

Simple method to convert BAQ query to SQL server

Epicor ERP 10

Topic		Replies	Views
BAQ that calls a BAQ? Epicor ERP 10 baq	17	4520	April 23, 2024
Is there a way to create a BAQ from its SQL code? Epicor ERP 10 baq	22	3064	October 8, 2024
Poll - do you use BAQ designer or SQL? Epicor ERP 10 sql	32	3024	January 1, 2023
What do people really think about BAQ's? Kinetic ERP baq	41	8847	July 5, 2023
Direct SQL entry and editing in BAQ Designer Feature Requests and Suggestions	36	10082	June 20, 2019

Simple method to convert BAQ query to SQL server

Related topics