Category: Datawarehousing

Feed: The Connector by Workato. Author: Jon Gitlin; An organization’s net retention rate (NRR) is increasingly seen as their north star of success—and for good reason. It reveals the value your product provides; it demonstrates the quality of your success team; it underscores your position in the market; and it highlights the confidence in your product roadmap. Improving this critical business metric requires each of your customer-facing teams—from your sales reps to your customer success managers to your marketers—to receive timely and actionable insights based on product usage data. In other words, it requires leveraging product intelligence.  We’ll explain why ... Read More

Feed: AWS Big Data Blog. Streaming ETL jobs in AWS Glue can consume data from streaming sources such as Amazon Kinesis and Apache Kafka, clean and transform those data streams in-flight, as well as continuously load the results into Amazon Simple Storage Service (Amazon S3) data lakes, data warehouses, or other data stores. The always-on nature of streaming jobs poses a unique challenge when handling fast-changing reference data that is used to enrich data streams within the AWS Glue streaming ETL job. AWS Glue processes real-time data from Amazon Kinesis Data Streams using micro-batches. The foreachbatch method used to process ... Read More

Feed: Actian. Author: Traci Curran. Organizations initiate data migration projects for several reasons. They might need to overhaul an entire system, upgrade databases, establish a new data warehouse, support a cloud migration roadmap, or merge new data from an acquisition or other source. Data migration is also necessary when deploying another system that resides next to incumbent applications. Regardless of the exact purpose for data migration, the goal is generally to enhance business performance and competitiveness.Achieving your migration goals can be difficult. But with a solid data migration strategy and implementation approach and the right set of tools, you will ... 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: Actian. Author: Pradeep Bhanot. In this third and last part of the series on Actian Vector in Hadoop (VectorH), we will cover how the VectorH file format supports the performance and efficiency of our data analytics platform to accelerate business insights, as well as some of the other enterprise features that can help businesses move their Hadoop applications into production. Part one of this series showed the huge performance advantages VectorH has over other SQL on Hadoop alternatives, while part two explored the benefits of the richer implementation of SQL and the ability to perform data updates in VectorH.The ... Read More

Feed: Actian. Author: Lewis Carr. Saying that the current business climate and market conditions are tough is about as much an understatement as saying a Banana Slug is not terribly fast. Making the right decisions too slowly or wrong decisions too quickly can have equally adverse outcomes.In certain industries such as Retail, Travel, and Hospitality or for smaller businesses without the liquidity or significant credit lines, the COVID-19 pandemic has produced an epidemic of financial hardship, regardless of company size or industry.  The only logical approach is to make the best decisions you can with the information you have.  In ... Read More

Feed: Actian. Author: Dahye Huh. Total Cost of Ownership (TCO) has been an essential Key Performance Indicator (KPI) for the IT industry for many decades – and rightfully so. Large scale capital expenditures for IT infrastructure and data center resources were incurred at the onset of a project, allocated to different business functions and amortized (along with maintenance and upgrade costs)  over the expected useful life of the hardware. CIOs and finance leaders needed a tool for understanding the fully-loaded costs of IT investments to determine ROI for the company.  TCO gave them that.Data warehouse systems were significant investments for ... Read More

Feed: Actian. Author: Emma McGrattan. Today we are excited to announce the release of Actian Avalanche on Microsoft Azure. Azure is growing significantly as a platform in the enterprise space and becoming the de facto choice for retail analytics. Hence, making Actian Avalanche available on Microsoft Azure has been a priority for us.With this release, Actian Avalanche is now available on Microsoft Azure, AWS, and on-premises, delivering on our hybrid and multi-cloud vision. We have added new features to this release, like independent scaling of compute and storage resources. This is particularly appealing to those customers who have large amounts ... Read More

Feed: Actian. Author: Adam Luciano. Actian Avalanche on  Microsoft Azure launched this week with a free cloud storage offer.  This post will walk you through getting set up on Avalanche on Azure. You must first have an Actian account as a customer of Avalanche or have signed up for a free trial.  After you log in to the Avalanche service, you will see the below screen in the center of the Avalanche console:  To create your first warehouse, click the green Create your first Cluster button, which will load the below screen to get you set up:  All fields depicted above are required fields. After filling ... Read More

Feed: Actian. Author: Adam Luciano. Today we announced the availability of Actian’s industry-leading Avalanche Cloud Data Warehouse Managed Service on Azure. Actian Avalanche is the only hybrid data warehouse solution on Azure and provides significant performance gains at a lower cost compared to alternatives. Learn why Avalanche on Azure makes sense for your business.We are also pleased to announce a special offer of $0 cloud storage on Azure for customers of Avalanche.    Details of the offer:                              You will receive up to 10TB Free Cloud Storage with your Avalanche ... Read More