Tag Archives: blog

Exploring the Possibilities of Babelfish for Aurora PostgreSQL


You want to use the powerful AWS platform, but your organization is too invested in Microsoft SQL Server applications or lacks the resources to migrate legacy databases. The good news is that you don’t need to choose between the two technologies or go through a painful re-architecting process if you use Babelfish for Aurora PostgreSQL.


Imagine if you can have PostgreSQL Aurora as your database backend but:

  • You can continue to use your legacy application code written for the SQL Server
  • Your client driver continues to be related to the SQL Server
  • All your new developments can be written directly to the PostgreSQL Aurora


What is Babelfish for Aurora PostgreSQL?

AWS services like the schema conversion tool (SCT) and the database migration services (DMS) can be used for migrating existing SQL Server schema and data to Aurora PostgreSQL but it is often more effort and time-consuming tasks for migrating application code to be compatible with Aurora PostgreSQL.

Amazon recently released a new AWS service called Babelfish that acts as a translation layer. When you use it alongside an Amazon Aurora PostgreSQL instance, you can have the database understand the Microsoft SQL Server application commands. This translation layer places a significant emphasis on correctness and data fidelity, so your applications work the same as they would in their original environment. Babelfish is also available as an open-source tool with an Apache 2.0 license.

Babelfish works by translating T-SQL, the specific SQL dialect that Microsoft SQL Server uses, and it supports that technology’s communications protocol. It also includes stored procedures, data types, cursors, functions, triggers, and catalog views used by SQL Server. Babelfish supports applications that are based on SQL Server 2014 and up.

You only have to make a few code changes to your SQL Server applications with this layer in place. This functionality is exceptionally helpful when you have legacy applications you’d like to migrate to the cloud because of the time and effort involved in rewriting application code.

Babelfish is included in your Amazon Aurora subscription, so you pay nothing for this service. Setting it up is a simple process and takes place within the Amazon RDS management console. You still need to take your SQL Server data through a migration process, but you can use AWS Database Migration Service (DMS) to quickly move your data and schema to the new instances.

The Benefits of Babelfish for Aurora PostgreSQL 

Using Babelfish for Aurora PostgreSQL transforms your legacy SQL Server database and application migrations in many ways:

  • Speeds up migrations: You eliminate an especially time-consuming database migration step when all of your applications need only minor changes to use Aurora. You can get up and running on the new platform at a much faster pace thanks to the reduced complexity of this process, alongside helpful automated tools such as DMS to streamline the rest.
  • Reduces the risk of migrations: The fewer changes you need to make to your SQL Server applications, the less likely it is that errors occur. A less complex migration process also controls risk since you have fewer moving parts that could cause a problem.
  • Lets you use your current tools: You don’t have to switch many of the tools you currently use with SQL Server. Babelfish uses PostgreSQL’s APIs, so you can continue to use your tools post-migration.
  • Decreases your development team’s workload: Your development team can focus on creating new applications for the cloud rather than spending their valuable time rewriting legacy software.
  • Reduces migration costs: The full cost of your SQL Server to Aurora PostgreSQL migration is kept under control when you no longer need to rewrite existing code bases. You also get to move away from SQL license fees with this AWS service, which can be a significant expense.
  • Freedom to migrate and innovate: Once you migrate to Babelfish for PostgreSQL Aurora, you can continue converting SQL Server modules/codes to PostgreSQL compatible at your own pace. In parallel all your new functionalities and developments can be on PostgreSQL code side-by-side with your current T-SQL code.

Getting the Most Out of Your SQL Server to Aurora PostgreSQL Migration

Moving from on-premises SQL Server databases to a cloud-based Aurora PostgreSQL instance is a big change. To ensure that you’re maximizing the value of your cloud investment, work with an experienced AWS specialist like Datavail. We have over 1,000 DBAs and data experts ready to help you along your cloud journey. Contact us to learn more.

Read This Next

Amazon Aurora Optimization Offer

As the complexity of modern database deployments increases more enterprises are deploying MySQL and PostgreSQL within Database as a Service (DBaaS) environments such as Amazon Aurora.

The post Exploring the Possibilities of Babelfish for Aurora PostgreSQL appeared first on Datavail.

Top 6 Features of Oracle Cloud Financials


It’s been almost a decade since Oracle Cloud ERP hit the stands in 2012. As one of the earlier cloud service options for the financial industry, it has built up an eclectic client base over the years from SMBs to major institutions like Thomson Reuters and Bank of America. Within Cloud ERP, there are nine modules companies can invest in, each of which provide different services to different business units across an enterprise.

