We care and want to help

Brandon JonesNews and Updates, Notes, OfferingsLeave a Comment

Help for your organization during COVID-19 Corona Virus

How are you feeling? Do you and your organization have what you need? We understand that the current situation has likely given rise to additional stresses and concerns for you, your family, your community, and even your organization. We’ve been working under the same pressures and wanted to give you some updates on M&S. Although this situation is certainly unique, the ability to work remotely isn’t new to us and we are happy to leverage our experience to help you through the transition. We’ve worked hard to equip our team with an established and robust infrastructure that has been successfully … Read More

Develop a Better Data Sharing and Integration Strategy

Brandon JonesBig Data & BI, Business Strategy, Higher Education, OfferingsLeave a Comment

Build a better data integration and sharing strategy

Today’s higher education institutions are facing a multitude of challenges around data analysis, security, and increasingly hybrid architectures. The issue of how to balance ongoing security challenges while connecting cloud and on-premises applications is common across institutions. These challenges may lead many organizations to develop an integration strategy to help in the alignment of these increasingly complex architectures. However, limiting the focus to only integrations can become overly technically focused. Instead of developing an integration strategy, institutions should instead take a holistic approach to data sharing and develop an information strategy.  As information is a valuable asset for organizations and … Read More

Taking Advantage of Our Higher Education AWS Standard Plays (Begin Your Journey to the Cloud)

Brandon JonesBusiness Strategy, Cloud and Virtualization, Higher Education, Identity & Access Management, News and Updates, OfferingsLeave a Comment

M&S helps direct you on your journey to the cloud

Is your institution moving to the cloud? Are you adopting a cloud strategy, such as Cloud First, where the institution takes the plunge and jumps in with both feet, or perhaps an Opportunistic Cloud or Experimental Cloud strategy where they test the waters with select projects? Perhaps your institution has instead elected to stay out of the cloud entirely and to simply watch from a distance. Each of these strategies can be appropriate in the right context, but adopting a cloud strategy that works for your institution should be a priority. With any of these strategies, you need to ensure … Read More

What is RPA (Robotics Process Automation)?

Brandon JonesBusiness Strategy, Offerings, Technical TipsLeave a Comment

What is RPA? Robotic Process Automation (RPA) is a productivity tool/software technology that enables organizations to automate manual tasks, helping to create efficiencies, freeing up resources from dull, repetitive work to concentrate on other more complex tasks and increasing productivity. RPA exceptionally well suited for high volume, repetitive, rule-based tasks with limited need for human intervention. Depending on the RPA vendor, RPA automation scripts are referred to as robots or “BOTs”, or a “BOT” is the one executing the RPA automation scripts. For large volume processes, there can be multiple BOTs executing an automation script. For low volume processes, one … Read More

Visit Us at Mid-Atlantic Banner User Group, 2018

Brandon JonesEvents, Higher Education, Industry Trends, News and Updates, OfferingsLeave a Comment

M&S is proud to be a MABUG (Mid-Atlantic Banner User Group), 2018 sponsor! In addition to helping sponsor the event, we will be presenting on a framework M&S Consulting’s Higher Ed practice has been working to perfect: Using a Common Data Model (CDM) intermediary to integrate diverse campus systems leveraging APIs. Our team that will be attending MABUG, Kate and Tak, have decades of experience in Higher Ed tech and are excited to be in the middle of all the excitement October 14-16 in Fredericksburg, VA. If you’re going to be there we would love for you to come and say hi … Read More

How to Bypass Validation from Apex Across Objects [Salesforce]

Brandon JonesOfferings, Salesforce, Technical TipsLeave a Comment

If your Salesforce org has Triggers and Apex, you’ve probably run into the issue of hitting Validation Rules (VRs) when your Apex code tries to insert or update a record. The example below is across two objects and how you can solve for it. Let’s say you have an object called Positions and another object called Applicants. There is a lookup field on Applicants to the Position object. On the Positions object, you have a date field called Last Interview Date to identify the latest date an applicant was interviewed. Due to the relationship between Applicants and Positions only being … Read More

A Work-Around for Salesforce Bulk API v2.0 (in Dell Boomi)

Brandon JonesOfferings, Salesforce, Technical TipsLeave a Comment

Summary: Salesforce Bulk API Usage, though it offers performance benefits over regular APIs is a scarce resource for organizations. It is important to conserve and optimally use the Bulk API. ——- The Dell Boomi Salesforce connector does not support the Bulk API v2.0 (which essentially makes a determination automatically whether to use the regular or bulk API) at the time of writing. This feature is sought-after in the forums since organizations hit their Bulk API usage limits frequently. Processing much lower volumes of documents through the Bulk API (Bulk API accepts 10,000 documents in a single go) may be a wasted … Read More

A Guide to the Changes at the Analytics and Data Summit 2018 (Formerly BIWA Summit)

Brandon JonesBig Data & BI, Events, News and Updates, Offerings, OracleLeave a Comment

Changes at Analytics and Data Summit 2018 (Formerly BIWA Summit)

What a year for the BIWA User Community and Oracle Spatial & Graph Special Interest Group (SIG)! Both groups have expanded their leadership teams, as well as rebranding and moving the date of their flagship event, the Analytics and Data Summit (formerly known as the Oracle Business Intelligence, Warehousing, and Analytics (BIWA) Summit.  As a new member of the board of both BIWA and the Summit, we wanted to let you in on the exciting changes, and what they mean to you. The BIWA User Community was founded in 2006 as a special interest group (SIG) of the Independent Oracle User Group (IOUG) … Read More