Extract, Transform, and Load (ETL) and Extract, Load, and Transform (ELT) are two common approaches for moving data from source systems into a data warehouse or data lake. Both serve the same general purpose, but work in slightly different ways. In this post, we'll review the key differences between ETL and ELT and when you may want to choose one approach or the other.
This past week we released an exciting new AI capability – Qlik conversational analytics in Microsoft Teams. With the new Qlik app for Teams, you can easily chat with Insight Advisor, Qlik's intelligent AI assistant, to explore data using natural language directly within Teams. Users can now ask questions through individual or group chat and Qlik will respond with AI-generated data visualizations and insights, using data from across your Qlik apps. Because it's Microsoft Teams, you can collaborate with others in real-time, collectively making decisions using the insights generated by Qlik. And with the Teams mobile app, you have access to Qlik Analytics on-the-go, for insights at the point of decision.
We are happy to announce the next version of our client-managed analytics offering, Qlik Sense November 2023. This version includes improvements primarily focused on new visualizations, formatting and functionality, a new AI-powered natural language object, and scripting improvements.
November brings us to autumn/fall with darker winter nights approaching, and in some countries there will be bonfires and fireworks that can bring frights and bangs to many an excited crowd, against the cold, dark night air.
This release of Qlik Replicate November 2023 helps to minimize the frights and keep the lights on to protect against the dark. Security is always top of mind for IT depts around the globe, and this release sees some serious enhancements across endpoints.
Qlik Cloud Data Integration enables users to build automated data pipelines with an intuitive visual interface to ingest, transform, and deliver analytics-ready data. Several major capabilities have been added in the November 7th, 2023 release to strengthen Qlik Cloud for enterprise hybrid and multi-cloud data integration.
Cloud Data Integration (QCDI) provides powerful capabilities for building automated and scalable data pipelines. One of the key benefits is incremental processing, which only processes changed data rather than the full data set on each run. This improves efficiency, especially for large datasets.
While core QCDI for landing, storing, or performing basic transformations are automatically incremental, custom SQL queries fully reprocess all data by default. With complex logic, this repetitive processing could become inefficient.
That’s why we’re excited to announce new Macro capabilities that give you more control over incremental processing in custom SQL pipelines. Now you can easily specify different logic to run during initial loads vs incremental updates.