Meiro Integrations
Your way out of the data labyrinth.
If you need technical support while using Meiro System, please contact us at 'help@meiro.io'.
Introduction
Introduction to Meiro Integrations with list of integrations
Meiro means “Labyrinth” in Japanese. The logo of Meiro Integrations represents the data maze and ...
Glossary: what is what in Meiro Integrations
The terms used in Meiro Integrations and their meanings. Activity An overview of all configurat...
Terms & conditions
To learn more about Meiro Terms & Conditions please refer to this article.
Meiro User Security Guidelines
To learn more about Meiro User Security Guidelines please refer to this article.
Technical Support
Overview Encountering issues and bugs is part and parcel of using just about any software system...
User Interface
User Interface Of Meiro Integrations
Meiro means “Labyrinth” in Japanese. The logo of Meiro Integrations represents the data maze and ...
Components
Connectors, Processors, Loaders Each workspace can contain different types of components: Connec...
Tab: Administration
The Administration page is visible to a user with an admin level of access and is split into thre...
Tab: DAWG
Directed Acyclic Workspaces' Graph (DAWG) DAWG allows you to organize your workspaces in the dir...
Tab: DAWG Detail
DAWG (Directed Acyclic Workspaces' Graph) Detail By clicking on a particular DAWG workspace, you...
Tab: Full-text search
The Full-text search tab allows searching through the configurations’ name/description/parameters...
Tab: Monitoring
Tab Monitoring displays the usage of CPU as well as how occupied the server is (if the number is ...
Tab: Trash
Deleted or removed items (workspaces, configurations, users) can be found in the Trash tab. ...
Tab: User Settings
The User Settings tab displays the main information relevant to the account: User Settings t...
Tab: Workspaces
A workspace enables you to create real-time project intelligence. The Workspaces tab lists all th...
Tab: Workspaces Detail
Workspace Detail By clicking on a particular workspace in the Workspaces tab, you will be able t...
Getting Started
How data flow and components work
In this article, we explain how the folder structure and execution model works in Meiro Integrati...
How to set up a schedule
After you set up a data flow in your workspace, most probably you will need to run it regularly t...
Activity Details
Activity details are available for the workspaces, as well as for particular components. Activit...
Configuration file
Inside a configuration, you can see the form/JSON tumbler, that switches the view in which all th...
Filter in components
The filter is available for the Data In bucket (processors, loaders) and allows to choose the dat...
Folder Structure
Each configuration in Meiro Integrations is an independently running Docker container with a pred...
Quick tips
Reload cache Use Ctrl+r+Shift (or Ctrl+F5) to reload the page and to clear the cache. This short...
Workspace variables
Workspace variables in Meiro Integration is a feature that allows you to hold common information ...
Connectors
Connector Adobe Analytics
Adobe Analytics is a robust web analytics platform developed by Adobe Systems, designed to help b...
Connector AppsFlyer
AppsFlyer is a mobile attribution and marketing analytics platform. AppsFlyer uses tracking links...
Connector AWS S3
Amazon Simple Storage Service (S3) is a scalable and highly durable cloud storage service provide...
Connector Clockify
Clockify is a versatile time-tracking tool designed to streamline and optimize time management. I...
Connector contactSPACE
ContactSPACE is a software that helps to automatise the activity of the contact center. It collec...
Connector Doubleclick
DoubleClick is a digital marketing platform developed by Google that provides services for advert...
Connector Facebook
Facebook serves as a central hub for online interactions. In the context of data utilization, bus...
Connector Facebook Ads
Facebook Ads is a comprehensive advertising platform provided by Facebook, enabling businesses to...
Connector Facebook Pixel
Facebook Pixel is a tracking tool provided by Facebook that allows advertisers to measure the eff...
Connector Gmail
Gmail is a widely-used email platform developed by Google that allows users to send and receive e...
Connector Google Gmail Attachments
Google Gmail Attachments refer to the files and documents that users can send and receive via Gma...
Connector Google Ads
The Google Ads connector in Meiro Integrations allows you to interact with the Google Ads API and...
Connector Google Analytics
Google Analytics is a powerful web analytics service provided by Google that enables website owne...
Connector Google BigQuery
Google BigQuery is a fully managed, serverless data warehouse solution that enables organizations...
Connector Google Cloud Storage OAuth2
Google Cloud Storage OAuth2 is an authentication and authorization mechanism that allows secure a...
Connector Google Cloud Storage Service Account
A Google Cloud Storage Service Account serves as an authentication mechanism, allowing applicatio...
Connector Google Spreadsheet
Google Sheets is a cloud-based spreadsheet application developed by Google, offering users a vers...
Connector HTTP
HTTP, or Hypertext Transfer Protocol, is the foundation of data communication on the World Wide W...
Connector Instagram
Instagram is a popular photo and video-sharing social networking service owned by Facebook. It en...
Connector ipSCAPE
ipSCAPE is a cloud-based contact center software that is a comprehensive solution for managing cu...
Connector Kafka
Kafka, developed by the Apache Software Foundation, is an open-source distributed event streaming...
Connector Klaviyo
Klaviyo is a renowned global technology company offering a robust marketing automation platform p...
Connector LDAP
LDAP, or Lightweight Directory Access Protocol, is a standardized protocol used for accessing and...
Connector Magento V2
Magento V2 is an open-source e-commerce platform renowned for its flexibility and scalability, de...
Connector Mailchimp
Mailchimp is a popular email marketing platform that enables users to create, send, and manage em...
Connector Microsoft Dynamics
Microsoft Dynamics is a comprehensive suite of business applications designed to streamline and i...
Connector MsSQL
Microsoft SQL Server (MsSQL) is a relational database management system (RDBMS) developed by Micr...
Connector MySQL
MySQL is an open-source relational database management system that allows users to organize, stor...
Connector Optimizely
Optimizely is a leading experimentation and optimization platform designed to empower businesses ...
Connector OracleDB
Oracle Database (OracleDB) is a widely-used relational database management system (RDBMS) develop...
Connector Pipedrive
Pipedrive is a customer relationship management (CRM) platform designed to streamline and enhance...
Connector Postgres
PostgreSQL, often referred to as Postgres, is an object-relational database management system (RD...
Connector Provetic
Provetic is a data analytics approach that involves monitoring and analyzing online conversations...
Connector Pure Cloud
PureCloud is a cloud-based customer engagement platform that provides a comprehensive suite of co...
Connector Salesforce Commerce Cloud
Salesforce Commerce Cloud is an e-commerce platform that empowers businesses to manage their onli...
Connector Salesforce Sales Cloud
Salesforce Sales Cloud is a customer relationship management (CRM) platform designed to streamlin...
Connector SFTP
Secure File Transfer Protocol (SFTP) is a network protocol that enables secure and encrypted file...
Connector SmartEmailing API CSV
The SmartEmailing API CSV facilitates the seamless export of crucial data from the SmartEmailing...
Connector Snowflake
Snowflake is a cloud-based data warehousing platform that revolutionizes how organizations manage...
Connector Twitter
Twitter is a social media platform that allows users to share short messages, called tweets, with...
Connector WooCommerce
WooCommerce is a popular open-source WordPress plugin designed for e-commerce websites, enabling ...
Connector Youtube Insight
YouTube Insight is the analytical tools and data available on the YouTube platform, enabling cont...
Connector Zoho CRM
Zoho CRM is a comprehensive customer relationship management (CRM) software developed by Zoho Cor...
Connector Zoom
Zoom is a widely-used video conferencing platform that facilitates online meetings, webinars, and...
Processors
Processor Command Line Interface Code
Processor Command Line Interface Code intends to transform files in the configuration using Bash ...
Processor Create File
The Create File processor's purpose is to create a file with content and an extension of your cho...
Processor Great Expectations
Great Expectations is a processor that runs user-defined tests on their dataset. It can generally...
Processor IP Geolocation
IP GeoLocation is a processor that reads the IP addresses from a CSV and appends the CSV with loc...
Processor Json to CSV
Data In/ Data Out JSON to CSV processor is a CSV auto flattening processor. Data In ...
Processor Postgres
PostgreSQL, often referred to as Postgres, is an object-relational database management system. P...
Processor Python 3 Code
Overview The Python processor allows you to transform the data using Python scripts. Python is a...
Processor Python from Git repository
The Python from Git repository processor allows you to run a Python code located in a Git reposit...
Processor R Code
The R code processor allows you to transform data using R scripts. R is a free software environme...
Processor R from Git repository
The R from Git repository processor allows you to run an R code located in a Git repository. Meir...
Processor SQL on CSV
SQL stands for Structured Query Language, it lets you access and manipulates data in databases us...
Loaders
Loader ActiveCampaign
ActiveCampaign, known for its strong email marketing capabilities, offers a user-friendly interfa...
Loader AWS S3
AWS S3, or Amazon Simple Storage Service, is a foundational cloud storage service provided by Ama...
Loader CDP destination
This component allows loading values for parameters in CDP. Data In/Data Out Data In ...
Loader CDP Feed Items
The loader ‘CDP Feed Items’ uploads specified feed items to the CDP, enabling the use of custom b...
Loader Cockroach
Cockroach is an object-relational database management system. Cockroach uses and extends the SQL...
Loader Criteo
Criteo is a well-known online advertising landscape, offering advertisers the means to connect wi...
Loader Exponea
Exponea is a well-established player in the digital marketing landscape, providing businesses wit...
Loader Facebook Custom Audience
Facebook Custom Audience allows businesses to connect with users based on their demographics, int...
Loader: Facebook Conversion API
In the realm of data-driven marketing, accurate event tracking and optimization are vital for dri...
Loader Facebook Custom Anonymous Audience
In the context of data privacy and targeted advertising, Facebook Custom Anonymous Audience provi...
Loader Genesys
Genesys plays a significant role in the field of customer experience and engagement, offering too...
Loader Google Ads Customer Match Audience
The Google Ads Customer Match Audience allows businesses to create custom audiences within Google...
Loader Google Analytics Audience
The Google Analytics Audience feature is a powerful tool that enables businesses to transfer segm...
Loader Google Analytics 4 Audience
Google Analytics 4 Audience is a powerful tool that allows businesses to transfer segmented audie...
Loader Google BigQuery
Google BigQuery is a prominent platform in the data analytics and storage domain, offering busine...
Loader Google Cloud Storage
Google Cloud Storage is a widely recognized data storage solution that businesses can count on to...
Loader Google Drive
Google Drive is a well-known cloud storage service that offers businesses a practical solution fo...
Loader Google DV360 Customer Match Audience
The Google DV360 Customer Match Audience empowers advertisers to engage with their current custom...
Loader Google Spreadsheet
Google Spreadsheet is a widely used cloud-based application that businesses use to organize and a...
Loader HubSpot
HubSpot is a versatile suite of inbound marketing and sales tools that offers a comprehensive pla...
Loader Kafka
Kafka is an open-source distributed event streaming platform designed to handle real-time data fe...
Loader Klaviyo
Klaviyo, a popular customer data and marketing automation platform, is a vital tool for businesse...
Loader Magnews Audience
Magnews Audience is a powerful audience management platform that enhances customer engagement thr...
Loader Mailchimp
Mailchimp is a widely used marketing automation platform that allows businesses to create and man...
Loader Mailkit
Mailkit is a comprehensive email marketing platform designed to streamline and enhance the email ...
Loader ME to CDP
Loader ME to CDP extracts raw customer events from the Meiro Events (ME) database, transforms the...
Loader MsSQL
Microsoft SQL Server (MsSQL) is a relational database management system designed to store and ret...
Loader MySQL
MySQL is an open-source relational database management system (RDBMS) widely utilized for managin...
Loader Pipedrive
Pipedrive is a customer relationship management (CRM) platform designed to streamline sales proce...
Loader Postgres
PostgreSQL, often referred to as Postgres, is an object-relational database management system (RD...
Loader Redshift
Redshift is a fully managed, petabyte-scale data warehouse service in the cloud designed to handl...
Loader Salesforce Marketing Cloud
Salesforce Marketing Cloud is a comprehensive digital marketing platform designed to streamline a...
Loader Sendinblue
Sendinblue is a comprehensive marketing automation platform that offers a range of tools for busi...
Loader SFTP
Secure File Transfer Protocol (SFTP) is a secure and encrypted network protocol used for transfer...
Loader Sklik
Sklik is an online advertising platform developed by Seznam.cz, a major Czech internet company. I...
Loader Slack
Slack is a popular team collaboration platform that facilitates communication and information sha...
Loader SmartEmailing
SmartEmailing is a comprehensive email marketing platform that empowers businesses to create, sen...
Loader SmartEmailing Trigger
SmartEmailing Trigger is an advanced feature within the SmartEmailing platform that enables marke...
Loader Snapchat Audience
Snapchat, the popular social media platform known for its ephemeral content, offers a unique adve...
Loader Snowflake
Snowflake is a cloud-based data warehousing platform that provides a scalable and flexible soluti...
Loader The Trade Desk
The Trade Desk is a leading global technology platform that empowers advertisers to reach their t...
Loader Twitter Ads Audience
Twitter Ads Audience enables advertisers to target their ads to a specific audience based on vari...
Loader TikTok
TikTok is a popular social media platform that allows users to create, share, and discover short-...
Loader Yandex Audience
Yandex Audience, part of the larger Yandex ecosystem, provides a valuable advertising tool that a...
Loader Pinterest Audience
Pinterest Audience enables businesses to connect with visually driven, highly engaged users throu...
Tutorials
Tutorial: Google Analytics connector
In this tutorial, we will explain how to connect data from the Google Analytics connector to Meir...
Tutorial: How to create a workspace and data flow
1. Click on the Create Workspace button. 2. Provide a name of your choice for the workspace th...
Tutorial: How to use the sandbox in the Postgres processor
In this tutorial, we will explain how to use the Postgres processor and its sandbox feature: A...
Tutorial: how to configure Power BI to connect to PGSQL ran by Meiro
It is possible to connect data from Meiro with Power BI through the PostgreSQL database. In thi...
Tutorial: SQL on CSV processor sandbox
This article demonstrates how to create a sandbox for SQL on CSV processor in your local environm...
Meiro Analytics
Meiro Analytics is a solution for reporting the success of Meiro use cases. Instead of calculatin...
Best Practices
How to cooperate on the components with your team
When you or your teammates are working on improving a certain component, please the first experim...
Multiple chained queries in SQL on CSV processor
While working on data flow and using the SQL on CSV processor, you may encounter the problem of w...
Naming conventions
We recommend using only alphanumeric characters [a-z, A-Z, 0-9], as well as _ and -. It is good ...
Shortcuts
Use Ctrl+r+Shift (or Ctrl+F5) to reload the page, overriding cache. This shortcut is useful after...
Working on a complex workspace
While working on a complex workspace it is recommended to break a data flow into separate workspa...
FAQ
Browsers we recommend
Chromium: version 58 or newer Google Chrome: version 58 or newer Microsoft Edge: version 16 or ...
How to clone a component/ workspace
The cloning feature can be found at the top of a workspace, as well as at the top of a particular...
How to create a header in your file using Command Line Interface Code processor
If the data you receive does not have any headers you can add the header row using a simple BASH ...
How to create an Access Key and Secret Access Key for AWS S3
To set up a configuration for both AWS S3 connector and AWS S3 loader, you need to create an Acce...
How to move files from one folder in configuration to another using Command Line Interface Code processor
In Meiro Integrations output files or tables in the connector or processor components are saved i...
How to obtain credentials for Google Analytics
1. Universal Analytics 2. Google Analytics 4 1. For Universal Analytics property 1.1 To obta...
How to search & replace within a code editor
Click inside the text editor (while in edit mode) and press cmd+f followed by ctrl+h (ctrl+f and ...
How to set up a Jupyter notebook sandbox on localhost
Sometimes it may be useful to set up a Jupyter “sandbox” in your own development environment with...
How to set up SSH keys
Sometimes when you want to connect to the database, you will be asked by the database administrat...
How to use Description field formatting
Can happen that your code, the name of the file/table or any other text is read as a description ...
Where can I find the File ID on Google Drive
The Google Drive File ID is a unique identifier assigned to each file on Google Drive. It is a st...
Where can I find the Sheet ID of Google Spreadsheet file
The Sheet ID is a unique identifier for a specific sheet within a Google Spreadsheet file. To obt...
What does "Continue on Failure" mean?
You can set any configuration in a workspace to the Continue on Failure state. This feature per...
What is the difference between a user and admin level of access
Each person that uses Meiro Integrations can be granted either a user or admin level of access. ...
What is the difference between /files and /tables folders
In general, the folder /tables contains only CSV tables and the folder /files contains all other ...
What "No running Worker" in the fail logs mean?
Every configuration has its docker container. Meiro’s worker processes configuration details, col...
Why does my AWS S3 loader configuration not write anything in the bucket
Wait a few minutes and reload the AWS S3 webpage, as it can take some time to transfer files to...