Data to AWS Three Ways - A SharePlex Cookbook Part One

My wife and I are foodies, and in addition to cooking and dining out, we enjoy watching some of the cooking competitions on TV.   One of our favorite themes is when the celebrities are challenged to produce multiple dishes with the same ingredients.

Recently, our SharePlex customers and potential customers have challenged us with the question, “How do I get data out of my Oracle database into a file in AWS, or S3 storage”.  Like great chefs, our SharePlex developers have given us multiple ways to answer that question.   In this blog, I’ll give you a high-level overview of the three ways you can use SharePlex to help you move your valuable data from an Oracle database into AWS.

How AWS stores data

In addition to relational and “NoSQL” databases, AWS has other options for storing data.  The two most common are S3 and “traditional” files.  

 

Amazon S3

S3 stores objects in buckets.   Each bucket is typically accessed through a URL, for example, https://example-bucket.s3.amazonws.com/photos/mykids.jpg.   Amazon provides APIs and Command Line interfaces to allow access to these objects.

 

Files

Files are another way to store data in AWS.   Files are collections of data stored on some sort of persistent media, usually hard disks or solid-state drives, created and accessed through an operating system such as Windows or Linux.   Files can contain plain text, formatted documents or binary data such as a picture.  An example of a file might be C:\My Pictures\Bobs 1st Birthday.jpg.  

 

What’s so special about files?

Let’s look at why a customer might want their data in a “plain old file” in the first place.    The biggest reason we see is to move data between systems.  Most systems have at least one way to ingest or receive data in a file.  In fact, for some systems, this may be the preferred way to ingest data.   Also, data in files is portable, as we’ll see, files can be easily transferred between systems.  In Amazon, files can be stored directly as files or they can be placed in an S3 bucket.

SharePlex and files

The SharePlex FILE target is perhaps one of the most versatile targets to which SharePlex can move data.   The FILE target is a “change record” of exactly what happened in the database, an insert, update or delete.   The file can also contain metadata about the database object being changed, including a definition of the schema, the date and time of the change, the operation that was performed and even which database user performed the change.  Files can be in one of three formats, XML, JSON or SQL.    XML and JSON are “portable” file formats that can contain information about the data, such as table and column names.  The SQL file type is a record of the database changes in a “portable” subset of SQL (Structured Query Language).   There are small examples of each of these formats at the end of this blog.

 See the recipes in my next blog

Anonymous
  • In this insightful article, the author effectively delineates the primary data storage options offered by AWS, namely S3 and traditional files, emphasizing their respective utilities. Amazon S3 is known for storing objects in uniquely accessible buckets via URLs, allowing seamless integration through APIs and command-line interfaces. This robust functionality is contrasted with traditional file storage, which remains paramount for data transfer between distinct systems due to its versatility and portability.

    A noteworthy aspect discussed is the role of SharePlex in providing a flexible "change record" target through its FILE target feature, which can document database changes in XML, JSON, or SQL formats. This serves as a vital tool for data management and integration across platforms.

    For musicians and bands seeking creative inspiration or names, the Band Name Generator offers a novel solution to enhance their artistic branding. Discover unique band names by leveraging AI technology by visiting Band Name Generator.

  • This is a great analogy to those cooking competitions! So cool to see SharePlex offering so many options for moving data. It's like a data chef with a bunch of secret ingredients! Thanks for breaking down how to get Oracle data into AWS. Super helpful! Now I’m back to Friday Night Funkin.

  • Yes and Their skilled team ensures safety, efficiency, and compliance across residential, commercial, and industrial projects. From new system is evaporative cooling good in melbourne installations to upgrades and maintenance, they guarantee precision in every service.

  • Great insights on the SharePlex FILE target! Its versatility in capturing database changes is indeed impressive, especially with the support for XML, JSON, and SQL formats. For those looking to unwind after dealing with data management, I recommend checking out Funny Shooter 2—it's a hilarious way to relax! This game might even spark some creative ideas for your data projects. Keep up the great work!

  • This was an outstanding blog post! If you are visiting southern Africa, consider using Zambia Kaza Univisa for smooth travel. This visa allows access to Zambia and Zimbabwe under one document, reducing the hassle of applying for multiple visas. It is perfect for tourists who wish to explore both countries without restrictions. Understanding the duration and conditions of this visa is crucial to ensure a well-planned trip.

Related Content