Today, we’ll discuss Oracle Cloud Financials, a widely used module that modernizes accounting and speeds the pace of financial processes for companies across the globe. Cloud Financials enables organizations to close the books faster, process invoices with simplicity, manage revenue, and improve cash flow all from one application. But how? Let’s look at the top six features of Oracle Cloud Financials that deliver the biggest business benefits.

1. Close Manager

Reducing the monthly close cycle is top-of-mind for most financial professionals – and Oracle Cloud Financials can help speed the process. Close Manager offers a visual representation of the close process from start to finish across the entire organization. It automatically identifies subledgers that are not closed and employs real-time monitoring to identify changes in account balances. The account monitor also compares existing data against a baseline to identify any anomalies that might exist so you can step in and manage them.

2. Touchless Supplier Invoice Processing

Cloud Financials takes the strain out of processing invoices. With touchless invoice processing, Intelligence Document Recognition (IDR) completes and validates your invoices using the latest recognition technology. In addition, you receive real-time alerts notifying you of any issues or exceptions that might come up in the process. A comprehensive display of all transactions and single-click approvals or releases relieve you of the time and effort of sorting through these invoices one-by-one.

3. Self-service Customer Billing

These days, customers expect a seamless billing and paying experience that can be completed with minimal effort. Cloud Financials offers a self-service solution where customers can manage their accounts, view bills, and contact customer service all from the comfort of their digital device of choice. From the organizational side, you can highlight notable transactions directly in the work area and use the credit management portal to look up customer credit profiles and reviews.

4. High-performing Collections

Digging further into customer analysis and billing, Cloud Financials allows you to score your customers based on their ability to pay. From there, you can automate your payment request letters and calls to collections agents. You can also assign automated and manual tasks to put your collection strategy into action. See all of your collections data in one place in the collections manager dashboard where you can pull your most valuable KPIs and assess the health of your receivables.

5. Expense Matching

This might seem like a small feature, but it packs a big punch. With expense matching, your application prepopulates expenses originating from credit card transactions so it’s easy to then match them with the corresponding receipts. You can also enter receipts using an iPhone or Android, or use the digital assistant to enter them using voice or text.

6. Fast Reporting

Good reporting is the hallmark of good financial management. Without reports you can rely on, you run the risk of delivering data to your executives that doesn’t reflect the challenges and successes your company is experiencing. Cloud Financials delivers reports with pre-aggregated financial information that can be viewed from a configurable and customized dashboard. You can analyze general ledger account balances across multiple dimensions and use several chart types and interactive tools to view the data. And, of course, as is standard this day and age, you can view your reporting from your mobile device.

Final Thoughts

As a popular module of the Oracle Cloud ERP suite of applications, Oracle Cloud Financials has a lot to offer organizations of all sizes. From faster invoice processing to automated expense matching to comprehensive interactive dashboards, this cloud software can deliver business benefits that are worth the investment.

It’s one thing to read about the upside of Oracle Cloud ERP applications – it’s another to see it in action. One Datavail client that invested in Oracle Cloud Financials was able to speed financial processing, automate data capture, and increase the security of their financial data simply by asking our experienced ERP team to set up features and modules of the software they didn’t know how to implement. This situation is common and leaves companies with tedious processes that could be easily ameliorated from within their own application.

To read more about this story and learn how you can take full advantage of your cloud applications, download our case study, “Community Lender Improves Process Speed and SOX Compliance with Oracle Cloud ERP.”

If you’ve made the move to Oracle Cloud ERP already, you likely already understand the value of each of these application features. If you haven’t, you have a few additional reasons to make the move. Regardless of whether you are pre- or post-implementation, Datavail’s Cloud ERP Team can help. Contact us to discuss how we can help you make the most of your investment.

The post Top 6 Features of Oracle Cloud Financials appeared first on Datavail.

Why Companies Are Moving Their Analytics to Oracle Cloud


More and more organizations are moving their analytics to the cloud—and Oracle is one of the most popular destinations. In a November 2020 ranking by Cloud Wars, Oracle was the second fastest-growing cloud vendor with an estimated quarterly revenue growth of 33 percent, behind only Google Cloud.

Looking to move your own analytics workflows to Oracle Cloud? As an Oracle Platinum Partner, Datavail has the skills and experience that companies need to make their next Oracle cloud analytics migration a success. Below, we will go over the benefits of running analytics in the Oracle Cloud, as well as some tips, tricks, and best practices for an Oracle cloud analytics migration.

Data Architecture

Source: https://docs.oracle.com/en/solutions/oci-curated-analysis/img/analysis-enterprise-and-streamed-data-architecture.png

The Benefits of Analytics on Oracle Cloud

