Remove Data Lake Remove Data Warehouse Remove Operational Reporting
article thumbnail

Complexity Drives Costs: A Look Inside BYOD and Azure Data Lakes

Jet Global

OLAP reporting has traditionally relied on a data warehouse. Again, this entails creating a copy of the transactional data in the ERP system, but it also involves some preprocessing of data into so-called “cubes” so that you can retrieve aggregate totals and present them much faster. Option 3: Azure Data Lakes.

article thumbnail

Navigating Data Entities, BYOD, and Data Lakes in Microsoft Dynamics

Jet Global

That’s appropriate and adequate for traditional reporting tasks. For more sophisticated multidimensional reporting functions, however, a more advanced approach to staging data is required. The Data Warehouse Approach. Data warehouses have been in widespread use for years. Data Lakes.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

How Gupshup built their multi-tenant messaging analytics platform on Amazon Redshift

AWS Big Data

About Redshift and some relevant features for the use case Amazon Redshift is a fully managed, petabyte-scale, massively parallel data warehouse that offers simple operations and high performance. This compiled data is then imported into Aurora PostgreSQL Serverless for operational reporting.

Analytics 119
article thumbnail

How smava makes loans transparent and affordable using Amazon Redshift Serverless

AWS Big Data

The data products used inside the company include insights from user journeys, operational reports, and marketing campaign results, among others. The data platform serves on average 60 thousand queries per day. The data volume is in double-digit TBs with steady growth as business and data sources evolve.

Data Lake 115
article thumbnail

Migrate data from Azure Blob Storage to Amazon S3 using AWS Glue

AWS Big Data

Today, we are pleased to announce new AWS Glue connectors for Azure Blob Storage and Azure Data Lake Storage that allow you to move data bi-directionally between Azure Blob Storage, Azure Data Lake Storage, and Amazon Simple Storage Service (Amazon S3). option("header","true").load("wasbs://yourblob@youraccountname.blob.core.windows.net/loadingtest-input/100mb")

Data Lake 111
article thumbnail

Two Birds, One Stone: How to Get Better AX Reporting and Prepare for Future D365 Migration Today

Jet Global

With Jet Analytics, the customer has streamlined that process and vastly simplified intercompany reports. Many AX customers have invested heavily in data warehouse solutions or in robust Power BI implementations that produce considerably more powerful reports and dashboards.

article thumbnail

Use AWS Glue to streamline SFTP data processing

AWS Big Data

With AWS Glue, you can discover and connect to hundreds of diverse data sources and manage your data in a centralized data catalog. It enables you to visually create, run, and monitor extract, transform, and load (ETL) pipelines to load data into your data lakes.