Category: Datawarehousing

Feed: Actian. Author: Traci Curran. Customer Analytics Overview: A true 360-degree view of a customer can’t be sourced exclusively from internal data let alone from a single system or department. Organizations trying to correlate customer interactions, transaction history, and behaviors to improve customer acquisition ROI and retention struggle to aggregate and analyze data and signals across operational, social engagement, customer experience, and outreach systems to provide real-time customer insights.Why Customer Analytics? Customer Analytics helps enterprise-wide stakeholders bridge the gap between customer and sales and marketing, whether the goals are to increase revenue, build customer loyalty, and create a memorable brand experience ... Read More

Feed: Recent Announcements. AQUA (Advanced Query Accelerator) for Amazon Redshift is now generally available for Amazon Redshift RA3.xlplus nodes. AQUA is a new distributed and hardware-accelerated cache that enables Amazon Redshift to run up to 10x faster than other enterprise cloud data warehouses by automatically boosting certain types of queries. AQUA uses AWS-designed processors with AWS Nitro chips adapted to speed up data encryption and compression, and custom analytics processors, implemented in FPGAs, to accelerate operations such as scans, filtering, and aggregation. Amazon Redshift RA3 is the latest generation node type that allows you to scale compute and storage for ... Read More

Feed: Teradata Blog. Many Teradata customers are interested in integrating Teradata Vantage with Amazon AWS First Party Services. This Getting Started Guide will help you to connect Teradata Vantage with AWS Kinesis service.  Although this approach has been implemented and tested internally, it is offered on an as-is basis. Neither AWS nor Teradata provide validation of Teradata Vantage with AWS services.  We encourage your feedback. We want to understand what you found useful and how we can improve this guide.   Please send your feedback to shamira.joshua@teradata.com and wenjie.tehan@teradata.com.  Disclaimer: This guide includes content from both AWS and Teradata product documentation.  Overview  AWS Kinesis is a streaming service that makes it easy to collect, process, and analyze real-time, streaming data.  Kinesis streaming data ... Read More

Feed: Actian. Author: Linda Anderson. Data maintenance is an ongoing requirement in every database environment. Archiving historic data, synchronizing data after off-line access, or auditing changed data are all issues that typically require customized programming.  Most of these solutions often need database design changes or time-consuming processes to complete these tasks.  With the release of Zen v15, there is now an easy way to do this for any existing Zen data file without impacting existing applications and data layouts – it’s called “System Data v2”.System data has been around for a long time; it provides a hidden unique identifier on ... Read More

Feed: AWS Architecture Blog. In Part I of this series, we introduced you to strategies to optimize the compute layer of your AWS architecture for sustainability. We provided you with success criteria, metrics, and architectural patterns to help you improve resource and energy efficiency of your AWS workloads. This blog post focuses on the storage layer of your AWS infrastructure and provides recommendations that you can use to store your data sustainably. Optimizing the storage layer of your AWS infrastructure Managing your data lifecycle and using different storage tiers are key components to optimizing storage for sustainability. When you consider different storage mechanisms, ... Read More

Feed: Matillion. Author: Rob Callaghan; We are very excited here at Matillion to announce the first version of our “Create Your Own Connector” feature.  No more data connector anxiety – create your own custom connector in minutes Creating your own connector means never having to ask the question, “Does Matillion ETL have a connector for X?” again. By providing an easy-to-use interface for connecting to any REST API, you can quickly connect to any API source system and bring that data into your cloud data warehouse or data lake. Matillion’s wizard driven approach to universal connectivity means unlimited access to ... Read More

Feed: Actian. Author: Traci Curran. Hybrid cloud adoption is on the rise. As companies look to accelerate their cloud journey, it’s becoming clear that there are numerous values – and constraints –  when blending the use of private on-premise clouds with those of public off-premise clouds. Creating a strategic balance between the two can often yield more favorable results for the business, but it’s important to carefully consider the benefits and risks associated with data that moves between public and private infrastructures.What is a Hybrid Cloud? A hybrid cloud environment or architecture combines using a public cloud and a private ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We are happy to announce that we have just released the September update for the On-premises data gateway (version 3000.96.1)   Here are some of the things that we would like to highlight with this month’s  release:  Azure Active Directory-based Single Sign-On for Amazon Redshift Kerberos-based Single Sign-On for Hive LLAP and Tibco Data Virtualization Compatible with the September PBI desktop Amazon Redshift – Azure Active Directory-based Single Sign-On We are excited to release Azure Active Directory-based Single Sign-On (AAD SSO) for the Amazon Redshift connector, allowing you to use seamless ... Read More

Feed: Teradata Blog. How do you optimize your entire supply chain?  How do you know you are economically balancing the costs of demand and supply fulfilment across the entire organization when each organization has different objectives and measures, and often maintains their own applications and data? This post will help you think about and answer these questions for your business.  The supply chain is like a river, flowing over rocks, around bends and frequently looking for the easiest path downhill.  Removing one rock or changing a branch of the river may provide improved flow at a given point but will ... Read More

Feed: Recent Announcements. Amazon Redshift data sharing allows you to share live and transactionally consistent data across different Redshift clusters without the complexity and delays associated with data copies and data movement. Ability to share data across clusters that are in the same AWS account is already available in AWS GovCloud(US) Regions. Now sharing data across Redshift clusters in different AWS accounts is also generally available in AWS GovCloud(US) Regions. Cross-account data sharing is supported on all Amazon Redshift RA3 node types. There is no additional cost to use cross-account sharing on your Amazon Redshift clusters.  With data sharing, you can securely ... Read More