Choosing the right cloud analytics partner is an essential part of a successful migration—so why Oracle Cloud? Migrating analytics to the Oracle cloud has the following benefits:

  • Lower IT costs: By saving money on expenses such as on-premises hardware, software licenses, and ongoing support and maintenance, many organizations find that cloud analytics is significantly more cost-effective.
  • Increased scalability and flexibility: Instead of running up against hardware constraints, organizations can make their analytics workloads more scalable and flexible by migrating to the cloud. Oracle Cloud Analytics makes it easy for users to scale their usage of Oracle Compute Units (OCPUs) up or down as necessary.
  • Data backup and business continuity: Backing up your business-critical information using Oracle Database Backup Cloud Service is essential for recovering quickly from data loss or disaster.

Tips and Tricks for Moving Analytics to Oracle Cloud

While there are many advantages of Oracle cloud analytics, moving your analytics platform to the cloud is not as easy as just snapping your fingers. Below, we offer some advice and best practices for an Oracle cloud analytics migration.

  1. Start simple

    The Oracle cloud ecosystem is vast, encompassing a wide range of services—just getting started can be intimidating and confusing. By starting small and simple with a pilot project, you can rack up a few “quick wins” that will convince key stakeholders of the benefits of an Oracle cloud migration.

  2. Take full advantage of the Oracle ecosystem

    That said, there is no shortage of synergies in the Oracle ecosystem that your organization can realize when you do ramp up your use of the Oracle cloud.

    One of Datavail’s clients, a healthcare and pharmaceutical company, was originally facing substantial barriers to effective data management and reporting. Although the client was using Oracle NetSuite cloud software for enterprise resource planning (ERP), the software’s output was simply dumped in Excel.

    Datavail helped the client build a scalable financial reporting repository in Oracle Analytics Cloud (OAC) that allows for ad hoc queries and drill-through analyses, getting smarter business insights from their data. In addition, the client now uses other Oracle tools such as Oracle Smart View and Oracle Data Visualization Desktop (DVD) for sharing and visualizing the outputs of their ETL process.

  3. Use Oracle migration tools

    Oracle’s ecosystem also extends to its cloud migration tools. For one, Oracle offers cloning tools for “lift and shift” migrations that copy data and applications to the cloud without modification. Meanwhile, Oracle GoldenGate Cloud Service is used for real-time replication of information mission-critical databases that can’t suffer downtime during the migration. The right Oracle migration partner can help advise you on the steps to take and the best tools to use throughout your move.

How Datavail Can Help

Datavail is an Oracle Partner, with years of experience helping businesses migrate to the Oracle cloud. We have the knowledge and skillset to make your next Oracle cloud migration a success. Our suite of Oracle cloud migration services includes:

  • Selecting the right cloud technologies for your business.
  • Completing a cloud readiness assessment of your organization.
  • Developing a cloud migration roadmap with an appropriate timeline.
  • Creating a total cost of ownership (TCO) estimate and deploying a proof of concept.
  • Uplifting analytics solutions from on-premises to the cloud.
  • Providing ongoing cloud support, maintenance, and management.


Want to see the benefits of moving your analytics to Oracle Cloud for yourself? Get in touch with Datavail’s team of cloud migration experts today for a chat about your business needs and objectives—or download our white paper “Across the Continent with Cloud Analytics” to see how 8 of our clients have leveraged cloud analytics to their advantage.

The post Why Companies Are Moving Their Analytics to Oracle Cloud appeared first on Datavail.

Escape MySQL 5.6 on Azure End of Life with a 5.7 Upgrade

MySQL on Azure 5.6 reached End of Life (EoL) on February 4, 2021. If your organization is still using this version of the service, it’s time to choose your upgrade option. Learn how an upgrade to MySQL on Azure 5.7 makes the most sense for your managed databases.

What Is MySQL on Azure

Azure Database for MySQL is a fully managed database service that makes it simple to take MySQL databases into the cloud. You have access to the most recent community editions of this database, along with the powerful benefits that Azure’s platform delivers.

  • Up to 99.9% availability, backed by a service-level agreement.
  • Automated infrastructure management, including updates, backups, and other maintenance.
  • Custom performance recommendations to help you optimize your MySQL databases.
  • Expand your MySQL capabilities through tight integration with other Azure services.
  • Single-zone and zone-redundant high availability.
  • Advanced security features, including Microsoft Defender for Identity.
  • Keep working with the same development tools, as Azure supports a variety of programming languages, development environments, and other software.
  • Scale your MySQL databases in seconds and keep costs optimized with pay-as-you-go pricing models.

What MySQL 5.6 EoL Means for Your Organization

Azure Database for MySQL no longer allows you to make MySQL 5.6 database instances as of April 1, 2021. While this MySQL version has had an exceptional run since February 5, 2013, continuing to use it puts your organization at risk.

