Blob Extraction

A common occurence

Databases commonly store a large volume of extensive data objects, like images and documents. While keeping blobs in your database can simplify maintenance, their actual size and quantity often grow far beyond initial predictions as business needs and data evolve.

This can lead to significantly higher costs for cloud databases, especially when these large objects consume the majority of storage and drive expenses. Cloud object storage offers a superior alternative: it's a cost-effective, highly reliable, and efficient solution that's difficult to replicate in a private datacenter. If these large data objects are dictating most of your cloud database costs, it's time to explore other options.

Trimming Your Database Size

Migrating data to the cloud is an ideal opportunity to optimize your database and reduce costs by extracting large blobs during the process. Omni Loader makes this seamless by automatically offloading blob data to cloud storage as part of the migration.

To use this feature, simply enable the “Blob Extraction” option when setting up your target database connection, and provide the destination for your blob storage, such as Amazon S3, Azure Blob Storage, or ADLSv2. As data is copied, Omni Loader uploads each blob to the specified cloud storage location and replaces the original blob in the target database with a lightweight identifier.

This approach significantly reduces the size of the target database, lowers backup overhead, and cuts down on long-term storage costs.