Is a "pure" development platform?

We are looking to build an internal CRM system and are currently examining tools available in two main categories:

A - "Pure" development platform, for example Access + SQL. Application design (including the data model) and implementation are completely under the developer's control.

B - "You can customize our data model and (seemingly) retain control, but in the end, you are tied to ours". Under this platform, I'm assuming that once you attempt to deploy, you end up paying the license fees as outlined under one of the standard editions (e.g. in which case it isn't truly free for life as the Developer Edition of claims to be.

I am not certain where falls. After creating a test project with several tables and playing a bit with the Developer Schema, I was feeling confident it fell under category A. Then I had a meeting with my boss who said he suspects it's actually B.

I don't want to go into the details of the application itself and its purpose, as I'm not looking for platform advice. I just want to clarify what we'd be "signing up for" if we decided to undertake the project with

Cathy Munsen
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

While I think your comparison of (Access + SQL) -v- Developerforce is somewhat unfair, I would place into category B.

A more 'level playing field' comparison in my mind would be Azure -v-; both are cloud based and both closer to your "pure" development platform example.

But you open with: "build an internal CRM system"

if it's internal (only) then why look at cloud?
perhaps you meant "custom" to meet internal requirements

if it's CRM, then leveraging might make sense.
the point of the platform is that you have prebuilt CRM functionality that you may configure to specific needs, and the claimed advantage from that is speed (i.e. get to the end quicker).

I'd suggest you need to decide if you need/want cloud based services in the long term first. If this answer is yes, then choose the "Platform as a Service" (PaaS). The point is that your organization will be paying for the cloud services for as long as they use the solution as operating expense.

If the answer to cloud is no, then there will be a different set of platform choices open to you, and the overall cost model will differ as well (e.g. capital for infrastructure, staffing and so on).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Shalom CarmelCTOCommented:
Definitely B

You will be tied to the application servers and eco system of the vendor.
This is not necessarily a bad thing - just something to be aware of.
An application developed on the platform cannot be ported to run elsewhere.
CathyMunsenAuthor Commented:
Thanks to both of you for timely and clear responses. Yes, I did mean "custom" to internal requirements for a solution that will require external access (e.g. for work@home employees). My head is admittedly swimming with the possibilities, though you've both given me solid feedback to consider.

Thanks for the grading, good luck with the project. Cheers, Paul
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.