You will no longer receive security updates, patches, bug fixes, or any other support for this database. The longer you use an obsolete database version, the more likely it is that you will suffer from a data breach or another type of malicious attack. Your next step is preparing for a migration to a newer version of MySQL available on Azure.

Why Upgrade to MySQL 5.7 on Azure

MySQL 5.7 and 8.0 are available on Azure. While both versions have many benefits and new features, MySQL 5.7 has several compelling reasons to choose it.

  • You can easily upgrade from MySQL 5.6 to MySQL 5.7 directly. It’s not a best practice to go directly to MySQL 8.0 from 5.6, so you would have to go through two upgrade processes back-to-back instead of one.
  • MySQL 5.7 has many improvements over 5.6, such as being three times as fast, but it’s still in the same major release number. You have to do less work to keep your applications working properly than with the more drastic shift to MySQL 8.0.
  • MySQL 5.7 has continued support until October 2023. You have two years to prepare your organization for the next major upgrade, allowing you to make the most of each version.


MySQL 5.7 adds JSON and GIS support, better InnoDB scalability, new monitoring functionality, improved security, a rewritten Optimizer, and more to this powerful database.

Planning Your MySQL on Azure 5.6 to 5.7 Upgrade

No matter which MySQL version you choose, database upgrades are a complex process. With Datavail’s MySQL and Azure experts at your side, you’ll be able to get back to a supported database version in no time. Contact us to learn more about our database management and maintenance services.

The post Escape MySQL 5.6 on Azure End of Life with a 5.7 Upgrade appeared first on Datavail.

4 Microsoft Azure Services for Software Development and Modernization


Modernizing your legacy IT is one of the most common ways to enact digital transformation, but not every organization knows how to get started with such a project.

In a previous blog post, we discussed a number of ways that you can modernize your legacy applications, including cloud migrations, microservices and DevOps. Below, we’ll go into more detail about the Microsoft Azure cloud, including some of the most important Azure features and services for developing and modernizing applications.

1. Azure Machine Learning

Machine learning and artificial intelligence (AI) have been cited as keys to digital transformation for organizations of all sizes and industries. Azure Machine Learning is Microsoft’s “machine learning as a service” offering in the Azure cloud, making it easier for businesses to enjoy AI insights.

Azure Machine Learning simplifies the process of building, training, and deploying production-ready machine learning models. While it includes a user-friendly, drag-and-drop interface, Azure Machine Learning can also be used by data scientists and machine learning professionals who want to get more from the experience.

2. Azure Service Fabric

Azure Service Fabric is an Azure PaaS (platform-as-a-service) offering: a distributed services platform for building, deploying, and managing containers and microservices-based applications.

Azure customers can use Service Fabric to build modular, independent microservices that communicate with each other using APIs (application programming interfaces). In fact, Azure Service Fabric is a critical part of Microsoft’s cloud infrastructure: it powers many other Azure products and services, such as Azure SQL Database, Cortana, Azure IoT, and Power BI.

3. Azure DevOps

As the name suggests, “DevOps” is a software development methodology that seeks to foster closer collaboration and tighter feedback loops between your development and IT operations teams. Azure DevOps is a collection of related services that can help your team implement DevOps in the Azure cloud.

The list of Azure DevOps services includes:

  • Azure Boards for planning and tracking work, including Kanban boards, backlogs, and dashboards.
  • Azure Pipelines for implementing CI/CD (continuous integration/continuous deployment).
  • Azure Test Plans for creating both manual and automated software tests.
  • Azure Artifacts for creating and sharing Maven, npm, NuGet, and Python packages.

4. Azure Functions

Azure Functions helps users build serverless applications. The term “serverless computing” is a bit of a misnomer: servers are still required to run your software, but developers don’t have to worry about the tasks of provisioning and maintaining them.

Serverless computing has a variety of advantages:

  • Lower costs: Applications are only executed in response to a particular event or trigger, saving you money by using fewer resources.
  • Greater scalability: Because the cloud vendor is responsible for server monitoring and maintenance, serverless computing provides built-in scalability.
  • Ease of development: Serverless computing largely frees developers from server management and maintenance, and also aligns well with methodologies such as microservices—each function is tiny and built for a single purpose.


From machine learning, microservices, DevOps and serverless computing, this article just scratches the surface of what’s possible for application modernization and development in the Azure cloud. And we should know—Datavail is a Microsoft Gold Partner that has helped countless clients migrate to the Azure cloud and modernize their legacy applications.

To learn more about how we helped a recent client modernize their IT portals in the Microsoft Azure cloud, check out our case study “Public College Modernizes Online Application Process with Azure.” You can also get in touch with our team of IT experts for a chat about your business needs and objectives.

The post 4 Microsoft Azure Services for Software Development and Modernization appeared first on Datavail.