I was employed as a business analyst in a small company who was running everything on spreadsheets, and they needed a system. I assumed that I would draw up the specification documents and work with a software development house to develop the required system. Unfortunately, the shareholders and board of directors are not willing to spend a lot of money on a system, as they do not turn a huge profit yet. So they asked me to come up with an alternative.
While I am drawing up the specification, I am considering my options.
Dataverse and PowerApps are my first choice since it is low-code. But I am scared that it will be too limiting. I don't know how powerful these are and I don't have anybody that I can discuss this with.
I am currently busy with the database diagram and dictionary, and we are already at more than 150 tables. There are many parent-child relationships.
If this was your decision, would you go with Dataverse and PowerApps? Or should I rather look at building the DB in SQL?
Please note: I am not a developer. I used to code 30 years ago in Cobol, so any new coding language will be a huge challenge to me.
I wish I could sit and have coffee with a person who know a lot about both Microsoft worlds to get some advice. What are your opinions?
Good morning @hildasteyn , Dataverse and PowerApps are very very powerful and you can build enterprise solutions that are very reliable and effectives. Note that Dataverse is not only a data base, it is way more than that.
You get OOB all the security infrastructure and business rules layers in addition to the amount of integration you can accomplish with external data sources and systems.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2