Liberate your data

Intelligence is all about knowledge. This website is dedicated sharing expertise on Oracle BI. More »

 

7 Reasons Why Companies Migrate to Azure Cloud


 

According to an article by Forbes.com, 23% of IT workloads are now in the cloud, and that number is expected to grow to 43% in three years.

 
Companies across the globe are scrambling to take advantage of the benefits of the cloud and that includes making difficult decisions about which cloud vendor has the most to offer. All organizations big or small experience unique sets of requirements and challenges which may benefit from a different cloud provider. It can be a difficult landscape to navigate.

In early 2020, CNBC reported that Microsoft continued to lead the pack as one of the most popular suppliers of public cloud services, especially with larger companies. It touts more than 50 regions around the world and offers an appealing free 12 months of service for new customers (restrictions apply). And, of course, it is backed by one of the largest corporate enterprises in the world.

But that’s not the only reason IT organizations are flocking to Azure. Here are the seven main reasons companies choose this versatile platform:

  1. High Availability: Microsoft has a significant global footprint which means Azure can provide a Service Level Agreement (SLA) of 99.95% for its customers. If your company has hundreds of worldwide locations or even just one obscure location, Azure might be the right way to go.
  2. Existing Microsoft Investments: Large companies that are already using Microsoft products usually have an existing Microsoft Enterprise Agreement, which means they receive discounts on bulk licensing and other cost-saving benefits. They are also likely already developing in .NET and using other Microsoft platforms like SQL Server and Office 365 that easily integrate with Azure.
  3. Hybrid Flexibility: Azure offers unmatched flexibility for small or large companies that may not be ready to go all-in on the cloud. Companies can pick and choose which databases and applications provide the best cloud benefits, while remaining on-premises everywhere else. This “pay-as-you-go” design allows companies to manage their Azure consumption, and only pay for the services they use. Another way to test the waters before diving-in completely is via a pilot project. These are usually easy to run so organizations can test their cloud-readiness in specific areas before making a final decision.
  4. All-in-One IaaS, PaaS, SaaS: Azure offers Infrastructure, Platform, and Software-as-a-Service capabilities, making it extremely versatile. Customers can migrate their entire infrastructure to Azure, develop and host applications and software in Azure, or access and configure Microsoft SaaS applications in Azure – or any combination of those three options.
  5. Continuous Innovation: As of this writing, Microsoft has built over a thousand new capabilities in Azure  in just one year, keeping it on the cutting edge of analytics, artificial intelligence, and virtualization. This includes innovations in machine learning for IT Ops, updates to Azure Resource Manager (ARM), greater storage efficiency, and the soon-to-be-released Azure Chaos Studio. You can follow their blog to stay up to date on the cutting-edge changes and releases.
  6. Unlimited Scalability: The Azure cloud platform provides hyperscale relational databases and a fast NoSQL database with open APIs for any scale. This includes high-performance horizontal scaling on Postgres using Hyperscale (Citus), integration with valuable Postgres features including JSONB, geospatial support, rich indexing, and dozens of extensions, and intelligent performance recommendations generated from a custom analysis of your database. This elastic framework provides the infrastructure companies can leverage to scale to meet increased user demands.
  7. Instant Insights: Azure combines big data analytics and data warehousing—from serverless or provisioned resources—through a single, cloud-native analytics service, delivering critical insights for businesses. You can innovate with the latest advancements in areas including machine learning, AI, databases, and virtualization.

 

In addition to all of these benefits, it’s also a cost-friendly option with many available resources to help manage your usage and spend. And, of course, there’s the standard cloud benefits of mobility, accessibility, flexibility, reduced infrastructure costs, and regular platform updates.

With so many upsides, it’s easy to understand why Azure continues to move towards the front of the pack.

Read This Next

5 Companies That Solved Common Challenges with Azure Cloud

In this white paper, you’ll learn why Microsoft Azure is the cloud platform of choice for so many organizations. You’ll also learn why, as a flexible, scalable cloud service, it also comes with many roadblocks that are difficult to anticipate.

The post 7 Reasons Why Companies Migrate to Azure Cloud appeared first on Datavail.

How to Simplify Your Data Integration by Moving to the Cloud


 

