Category: Datawarehousing

Feed: Cloud Data Transformation Software | Matillion. Author: Paul Johnson, Solution Architect; Paul Johnson, Solution ArchitectA data lake is not a direct replacement for a data warehouse; they are supplemental technologies that serve different use cases with some overlap. Most organizations that have a data lake will also have a data warehouse. The following section will compare the properties of a data lake in comparison to a traditional BI architecture (data warehouse & separate ETL server).1. Data in Data Lakes is stored in its native formatData can be loaded faster and accessed quicker since it does not need to go ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Paul Johnson, Solution Architect; Paul Johnson, Solution ArchitectOur customers have special data storage requirements, especially around volume and variety (unstructured data). To meet their needs, they are employing data lake architectures.A data lake can store data in any volumes and make it available without needing to transform it before being ready for analysis. This ability can address unique requirements by providing a cost effective resource for scaling, storing and accessing large volumes of diverse data types. Data lakes, however, do not come without their challenges. In this blog, we outline common challenges ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. A version of this blog post first appeared in the developer-oriented website, The New Stack. It describes how MemSQL works with Apache Kafka to guarantee exactly-once semantics within a data stream. Apache Kafka usage is becoming more and more widespread. As the amount of data that companies deal with explodes, and as demands on data continue to grow, Kafka serves a valuable purpose. This includes its use as a standardized messaging bus due to several key attributes. One of the most important attributes of Kafka is its ability to support exactly-once semantics. With exactly-once ... Read More

Feed: James Serra's Blog. Author: James Serra. Azure Data Explorer (ADX) was announced as generally available on Feb 7th.  In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes of data streaming (i.e. log and telemetry data) from such sources as applications, websites, or IoT devices.  ADX makes it simple to ingest this data and enables you to perform complex ad-hoc queries on the data in seconds – ADX has speeds of up to 200MB/sec per node (currently up to 3 nodes) and queries across a billion records take less than a second.  A ... Read More

Feed: Actian. Author: Kishor Kalivarapu. We are excited to announce that Actian DataConnect suite of products are now available on the Amazon Web Services (AWS) Marketplace.Actian DataConnect is a hybrid integration solution that enables you to quickly and easily design, deploy, and manage integrations on premise, in the cloud, or in hybrid environments.  DataConnect engineered to help you cost-effectively integrate diverse data and applications from numerous endpoints with its emphasis on reuse and adaptability. AWS marketplace customer(s) are now able to subscribe to these offerings by accessing the following links: These are a BYOL (Bring Your Own License) offerings that could be leveraged by Actian customers ... Read More

Feed: Actian. Author: Sampa Choudhuri. Companies around the world are migrating their IT and business applications from on-premise data centers to cloud environments. The benefits of hosting apps in the cloud are clear and well understood; however, the process of data migration is much more challenging than one would think. Migrating data between different applications that are either located on-premise or in the cloud or in hybrid environments is often where IT teams encounter problems. Leveraging a hybrid data-integration platform, such as Actian DataConnect, can help companies both accelerate the cloud data-migration process and lower the risk of migration issues.What ... Read More

Feed: Actian. Author: Sampa Choudhuri. Organizations initiate data migrations for several reasons. They might need to overhaul an entire system, upgrade databases, establish a new data warehouse or merge new data from an acquisition or other source. Data migration is also necessary when deploying another system that resides next to existing applications. Regardless of the exact purpose for a data migration, the goal is generally to enhance performance and competitiveness. Achieving your data migration goals can be difficult, but with a solid plan and the right set of tools, you will be well positioned for data migration success.Why you should ... Read More

Feed: Actian. Author: Cris Ianculovici. We have documented the best way to connect from PHP to an Ingres database via ODBC in an Actian Knowledge Base article called Ingres ODBC with PHP and in a previous post, Connecting to Actian X (Ingres) with PHP and NGINX. Sometimes, however, due to limitations, users may need to use JDBC instead of ODBC to connect. This post shows how this can be done, although no native support exists to connect through JDBC using PHP.In this situation a PHP-JDBC bridge is necessary. For this example, we are using the bridge available at PHP-JDBC Bridge. Validate ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this webinar, MemSQL Product Marketing Manager Mike Boyarski describes trends in data initiatives for banks and other financial services companies. Data is the lifeblood of modern financial services companies, and MemSQL, as the world’s fastest database, is rapidly growing its footprint in financial services. Financial services companies are leaders in digital transformation initiatives, working diligently to wring business value from the latest initiatives. According to Gartner’s 2019 CIO Agenda survey, Digital transformation is the top priority for banks, followed by growth in revenue; operational excellence; customer experience; cost optimization/reduction; and data and analytics ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Risk management is a critical task throughout the world of finance (and increasingly in other disciplines as well). It is a significant area of investment for IT teams across banks, investors, insurers, and other financial institutions. MemSQL has proven to be very well suited to support risk management and decisioning applications and analytics, as well as related areas such as fraud detection and wealth management. In this case study we’ll show how one major financial services provider improved the performance and ease of development of their risk management decisioning by replacing Oracle with MemSQL ... Read More