Category: Datawarehousing

Feed: Redis Labs. Author: Steve Naventi. The shift toward online digital conferences has prompted Microsoft to reconvene Ignite about six months early this year. Scanning the data and analytics announcements, the overriding theme is of extending the reach of the portfolio of Azure data platforms.For data and analytics, the headlines on this go-round include a new Azure Managed Instance for Apache Cassandra; support for a MongoDB 4.0 API in Azure Cosmos DB; the general availability of Azure Synapse Link for Cosmos DB; and some enhancements to Azure Cache for Redis offering. And Microsoft is introducing new tools for data warehouse ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; HeatWave is designed to enable customers to run analytics on data which is stored in MySQL databases without the need for ETL. This service is built on an innovative, in-memory analytics engine which is architected for scalability and performance and is optimized for Oracle Cloud Infrastructure (OCI) Gen 2 hardware. This results in a very performant solution for SQL analytics at a fraction of the cost compared to other cloud services including AWS Aurora, Redshift, Google Big Query, RDS.  The amount of acceleration an application would observe with HeatWave depends upon a number ... Read More

Feed: James Serra's Blog. Author: James Serra. I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer is almost always star schema, and Patrick LeBlanc does a great job explaining what a star schema is and why star schemas are so important for Power BI in his video Why Power BI loves a Star Schema. I wanted to list out his four reasons: Usability: If you have just one large table with all the data, when creating a report it is ... Read More

Feed: Teradata Blog. In the past I’ve heard some criticisms around Teradata’s founding “vision” -- criticisms that have been bolstered by the misperception that Teradata has admitted that its original vision of a “single store of business data” is no longer correct. Allow me to clear a few things up… Teradata started with the vision of “bring data together” so users could ask “any question of any data at any time.” At our heart we started as an analytic software company. We revolutionized a new paradigm of MPP software that was able to scale to (at the time) unfathomable amounts ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Alaa Mahjoub. In many cases, for an enterprise to build its digital business technology platform, it must modernize its traditional data and analytics architecture. A modern data and analytics platform should be built on a services-based principles and architecture. Introduction part 1, provided a conceptual-level reference architecture of a traditional Data and Analytics (D&A) platform. This part, provide a conceptual-level reference architecture of a modern D&A platform. Parts 3 and 4, will explain how these two reference architectures can be used to modernize an existing traditional D&A platform. This will be ... Read More

Feed: Matillion. Author: Julie Polito; It’s great when things go right when you’re loading and transforming your data. But it’s equally important, even more so, to know when things don’t go so well. Matillion ETL already has a number of ways to help make jobs more resilient to errors including explicit error handling, logging and notifications. However, as cloud infrastructures become more complex–often extending across multiple platforms–so do the ETL jobs that support them.  Feedback from our  customers confirms this new reality. Many of them say that failures are now  more problematic to diagnose because:Errors may be several layers deep within ... Read More

Feed: AWS for SAP. Author: Axel Streichardt. Introduction Recently, SAP announced RISE with SAP, an offering that enables you to upgrade to SAP S/4HANA more easily through a single-tenant, SAP-managed ERP implementation. RISE with SAP further simplifies SAP S/4HANA adoption by bundling the technology needed to execute your cloud journey into a single offer with one contract. This offering delivers a standard production SLA of 99.7% (99.5% non-PROD) on the core RISE with SAP offering (and a 99.9% SLA with a price uplift), as well as a 20% reduction¹ in total cost of ownership (TCO) over five years compared to ... Read More

Feed: Actian. Author: Lewis Carr. And why is it better than a Data Lake or an Analytics Hub? In the opening installment of this blog series—Data Lakes, Data Warehouses and Data Hubs: Do we need another choice?  I explore why simply migrating these on-prem data integration, management, and analytics platforms to the Cloud does not fully address modern data analytics needs. In comparing these three platforms, it becomes clear that while all of them meet certain critical needs, none of them meet the needs of business end-users without significant support from IT. What we in fact need is a platform ... Read More

Feed: Matillion. Author: Julie Polito; Matillion Data Loader v1.22 is here with some important new connectors and features to support your multi-cloud strategy and keep your pipelines up to date. Support your multi-cloud strategy: Snowflake and Redshift connectors        More and more organizations are adopting a multi-cloud strategy to support security requirements and ensure that they have the right cloud data platform for each type of data they work with. We’re excited to announce the addition of connectors for both Snowflake and Redshift that enable data teams to move data between clouds and cloud data platforms. With the Redshift connector ... Read More

Feed: Teradata Blog. You’re browsing a retailer’s website looking for BBQs. The next time you login to the site you get a discount offer on BBQs. But in the meantime, you’ve bought one for full price at a physical store. Sounds familiar?Imagine instead that the retailer recognised your interest in BBQs and immediately sent an offer to your mobile encouraging you to purchase one either online or in one of their physical stores. Helpful to you, and sales, plus loyalty driving to them.Or better still, knowing that you have now redeemed the BBQ offer, they then see BBQ food in ... Read More