Learn More About Zuar Runner for ETL & Data Staging

What is business intelligence consulting?

Data Pipeline

Business Intelligence Consultants: What They Do & How to Become One

Learn about BI Consultants in this comprehensive guide.

Top 4 data transformation solutions for 2023

Data Pipeline

4 Best Data Transformation Tools of 2023

See Zuar's 2023 top picks for data transformation software tools.

Data Pipeline

Data Pipeline Architecture: Everything You Need to Know

In this guide, Zuar explains what data pipeline architecture is, the types of data pipelines, the difference between ETL and ELT, and much more!

Data Pipeline

Data Connectors Guide: Learn Everything You Need to Know

In this guide, Zuar covers what data connectors are, the advantages of building custom connectors, and how to overcome data connector challenges.

Learning

Data Insights: What They Are, Modern Ways to Gather Them & More

Learn about the types and uses cases of data insights, how they differ from data analytics, and ways to extract actionable information from data.

Learning

Data Strategy Roadmap: Creating a Data Strategy Framework For Your Organization

Learn about the benefits of a data strategy roadmap and how to create one. Understand the key elements of a data strategy framework.

Learning

Data Ingestion: Types, Pipelines, Tools & More

Learn about data ingestion tools and methods, and how it all fits into the modern data stack through ETL/ELT pipelines.

Overview of data silos, including disadvantages and how to identify and break down data siloes.

Learning

What is a Data Silo?

Learn what a data silos is, how they negatively impact your business, how to identify and eliminate them, and frequently asked questions .

Learning

What is Google Cloud Dataflow?

Learn the concepts of Google Cloud Dataflow, how it executes data pipelines, its data sources and sinks, and its functionalities/limitations.

Learning

What is AWS Glue?

Amazon Web Service’s Glue is a serverless, fully managed, big data service that provides a cataloging tool, ETL processes, and code-free data integration. These are services for data that is moved, transformations and managed both within and outside the AWS account. The biggest asset outside of its serverless architecture

Data Pipeline

How to Use Data to Become a Cannabis Industry Leader

In any industry that experiences exponential growth over a short period of time, leveraging data becomes a differentiating factor for sustainable, long-term success. Learn how to do this in the cannabis industry.

Data Pipeline

ZUAR RUNNER UPDATE - SALESFORCE & TABLEAU CLOUD MFA REQUIREMENTS

On February 1, 2022, Salesforce began requiring MFA on all products developed on the Salesforce platform - including Salesforce Sales Cloud and Tableau Cloud. This may have an impact on Zuar Runner usage and we will address measures needed to be taken to avoid disruptions to you data pipeline...

Data Pipeline

Pros & Cons of ELT vs. ETL

Learn the differences between ELT and ETL tools, the processing differences between each, and how to choose between them for your data pipeline needs.

Data Pipeline

ETL vs ELT: What's the Difference?

At Zuar, we advocated using ELT instead of the more traditional ETL due to the ease of eliminating errors and auditing data with ELT. Here's why...

Visualization of data pipeline architectures

Database/Cloud

Should You Build Your Own Data Pipeline?

What is a data pipeline? Data pipelines are systems that pull in data points from different sources and consolidate them into a streamlined repository for analysis and modeling. Your data pipeline could be handling thousands of data points from multiple sources, depending on your company's scope. Beyond that, the data

Learning

What Is a Data Pipeline and How to Build One

Data pipelines enable the smooth flow of information. They automate the process of extracting, validating, and loading the data for analysis. This helps eliminates errors and combats latency. Effective data pipelines are critical for data-driven enterprises.

Data Pipeline

The NetSuite API: Exploring SOAP Requests

Learn new ways to work with NetSuite's SuiteTalk Web Services Platform to gain access to customer data for subsequent transformation, enhancement, and presentation.

Database/Cloud

Data Warehouse Strategy: What Questions Should You Ask?

What questions should you ask before implementing a data warehouse strategy? Read our informative blog and contact Zuar today to learn even more!

Data Pipeline

How Automated Data Analytics Can Improve Your Data Team's Productivity

Not sure If data automation Is worth the effort? Learn more about automation, the methods, the tools, and more.

Rclone OneDrive and SharePoint integration

Data Pipeline

Using Rclone for SharePoint Shared Files

Use Rclone for Sharepoint Shared Files. In this example, the Sharepoint user doesn't own the files shared with them, so Rclone does not show them...

Data Pipeline

Python with Virtualenv in Zuar Runner

Runner is Zuar's data pipeline solution. Learn about importing a Python package we don't have installed on Runner, such as pandas or numpy.

How to update multiple jobs with the python mitto sdk

Data Pipeline

Updating Multiple Jobs with the Python Mitto SDK

Mitto has an extensive API, allowing users to remotely interact with jobs, schedules, etc on their Mitto instance. We recently released a Python SDK for interacting with the Mitto API, available on the Python Package Index.

Data Pipeline

Getting Started with Zuar Runner

The video tutorials below are for those looking to get started using Runner or learn more about the available features. * Runner UI Tour * Creating IO (Input/Output) Jobs * Creating SQL Jobs * Using API and Webhooks to Fire Off Jobs * Creating Sequences * Creating Schedules * Adding Tags * Creating Notifications * Rclone Use Cases

Data Pipeline

Anatomy of a Zuar Runner IO Job

Zuar Runner comes with many different plugins that create jobs of all different types. Most of Runner's plugins come with wizards to help you create jobs. However, if you really want control over your Runner jobs, you need to understand the components of a Runner job configuration. What is an

Data Pipeline

Amazon Advertising API Plugin for Zuar Runner

Zuar's newly released Amazon Advertising API plugin (AAAPI) enables Zuar Runner to pipe data from a customer's Amazon Advertising account and store the data in a database. This is a brief high-level description of plugin's operation. Learn more about Runner's Amazon Advertising API: * Runner help documentation * Runner API documentation Amazon