Thank you for the content on Business Central. I recently started learning BC and your videos will be very helpful.
@Areopawebinars2 ай бұрын
Unfortunately the recording resolution was bigger than our screens with the consequence that these are not "full screen". Apology for that.
@samihnaien48403 ай бұрын
i have a question. why you load data in power bi desktop and not in power bi in microsoft fabric?
@bertholland993 ай бұрын
You can do indeed both. I was using PowerBI desktop in this example. But you can also do it in the web. That is up to you. But in both cases you can access the data and the semantic model.
@TheBrahmaBull183 ай бұрын
thank you for this video! very useful
@cbrill823 ай бұрын
Very helpful, thanks. I quick question: Why do you use the "Sports Evaluation Setup" - table just to pass on a single value? Wouldn't it be easier (and also faster) to just add a second parameter in the "GetHandler"-procedure? Or is this meant to be a general setting for the system and not an option to be frequently changed?
@Areopawebinars3 ай бұрын
Tobias Fenster: I would say it's a general settiing
@go-live4 ай бұрын
Apologies for the jerkiness of this presentation. I made the cardinal mistake of not doing a full run through of a new tool. I didn't realize that Slido was covering up my Power point presentation and that got me all flustered.
@user-xt1vl3sp5s4 ай бұрын
really like your sessions!
@go-live4 ай бұрын
Thank You.
@julienremaud73074 ай бұрын
Thanks for your presentation! Loud and Clear, as said by Luc ;-) I hope I can start using Logic Apps soon :p
@user-xt1vl3sp5s4 ай бұрын
Great content!
@Areopawebinars9 ай бұрын
Would you want to follow Xavi: www.myowncommonsense.com/.
@O2hSolution-cd2el10 ай бұрын
The great Idea to Access data of "Business Central 365". One Question That where can i get this source Code??
@PontyclunBosomPals Жыл бұрын
Unfortunately this is what Synapse has amounted to as a solution for the dynamics products. What was designed to be a better performing , easy to use architecture has significantly increased the complexity. Ultimately an ADF pipeline connecting to BC dataverse and pulling the data into an Azure serverless V-core SQL database (or DTU model) with stored procedures to carry out append ( for transactions) and merge ( for master tables) is a far easier to implement solution. Ultimately it will also result in a cheaper solution. A dedicated synapse instance represents a considerable increase on an Azure SQL V core model and a synapse serverless solution performs very poorly when querying CSV files. I would have expected an export to datalake solution to provide an incremental export based on change tracking ( as is the case for CE and finance) as opposed to schedule and export. I am also surprised that there is a need to create pipelines to carry out the merge process for the delta files ( I would export the export process to manage this for me). In short - this is a far more convoluted solution that brings significantly more complexity without any benefits in terms of reduced latency or costs. You now have additional resources ( azure data lake, synapse (including synapse studio) and mapping dataflows) combined with either a dedicated instance or a serverless database. All of these resources comes with their own cost, security , access and network considerations. In additional if this is being implemented for a customer - the customers will need the skills with all of these products in order to manage the solution going forward.
@Fajoekit7 ай бұрын
Can you tell me more on how to connect ADF to BC dataverse? I've got a customer who's BC partner is totally unwilling to install any form of Extensions. So we are only left with the BC Odata webservice or Rest API. We are experienced in ADF, but not in pulling in data from BC without an Extension providing a table list.
@klauskaan6320 Жыл бұрын
I love this approach. Seperation of concerns is important. Thanks Peter!
@user-bg3mx1us4d Жыл бұрын
Hi, has anyone managed to implement an incremental refresh for data being loaded from Business Central (SaaS)?
@Areopawebinars Жыл бұрын
github.com/vjekob/al-test-doubles
@klauskaan6320 Жыл бұрын
This might be the single most important webinar this year.
@alvinlau4572 Жыл бұрын
Good presentation, thanks Krzysztof
@marcusnordlund8486 Жыл бұрын
At 1:08:07 A more detailed answer on how he replaces the test is: In the installation codeunit in test integration app you create a test suite and add all "base tests" for each apps. Then you launch a "discover pattern" event that each app responds to with which tests that should be disabled and/or updated. When disabling a test you find the "Test Method Line" for that test and sets the field Run = false (=skip). Well - that's pretty much it. You can also test if there is a replacement procedure in place as well .
@ricardaskersulis3811 Жыл бұрын
Perfect presentation. Thank you, Stefano.
@temingmccormack1649 Жыл бұрын
Excellent presentation! Thanks very much for sharing it!
@nareshbandari8493 Жыл бұрын
How can we add namespace with prefix on XML creation using XmlDocument, XMLElement and XmlNamespaceManager?
@gavinmcphilomey7619 Жыл бұрын
Great info. How can we interact with Azure File Share via AL code? Stefano has a demo for the blob storage but not file share. I need to be able to access a locally mapped drive and move files around it. thanks
@demilianistefano9715 Жыл бұрын
For Azure File Share there’s not a built-in AL module today. Best way is to use Azure Functions (full code) or Azure Logic Apps (low code approach) for that. Azure Logic apps in particular has a File System connector that you can use with the Blob Storage connector to do exactly what you want. I’m live demoing that today at DynamicsMinds conference.
@MKAY18185 ай бұрын
@@demilianistefano9715 Excellent demo! Do you have a link to the File System connector demo, or more info?
@ddm1994 Жыл бұрын
I am very interested in this topic. Thank your for uploading the video. For now i just skimmed the video. But what i saw is, that you have to code a lot for yourself. My feelings at the moment are that using the tool can possibly lead to distraction during programming, so that one no longer concentrates on the actual task. However, I can imagine that the co-pilot can help out with development in the future. For topics that are a little more complicated, you will probably be on your own at first. For example, when processing takes place in recursive functions for nested BOMs. FYI: I came here from your interesting article "Maximizing Business Central With ChatGPT".
@mckennahaleigh5637 Жыл бұрын
Love the videos! Get to know the secret - 'Promo sm' !!!
@Areopawebinars Жыл бұрын
Note that the dates in January, February and March of the upcoming webinars should have had 2023 as year.
@JAlmaraz Жыл бұрын
Agree with the final thoughts: patience. We need patience and .........lots of AL training. I have been using Co-pilot for half and a year to create my VSCode extensions in JavaScript and the feelings are widely different. With JavaScript is a real pair programming I developed so many features that I can not explain why I did so many things. Is a real and mad increase of productivity. The future is working in Hybrid teams of machines and humans. In JavaScript the future has come, but AL time will come later.
@koppolusujatha9363 Жыл бұрын
Data is not visible properly
@BijouBakson Жыл бұрын
Thank you.
@philipdelaharpe2674 Жыл бұрын
Excellent tutorial. Thank you. Complete and clear with nothing missed and has answered alot of my questions and resolved the issue that had me searching for this information.
@khoivu8172 Жыл бұрын
tks
@raghavsharma3211 Жыл бұрын
I didn't knew Stefano himself will be teaching us. This is a treat honestly.
@wintonwang168 Жыл бұрын
how can you update customer via dynamic 365 business central api using Oauth ?
@kennienybo2 жыл бұрын
Get the app here: aka .ms/bctelemetryreport (remove the space
@hugo_alves2 жыл бұрын
10:40 He recommends to create Dataverse Integration with CRM First and only after that integrate DV to BC. In case you need data shared between BC and CRM you should create in this sequence.
@Areopawebinars2 жыл бұрын
A note from Freddy, yesterday on twitter: Somebody asked me yesterday whether you could add a custom code cop to AL-Go. There is a setting called CustomCodeCops, where you can specify a number of custom code cops you want to run on your code.
@sahilkharidia5632 жыл бұрын
I see that workItemtracking is deprecated now ? Can this still be used ?
2 жыл бұрын
Hi and thx. A question for Waldo: I could see that in the web page, you recomend to use Single instance codeunits for subscribers, but I could see that you do not declare this codeunits as single insance in your code you showed. Why?
@waldo6347 Жыл бұрын
Yeah - this is something that we didn't retro-fit .. yet ;-)
@divyasiriedula28502 жыл бұрын
Is there a way to retrieve veracode scan results from api
@tobiasfenster21642 жыл бұрын
I've never worked with Veracode, but if I understand the documentation correctly, the results should be available as artifact, which you can get through the API: docs.microsoft.com/en-us/rest/api/azure/devops/build/artifacts/get
@toddz93442 жыл бұрын
😜 pr໐๓໐Ş๓
@matthiasra18062 жыл бұрын
very interesting + great presentation 👍
@patrikherrscher94252 жыл бұрын
Thank you very much for that interesting video. One Question. Where can I get the postman collection you used for BC? Do you have a link you can share with me? Thanks
@matthiasra18062 жыл бұрын
Very interesting topic. Thanks for the presentation
@aexanderbutko1662 жыл бұрын
Where i can find the fist videos of Areopa webinars?
@Areopawebinars2 жыл бұрын
In this channel. There have been 47 published so far.
@Areopawebinars2 жыл бұрын
Find the code examples on this repo: github.com/demiliani/ALFileManagement
@developd3652 жыл бұрын
Thank you for uploading this webinar, I was waiting this desperately. I couldn't join the whole webinar session.
@sshadows2 жыл бұрын
You might want to correct the typos regarding SSDs. It is Solid State Drive, not Disk. The reason they are fast is that there aren't any disks. :)
@jennyjeon60562 жыл бұрын
API vs US page web service .... It is well explained. I was looking for this for a while thanks
@matthiasra18062 жыл бұрын
Another valuable webinar 👍 thank you!
@nileshyadav70102 жыл бұрын
This webinar really helped me to understand the 3 main options to manipulate the resources in DevOps. I was wondering do you have the same options with Python library?. If it is can you share me the same examples with python lanuguage.?
@tobiasfenster21642 жыл бұрын
I don't have the examples in Python, but you ought to be able to use this github.com/microsoft/azure-devops-python-api, although I am not sure how well this is maintained
@nileshyadav70102 жыл бұрын
@@tobiasfenster2164 Thank you for your reply and sharing the link. Yes, I am working on it need to understand first the library.
Пікірлер
Thanks for the video
Thank you for the content on Business Central. I recently started learning BC and your videos will be very helpful.
Unfortunately the recording resolution was bigger than our screens with the consequence that these are not "full screen". Apology for that.
i have a question. why you load data in power bi desktop and not in power bi in microsoft fabric?
You can do indeed both. I was using PowerBI desktop in this example. But you can also do it in the web. That is up to you. But in both cases you can access the data and the semantic model.
thank you for this video! very useful
Very helpful, thanks. I quick question: Why do you use the "Sports Evaluation Setup" - table just to pass on a single value? Wouldn't it be easier (and also faster) to just add a second parameter in the "GetHandler"-procedure? Or is this meant to be a general setting for the system and not an option to be frequently changed?
Tobias Fenster: I would say it's a general settiing
Apologies for the jerkiness of this presentation. I made the cardinal mistake of not doing a full run through of a new tool. I didn't realize that Slido was covering up my Power point presentation and that got me all flustered.
really like your sessions!
Thank You.
Thanks for your presentation! Loud and Clear, as said by Luc ;-) I hope I can start using Logic Apps soon :p
Great content!
Would you want to follow Xavi: www.myowncommonsense.com/.
The great Idea to Access data of "Business Central 365". One Question That where can i get this source Code??
Unfortunately this is what Synapse has amounted to as a solution for the dynamics products. What was designed to be a better performing , easy to use architecture has significantly increased the complexity. Ultimately an ADF pipeline connecting to BC dataverse and pulling the data into an Azure serverless V-core SQL database (or DTU model) with stored procedures to carry out append ( for transactions) and merge ( for master tables) is a far easier to implement solution. Ultimately it will also result in a cheaper solution. A dedicated synapse instance represents a considerable increase on an Azure SQL V core model and a synapse serverless solution performs very poorly when querying CSV files. I would have expected an export to datalake solution to provide an incremental export based on change tracking ( as is the case for CE and finance) as opposed to schedule and export. I am also surprised that there is a need to create pipelines to carry out the merge process for the delta files ( I would export the export process to manage this for me). In short - this is a far more convoluted solution that brings significantly more complexity without any benefits in terms of reduced latency or costs. You now have additional resources ( azure data lake, synapse (including synapse studio) and mapping dataflows) combined with either a dedicated instance or a serverless database. All of these resources comes with their own cost, security , access and network considerations. In additional if this is being implemented for a customer - the customers will need the skills with all of these products in order to manage the solution going forward.
Can you tell me more on how to connect ADF to BC dataverse? I've got a customer who's BC partner is totally unwilling to install any form of Extensions. So we are only left with the BC Odata webservice or Rest API. We are experienced in ADF, but not in pulling in data from BC without an Extension providing a table list.
I love this approach. Seperation of concerns is important. Thanks Peter!
Hi, has anyone managed to implement an incremental refresh for data being loaded from Business Central (SaaS)?
github.com/vjekob/al-test-doubles
This might be the single most important webinar this year.
Good presentation, thanks Krzysztof
At 1:08:07 A more detailed answer on how he replaces the test is: In the installation codeunit in test integration app you create a test suite and add all "base tests" for each apps. Then you launch a "discover pattern" event that each app responds to with which tests that should be disabled and/or updated. When disabling a test you find the "Test Method Line" for that test and sets the field Run = false (=skip). Well - that's pretty much it. You can also test if there is a replacement procedure in place as well .
Perfect presentation. Thank you, Stefano.
Excellent presentation! Thanks very much for sharing it!
How can we add namespace with prefix on XML creation using XmlDocument, XMLElement and XmlNamespaceManager?
Great info. How can we interact with Azure File Share via AL code? Stefano has a demo for the blob storage but not file share. I need to be able to access a locally mapped drive and move files around it. thanks
For Azure File Share there’s not a built-in AL module today. Best way is to use Azure Functions (full code) or Azure Logic Apps (low code approach) for that. Azure Logic apps in particular has a File System connector that you can use with the Blob Storage connector to do exactly what you want. I’m live demoing that today at DynamicsMinds conference.
@@demilianistefano9715 Excellent demo! Do you have a link to the File System connector demo, or more info?
I am very interested in this topic. Thank your for uploading the video. For now i just skimmed the video. But what i saw is, that you have to code a lot for yourself. My feelings at the moment are that using the tool can possibly lead to distraction during programming, so that one no longer concentrates on the actual task. However, I can imagine that the co-pilot can help out with development in the future. For topics that are a little more complicated, you will probably be on your own at first. For example, when processing takes place in recursive functions for nested BOMs. FYI: I came here from your interesting article "Maximizing Business Central With ChatGPT".
Love the videos! Get to know the secret - 'Promo sm' !!!
Note that the dates in January, February and March of the upcoming webinars should have had 2023 as year.
Agree with the final thoughts: patience. We need patience and .........lots of AL training. I have been using Co-pilot for half and a year to create my VSCode extensions in JavaScript and the feelings are widely different. With JavaScript is a real pair programming I developed so many features that I can not explain why I did so many things. Is a real and mad increase of productivity. The future is working in Hybrid teams of machines and humans. In JavaScript the future has come, but AL time will come later.
Data is not visible properly
Thank you.
Excellent tutorial. Thank you. Complete and clear with nothing missed and has answered alot of my questions and resolved the issue that had me searching for this information.
tks
I didn't knew Stefano himself will be teaching us. This is a treat honestly.
how can you update customer via dynamic 365 business central api using Oauth ?
Get the app here: aka .ms/bctelemetryreport (remove the space
10:40 He recommends to create Dataverse Integration with CRM First and only after that integrate DV to BC. In case you need data shared between BC and CRM you should create in this sequence.
A note from Freddy, yesterday on twitter: Somebody asked me yesterday whether you could add a custom code cop to AL-Go. There is a setting called CustomCodeCops, where you can specify a number of custom code cops you want to run on your code.
I see that workItemtracking is deprecated now ? Can this still be used ?
Hi and thx. A question for Waldo: I could see that in the web page, you recomend to use Single instance codeunits for subscribers, but I could see that you do not declare this codeunits as single insance in your code you showed. Why?
Yeah - this is something that we didn't retro-fit .. yet ;-)
Is there a way to retrieve veracode scan results from api
I've never worked with Veracode, but if I understand the documentation correctly, the results should be available as artifact, which you can get through the API: docs.microsoft.com/en-us/rest/api/azure/devops/build/artifacts/get
😜 pr໐๓໐Ş๓
very interesting + great presentation 👍
Thank you very much for that interesting video. One Question. Where can I get the postman collection you used for BC? Do you have a link you can share with me? Thanks
Very interesting topic. Thanks for the presentation
Where i can find the fist videos of Areopa webinars?
In this channel. There have been 47 published so far.
Find the code examples on this repo: github.com/demiliani/ALFileManagement
Thank you for uploading this webinar, I was waiting this desperately. I couldn't join the whole webinar session.
You might want to correct the typos regarding SSDs. It is Solid State Drive, not Disk. The reason they are fast is that there aren't any disks. :)
API vs US page web service .... It is well explained. I was looking for this for a while thanks
Another valuable webinar 👍 thank you!
This webinar really helped me to understand the 3 main options to manipulate the resources in DevOps. I was wondering do you have the same options with Python library?. If it is can you share me the same examples with python lanuguage.?
I don't have the examples in Python, but you ought to be able to use this github.com/microsoft/azure-devops-python-api, although I am not sure how well this is maintained
@@tobiasfenster2164 Thank you for your reply and sharing the link. Yes, I am working on it need to understand first the library.