Are you struggling to integrate your enterprise data sources into an efficient, centralized location for reporting and analysis? You’re not alone—so was one of our recent clients until Datavail gave them a helping hand.

 
Datavail’s client is one of the world’s leading manufacturing and services companies, with more than 60,000 employees across 200 countries and territories, and with products that 2 billion people use every day. The client’s primary impetus for working with Datavail was the need for a singular view of their customer relationship management (CRM) data; each regional branch was using their own CRM software, creating a fractured ecosystem that lacked a global, unified perspective.

Moving to the Microsoft Azure Cloud for CRM

As an existing Microsoft customer, the client used the Microsoft Azure cloud for this project. Datavail was the ideal Azure cloud migration partner, with Microsoft Gold Partner status, copious years of working remotely and across time zones, and a 24/7 hybrid onshore/offshore business model.

Datavail helped the client adopt Microsoft Azure cloud technologies such as:

  • Azure Data Factory: Microsoft’s cloud-based solution for ETL (extract, transform, load), integrating data from unique sources and storing it in a single centralized target location.
  • Microsoft Dynamics 365: Microsoft’s cloud-based CRM and enterprise resource planning (ERP) software, leveraging artificial intelligence to deliver smarter business insights.

 
In addition, Datavail helped the client switch their use of ETL software from a proprietary tool with a steep learning curve, to KingswaySoft, which uses standard SQL commands and has connectors with many data sources and targets, including Microsoft Dynamics 365.

The client now enjoys lightning-fast ETL processes and marked improvements to the quality of their enterprise data. By applying Datavail’s Azure data migration expertise, the client’s data migration workloads—which once took 8 to 10 hours to run—are now half as long or shorter. Datavail also helped the client automate their post-load validation (PLV) processes to make sure data was correctly and successfully migrated during ETL.

From working with Datavail, the client has realized benefits including:
 

  • A unified CRM system in the Microsoft cloud.
  • Dramatically faster data migration times.
  • Simplified ETL stored procedures.
  • Uncovering hidden data tables that were part of the client’s ETL workflows.
  • Automating the post-load validation process.
  • Completing more than 1,000 agile tasks and fixing hundreds of bugs for the client.
  • Building a robust, complete set of documentation and templates for future collaborations with IT managed services partners.

Read This Next

Worldwide Manufacturing and Services Company Modernizes with Sleek New CRM

Want the full story of how Datavail helped the client achieve a modern, unified CRM in the cloud? Download the complete case study.

The post How to Simplify Your Data Integration by Moving to the Cloud appeared first on Datavail.

Single Sign-On (SSO) as an Essential Cybersecurity Practice


 

The rise of “password fatigue” as a real, documented phenomenon has shown that our current approach to enterprise IT security and authentication is flawed.

 
According to a 2019 report from Yubico and the Ponemon Institute, employees spend an average of 10.9 hours per year entering or resetting their passwords; this corresponds to a total annual loss of $5.2 million for the average organization. Meanwhile, Netskope’s 2019 Cloud Report has found that the average enterprise uses a staggering 1,295 cloud services.

Faced with the Herculean task of remembering too many login credentials, employees may engage in a number of undesirable practices. Some users may reuse the same password in multiple locations, increasing the risk of a security breach, while others may engage in “shadow IT” (the use of IT devices, software and services outside the ownership or control of IT) thereby undermining an organizations IT department’s security protocols.

What’s more, the COVID-19 pandemic has only increased the risk of cybersecurity issues. The Center for Internet Security’s “CSO Pandemic Impact Survey” found that 61 percent of security and IT leaders are concerned about an increase in cyber-attacks; and 26 percent have observed an increase in the volume or severity of attacks since the pandemic.  One recent reminder of this fact is the cyber attack on the Colonial Pipeline, which crimpled our fuel supply lines from Texas to much of the East Coast, equating to hundreds-of-millions of dollars in lost productivity.

Although there’s no shortage of solutions to the issue of password fatigue—including biometrics and password management software—one of the most popular options is single sign-on (SSO). Single sign-on is a cybersecurity best practice in which users only have to log in one time (hence the name) in order to access a suite of software applications or services.

