Working with AWS Glue

We’ve helped hundreds of customers deliver Business Intelligence across their entire organization. By leveraging the fully managed extract, transform, and load (ETL) service, AWS Glue, we can prepare and load your data for analytics. Using generated code, we can start your data transformations and data loading processes. After we create and run an ETL job, your data becomes immediately searchable and query-able.

AWS Glue is a great way to extract ETL code that might be locked up within stored procedures in the destination database, making it transparent within the AWS Glue Data Catalog. The following is an example of how we took ETL processes written in stored procedures using Batch Teradata Query (BTEQ) scripts. We used AWS Glue services to implement the same functionality while using Amazon Redshift as the destination database.

AWS Glue connects to Amazon S3 storage and any data source that supports connections using JDBC, and provides crawlers which then interact with data to create a Data Catalog for processing data.

Here are the primary technologies that we have used with customers for their AWS Glue jobs.

AWS Glue Chart

Amazon Data Warehouse Solutions

Working closely with the Amazon Redshift team, DB Best is ready to help customers migrate aging on-premises data warehouse workloads to Redshift. We can also optimize your Redshift data warehouse and integrate it with other Amazon Web Services.

AWS RDS Platform

With the AWS RDS platform and infrastructure, you have many options for running your favorite database on EC2, RDS, and Aurora. Learn how we can optimize your database solutions on AWS.

Oracle Database

If you are using out-of-support Oracle databases, you may be facing huge licensing cost from Oracle. DB Best can help you optimize your Oracle licenses as part of a database upgrade or migrate the solution to other database platforms.

Microsoft SQL Server

Your SQL Server databases store and retrieve the lifeblood of your business – data. DB Best provides expert consulting services to organizations of all sizes for mission-critical Microsoft SQL Server installations.

MySQL

DB Best has developed hundreds of applications for customers using the MySQL platform. Our team can help you with new solutions, operational support or moving your applications to the cloud.

PostgreSQL

DB Best has developed hundreds of applications for customers using the PostgreSQL platform. Our team can help you with your new solutions or move your existing applications to the cloud.

Microsoft Data Warehouse Solutions

See how DB Best can help you get the most out of the Microsoft Data Warehouse platform technologies like SQL Server, Azure SQL Data Warehouse, Azure Data Lake, and more.

Teradata

If you are looking at moving your Teradata database to the cloud, switching to a new data warehouse technology, or improving performance of you existing deployment, we are here to help.

What We Do

Having a great experience in crafting business intelligence systems for various companies worldwide, we can discover the very best BI solution that fits your requirements. Particularly, we can:

  • Provide technical expertise in mapping various data sources.
  • Ensure credible and consistent data without the need to change data sources.
  • Provide you with reliable, scalable and cost-effective cloud storage.
  • Accelerate and improve decision-making solutions.
  • Deliver a familiar user experience while gaining a competitive advantage over business rivals.
  • Ready to help you with a Proof of Value project to identify market trends.

Loading Amazon Redshift Data Utilizing AWS Glue ETL service

In the following video, we will describe our approach to the conversion of Teradata ETL scripts into AWS Glue. Find the code snippets on our blog post on ETL scripts conversion from Teradata to AWS Glue.

Let's get together to talk about AWS Glue
Contact us today

Getting started with Amazon Glue

We’ve got a couple of basic offerings to get started with Amazon Glue services.

Learn more

Blog posts

Loading Amazon Redshift Data Utilizing AWS Glue ETL service
27 December 2017 Bill Ramos

Your CIO has made the decision to move to AWS and now you're left wondering how to move your Enterprise Data Warehouse (EDW) on Teradata: should you opt for using Teradata Software Ti...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote