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...
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
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 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.
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
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
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
Data Pipeline Automate Bash, R, and Python Scripts With Zuar Runner In this blog post we will discuss the Zuar Runner command line job, and then walk through examples of automating scripts from various languages: * Bash * R * Python With Zuar's Runner platform,
Data Pipeline Modernizing Supply Chain Analytics In this article, we discuss the fundamental building blocks for supply chain analytics, the benefits of a modern analytics approach, how companies can get started, and more.
Data Pipeline How to Manipulate Excel Data for Analytics Using Mitto Recently at Zuar [https://www.zuar.com/], we had a user that needed to pull a subset of data from a Microsoft Excel [https://www.microsoft.com/en-us/microsoft-365/excel] spreadsheet, and pivot
Data Pipeline NetSuite Setup Instructions for Zuar Runner Instructions for setting up your Netsuite instance so that Runner can connect and pull data via the Netsuite APIs into a database for analytics.
Data Pipeline If your business runs on NetSuite and you make your reports in Excel, you have to check this out! NetSuite helps companies run sales, purchasing, inventory, and more…all in the cloud. Here's how Zuar can help you use that data to its fullest potential.
Data Pipeline How To Unzip Files in Zuar Runner It's inevitable that if you deal with enough data, especially exporting data from source systems, that you'll eventually need deal with .zip, .gz, or tar.gz files. To get
Data Pipeline Salesforce Setup Instructions for Zuar Runner Learn how to set up Salesforce so that Runner can automatically connect to the Salesforce REST API and pipe data into a database on a schedule.
Data Pipeline How to Use Data Analytics to Prepare Your Supply Chain During a Crisis How to use data analytics to prepare your supply chain during a crisis or disaster.
Data Pipeline Adding Custom Plugins to Zuar Runner Learn how to add and use custom plugins in the Zuar Runner ELT platform.
Data Pipeline Zuar Runner and Rclone - Custom Jobs Rclone is a program that can be used to transfer files to and from more than forty different storage backends (e.g., Amazon S3, Box, Dropbox, FTP, Google Cloud Storage, Google Drive, Microsoft