The benefits of SSO include:

  • Ease of use: SSO is obviously attractive from an end user standpoint because it simplifies the login process. There’s no need to memorize 10 separate passwords for 10 different applications, and your session won’t expire if you haven’t used a single application in a while.
  • Lower IT burden: With telecommuting on the rise, many decidedly non-tech-savvy employees have been forced to act as their own tech support, diagnosing and resolving issues from home. Fewer forgotten passwords also mean a lower burden on your IT support team who have to help users reset their credentials.
  • Increased productivity: Less time spent logging in and out, and less time spent waiting for help from the IT team, means an increase in employee productivity. This can help organizations recoup potentially millions of dollars due to inefficient login practices.
  • Greater security: In addition to the monetary gain from productivity, businesses also need to consider the potential financial and reputational losses as a result of a cyber-attack. SSO helps improve IT security and decrease the risk of a devastating data breach.

 

Some organizations have the misconception that SSO actually weakens IT security by providing just a single point of weakness for an attacker. If a user’s password is exposed or cracked, the theory goes, a malicious actor could simply waltz into the application portal unopposed.

In practice, however, SSO improves IT security for multiple reasons. First, SSO can and should be used in combination with other IT security best practices, such as multi-factor authentication (MFA) and risk-based authentication (RBA):

  • With MFA, users need to authenticate their login via at least one other means, such as entering a code from an email or verifying with a smartphone authentication app.
  • RBA analyzes the metadata surrounding a particular login (such as the IP address, the device, the user’s location, and the time of day) to assess the likelihood that the login is fraudulent, alerting the user if it detects suspicious behavior.

 

There are several other reasons why SSO improves IT security within an organization:

SSO streamlines the login process, making it less likely that users will write down their passwords.

  • Thanks to this simplification, IT departments can also place more stringent requirements on password length and complexity, making them harder for attackers to crack.
  • SSO facilitates identity management (IdM), allowing organizations to create roles for users and groups of users that clearly define which applications and services they should have access to.
  • Employees’ login credentials can be quickly and easily restricted or terminated (e.g., when they depart the organization), lowering the risk of an insider threat.
  • More sensitive systems, applications, and data can be excluded from the SSO portal as necessary.

 

Looking to implement your own SSO portal for your existing cloud applications—or as part of an upcoming cloud migration? Datavail can help. To learn how we helped one client implement SSO as part of their Microsoft Azure cloud migration, check out our recent case study “Major Auto Manufacturer Migrates Application Portal to Azure Cloud.”

The post Single Sign-On (SSO) as an Essential Cybersecurity Practice appeared first on Datavail.

Why You Need an Integrated CRM Ecosystem


 

Customer relationship management (CRM) software is one of the most crucial applications for enterprise IT, helping businesses keep track of their contacts with vendors, leads, and clients.

 
91 percent of organizations with more than 10 employees now use a CRM—and the average return on their investment can be as high as $8.71 for every dollar spent.

Yet with many companies operating across multiple locations, regions, countries, and time zones, integrating all of your CRM data can be a significant challenge. Yet the results of a CRM integration project are well worth the time and effort. The benefits of an integrated CRM ecosystem include:

  • Creating stronger customer relationships and improved customer retention rates.
  • Identifying new opportunities based on customer feedback.
  • Developing better products and services through data-driven decision-making.
  • Making smarter sales and marketing decisions for different countries and regions.
  • Improving data quality by reducing data duplication in multiple locations.

 
In particular, a cloud-based CRM can offer advantages such as:

  • Lower costs: Migrating from on-premises to the cloud is also a move from a capital expense to a recurring operating expense; many businesses find that the latter is more cost effective. The cloud also frees you from the obligation of employing in-house staff for IT support and maintenance.
  • Greater scalability: Scaling on-premises IT is challenging without making another costly hardware purchase. In the cloud, however, you can scale your data or storage by leveraging the cloud provider’s existing resources.
  • Easier integration: Moving to the cloud makes it easier to integrate with other software, systems, and platforms.

 
With over 60,000 employees in 200 countries and territories, one of Datavail’s recent clients was struggling to integrate their fractured CRM ecosystem, with different systems in use at each regional branch. To find out how Datavail helped the client unite their CRM software in the Microsoft Azure cloud, check out our case study “Worldwide Manufacturing and Services Company Modernizes with Sleek New CRM.”

