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

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)?

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

New to Salesforce? The Ups and Downs of Chasing Certifications

Chasing Salesforce Certificates

Salesforce professionals will tell you the importance of obtaining and keeping certifications. Certifications demonstrate a set of skills and knowledge that are valuable to peers or potential employers. For an organization, the process of obtaining and maintaining certifications ensures that the holder understands best practices and is up to date with changes to the platform. In short, a certification should demonstrate that the holder has a true grasp of the subject material. However, that is not always the case. The single-minded pursuit of certifications puts the focus on passing a test; often, the knowledge gained doesn’t translate into functional knowledge … Read More

Quote 2 Cash Consulting: What’s Missing

Change is a process

In today’s consulting world there is a relentless focus on the Quote 2 Cash (Q2C) Ecosystem. This focus has brought to the forefront the need for all companies to look across the spectrum of their business and align their processes and technologies to achieve maximum agility and velocity for ever greater customer experience and revenue growth. Company owners and executive teams have finally realized that the silo mentality and approach does not work allowing the company to function as a cohesive and efficient unit. The Q2C Ecosystem is approached, described, and deciphered slightly differently based on which consulting firm you … Read More

Sharing Salesforce: Be a Multiplier

Thinking about sharing Salesforce with someone who is looking to “skill up for the jobs of the future”? Join in the Be A Multiplier movement. It is a great way to pay it forward, to blaze a trail for others to follow! Think about how you got your start in Salesforce. Likely, there was someone who had your back, encouraging you every step of the way. They were a Multiplier, willing to teach and reach others. You see, when you love what you do, people can tell. You’ll be telling everyone about it – even if you don’t realize it! … Read More

Does the SYS user really become inaccessible in Oracle Database running on Amazon Web Services (AWS)?

Is the inaccessibility of the SYS user on Amazon Web Services (AWS) Oracle only on Relational Database Service (RDS) implementations?

I had heard from a fellow DBA colleague that a known problem with Oracle Databases on AWS was that, in certain cases, the SYS user was not available to the DBA. Curious (and slightly alarmed), I did a little research online and discovered more than a few forum posts asking what to do about the apparent inability to execute common DBA tasks as SYS running Oracle Database on AWS. DBAs who were accustomed to being able to run DBMS_CRYPTO or install APEX from the command line were wondering how to get their work done in the cloud. In response, AWS had … Read More

Between a rock and a hard place: How does Oracle bug 28793062 affect Banner schools’ plans to upgrade to 18c?

Ellucian rescinded support for 12.2.0.2, AKA 18c due to a severe defect.

12.2.0.2 was renamed 18c following Oracle’s new naming convention. “18” for its 2018 release (cloud: 18.1.0 in 2/18 and on-premises: 18.3.0 on 7/18). In October of 2018, Ellucian rescinded support for 12.2.0.2, AKA 18c due to a severe defect. Some PL/SQL procedures in Banner including arguments based on table%rowtypes would no longer compile, complaining that a “PL/SQL package with user-defined type is throwing PLS-00801: [Unexpected Fragile External Reference.])”… and there was no workaround. Ellucian’s rescission of support for 18c with Banner came at a tricky time for schools. IT departments were already feeling pressure to stay on top of upgrades … Read More

Visit Us at Mid-Atlantic Banner User Group, 2018

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