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 the industry-leading solution for applying real-time analytics and detailed...
Connector AppsFlyer
AppsFlyer is a mobile attribution and marketing analytics platform. AppsFlyer uses tracking links...
Connector AWS S3
The AWS S3 connector allows you to connect an AWS S3 bucket with Meiro Integrations and use it as...
Connector Clockify
Clockify is a simple time tracker and timesheet app that lets you track work hours across project...
Connector contactSPACE
ContactSPACE is a software that helps to automatise the activity of the contact center. It col...
Connector Doubleclick
This connector enables you to connect to Doubleclick. Data In/Data Out Data In N/A...
Connector Facebook
The Facebook Connector allows you to connect to a Facebook business account and get data out of t...
Connector Facebook Ads
The Facebook Ads connector allows you to integrate your Facebook Ads account with Meiro Integrati...
Connector Facebook Pixel
This component extracts ads pixel stats data from Facebook Graph API. Learn more: about the end...
Connector Gmail
This component is used to extract data from Gmail email account. Data In/ Data Out Dat...
Connector Google Gmail Attachments
Data In/ Data Out Data In N/A Data Out Data will be saved in /data/out/tables if ...
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 connector allows you to integrate your Google Analytics account with Meiro Integ...
Connector Google BigQuery
Google BigQuery allows loading data from Google BigQuery to Meiro Integrations. Data In/Data Out...
Connector Google Cloud Storage OAuth2
The Google Cloud Storage OAuth2 Connector allows you to connect the Google Cloud Storage bucket w...
Connector Google Cloud Storage Service Account
The Google Cloud Storage connector allows you to connect the Google Cloud Storage bucket with Mei...
Connector Google Spreadsheet
Google Spreadsheet Connector allows you to use Google Spreadsheet files as a data source for the ...
Connector HTTP
Connector HTTP allows you to use the data stored under the URL address in your data flow. Featur...
Connector Instagram
Overview The Instagram connector allows you to integrate your Instagram account with Meiro Integ...
Connector ipSCAPE
Data In/ Data Out Data In N/A Data Out Upload all files in /data/i...
Connector Kafka
The Kafka-to-CDP connector enables the loading of messages from Apache Kafka to Meiro CDP. Le...
Connector Klaviyo
Klaviyo is a global technology company that provides a marketing automation platform, used primar...
Connector LDAP
This component connects, searches and gets data from the LDAP server. Data In/ Data Out ...
Connector Magento V2
The Connector Magento V2 component collects data from several Magento API resources. Data In/Dat...
Connector Mailchimp
The Mailchimp connector allows you to use your Mailchimp account as a data source with lists info...
Connector Microsoft Dynamics
This connector enables you to connect to Microsoft Dynamics 365 CRM. Data In/Data Out Dat...
Connector MsSQL
The SQL Server connector enables connections to Microsoft SQL Server data sources. Data In/Data ...
Connector MySQL
The SQL Server connector enables to connect to Microsoft SQL Server data sources. Data In/Data O...
Connector Optimizely
Optimizely is an American company that makes progressive delivery and experimentation software fo...
Connector OracleDB
The Oracle connector enables connections to Oracle server data sources. Data In/Data Out ...
Connector Pipedrive
The Pipedrive connector extracts contact information and their activities. Data In/ Data Out ...
Connector Postgres
PostgreSQL often referred to as Postgres, is an object-relational database management system. Po...
Connector Provetic
Data In/ Data Out Data In N/A Data Out All the data is saved in CSV...
Connector Pure Cloud
Data In/Data Out Data In Data Out N/A Learn more: about fol...
Connector Salesforce Commerce Cloud
The component exports data from Salesforce Commerce Cloud from the endpoint: orders, e.g. order d...
Connector Salesforce Sales Cloud
The component exports data from Salesforce Sales Cloud to objects and fields. Learn more: List ...
Connector SFTP
Data In/ Data Out Data In N/A Data Out All the data is saved in CSV...
Connector SmartEmailing API CSV
The SmartEmailing API CSV connector downloads from Automation (Automatizace) section of SmartEmai...
Connector Snowflake
The Snowflake connector enables the loading of tables from the Snowflake database to Meiro Integr...
Connector Twitter
This connector enables you to extract tweets data from a user’s Twitter account. Data In/Data O...
Connector WooCommerce
Component extracts data from WooCommerce API from Orders endpoint. Prerequisites Application re...
Connector Youtube Insight
Youtube Insights connector extracts your Youtube account’s metrics from the Youtube Analytics API...
Connector Zoho CRM
Data In/ Data Out Data In N/A Data Out Depending on the Output File n...
Connector Zoom
Zoom connector enables to load of the data from the Zoom platform for you users, meeting, as well...
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 AWS S3
AWS S3 loader allows you to upload files from Meiro Integrations to the S3 bucket. Requirements...
Loader Bukalapak
Loader upserts user interests to Bukalapak. Data In/Data Out Data In Loader requir...
Loader Cockroach
Cockroach is an object-relational database management system. Cockroach uses and extends the SQL...
Loader Criteo
This component creates a new audience or updates users to an existing audience in Criteo. When up...
Loader Exponea
Loader Exponea allows you to export data to Exponea. Data In/Data Out Data In Loader ...
Loader Facebook Audience
Facebook loader component is used for setting Facebook as a destination within Meiro Integrations...
Loader: Facebook Conversion API
This component adds events to the Facebook Conversion API. Requirements To use the loader, one ...
Loader Facebook Custom Anonymous Audience
Loader Facebook Custom Anonymous Audience is exporting Facebook Pixel cookies and user agents b...
Loader Genesys
This component allows importing and deleting contacts to Genesys Contacts lists. Data In/ Data ...
Loader Google Ads Customer Match Audience
The Google Ads Customer Match Audience Loader extracts data from a supplied CSV table to create a...
Loader Google Analytics Audience
Data In/ Data Out Data In A CSV file named export.csv, file should be in folder ...
Loader Google Analytics 4 Audience
This loader is used for importing Google Client IDs to Google Analytics 4 accounts. Component p...
Loader Google BigQuery
Google BigQuery loader enables to load of the data from Meiro Integrations to Google Big Query. ...
Loader Google Cloud Storage
Google Cloud Storage loader allows you to export data to Google Cloud storage. Data In/Data Out ...
Loader Google Drive
Loader Google Drive allows you to upload or update existing spreadsheets/ CSV tables in your Goog...
Loader Google Spreadsheet
Google Spreadsheet loader allows you to upload the CSV tables from the Meiro Integrations to the ...
Loader HubSpot
This loader is used for importing contacts to the Hubspot. Data In/Data Out Data In ...
Loader Kafka
Loader Kafka sends input data as messages to Kafka brokers. The component can produce two types ...
Loader Klaviyo
This loader is used for importing contacts to Klaviyo EDM. Data In/Data Out Data In ...
Loader Magnews Audience
This component is used for importing contacts to MagNews EDM tool. Learn more: about magnews API...
Loader Mailchimp
The Mailchimp loader allows you to: Create new list(s), Update existing list(s), Add member...
Loader Mailkit
Loader Mailkit allows you to load data into Mailkit. Data In/ Data Out Data In /da...
Loader ME to CDP
Loader ME to CDP extracts raw customer events from the Meiro Events (ME) database, transforms the...
Loader MsSQL
MsSQL loader exports data to Microsoft SQL server database. Prerequisite When connecting to an ...
Loader MySQL
Loader MySQL imports CSV data into MySQL database. Data In/Data Out Data In Upload all f...
Loader Pipedrive
This component allows you to load data into Pipedrive. Data In/ Data Out Data In Upload ...
Loader Postgres
PostgreSQL, often referred to as Postgres, is an object-relational database management system. P...
Loader Redshift
Redshift loader enables the loading of the data from Meiro Integrations to Redshift. Files from M...
Loader Salesforce Marketing Cloud
This component is used for importing contacts (email addresses with attribute values) to Salesfor...
Loader Sendinblue
Sendinblue is a SaaS solution for relationship marketing. Set up Sendinblue loader to be able to...
Loader SFTP
The SFTP loader allows you to: Create a remote path in the SFTP, if it does not exist. Creat...
Loader Sklik
This component is used for importing contacts(email addresses) to Sklik’s retargeting list. Pre...
Loader Slack
This is a component that reads a CSV input file that has {message, channel_id} fields and posts e...
Loader SmartEmailing
The SmartEmailing loader reads emails and custom fields from customfields.csv and adds/updates th...
Loader SmartEmailing Trigger
The SmartEmailing Trigger loader reads emails, events, and payload from triggers.ndjson and trigg...
Loader The Trade Desk
The Trade Desk is a global technology company that markets a software platform used by digital ad...
Loader Twitter Ads Audience
This component is used to import contacts to Twitter Ads Audiences. Learn more: about Twitter A...
Loader TikTok
Loader for creating custom audiences in TikTok. Learn more: about endpoint dictionary, upload f...
Loader Snowflake
Snowflake is a cloud-based data storage and analytics service. Learn more: about Snowflake from ...
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...
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...