The post Why You Need an Integrated CRM Ecosystem appeared first on Datavail.

Stop Doing the Same Tasks Over and Over, Automate Instead!


 

Many IT leaders were trying to figure out how to address the mainframe talent shortage in 2020, and the situation is still a problem in 2021. One thing that has made a difference to many of the companies we work with is automating repetitive and mundane tasks that take your DBA resources time.

 

Sometimes, in the rush to keep everything running smoothly, IT leaders can overlook things that are easy to do but save a significant amount of time and improve service levels. Automating tasks that a software bot can do even more effectively than a human being is one of those things.

Repetitive Tasks Can Cause Big Problems

In today’s environment, business depends on its automation tools much more than in the past. If a database driving critical business functions has a problem, the repercussions go far beyond the IT department. And, if mundane and repetitive tasks aren’t performed well, IT can end up in a situation where the users know about a problem before it does, and that’s a situation IT departments really want to avoid.

Take Oracle EBS, for example. It drives critical applications, including ERP, CRM, and Supply Chain Management. You can imagine what would happen if one of those applications was down or not operating at peak efficiency. Here are just a couple of the problems you could run into if some mundane tasks weren’t completed correctly and on a timely basis.

  • Mundane Task: Monitoring concurrent managers and workflow.
  • Potential Problems: User requests will slow down, and some requests will return errors.
  • Mundane Task: Monitoring pending, long running, and errored tasks.
  • Potential Problems: Since users often fail to monitor the successful completion of their tasks, an errored task could result in the production of an inaccurate report that may be acted on by management.

How to Use Software Bots to Automate Repetitive Tasks

A software bot is a script written to automate a task. They’re not as complex as a chatbot, for instance. All a software bot must do is automate a series of steps and present the results to the person responsible for monitoring that task.

Let’s take daily health checks as an example. It’s a fairly easy task when only one environment is involved, but when you need to monitor multiple environments, the task becomes much more complicated but not more interesting. Daily health checks are prone to human error and take valuable time away from the person who is assigned the task.

Using a software bot, a report showing the health of the system can be presented at the start of every day. Rather than hours of logging in and out of multiple systems, the task becomes a few minutes of review. And, the report can be tailored to everyone who needs to use it. One report can contain the details for system engineers and DBAs and a high-level summary for management. We helped one of our clients take a manual check from one hour to 15 minutes, saving 22.5 hours per month.

Automating Tasks Gives You the Upper Hand

There are so many benefits to automating repetitive and mundane tasks that you’ll find your department spending more time doing high-value tasks and less time simply trying to keep your systems running at peak performance. Here are just a few of the benefits you’ll see:

  • Catching small issues before they become big problems. For example, you can have a bot monitor the status of request sets during month-end close activities. If a problem comes up, you can fix it before everyone involved in the close ends up in your office.
  • Eliminating human error. Ask anyone who has done manual checks for performance tuning, and they’ll tell you how time-consuming they are. Wading through menu trees and lists of SQLs makes this manual task prone to human error, regardless of how diligent you are.
  • Receiving automated alerts or trouble tickets. In Oracle EBS, for example, monitoring concurrent managers is a complex task. But, you can use a software bot to do that for you. The bot can send you an alert or generate a trouble ticket automatically if problems are spotted.

 

You’ll also see global advantages. You’ll increase the service level you can provide to your users. You can also offer more challenging work to your talented staff to motivate them to stay on the job. And, you’ll make your life easier, which is sometimes an elusive goal.

Next Steps

Datavail provides expertise that can give you the upper hand. We’re an Oracle Partner, and we can perform Oracle EBS upgrades, help with special short-term projects, and provide managed services. We also have extensive experience helping clients set up automation for their EBS environments.

Read This Next

Automate These 7 Oracle EBS Tasks to Save Time and Improve Productivity

Download this white paper to learn how you can employ software bots, which are programs that accomplish repetitive or mundane tasks without intervention, in your own Oracle EBS environment.

The post Stop Doing the Same Tasks Over and Over, Automate Instead! appeared first on Datavail.