SharePoint Data Integration CASE STUDIES

1000+ companies trust Layer2 connectors to manage their business critical data and file migration, backup and integration. Learn more about their specific business cases and how they have solved it with the help of the Layer2 Business Data List Connector.

User Story

At WealthVest Marketing we are currently using a legacy CRM system (due to be replaced next year) which is severely limited in its expandability and does not support master-detail relationships or other important entities outside of contacts. Our business model is quite complex and we do quite a bit of SQL/DBMS processing combining the CRM data and other data we import for agency management, as well as our own custom tables. It is these latter tables, which contain details of business deals, sales hierarchies, marketing program information, etc. that are used to drive critical business reports and processes such commission processing that we would use Microsoft SharePoint lists for.

SharePoint external data integration to maximize the leverage of the existing platform  

The current situation is that IT is required to setup these tables and manage their data. However, this is data that really should be owned and managed by the business. The consequence of this situation is that the business is not even aware of this data and often it is out of date and incorrect, leading to much rework at times, consisting of emails back and forth and IT managing the data through the back end. Not very efficient to say the least. “My IT philosophy is that it is IT's mission to provide systems to empower users. At the same time, being of very limited resources, we have to be extremely vigilant about what technologies we adopt and maximize our leverage of existing infrastructure so as to save in purchasing, development, and maintenance costs. It is very important that we do not become a software development company”, Dan Goldman, Vice President IT WealthVest Marketing, Inc. describes the current state.

Layer2 Business Data List Connector for SharePoint is ready-to go in just seconds

This is where the Layer2 Business Data List Connector for SharePoint (BDLC) comes in. By using the BDLC we can provide a simple, easy-to-use, and familiar interface (native SharePoint lists) to manage mission critical business data. We will not need to adopt new technologies, learn new development environments, or program. We have a ready-to-go out-of-the-box user interface that takes seconds to setup, requires no user training, and addresses our immediate business data management needs. Our business users including Sales, Operations, Marketing, and even IT can now own and manage their own data, ensuring its integrity, all the while making it immediately available to IT for mission critical reporting and business processing.

Ready for the next steps?