Related sites:
Newsletter: Perspectives on Power Platform
Company: Niiranen Advisory Oy
If you haven’t worked with CRM Online using Office 365 Global Admin rights recently, you might have missed the new delivery mechanism that Microsoft has created for additional CRM functionality not included in a new Online org by default: preferred solutions. Unlike the traditional solution import mechanism under the CRM application’s Settings area, these preferred solutions are both installed as well as updated (upgraded) via a miniature “CRM app store” controlled by and reserved for Microsoft exclusively. To access these preferred solutions you need to go to the O365 Admin Portal, open the CRM Online Administration Center, choose an instance and click the edit icon next to “Solutions”. You’ll be presented with a list like this one:
OK, maybe not exactly like this one, unless you work in the United States. You see, these preferred solutions are also targeted to preferred customers, meaning in practice CRM Online customers who use a tenant located in North America. Let me point this preferred region out to you from the Office 365 and CRM Online datacenter map:
The current availability of the preferred solutions is as follows:
Although not a CRM solution in technical terms, it’s also worth mentioning that the CRM App for Outlook which was released as US only preview last summer is now available to all CRM Online users who are on CRM 2016 version. I haven’t seen any upgrade time slots being scheduled for existing CRM Online customers yet, so currently mostly newly provisioned orgs can access the Settings – CRM App for Outlook menu to enable users for this lightweight successor to the “heavyweight” Outlook client of the past.
With all the goodies deployed in a CRM Online trial org in North America, this is how your CRM Nav Bar will look like with the new areas added for FieldOne Sky, Voice of the Customer and FantasySalesTeam:
Quite a lot going on there, don’t you think? We haven’t yet even installed the latest Microsoft XRM acquisition, Adxstudio, into our organization, nor done any customization for creating new entities to hold customer business process specific data and we’ve already got a whopping 4459 components in our CRM organization’s default solution, including 264 entities visible via the customization UI. Knowing that at the last time Shan McArthur counted them, Adxstudio Portals included 155 entitites when installing all the vertical solutions into a single CRM instance, we’ll be pushing beyond four hundred entities in a Dynamics CRM Online environment before deploying anything that’s custom or ISV produced.
This ain’t your grandpa’s customer database anymore, that’s for sure. Back in CRM 2011 days, which was only five short years ago, the world looked very different through the eyes of a Microsoft business consultant. Check out my 5 year blogging retrospective if you want to enjoy a more scenic trip down the memory lane, but for now let’s just focus on the expanding CRM schema. During a recent migration project I ran into a document from MS that included a comparison of the database complexity between Siebel and Microsoft Dynamics CRM. At that point, CRM 2011 was stated to have less than 200 database tables, whereas Siebel 8.1 was a monstrosity consisting of more than 2000 tables. We of course have to keep in mind that the actual table count is higher than the number of visible entities in Dynamics CRM, and that many of the system entities are not something that a user will ever encounter in the CRM UI. Anyway, the rate of growth in entity count for a Dynamics CRM environment with standard Microsoft functionality is quite impressive.
Does the entity count matter? Purely in itself, not really, as it’s just virtual table structures in a database management system that doesn’t have any feelings towards what’s “too little” or “too much” when it comes to the amount of bits. It is, however, an indicator of important changes that are taking place around the CRM platform:
As detailed in my earlier “XRM Strikes Back” post, I believe the success rate for this type of applications is going to be higher than when trying to build integrations and connectors between separate data silos. If we want to push CRM to the next level and really start to build systems that help companies achieve better Customer Engagement, then things aren’t about to become any simpler as the number of channels and amount of data types we need to work with keeps growing in exponential fashion. For some great insight on CRM’s role in the new CEM/CX jungle, go and read Paul Greenberg’s definition on how these three acronyms need to be positioned, as well as his list of 18 customer engagement technologies that companies need for supporting their CEM strategies. While they most definitely can’t all be built into one monolithic system, it’s equally obvious that we can’t know in advance what specific bits and pieces different organizations need when engaging in continuous interactions with their customer base. We therefore need the flexibility to configure and adjust these processes as the expectations for the engagement paths evolve, and achieving this agility requires not a set of products but a business process platform – like XRM, for example.
If the destiny of these central platforms is to expand in their coverage of channels and processes, it means we’ll need to develop the skills & strategies to cope with this change. Thinking about the example of preferred solutions now offered as optional components for any Dynamics CRM Online environment (and eventually on-premises, too), clearly not every customer organization is going to need all the components, but that doesn’t mean they wouldn’t gradually become a part of the package we think of as Dynamics CRM. Below is a list of the entities you have after installing the solutions (click for a larger version):
I bet this would make a great drinking game for CRM consultants: “Default or Custom?” You pick the name of an entity and the players must tell whether it comes as a part of CRM delivered by Microsoft or if it’s a custom created entity.
Continue until the bottle is empty, then launch Dynamics Marketing and crack open a new bottle of vodka… But seriously, there’s going to be a lot of work ahead of us to learn what might come as an OoB feature and how to align these with custom entities. For example, let’s assume an organization has integrated payment data from their financial system into their CRM account profiles. Then along comes FieldOne Sky and these new “Payment”, “Payment Details”, “Payment Method” and “Payment Term” entities appear in the CRM data model. What are you gonna do? I don’t have an answer nor recommendation for you at this point, but it just goes to show that we all better start educating ourselves on what these new preferred solutions have to offer.
Great piece thanks Jukka, the CRM landscape is certainly expanding.
We’re heavily into the FieldOne Preferred Solution and have been for two years before the FieldOne purchase. This is a great extension and we even have our own Accelerator, Portal and Survey solutions to extend FieldOne service management even further.
We’re happy to “Field” any questions on FieldOne !
Missing Canadian DC 🙂
Shh, better keep quiet about it, since obviously that DC doesn’t fall under “locations Microsoft has elected to disclose to the general public”.
Hi Jukka, great article. I think the restriction of Insights to North America is related to a commercial licensing agreement between Microsoft and InsideView, rather than a limitation of quality. In the UK, for example, there is much more information available about all private companies, and InsideView presents this to UK customers. Hopefully Jujhar will do a global deal soon.
[…] to our updated dashboard now. As a starting point I have a CRM Online demo environment from my previous post regarding “preferred vendor solutions” offered by Microsoft. As you can see, one of these solutions (probably FieldOne) has turned the […]
Agree with alot of this, data tables do not so much matter [although performance is improved in querying data by having to go through fewer relationships.] The main issue i have today with MS Dynamics is about scaleability and performance, when data volumes increase and you have many automated/partially automated business processes running off of it. My experience tells me that CRM just won’t support that level of data driven automation where large data volumes and numbers of processes are involved and are run from CRM. When i have done this in the past ,it has significantly affected the users experience and overall performance. You cannot continue to keep throwing RAM/Processing capability at your on premise installation and ever growing database it only works to a point. As such i am having to find some very creative ways to form IT architecture around Dynamics CRM so i can leverage the nice easy to maintain none coded features of Dynamics CRM [where the real business value still lies] while supporting process automation and analysis of large volumes of data especially when that data is written directly from addons to CRM. Solutions i consider to achieve this include multiple crm servers for differing business purposes/processes and integration between them as necessary [you also need to maintain master data between them and other business sytems], Datawarehousing and analysis outside CRM [do the number crunching elsewhere to simplify data structure in CRM just so we don’t choke the thing up querying data. For example, multiple storage formats of data for various purposes that consider its validity over time e.g. monthly, quarterly, annual data rolled up in differing entities/tables so we don’t have to query just monthly records to create trend reports to utilise CRM charts and dashboards fully [you cannot just keep increasing the querying limits when data volumes increase too much]. This is very expensive to develop and manage and requires serious technical expertise, this seems to be against the entire Microsoft strategy of adding more and more non coded admin functionality [dont get me started on performance issues around real time workflows ;-)]. To optimise CRM performance more and more you have to really focus on your data model and optimise as much as possible. No unnecessary tables, relationships and no unnecessary data. I would really hope Microsoft would invest in solving these issues because continuously adding functionality and addons that are writing more and more data to the CRM database will make an already serious problem worse. My strategy nowadays is to avoid that at all costs and format data into suitable format elsewhere and do all number crunching outside CRM before writing it there and also deleting data when it becomes obsolete [performance and cost saving reasons]. This is not very sustainable and is a serious limiting factor when i consider adopting Microsofts recent addons such as marketing and social listening let alone the others they are aquiring. I want these addons nicely integrated to crm in terms of data and usage without impacting performance. Microsoft need to address the underlying scaleability problems both online and on premise installations before i would ever consider taking large volumes of data to crm for process automation again. This seriosuly limits my desire to purchase more Microsoft addons for CRM. If they don’t scale and you need to make complex architecture to handle the problem why wouldn’t you just go and buy a third party tool [that is usually better] and integrate it to your CRM according to your own needs?. Also having this “Bolt on” strategy means you do not get tied to one service provider and can easily “cut and paste” tools into your existing IT architecte (if planned well) and even your CRM solutions. You can probably tell i am back on the customer side these days 😉