New Integrations: Integrate S3, Heap, SFTP and Magento with your data warehouse

We are excited to introduce a number of new integrations as data sources. Now you can integrate S3, Heap, SFTP, and Magento with Blendo.

Let’s take a closer look at the new data sources we have added.

• Amazon S3 as a data source
• Heap as a data source
• Magento (via MySQL) as a data source
• SFTP as a data source

Amazon S3

Amazon Simple Storage Service (Amazon S3) is an object storage service that offers industry-leading scalability, data availability, security, and performance. Companies use it to store data from various sources and since S3 storage is really cheap, it makes a lot of sense to use it as the storage for a company data lake.

Amazon S3 Integration with your data warehouse.

Connecting S3 as a Source with Blendo makes it easier than ever to pull your S3 bucket data and combine it with other business data into your data warehouse for smarter insights. You can connect your source and destination and move data instantly without writing any code.

Integrate S3 with a straightforward configuration.

Configure your resources.

How to use the S3 Connector to sync your data with Blendo

Firstly, you need to have access to Amazon S3 and make sure you have a Blendo account. If you do not have access, it’s helpful to ask assistance from an engineer from your side or check with our customer support.

1. Connect your data warehouse. We support all the popular ones like Amazon Redshift, Google BigQuery, MS SQL Server, PostgreSQL, and Snowflake. Don’t have one? Contact our team to help.
2. Connect S3 as a data source (Amazon S3 integration documentation)
3. Connect any other business cloud data sources.
4. Analyze with your favorite Business Intelligence tool. Blendo is BI agnostic, so any of the BIs will be able to make use of the analytics-ready data Blendo prepares for you.

 

Heap

Heap is a SaaS platform that provides product analytics for understanding user behavior in apps and websites. If you use Heap as your product events’ platform then you definitively want to start combining with your sales and marketing data. Then you start adding intent in your customer touchpoints and engagement.

Heap Integration with your data warehouse.

Connecting Heap as a Source with Blendo makes it easier than ever to pull your product engagement data and combine it with sales, support or marketing data into your data warehouse for smarter insights. You can connect your source and destination and move data instantly without writing any code.

Integrate Heap with a straightforward configuration.

Heap uses S3 to push data. So we need a similar setup to the S3 configuration like before.

Configure the Earliest Report Date that you need data from.

Select the Heap resources you need.

How to use the Heap Connector to sync your data with Blendo

Firstly, you need to have access to Heap and make sure you have a Blendo account. If you do not have access, it’s helpful to ask assistance from an engineer from your side or check with our customer support.

1. Connect your data warehouse. We support all the popular ones like Amazon Redshift, Google BigQuery, MS SQL Server, PostgreSQL, and Snowflake. Don’t have one? Contact our team to help.
2. Connect Heap as a data source (Heap integration documentation)
3. Connect any other business cloud data sources.
4. Analyze with your favorite Business Intelligence tool. Blendo is BI agnostic, so any of the BIs will be able to make use of the analytics-ready data Blendo prepares for you.

Magento

Magento is a popular e-commerce platform built on open source technology. It provides online merchants with a flexible shopping cart system, as well as control over the look, content, and functionality of their online store. Magento also offers search engine optimization, marketing, and catalog management tools. Having your Magento data in the same data warehouse as your marketing, support, and sales will help you get a holistic understanding of your customer engagement and e-shop performance.

Magento Integration with your data warehouse.

Connecting Magento as a Source with Blendo makes it easier than ever to pull your e-commerce data and combine it with support or marketing data into your data warehouse for smarter insights. You can connect your source and destination and move data instantly without writing any code.

Integrate Magento with a straightforward configuration.

Magento uses MySQL as part of its technology stack. Our integration uses our MySQL connector to pull data from Magento.

Select the Magento resources you need.

Schedule the Magento pipeline sync.

How to use the Magento Connector to sync your data with Blendo

Firstly, you need to have access to Magento and make sure you have a Blendo account. If you do not have access, it’s helpful to ask assistance from an engineer from your side or check with our customer support.

1. Connect your data warehouse. We support all the popular ones like Amazon Redshift, Google BigQuery, MS SQL Server, PostgreSQL, and Snowflake. Don’t have one? Contact our team to help.
2. Connect Magento (via MySQL) as a data source (Magento integration documentation)
3. Connect any other business cloud data sources.
4. Analyze with your favorite Business Intelligence tool. Blendo is BI agnostic, so any of the BIs will be able to make use of the analytics-ready data Blendo prepares for you.

SFTP

Amazon Simple Storage Service (Amazon S3) SFTP is an encrypted secure network protocol for transferring files over a reliable stream. SFTP is a secure way to upload files into your data warehouse so you can explore it along with data from sales or marketing.

Amazon S3 Integration with your data warehouse.

Connecting SFTP as a Source with Blendo makes it easier than ever to pull your S3 bucket data and combine it with other business data into your data warehouse for smarter insights. You can connect your source and destination and move data instantly without writing any code.

Integrate SFTP with a straightforward configuration.

Configure your resources.

How to use the SFTP Connector to sync your data with Blendo

Firstly, you need to have access to SFTP and make sure you have a Blendo account. If you do not have access, it’s helpful to ask assistance from an engineer from your side or check with our customer support.

1. Connect your data warehouse. We support all the popular ones like Amazon Redshift, Google BigQuery, MS SQL Server, PostgreSQL, and Snowflake. Don’t have one? Contact our team to help.
2. Connect SFTP as a data source (SFTP integration documentation)
3. Connect any other business cloud data sources.
4. Analyze with your favorite Business Intelligence tool. Blendo is BI agnostic, so any of the BIs will be able to make use of the analytics-ready data Blendo prepares for you.

 

Why should I get my business data sources into my data warehouse with Blendo?

Fewer silos – Data may live anywhere, from S3 buckets to databases and cloud services. It can contain from product data to financial info that you need to load it into a data warehouse for analytics use cases. With Blendo you will have no more silos for your data.

Faster implementation, less maintenance – You don’t need to create any ETL/ELT scripts or engage engineering resources to pull your data from your data source into your data warehouse.

Only the data you need – Do you need all the data or part of it? Do you need the rest of the data (e.g., Sales, Marketing, Support cloud application data) along? You will have all the data you care in one place.

Data when you need it – Build your S3 bucket export schedule or have daily sync of your database data. With Blendo, you now have access to your data into your data warehouse the moment you need it.

 

New to Blendo? It’s a tool that helps anyone connect their business apps with their data warehouse and BI automatically — without code. Blendo will prepare and keep in sync analytics-ready data from your data sources so you can focus on getting smarter insights. Sign up for a free trial to use S3, Heap, Magento or SFTP as a source with Blendo.